Laman Utama Tanya Wiki English Artikel Komuniti E-Mel Ringtones Search

Bantuan | Carian | Ahli | Kalendar

Google

Selamat Datang ( Log In | Daftar )

 
Reply to this topicStart new topic
Sapa nak RM900 jawab soalan ni
zura_84
post May 8 2008, 12:52 PM
Kiriman #1


Ahli Baru


Grup: Learning
Kiriman: 19
Penyertaan: 5-May 08
Dari: pahang
Ahli ke- 47,029



hello...
bleh mintak tolong ajar kan tak....

mane lagi senang, create butang carian then kuar maklumat yang dkehendaki atau biler kite insert maklumat,automatik maklumat yang kite masukkan tadi tu kuar bersebelahan nye..

conth:

matric no:____________<----insert sendiri

biler dah insert, automatik name pelajar yang pegang no matric yg di insert tadi kuar sebelah dier...

masalah saya skarang, table untuk matric n name pelajar tu berlainan...
nak join kan dua-dua nye cm ne script dier ar??? urgent sangat nie
Go to the top of the page
 
+Quote Post
cyberfly
post May 8 2008, 02:22 PM
Kiriman #2


Ahli Rajin
****

Grup: Members
Kiriman: 726
Penyertaan: 11-April 04
Dari: http://jomphp.blogspot.com
Ahli ke- 40



haha bestnya dapat duit byk tongue.gif

kalau nak buat automatik,kena guna Ajax.try google.kena belajar dulu la laugh.gif

ni cara nak join smile.gif

$matricno = $_GET['matric_no'];

$matric="select * from matric where matricno='$matricno'";
$domatric=mysql_query($matric) or die(mysql_error());
$datamatric = mysql_fetch_array($domatric);

//lepastu amik foreign key dalam table matric no tu.aku assume idStudent.

$idStudent = $datamatric['idStudent'];


//then proceed ke table student untuk dapatkan nama dan lain-lain

$student="select * from student where idStudent='$idStudent'";
$dostudent=mysql_query($student) or die(mysql_error());
$datastudent = mysql_fetch_array($dostudent);

//cth nak nama student

$namastudent = $datastudent['namaStudent'];




--------------------
Intel C2D e6600 3.4ghz, Gigabyte P35-DS3,TT BigTyphoon VX, Silverstone Strider ST50F,
Crucial Balistix Tracer 4gb,Palit 8500gt 256mb ddr3,WD 1Terabyte sata2. || http://jomphp.blogspot.com
Go to the top of the page
 
+Quote Post
zura_84
post May 8 2008, 03:51 PM
Kiriman #3


Ahli Baru


Grup: Learning
Kiriman: 19
Penyertaan: 5-May 08
Dari: pahang
Ahli ke- 47,029



ni pakai ajax ke??? kalau pakai php cam ne script dier??? tolong weh... kite tak tau langsung pasal php nie... system nak kena run besok nak tengok... kite pun baru lagi keje pakai php nie tak sampai seminggu...!!! takat rm 100 bleh ar bg.. hehhehhe rolleyes.gif
Go to the top of the page
 
+Quote Post
cyberfly
post May 8 2008, 04:22 PM
Kiriman #4


Ahli Rajin
****

Grup: Members
Kiriman: 726
Penyertaan: 11-April 04
Dari: http://jomphp.blogspot.com
Ahli ke- 40



QUOTE(zura_84 @ May 8 2008, 03:51 PM) *
ni pakai ajax ke??? kalau pakai php cam ne script dier??? tolong weh... kite tak tau langsung pasal php nie... system nak kena run besok nak tengok... kite pun baru lagi keje pakai php nie tak sampai seminggu...!!! takat rm 100 bleh ar bg.. hehhehhe rolleyes.gif


tu php script la tu..
ajax aku pn tak belajar lagi laugh.gif
seratus pn jalan happy.gif


--------------------
Intel C2D e6600 3.4ghz, Gigabyte P35-DS3,TT BigTyphoon VX, Silverstone Strider ST50F,
Crucial Balistix Tracer 4gb,Palit 8500gt 256mb ddr3,WD 1Terabyte sata2. || http://jomphp.blogspot.com
Go to the top of the page
 
+Quote Post
zura_84
post May 8 2008, 04:59 PM
Kiriman #5


Ahli Baru


Grup: Learning
Kiriman: 19
Penyertaan: 5-May 08
Dari: pahang
Ahli ke- 47,029



eceh...sengkek yek...hahahahah ujung bulan gj bg ar... so yg php nie nak letak kat mane?? lepas kite wat input type ke ape
Go to the top of the page
 
+Quote Post
cyberfly
post May 8 2008, 05:03 PM
Kiriman #6


Ahli Rajin
****

Grup: Members
Kiriman: 726
Penyertaan: 11-April 04
Dari: http://jomphp.blogspot.com
Ahli ke- 40



QUOTE(zura_84 @ May 8 2008, 04:59 PM) *
eceh...sengkek yek...hahahahah ujung bulan gj bg ar... so yg php nie nak letak kat mane?? lepas kite wat input type ke ape


letak kat page displaysearchresult laugh.gif
kalau nak siap cepat, kena bayar cepat laugh.gif laugh.gif


--------------------
Intel C2D e6600 3.4ghz, Gigabyte P35-DS3,TT BigTyphoon VX, Silverstone Strider ST50F,
Crucial Balistix Tracer 4gb,Palit 8500gt 256mb ddr3,WD 1Terabyte sata2. || http://jomphp.blogspot.com
Go to the top of the page
 
+Quote Post
zura_84
post May 8 2008, 05:26 PM
Kiriman #7


Ahli Baru


Grup: Learning
Kiriman: 19
Penyertaan: 5-May 08
Dari: pahang
Ahli ke- 47,029



amboi...heheheh
php aku memang fail ler
pakai dreamweaver ni
Go to the top of the page
 
+Quote Post
SHiDi
post May 8 2008, 05:38 PM
Kiriman #8


Ahli Rajin
****

Grup: Members
Kiriman: 556
Penyertaan: 6-September 05
Dari: Ampang
Ahli ke- 10,285



QUOTE(cyberfly @ May 8 2008, 02:22 PM) *
CODE
$matric="select * from matric where matricno='$matricno'";
$domatric=mysql_query($matric) or die(mysql_error());
$datamatric = mysql_fetch_array($domatric);

//lepastu amik foreign key dalam table matric no tu.aku assume idStudent.

$idStudent = $datamatric['idStudent'];


//then proceed ke table student untuk dapatkan nama dan lain-lain

$student="select * from student where idStudent='$idStudent'";
$dostudent=mysql_query($student) or die(mysql_error());
$datastudent = mysql_fetch_array($dostudent);


Kenapa tak buat join query je? Sekali harung je? Jimat running time.


--------------------
World Of Mine - http://blog.mohdrashidi.com
Go to the top of the page
 
+Quote Post
DevGuy
post May 8 2008, 07:06 PM
Kiriman #9


Ahli
***

Grup: Members
Kiriman: 444
Penyertaan: 20-April 04
Ahli ke- 257



boleh jerr
meh jumpa aku
aku buat depan ko terus
then terus kasi aku duit
hehehe
amacamm
ada berani kaaa
Go to the top of the page
 
+Quote Post
cyberfly
post May 8 2008, 07:20 PM
Kiriman #10


Ahli Rajin
****

Grup: Members
Kiriman: 726
Penyertaan: 11-April 04
Dari: http://jomphp.blogspot.com
Ahli ke- 40



QUOTE(SHiDi @ May 8 2008, 05:38 PM) *
Kenapa tak buat join query je? Sekali harung je? Jimat running time.


lepas bro tanya baru terfikir..tadi tak join sbb rasa mcm takleh laugh.gif laugh.gif

camni ke?

select * from matric, student
where matric.matricno='$matricno' and matric.idStudent=student.idStudent


--------------------
Intel C2D e6600 3.4ghz, Gigabyte P35-DS3,TT BigTyphoon VX, Silverstone Strider ST50F,
Crucial Balistix Tracer 4gb,Palit 8500gt 256mb ddr3,WD 1Terabyte sata2. || http://jomphp.blogspot.com
Go to the top of the page
 
+Quote Post
SHiDi
post May 9 2008, 09:38 AM
Kiriman #11


Ahli Rajin
****

Grup: Members
Kiriman: 556
Penyertaan: 6-September 05
Dari: Ampang
Ahli ke- 10,285



QUOTE(cyberfly @ May 8 2008, 07:20 PM) *
lepas bro tanya baru terfikir..tadi tak join sbb rasa mcm takleh laugh.gif laugh.gif

camni ke?

select * from matric, student
where matric.matricno='$matricno' and matric.idStudent=student.idStudent


Tak berani jawab, sebab aku tak tahu macam mana dia punya table schema.


--------------------
World Of Mine - http://blog.mohdrashidi.com
Go to the top of the page
 
+Quote Post
zura_84
post May 9 2008, 12:39 PM
Kiriman #12


Ahli Baru


Grup: Learning
Kiriman: 19
Penyertaan: 5-May 08
Dari: pahang
Ahli ke- 47,029



nak tanye ni.. kenape biler aku insert data then klik ok semua data yang aku dah insert tu ter reset balik
nak buat ape yek??
Go to the top of the page
 
+Quote Post
cyberfly
post May 9 2008, 02:20 PM
Kiriman #13


Ahli Rajin
****

Grup: Members
Kiriman: 726
Penyertaan: 11-April 04
Dari: http://jomphp.blogspot.com
Ahli ke- 40



QUOTE(zura_84 @ May 9 2008, 12:39 PM) *
nak tanye ni.. kenape biler aku insert data then klik ok semua data yang aku dah insert tu ter reset balik
nak buat ape yek??


pastekan code insert kat sini baru member2 ada idea nak tolong happy.gif


--------------------
Intel C2D e6600 3.4ghz, Gigabyte P35-DS3,TT BigTyphoon VX, Silverstone Strider ST50F,
Crucial Balistix Tracer 4gb,Palit 8500gt 256mb ddr3,WD 1Terabyte sata2. || http://jomphp.blogspot.com
Go to the top of the page
 
+Quote Post
SHiDi
post May 9 2008, 02:31 PM
Kiriman #14


Ahli Rajin
****

Grup: Members
Kiriman: 556
Penyertaan: 6-September 05
Dari: Ampang
Ahli ke- 10,285



QUOTE(zura_84 @ May 9 2008, 12:39 PM) *
nak tanye ni.. kenape biler aku insert data then klik ok semua data yang aku dah insert tu ter reset balik
nak buat ape yek??


Data dimasukkan dalam form ke? Form tu punya header betul tak? Form tu ada open dengan close tag?

Rasanya ada error kat line 17. Cuba tengok.


--------------------
World Of Mine - http://blog.mohdrashidi.com
Go to the top of the page
 
+Quote Post
rasberry
post May 10 2008, 03:04 PM
Kiriman #15


Ahli
***

Grup: Members
Kiriman: 125
Penyertaan: 3-November 07
Ahli ke- 37,855



zura.. cuba ko bagi coding ngan database punya skima kat sini. kalo tanya soalan umum camni sampai bila nak selesai masalah.. sian kat abg Shidi nak kena jawab satu2 .. kalau nak cepat haa tu abg DevGuy tu ada, bawak laptop jumpa kat McD ke? starbucks ke? payung espresso secawan selesai masalah.. senang .. laugh.gif
Go to the top of the page
 
+Quote Post
DarkWan
post May 10 2008, 03:31 PM
Kiriman #16


Ahli Rajin
*****

Grup: PDP Moderator
Kiriman: 1,339
Penyertaan: 24-April 04
Dari: HELsinki
Ahli ke- 314



QUOTE(DevGuy @ May 8 2008, 07:06 PM) *
boleh jerr
meh jumpa aku
aku buat depan ko terus
then terus kasi aku duit
hehehe
amacamm
ada berani kaaa

Aku bukan nak bias, tapi kalau aku nk recommend orang yang boleh solve problem ko ni, 'DevGuy' is the guy smile.gif


--------------------
Team Raptor Malaysia - http://www.raptorpaintball.com

http://www.putera.com/wiki
Email: darkwan [at] putera [dot] com
#AMD Club :0362004
Go to the top of the page
 
+Quote Post
LanoG
post Semalam, 03:41 AM
Kiriman #17


Ahli Rajin
*****

Grup: Members
Kiriman: 2,006
Penyertaan: 21-May 06
Dari: Hide in Cubicle
Ahli ke- 16,976



QUOTE(zura_84 @ May 8 2008, 03:51 PM) *
ni pakai ajax ke??? kalau pakai php cam ne script dier??? tolong weh... kite tak tau langsung pasal php nie... system nak kena run besok nak tengok... kite pun baru lagi keje pakai php nie tak sampai seminggu...!!! takat rm 100 bleh ar bg.. hehhehhe rolleyes.gif


aik... tajuk thread kata RM900... mana duit nyer.. rupe2nya tanya soalan.

By the way.. sebelum tanya soalan tu, paste kan code or image yang berkaitan. senang ler diorang nak tolong... biggrin.gif


--------------------
TIME IS RELATIVE, IMAGINATION IS INFINITE
Jom buat Model 3D, Vector 2D, Raster 2D & Game or Application Programming!
www.senibinagame.com
Go to the top of the page
 
+Quote Post
DevGuy
post Semalam, 06:35 AM
Kiriman #18


Ahli
***

Grup: Members
Kiriman: 444
Penyertaan: 20-April 04
Ahli ke- 257



resberry ko ni pandai tul aaaa
tapi ok gakk
tak yah aaaa rm900
kasi aku banje chillis kerr ok jerr
wakakakka
mcd / starbuck ok gakk
hehehehe
memana aaa
wakakakaka
gua tak kisah
hehehehe
ajak ko sekali leh makan free
daripada rm900 mahal tuuu
kalau project company tak perr gakk
kalau duit sendiri tak yah aaa
leh tolong jerrr
Go to the top of the page
 
+Quote Post
rasberry
post Semalam, 10:52 PM
Kiriman #19


Ahli
***

Grup: Members
Kiriman: 125
Penyertaan: 3-November 07
Ahli ke- 37,855



ok gaks.. tp aku nak makan sup cendawan ngan shrimp roll kat TGI Friday.. laugh.gif

camner zura jadi tak? takyah takut abang2 kat sini semua dah kawen dah .. huhu
Go to the top of the page
 
+Quote Post
dellantre
post Hari Ini, 02:40 AM
Kiriman #20


Ahli
***

Grup: Members
Kiriman: 160
Penyertaan: 4-March 08
Dari: Gombak
Ahli ke- 43,931



join table je ker..
ok gak..

tunjuk la sikit kau punya carta database..
mane la tau aku leh tolong lebih dari tu.

my 20 sen...


--------------------
Belum pernah berlaku didunia ini,berlakunya keamanan disebabkan akta dan undang-undang.Tapi pernah berlaku didunia ini,keselamatan, keamanan dan kebahagiaan kerana manusia takutkan Tuhan.
Go to the top of the page
 
+Quote Post
zura_84
post Hari Ini, 08:16 AM
Kiriman #21


Ahli Baru


Grup: Learning
Kiriman: 19
Penyertaan: 5-May 08
Dari: pahang
Ahli ke- 47,029



xpela
dah settle pun...semalam dh jumpe member kat kl sentral....anyway tq la yek... t ader masalah lagi kiter tanye lagi siap br coding lagi... thanks a lot
Go to the top of the page
 
+Quote Post
LanoG
post Hari Ini, 10:01 AM
Kiriman #22


Ahli Rajin
*****

Grup: Members
Kiriman: 2,006
Penyertaan: 21-May 06
Dari: Hide in Cubicle
Ahli ke- 16,976



QUOTE(rasberry @ May 11 2008, 10:52 PM) *
ok gaks.. tp aku nak makan sup cendawan ngan shrimp roll kat TGI Friday.. laugh.gif

camner zura jadi tak? takyah takut abang2 kat sini semua dah kawen dah .. huhu


Hahaha.. yang dah kawen tu lebih berbahaya dari yang belum... biggrin.gif

QUOTE(zura_84 @ May 12 2008, 08:16 AM) *
xpela
dah settle pun...semalam dh jumpe member kat kl sentral....anyway tq la yek... t ader masalah lagi kiter tanye lagi siap br coding lagi... thanks a lot


Err.. ramai orang mintak belanja, dah terus settle ka... hehehe. laugh.gif


--------------------
TIME IS RELATIVE, IMAGINATION IS INFINITE
Jom buat Model 3D, Vector 2D, Raster 2D & Game or Application Programming!
www.senibinagame.com
Go to the top of the page
 
+Quote Post
zura_84
post Hari Ini, 05:01 PM
Kiriman #23


Ahli Baru


Grup: Learning
Kiriman: 19
Penyertaan: 5-May 08
Dari: pahang
Ahli ke- 47,029



hahahah betulla
ader lagi satu nie tapi besok ar kite bgtau
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic