crv82 0 Report post Posted October 1, 2007 saya nak wat system yg leh check keputusan kemasukan ke sekolah agama.bile pemohon masukkan no ic...die kuar result samada berjaya atau tak...ala,mcm yg check kemasukan ke ipt tu...<? session_start(); // sambungan $conn =mysql_connect('localhost','root','');//pilih databasemysql_select_db("pemohon",$conn);//arahan sql$sql="select * from berjaya where no_ic= '$_GET[no_ic]'";$rslt=mysql_query($sql);if ($login =mysql_fetch_array($rslt)) { echo " Tahniah,Anda Berjaya"; echo " <br> "; echo " <br> "; echo " $data["no_ic"] "; echo " $data["nama"] "; echo " $data["no_rujukan"] "; echo " $data["sekolah_pilih"] "; echo " $data["alamat"] "; include ("berjaya.php"); } else { include("gagal.php"); echo " <br> "; } ?>[/codebox]btul ker code kat atas tu..??itu sy try and error jerr...dan mmg error.. ..leh otai2 php tlg tak? Quote Share this post Link to post Share on other sites
amin007 1 Report post Posted October 1, 2007 saya nak wat system yg leh check keputusan kemasukan ke sekolah agama.bile pemohon masukkan no ic...die kuar result samada berjaya atau tak...ala,mcm yg check kemasukan ke ipt tu...<? session_start(); // sambungan $conn =mysql_connect('localhost','root','');//pilih databasemysql_select_db("pemohon",$conn);//arahan sql$sql="select * from berjaya where no_ic= '$_GET[no_ic]'";$rslt=mysql_query($sql);if ($login =mysql_fetch_array($rslt)) { echo " Tahniah,Anda Berjaya"; echo " <br> "; echo " <br> "; echo " $data["no_ic"] "; echo " $data["nama"] "; echo " $data["no_rujukan"] "; echo " $data["sekolah_pilih"] "; echo " $data["alamat"] "; include ("berjaya.php"); } else { include("gagal.php"); echo " <br> "; } ?>[/codebox]btul ker code kat atas tu..??itu sy try and error jerr...dan mmg error.. ..leh otai2 php tlg tak?mcm silap aje hehehemana laa ko copy koding nimula2 ko buat $login$login =mysql_fetch_array($rslt)lepas tu papar $data[]echo " $data["no_ic"] ";nak tanya, mana datang $data[] tu kalau ko buat $login =mysql_fetch_array($rslt)ni arahan yg biasa aku buat laa[code]//arahan sql $sql="select * from berjaya where no_ic= '$_GET[no_ic]'"; $rslt=mysql_query($sql); $rows = mysql_num_rows($rslt); // cari bilangan baris // nak cari $rows if ($rows=='0'): include("gagal.php"); echo " <br> "; else: // mula kalau jumpa while($data = mysql_fetch_array($rslt)) {// mula papar $data[] echo " Tahniah,Anda Berjaya"; echo " <br> "; echo " <br> "; echo " $data["no_ic"] "; echo " $data["nama"] "; echo " $data["no_rujukan"] "; echo " $data["sekolah_pilih"] "; echo " $data["alamat"] "; include ("berjaya.php"); }// tutup papar $data[] endif; //tamat jika jumpa[/code] Quote Share this post Link to post Share on other sites
crv82 0 Report post Posted October 2, 2007 mcm silap aje hehehemana laa ko copy koding ni wat sndiri....maklumle baru sbulan blajar...tu pun sndiri2..hehhehe,ntah pape jer koding sy tu..nway,tq..tq,nati sy cube ek... Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted October 2, 2007 (edited) ni arahan yg biasa aku buat laa//arahan sql $sql="select * from berjaya where no_ic= '$_GET[no_ic]'"; $rslt=mysql_query($sql); $rows = mysql_num_rows($rslt); // cari bilangan baris // nak cari $rows if ($rows=='0'): include("gagal.php"); echo " <br> "; else: // mula kalau jumpa while($data = mysql_fetch_array($rslt)) {// mula papar $data[] echo " Tahniah,Anda Berjaya"; echo " <br> "; echo " <br> "; echo " $data["no_ic"] "; echo " $data["nama"] "; echo " $data["no_rujukan"] "; echo " $data["sekolah_pilih"] "; echo " $data["alamat"] "; include ("berjaya.php"); }// tutup papar $data[] endif; //tamat jika jumpa Aku tak faham kenapa nak guna while? Kan No IC ni unique. Mana boleh lebih daripada 1 Kalau aku punya style pula: <? session_start(); // sambungan (ubah single quote kepada double quote) mysql_connect("localhost","root",'') or die("Unable to connect"); //pilih database mysql_select_db("pemohon") or die("Unable to select DB"); //arahan sql (pilih column mana nak guna) $sql="select no_ic, nama, no_rujukan, sekolah_pilih, alamat from berjaya where no_ic= '$_GET[no_ic]'"; list($no_ic, $nama, $no_rujukan, $sekolah_pilihan, $alamat) = mysql_fetch_array($sql); //No IC adalah unique so mesti ada la kan if (!empty($no_ic)) { echo " Tahniah,Anda Berjaya"; echo " <br> "; echo " <br> "; echo " $no_ic "; echo " $nama "; echo " $no_rujukan "; echo " $sekolah_pilihan "; echo " $alamat "; include ("berjaya.php"); } else { include("gagal.php"); echo " <br> "; } ?>Lagi elok kalau buat pemeriksaan sama ada no ic wujud ke tidak. Tapi memandangkan ni simple je, tak banyak proses rasa tak perlu la kot. Edited October 2, 2007 by SHiDi Quote Share this post Link to post Share on other sites
FryShadow 90 Report post Posted October 2, 2007 ape fungsi session_start() kalau tak utiliaze bnda tu. Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted October 2, 2007 ape fungsi session_start() kalau tak utiliaze bnda tu.Betul gak soalan kau tu. Aku agak dalam file yang dia include tu dia gunakan session nieh Quote Share this post Link to post Share on other sites
Cho Chang 0 Report post Posted October 2, 2007 (edited) include("gagal.php");numpang tanya... pa fungsi include tuhh?? leh terangkan x? Edited October 2, 2007 by NobbiesS Quote Share this post Link to post Share on other sites
FryShadow 90 Report post Posted October 2, 2007 include :refer : http://au2.php.net/manual/en/function.include.phpsalah satu function jgk dlm php untuk masukkan file cntoh include 'db.php';cntoh dlm db.php :<?php$connect = mysql_connect($host,$user,$pass);if(!$connect)echo "can't connect to server";?>[/code]Contoh situasi :page ko byk nk gna connection ke mysql cnth nak update,insert data searching and so on, so xkan ko nak taip coding db.php tu kat every page ko ye tak ? so function include ni dpt memudahkn ko , panggil satu file je pastu dah bleh gna variable2 dlm page db.php tue just my 0.5cents Quote Share this post Link to post Share on other sites
amin007 1 Report post Posted October 2, 2007 Aku tak faham kenapa nak guna while? Kan No IC ni unique. Mana boleh lebih daripada 1 Lagi elok kalau buat pemeriksaan sama ada no ic wujud ke tidak. Tapi memandangkan ni simple je, tak banyak proses rasa tak perlu la kot. kenapa guna while??ala, aku dah terbiasa guna whilelagi pun kalau guna while ($data = mysql_fetch_array($rslt))$data[] tu dlm bentuk arrayjadi aku boleh pakai nombor atau nama medanbiasanya dlm sistem nyg aku buat,memang aku set standard mcm tu.senang kalau nak ubah apa2ada kalanya aku malas nak list medan satu2 jadi aku buat mcm ni aje// dapatkan bilangan medan $fields = mysql_num_fields($result) or die("Num Fields Failed/ Nama Medan Takde"); ... ... ... while($row = mysql_fetch_array($result)) {// mula papar $row echo ($bil++ % '2'=='0')? "<tr bgcolor='plum'>" : "<tr>"; for ( $f = 0; $f < $fields; $f++ ) { echo "<td>".$row[$f]."</td>\n"; } echo "</tr>\n"; }// tutup papar $rowjika aku rasa nak papar medan tertentu ajeaku pakai nama medankalau medan tu banyak sangat,aku pakai nombor yg berulangpasal session_start() tu,rasanya dia main letak aje.takde pun tak apa.pasal include pulak,aku memang suka sangat guna.lebih2 lagi kalau koding yg aku buat dah panjang berjela.mcm buat karangan pulak tapi biasanya orang guna includeuntuk kod yg diulang beberapa kalimcm 1) kod nak buka database2) fungsi3) class4) kod yg .... Quote Share this post Link to post Share on other sites
Cho Chang 0 Report post Posted October 2, 2007 include :refer : http://au2.php.net/manual/en/function.include.phpsalah satu function jgk dlm php untuk masukkan file cntoh include 'db.php';cntoh dlm db.php :<?php $connect = mysql_connect($host,$user,$pass); if(!$connect) echo "can't connect to server"; ?>Contoh situasi :page ko byk nk gna connection ke mysql cnth nak update,insert data searching and so on, so xkan ko nak taip coding db.php tu kat every page ko ye tak ? so function include ni dpt memudahkn ko , panggil satu file je pastu dah bleh gna variable2 dlm page db.php tue just my 0.5cents ooo macam tuh kee...kk thak u my mentor thank u to abg amin007 2 Quote Share this post Link to post Share on other sites
crv82 0 Report post Posted October 3, 2007 <? // sambungan $conn =mysql_connect('localhost','root','');//pilih databasemysql_select_db("pemohon",$conn);//arahan sql$sql="select * from berjaya where no_ic= '$_GET[no_ic]'";$rslt=mysql_query($sql);$rows = mysql_num_rows($rslt); // cari bilangan baris$nama=$_POST['nama'];//$no_rujukan=$_POST['no_rujukan'];$no_ic=$_POST['no_ic'];$upsr=$_POST['upsr'];$sekolah=$_POST['sekolah_pilih'];$alamat=$_POST['alamat'];$phone=$_POST['no_phone'];// nak cari $rows//No IC adalah unique so mesti ada la kanif (!empty($no_ic)){echo " Tahniah,Anda Berjaya";echo " <br> ";echo " <br> ";echo " $no_ic ";echo " $nama ";echo " $no_rujukan ";echo " $sekolah";echo " $alamat ";include ("berjaya.php");}else{include("gagal.php");echo " <br> ";} ?>[/codebox]error dapat: [codebox]Notice: Undefined index: no_ic in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 17Notice: Undefined index: nama in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 21Notice: Undefined index: upsr in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 24Notice: Undefined index: sekolah_pilih in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 25Notice: Undefined index: alamat in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 26Notice: Undefined index: no_phone in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 27Tahniah,Anda Berjaya 830213035444 Notice: Undefined variable: no_rujukan in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 39naper die papar no ic jer? yg lain tu xkuar...ape masalah ek? Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted October 3, 2007 (edited) $sql="select * from berjaya where no_ic= '$_GET[no_ic]'"; $no_ic=$_POST['no_ic']; Kenapa dekat SQL Query kau guna $_GET[] tapi masa initialised kau guna $_POST[]? Mana satu ni? EDIT: Dekat SQL query kau pun ada kesilapan. Patutnya $_GET['no_ic'] atau $_POST['no_ic'] (memandangkan tak tau kau guna mana satu) "SELECT * FROM berjaya WHERE no_ic ='".$_POST['no_ic']."'";Soalan lagi satu, kenapa kau retrieve value daripada DB tapi lepas tu bila assign values untuk variable kau guna $_POST[]? Confused ah. Edited October 3, 2007 by SHiDi Quote Share this post Link to post Share on other sites
amin007 1 Report post Posted October 3, 2007 Kenapa dekat SQL Query kau guna $_GET[] tapi masa initialised kau guna $_POST[]? Mana satu ni?EDIT: Dekat SQL query kau pun ada kesilapan. Patutnya $_GET['no_ic'] atau $_POST['no_ic'] (memandangkan tak tau kau guna mana satu)"SELECT * FROM berjaya WHERE no_ic ='".$_POST['no_ic']."'";Soalan lagi satu, kenapa kau retrieve value daripada DB tapi lepas tu bila assign values untuk variable kau guna $_POST[]? Confused ah.betul kata shidi.ko patut keluarkan data dari tablebukan dari $_POST[]kan kita orang dah tunjuk cara2 nak masukkan variable dari table.guna cara tu laa Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted October 3, 2007 (edited) Ini aku buat lepas berbuka. Terasa nak tulis PHP lak. Lama tak tulis Memula borang untuk user masukkan nombor IC:<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> Nombor IC: <input type="text" name="no_ic"/> <input type="submit" name="submit" value="Periksa" /> </form> Lepas tu untuk buat pemprosesan: <?php if (isset($_POST['submit'])) { $no_ic = (int)$_POST['no_ic']; //pastikan hanya nombor yang dimasukkan sebagai no IC. if (!empty($no_ic)) { $sql = "SELECT nama, sekolah, alamat FROM pelajar WHERE no_ic = '".$no_ic."'"; list($nama, $sekolah, $alamat) = mysql_fetch_array($sql); if (!empty($nama)) { echo "Rekod Ditemui:<br />No IC: ".$no_ic."<br />Nama: ".$nama."<br />Sekolah: ".$sekolah."<br />Alamat: ".$alamat; } else { echo "Tiada Rekod Ditemui"; } } else { echo "Nombor IC tidak sah"; } } ?>Ni kira paling sempoi la. Pepandai eh ubah ikut kesusaian EDIT: contoh ni cuma menggunakan SATU file PHP Edited October 3, 2007 by SHiDi Quote Share this post Link to post Share on other sites
crv82 0 Report post Posted October 4, 2007 $sql = "SELECT nama, sekolah FROM berjaya WHERE no_ic = '".$no_ic."'";$rslt=mysql_query($sql);$nama=$_POST['nama'];[/codebox]bile sy wat camni,kuar data tp xsume.dan still ader error[codebox]Notice: Undefined variable: no_ic in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 18Notice: Undefined index: nama in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 24Notice: Undefined index: sekolah_pilih in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 28Tahniah,Anda Berjaya 820710036010 tapi bile saya tukar _post tu kpd _get,kuar error.Notice: Undefined variable: no_ic in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 18Notice: Undefined index: nama in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 24Notice: Undefined index: no_ic in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 26Notice: Undefined index: sekolah_pilih in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 28DUKACITANYA DIMAKLUMKAN ANDA GAGAL DALAM PERMOHONAN TERSEBUT.UNTUK RAYUAN,SILA KLIK DI SINI [/codebox]bile sy check kat mysql,no_ic yg saya insert xsame dgn yg ader dlm database.pelik laa.utk no_ic tu saya wat sbg int .naper jadi camtu ye?tlg... Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted October 4, 2007 $sql = "SELECT nama, sekolah FROM berjaya WHERE no_ic = '".$no_ic." ' ";$rslt=mysql_query($sql);$nama=$_POST['nama'];[/codebox]bile sy wat camni,kuar data tp xsume.dan still ader error[codebox]Notice: Undefined variable: no_ic in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 18Notice: Undefined index: nama in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 24Notice: Undefined index: sekolah_pilih in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 28Tahniah,Anda Berjaya 820710036010 tapi bile saya tukar _post tu kpd _get,kuar error.Notice: Undefined variable: no_ic in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 18Notice: Undefined index: nama in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 24Notice: Undefined index: no_ic in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 26Notice: Undefined index: sekolah_pilih in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 28DUKACITANYA DIMAKLUMKAN ANDA GAGAL DALAM PERMOHONAN TERSEBUT.UNTUK RAYUAN,SILA KLIK DI SINI [/codebox]bile sy check kat mysql,no_ic yg saya insert xsame dgn yg ader dlm database.pelik laa.utk no_ic tu saya wat sbg int .naper jadi camtu ye?tlg...apasal aku terasa ni macam masalah dengan easyPHP bukan coding dia. amin? apa pendapat kau? Melainkan dia tak post code yang sepenuhnya Quote Share this post Link to post Share on other sites
amin007 1 Report post Posted October 4, 2007 (edited) apasal aku terasa ni macam masalah dengan easyPHP bukan coding dia. amin? apa pendapat kau? Melainkan dia tak post code yang sepenuhnya aku pun rasa benda yg sama mcm ko rasa shidicrv82 , apa kata ko copy contoh shidi buat nifail no_ic.php<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> Nombor IC: <input type="text" name="no_ic"/> <input type="submit" name="submit" value="Periksa" /> </form> <?php if (isset($_POST['submit'])) { $no_ic = (int)$_POST['no_ic']; //pastikan hanya nombor yang dimasukkan sebagai no IC. if (!empty($no_ic)) { $conn =mysql_connect('localhost','root',''); // sambungan mysql_select_db("pemohon",$conn);//pilih database $sql = "SELECT nama, sekolah, alamat FROM pelajar WHERE no_ic = '".$no_ic."'"; list($nama, $sekolah, $alamat) = mysql_fetch_array($sql); if (!empty($nama)) {echo "Rekod Ditemui:<br />No IC: ".$no_ic."<br />Nama: ".$nama."<br />Sekolah: ".$sekolah."<br />Alamat: ".$alamat;} else {echo "Tiada Rekod Ditemui";} } else{echo "Nombor IC tidak sah";} } ?> lepas tu cuba paste kat sini apa outputnya. kalau keluar juga mcm Notice: Undefined variable: no_ic in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 18 Notice: Undefined index: nama in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 24 Notice: Undefined index: no_ic in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 26 Notice: Undefined index: sekolah_pilih in c:\program files\easyphp1-8\www\yik\action_checkin.php on line 28maknanya easyphp ko tu ada masalah.kalau tak, maknanya koding ko buat tu tak betul laa.nak selamat, koding ko jangan pakai langsungpakai shidi punya.tengok apa akan jadi Edited October 7, 2007 by amin007 Quote Share this post Link to post Share on other sites
crv82 0 Report post Posted October 5, 2007 ni error yg kuar bile sy copy koding shidiWarning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\program files\easyphp1-8\www\yik\aminshidi.php on line 27Tiada Rekod Ditemui [/codebox] maksudnyer skarang ni koding sy masalah ek?ni keseluruhan koding sy[codebox]<form id="form1" name="form1" method="post" action="try.php"> <div align="center"> <p align="center"><span class="style4">SILA MASUKKAN NOMBOR KAD PENGENALAN</span> <span class="style11"> <input name="no_ic" type="text" id="no_ic" /> </span><span class="style8"> </span> <span class="style9"><br /> </span><br /> <input type="submit" name="Submit" value="HANTAR" />=;try.php<? // sambungan $conn =mysql_connect('localhost','root','');//pilih databasemysql_select_db("pemohon",$conn);//arahan sql$sql="select * from berjaya where no_ic= $_GET['no_ic']";$rslt=mysql_query($sql);$rows = mysql_num_rows($rslt); // cari bilangan baris$nama=$_GET['nama'];$no_ic=$_GET['no_ic'];$sekolah=$_GET['sekolah_pilih'];// nak cari $rows//if (!empty($no_ic)){echo " Tahniah,Anda Berjaya";echo " <br> ";echo " <br> ";echo " $no_ic ";echo " $nama ";echo " $sekolah";include ("berjaya.php");}else {include("gagal.php");echo " <br> ";} ?>[/codebox]koding ni silap eh?? Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted October 5, 2007 (edited) Erk... baru perasan coding aku ada silap. Ni la akibatnya coding tanpa testing Silap kat line nieh:$sql = "SELECT nama, sekolah, alamat FROM pelajar WHERE no_ic = '".$no_ic."'"; list($nama, $sekolah, $alamat) = mysql_fetch_array($sql); Ubah kepada: $sql = "SELECT nama, sekolah, alamat FROM pelajar WHERE no_ic = '".$no_ic."'"; $query = mysql_query($sql) or die("MySQL Error: ".mysql_error()); list($nama, $sekolah, $alamat) = mysql_fetch_array($query); Tengok apa jadi lak. Btw aku tengok kau ada ubah gak coding aku nieh. Agak pelik gak ah EDIT: Lagi sekali aku nak tanya, apa sebab kau retrieve data daripada Database tapi assign value berdasarkan $_GET[]? // cari bilangan baris $nama=$_GET['nama']; $no_ic=$_GET['no_ic']; $sekolah=$_GET['sekolah_pilih']; Nilai daripada db langsung tak digunakan pun dalam coding kau. Dan ada kesilapan dalam SQL kau: $sql="select * from berjaya where no_ic= $_GET['no_ic']"; Kan dalam form tu dah pilih method="post" kenapa guna $_GET[] pula? $sql="SELECT * FROM berjaya WHERE no_ic = '".$_POST['no_ic']."'"; Aku tak faham logik dalam barisan ni: $rows = mysql_num_rows($rslt);Kenapa kau ada buat query nie? Untuk kira baris. Tapi tak nampak pun if statement atau apa pun yang gunakan $rows tu. Edited October 5, 2007 by SHiDi Quote Share this post Link to post Share on other sites
amin007 1 Report post Posted October 5, 2007 crv82, koding ko memang silapko sepatutnya ambil data hasil dari sql.data dlm bentuk $_POST[] atau $_GET[]datang dari form/borangbukan dari sqlkalau nak ambil data dari sqlbuat mcm ni$sql = "SELECT nama, sekolah, alamat FROM pelajar WHERE no_ic = '".$no_ic."'"; $query = mysql_query($sql) or die("MySQL Error: ".mysql_error()); list($nama, $sekolah, $alamat) = mysql_fetch_array($query);dengan lain perkataan data datang dari mysql_fetch_array($query)bukan dari $_POST[] atau $_GET[]silap konsep laa ko pakaishidi, aku pun tak perasan ko punya koding silap hehehe main copy ko punya, aku pun tak cek betul2 Quote Share this post Link to post Share on other sites
SHiDi 0 Report post Posted October 6, 2007 (edited) data dlm bentuk $_POST[] atau $_GET[]datang dari form/borangbukan dari sqlErk, kurang tepat tu. Untuk form kita gunakan $_POST[] dan $_REQUEST[]. $_GET[] pula digunakan untuk handle query. Contohnya: http://webaddress.com/index.php?query=test.So bila nak check atau validation boleh gunakan:$query = $_GET['query'];Sekadar berkongsi pendapat Salah tolong betulkan ye EDIT: @crv82 boleh tak gunakan tag code bukan codebox. Pasal tag codebox tu memang tak wujud. Edited October 6, 2007 by SHiDi Quote Share this post Link to post Share on other sites
crv82 0 Report post Posted October 7, 2007 <form action="action_check33.php" method="post"> <p> </p> <p align="center"><span class="style2">Masukkan Nombor IC Anda </span>: <input type="text" name="no_ic"/> <br /> <br /> <input type="submit" name="submit" value="Hantar" /> </p> <p> </p> <p> </p> </form> action_check33.php <?php if (isset($_POST['submit'])) { $no_ic = (int)$_POST['no_ic']; //pastikan hanya nombor yang dimasukkan sebagai no IC. if (!empty($no_ic)) { $conn =mysql_connect('localhost','root',''); // sambungan mysql_select_db("pemohon",$conn);//pilih database $sql = "SELECT nama, sekolah_pilih, alamat FROM pelajar WHERE no_ic = '".$no_ic."'"; $query = mysql_query($sql) or die("MySQL Error: ".mysql_error()); list($nama, $sekolah_pilih, $alamat) = mysql_fetch_array($query); if (!empty($nama)) { echo " Tahniah,Anda Berjaya"; echo " <br> "; echo " $no_ic "; echo " $nama "; echo " $sekolah"; echo " $alamat "; include ("berjaya.php"); } else { include("gagal.php"); } } else { echo "Nombor IC tidak sah"; } } ?>koding atas dah ok,xkuar error dah.tenkiu amin n shidi... Quote Share this post Link to post Share on other sites
crv82 0 Report post Posted October 7, 2007 CODE $sql = "SELECT nama, sekolah, alamat FROM pelajar WHERE no_ic = '".$no_ic."'"; $query = mysql_query($sql) or die("MySQL Error: ".mysql_error()); list($nama, $sekolah, $alamat) = mysql_fetch_array($query); ooo..rupanya cara2 nak amik data dr dbase guna koding atas ni ekk... sy masih konpius lagi ni...pasal assign value tu...nama2 mcm nama,sekolah,alamat tu kena sama ngan nama dlm field dlm mysql ek? if (isset($_POST['submit']))yg ni lak,aper maksud die?dah google tp kurang phm Quote Share this post Link to post Share on other sites
amin007 1 Report post Posted October 7, 2007 Erk, kurang tepat tu. Untuk form kita gunakan $_POST[] dan $_REQUEST[]. $_GET[] pula digunakan untuk handle query. Contohnya: http://webaddress.com/index.php?query=test.So bila nak check atau validation boleh gunakan:$query = $_GET['query'];Sekadar berkongsi pendapat Salah tolong betulkan ye EDIT: @crv82 boleh tak gunakan tag code bukan codebox. Pasal tag codebox tu memang tak wujud.shidi, untuk form kita boleh set post atau get kat method<form action="action_check33.php" method="post"> aatau <form action="action_check33.php" method="get">jadi nilai $_GET[] boleh dapat dari fom atau link.hasilnya sama ajeko baca topik ni - http://www.php.net.my/forum/thread.php/9/1105/1) GET lazimnya untuk mendapatkan data, makala POST boleh digunakan untuk apa sahaja seperti mengemaskini data, memesan arangan atau menghantar email.2) GET menghantar data melalui URL, maka keselamatanya diragui. URL ini akan tersimpan dalam browser's History dan sesiapa juga boleh membukanya semula. Sedangkan POST mencipta sambungan ke HTTP dan kemudian menghantar data ke server - tiada dalam History.3) GET tak boleh hantar data yang besar kerana saiz URL cuma 256 character. POST boleh menghantar apa jua termasuk fail yang besar seperti binari dan zip.satu lagi link pasal ni - http://www.cs.tut.fi/~jkorpela/forms/methods.htmlcrv82, pasal if (isset($_POST['submit]))ni linknya - http://www.php.net/manual/en/function.isset.phptu cuma nak cari nilai $_POST[submit] tu sama ada true atau falsepasal assign value tu...nama2 mcm nama,sekolah,alamat tu kena sama ngan nama dlm field dlm mysql ek?tu kena tanya shidi sebab dia yg buat. ada banyak cara nak assign value dari mysql.yg dia buat tu salah satu cara.pasal nama tu kena sama tu takde kaitan,takut nanti ko pening pulak pakai value lain. Quote Share this post Link to post Share on other sites
crv82 0 Report post Posted October 7, 2007 saya ada satu lagi masalah....pasal mysql ni....bile saye insert data dalam mysql...dlm kes sy ni sy nak insert no_ic.lepas insert,bile saya check dlm table,xsama ngan data yg saya masukkan.naper jadi camtu ek?3 kali insert,nombor yg kuar lain tpi nilai sama.cth sy masukkan no_ic 830810045676.bile check dlm table,kuar nombor ni 2147483647.bile saya insert no_ic yg lain,nombor ni jgk yg kuar.pelik laa.....aper masalahnye ye?xpaham laa.tlg.. Quote Share this post Link to post Share on other sites