sue_irna 1 Report post Posted June 6, 2010 (edited) hi...sesapa yang biasa buat php, harap dapat membantu menyelesaikan error yang saya ada ni... Notice: Undefined index: add in D:\xampplite\htdocs\Login\peperiksaan\ add-delete-update\add.php on line 4 Notice: Undefined index: msg in D:\xampplite\htdocs\Login\peperiksaan\ add-delete-update\add.php on line 47 Saya tak tau cam mana nak define index : add tu...dalam page ni..sepatutnya dia akan display data dari database dalam textfield (bentuk borang) dalam page yg sama saya boleh mengemaskini data yang ada tu... Code saya ialah dalam file : update.php [code]<?php include_once ("config.php"); if($_GET['update']) { //$PengawasID = mysql_real_escape_string($_POST['PengawasID']); $Nama = mysql_real_escape_string($_POST['Nama']); $KP = mysql_real_escape_string($_POST['KP']); $Jawatan = mysql_real_escape_string($_POST['Jawatan']); $Gred = mysql_real_escape_string($_POST['Gred']); $Tlantik = mysql_real_escape_string($_POST['Tlantik']); $Tsah = mysql_real_escape_string($_POST['Tsah']); $alamat = mysql_real_escape_string($_POST['alamat']); $poskod = mysql_real_escape_string($_POST['poskod']); $bandar = mysql_real_escape_string($_POST['bandar']); $notel = mysql_real_escape_string($_POST['notel']); $nofax = mysql_real_escape_string($_POST['nofax']); $nohp1 = mysql_real_escape_string($_POST['nohp1']); $query = mysql_query("UPDATE pengawas SET `Nama`= '$Name', `kp`= '$KP',`Jawatan`='$jawatan', `Gred`='$gred', `Tlantik`='$lantik1', `Tsah`= '$sah1',`alamat`= '$alamat', `poskod`= '$poskod', `notel`= '$notel', `nofax`= '$notelp', `nohp1`= '$hp'")or die('Error : ' . mysql_error()); header("Location: update.php?PengawasID=$PengawasID&msg=done"); exit; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" > <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>DBexam</title> <style type="text/css"> <!-- .style1 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; } .style2 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 16px; color: #333333; } --> </style> </head> <body> <h2 align="center" class="style2">Kemaskini Maklumat Pengawas </h2> <p> <?php if ($_GET['msg']) { echo "<p style=\"color:#FF0000\"><strong> Your content has been updated!</strong></p>"; } $show = "SELECT * FROM pengawas WHERE PengawasID='$_GET[PengawasID]'"; $result = mysql_query($show); while ($show = mysql_fetch_array ($result)) { //$PengawasID = $show['PengawasID']; $Name = $show['Nama']; $kp = $show['KP']; $jawatan = $show['Jawatan']; $gred = $show['Gred']; $lantik1 = $show['Tlantik']; $sah1 = $show['Tsah']; $alamat =$show['alamat']; $poskod = $show['poskod']; $bandar = $show['bandar']; $notel = $show['notel']; $notelp = $show['nofax']; $hp = $show['nohp1']; } ?> <form action="update.php?update=yes" method="post"> <table width="99%" border="0" cellspacing="1" cellpadding="1"> <tr> <th width="34%" class="text" scope="row"><div align="left" class="style1">Nama:</div></th> <td width="66%"> <input name="name" type="text" id="name" value="<?php echo $Nama; ?>"/> </td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No.Kad Pengenalan :</div></th> <td><input name="kp" type="text" value="<?php echo $KP; ?>" /> <label></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Jawatan : </div></th> <td><label> <input name="jawatan" type="text" id="jawatan" value="<?php echo $Jawatan;?>" /> </label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Gred Jawatan </div></th> <td><label> <input name="gred" type="text" value="<?php echo $Gred;?>" /> </label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Tarikh dilantik ke jawatan sekarang : </div></th> <td><label> <input name="lantik1" type="text" value="<?php echo $Tlantik;?>" /> </label> <label></label> <label></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Tarikh disahkan ke jawatan sekarang :</div></th> <td><label> <input name="sah1" type="text" value="<?php echo $Tsah;?>" /> </label> <label></label> <label></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Alamat tempat bertugas : </div></th> <td><label> <input name="alamat" type="text" value="<?php echo $alamat;?>" /> Poskod <input name="poskod" type="text" value="<?php echo $poskod;?>" /> Bandar : <input name="bandar" type="text" value="<?php echo $$bandar;?>" /> </label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No Telefon Pejabat : </div></th> <td><label> <input name="notel" type="text" value="<?php echo $notel;?>" /> </label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No Faks Pejabat : </div></th> <td><label> <input name="notelp" type="text" value="<?php echo $nofax;?>" /> </label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No Telefon Bimbit : </div></th> <td><label> <input name="textfield16" value="<?php echo $nohp1;?>" /> </label></td> </tr> <tr> <th scope="row"> </th> <td><input type="submit" name="Submit" value="Update" /> <input type="hidden" value="<?php echo $PengawasID; ?>" name="PengawasID"> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> </table> </form> <p> </p> </body> </html>[/code] Edited June 13, 2010 by Null code snippet Quote Share this post Link to post Share on other sites
slier 28 Report post Posted June 6, 2010 erro biasa je tu leh ignore je try letak menda ni kt top script ko [code]error_reporting(E_ALL ^ E_NOTICE);[/code] Quote Share this post Link to post Share on other sites
mrpixel05 1 Report post Posted June 6, 2010 (edited) Satu lg...cube blaja paste koding yg berjela2 tuh dlm tage kod...brlah taj sakit mata tgk .. no offense ...just my 0.02 bath ...Satu lg mcm aku rather suke tgk run-time error berserta dgn compile-time error...sbbnya tknak masalah2 kemudian hari timbul... tumpang lalu sy budak br blaja.. Edited June 6, 2010 by mrpixel05 Quote Share this post Link to post Share on other sites
sue_irna 1 Report post Posted June 6, 2010 o iyer ke..kena ignore je error tu?... kat file config.php saya letak code ni... ini_set('display_errors', 1); error_reporting(E_ALL); itu yang kuar error tu...tapi bila i letak code yang dicadangkan error tu x kuar lg arr...apa maksud error_reporting(E_ALL ^ E_NOTICE);? tapi dalam page aku ni mmg ada masalah...dia tak display record kat databse...record tu x kuar dlm textfield...x tau dimana silapnya...harap2 korang2 bole bantu saya membetulkan... klu perhati kat page ni..dia ada update query...lepas tu ada select query.. Quote Share this post Link to post Share on other sites
slier 28 Report post Posted June 6, 2010 klu ko bg maklumat yg lengkap senang je nak tolong xda file config.php xda file add.php Quote Share this post Link to post Share on other sites
sue_irna 1 Report post Posted June 8, 2010 (edited) [quote name='slier' date='06 June 2010 - 09:59 PM' timestamp='1275832742' post='1035250'] klu ko bg maklumat yg lengkap senang je nak tolong xda file config.php xda file add.php [/quote] ok..macam ni..ada 4 file...skg ni masalah saya ialah ...bila ke page update...dia tak boleh display record dalam database...so klu x display macam mana update record kan... File add.php..berfungsi dengan baik...cuma kena check kat view.php dan update.php. Saya harap sgt korang2 dapat membantu. config.php [code] <?php error_reporting(E_ALL ^ E_NOTICE); //ini_set('display_errors', 1); //error_reporting(E_ALL); define('DB_HOST', 'localhost'); define('DB_USER', 'root'); define('DB_PASSWORD', 'xxxxx'); define('DB_DATABASE', 'peperiksaan'); $connect = mysql_connect('localhost','root', 'xxxxx') or die("Cannot connect to the database"); mysql_select_db(peperiksaan) or die("Cannot select the database"); ?> Add.php <?php include_once ("config.php"); if ($_GET['add']) { $txtname = mysql_real_escape_string($_POST['Nama']); $txtkp = mysql_real_escape_string($_POST['KP']); $selectjawatan = mysql_real_escape_string($_POST['Jawatan']); $selectgred = mysql_real_escape_string($_POST['Gred']); $datum1 = mysql_real_escape_string($_POST['Tlantik']); $datum2 = mysql_real_escape_string($_POST['Tsah']); $txtalamat = mysql_real_escape_string($_POST['alamat']); $txtkod = mysql_real_escape_string($_POST['poskod']); $selectcity = mysql_real_escape_string($_POST['bandar']); $txtnotel = mysql_real_escape_string($_POST['notel']); $txtfaks = mysql_real_escape_string($_POST['nofax']); $nohp = mysql_real_escape_string($_POST['nohp1']); $query = "INSERT INTO pengawas (Nama, KP, Jawatan, Gred, Tlantik, Tsah, alamat, poskod, bandar, notel,nofax, nohp1) VALUES('$_POST[txtname]','$_POST[txtkp]','$_POST[selectjawatan]','$_POST[selectgred]','$_POST[datum1]','$_POST[datum2]','$_POST[txtalamat]','$_POST[txtkod]','$_POST[selectcity]','$_POST[txtnotel]','$_POST[txtfaks]','$_POST[nohp]')"; $result = mysql_query($query); if (!$result) { $errormessage = mysql_error(); echo "Error with query: " . $errormessage; exit(); } header('Location: add.php?msg=done'); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>DBexam</title> <script language="javaScript" type="text/javascript" src="calendar.js"></script> <link href="calendar.css" rel="stylesheet" type="text/css"> </head> <body> <link href="../../css/text.css" rel="stylesheet" type="text/css" /> <p class="style1"><a href="add.php"></a> <?php if ($_GET['msg']) { echo "<p style=\"color:#FF0000\"><strong>Maklumat pengawas telah ditambah!</strong></p>"; } ?> </p> <!-- Calender Script --> <table id="calenderTable"> <tbody id="calenderTableHead"> <tr> <td colspan="4" align="center"> <select onChange="showCalenderBody(createCalender(document.getElementById('selectYear').value, this.selectedIndex, false));" id="selectMonth"> <option value="0">Jan</option> <option value="1">Feb</option> <option value="2">Mar</option> <option value="3">Apr</option> <option value="4">May</option> <option value="5">Jun</option> <option value="6">Jul</option> <option value="7">Aug</option> <option value="8">Sep</option> <option value="9">Oct</option> <option value="10">Nov</option> <option value="11">Dec</option> </select> </td> <td colspan="2" align="center"> <select onChange="showCalenderBody(createCalender(this.value, document.getElementById('selectMonth').selectedIndex, false));" id="selectYear"> </select> </td> <td align="center"> <a href="#" onClick="closeCalender();"><font color="#003333" size="+1">X</font></a> </td> </tr> </tbody> <tbody id="calenderTableDays"> <tr style=""> <td>Sun</td><td>Mon</td><td>Tue</td><td>Wed</td><td>Thu</td><td>Fri</td><td>Sat</td> </tr> </tbody> <tbody id="calender"></tbody> </table> <!-- End Calender Script --> <form action="add.php?add=yes" method="post"> <table width="99%" border="0" cellpadding="1" cellspacing="1" class="text"> <tr> <th scope="row"><div align="left" class="style1">Nama:</div></th> <td><input name="txtname" type="text" id="txtname" pengawasid="Jawatan" /></td> </tr> <tr> <th scope="row"><div align="left" class="style1">No.Kad Pengenalan :</div></th> <td><input name="txtkp" type ="text" id="txtkp" size="12" maxlength="12" pengawasid="Gred" /> <label></label></td> </tr> <tr> <th scope="row"><div align="left" class="style1">Jawatan : </div></th> <td><label> <select name="selectjawatan" id="selectjawatan"> <option>---</option> <option>Pegawai Tadbir Diplomatik (M)</option> <option>Pegawai Tadbir (N)</option> <option>Penolong Pegawai Tadbir (N)</option> <option>Pegawai Teknologi Maklumat (F)</option> <option>Penolong Pegawai Teknologi Maklumat (F)</option> <option>Ketua Pembantu Tadbir (N)</option> <option>Pembantu Tadbir (PTPO)(N)</option> <option>Pembantu Tadbir Kewangan(W)</option> <option>Pembantu Tadbir Stor (N)</option> <option>Pegawai Khidmat Pelanggan (N)</option> </select> </label></td> </tr> <tr> <th scope="row"><div align="left" class="style1">Gred Jawatan </div></th> <td><label> <select name="selectgred" id="selectgred"> <option>---</option> <option>54</option> <option>52</option> <option>48</option> <option>44</option> <option>41</option> <option>38</option> <option>36</option> <option>32</option> <option>27</option> <option>22</option> <option>17</option> <option>11</option> <option>3</option> <option>1</option> </select> </label></td> </tr> <tr> <th scope="row"><div align="left" class="style1">Tarikh dilantik ke jawatan sekarang : </div></th> <td><label> <input type="datum1" name="datum1" /> <a href="#" onClick="setYears(1947, 2020); showCalender(this, 'datum1');"> <img src="calender.png"></a> </label></td> </tr> <tr> <th scope="row"><div align="left" class="style1">Tarikh disahkan ke jawatan sekarang :</div></th> <td><label> <input name="datum2" type="text" id="datum2" /> <a href="#" onclick="setYears(1947, 2020); showCalender(this, 'datum2');"><img src="calender.png" /></a></label></td> </tr> <tr> <th scope="row"><div align="left" class="style1">Alamat tempat bertugas : </div></th> <td><label> <input name="txtalamat" type="text" id="txtalamat" /> Poskod: <input name="txtkod" type="text" id="txtkod" size="5" maxlength="5" /> </label></td> </tr> <tr> <th scope="row"><div align="left">Bandar : </div></th> <td><select name="selectcity" id="selectcity"> <option>Kota Kinabalu</option> <option>Sandakan</option> <option>Tawau</option> <option>Kunak</option> <option>Lahad Datu</option> <option>Semporna</option> <option>Keningau</option> <option>Kudat</option> <option>Kota Merudu</option> <option>Kota Belud</option> <option>Penampang</option> <option>Inanam</option> <option>Luyang</option> </select></td> </tr> <tr> <th scope="row"><div align="left" class="style1">No Telefon Pejabat : </div></th> <td><label> <input name="txtnotel" type="text" id="txtnotel" /> </label></td> </tr> <tr> <th scope="row"><div align="left" class="style1">No Faks Pejabat : </div></th> <td><label> <input name="txtfaks" type="text" id="txtfaks" /> </label></td> </tr> <tr> <th scope="row"><div align="left" class="style1">No Telefon Bimbit : </div></th> <td><label> <input name="nohp" type="text" id="nohp" /> </label></td> </tr> <tr> <th scope="row"><div align="left"></div></th> <td> </td> </tr> <tr> <th scope="row"><div align="left"></div></th> <td><input type="submit" name="Submit" value="Add" /></td> </tr> </table> </form> <p> </p> </body> </html> View.php <?php include_once ("config.php"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <style type="text/css"> <!-- .style1 {font-family: Verdana, Arial, Helvetica, sans-serif} .style5 {color: #FFFFFF; font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; } .text { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-style: normal; font-weight: normal; color: #333333; } --> </style> </head> <body> <h2 align="center" class="style1">Maklumat Pengawas </h2> <table width="96%" border="0" cellspacing="1" cellpadding="1"> <tr> <th width="18%" bgcolor="#333300"><div align="left" class="style5">Nama</div></th> <th width="17%" bgcolor="#333300"><div align="left" class="style5">No.Kad Pengenalan </div></th> <th width="26%" bgcolor="#333300"><div align="left" class="style5">Jawatan</div></th> <th width="13%" bgcolor="#333300"><div align="left" class="style5">Gred </div></th> <th width="15%" bgcolor="#333300"><div align="left" class="style5">Alamat bertugas </div></th> <th width="11%" bgcolor="#333300"><div align="left" class="style5">Update</div></th> </tr> </table> <?php $show = "SELECT * FROM pengawas ORDER BY Nama ASC"; $result = mysql_query($show); while ($show = mysql_fetch_array ($result)) { $PengawsID= $show[PengawasID]; $Nama= $show[Nama]; $KP= $show[KP]; $Jawatan= $show[Jawatan]; $Gred= $show[Gred]; $alamat=$show[alamat]; ?> <table width="97%" border="0" cellpadding="1" cellspacing="1" class="text"> <tr> <td width="18%"><p align="left"><?php echo $Nama; ?></p></td> <td width="17%"><p align="left"><?php echo $KP; ?></p></td> <td width="25%"><p align="left"><?php echo $Jawatan; ?></p></td> <td width="13%"><p align="left"><?php echo $Gred; ?></p></td> <td width="15%"><p align="left"><?php echo $alamat; ?></p></td> <td width="12%"><p align="left"><a href="update.php?ID=<?php echo $PengawasID; ?>">Update</a> </p></td> </tr> </table> <?php } ?> <p> </p> </body> </html> update.php <?php include_once ("config.php"); if($_GET['PengawasID']) { //$PengawasID = mysql_real_escape_string($_POST['PengawasID']); $Nama = mysql_real_escape_string($_POST['Nama']); $KP = mysql_real_escape_string($_POST['KP']); $Jawatan = mysql_real_escape_string($_POST['Jawatan']); $Gred = mysql_real_escape_string($_POST['Gred']); $Tlantik = mysql_real_escape_string($_POST['Tlantik']); $Tsah = mysql_real_escape_string($_POST['Tsah']); $alamat = mysql_real_escape_string($_POST['alamat']); $poskod = mysql_real_escape_string($_POST['poskod']); $bandar = mysql_real_escape_string($_POST['bandar']); $notel = mysql_real_escape_string($_POST['notel']); $nofax = mysql_real_escape_string($_POST['nofax']); $nohp1 = mysql_real_escape_string($_POST['nohp1']); $query = mysql_query("UPDATE pengawas SET `Nama`= '$Name', `kp`= '$KP',`Jawatan`='$jawatan', `Gred`='$gred', `Tlantik`='$lantik1', `Tsah`= '$sah1',`alamat`= '$alamat', `poskod`= '$poskod', `notel`= '$notel', `nofax`= '$notelp', `nohp1`= '$hp'")or die('Error : ' . mysql_error()); header("Location: update.php?ID=$PengawasID&msg=done"); exit; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" > <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>DBexam</title> <style type="text/css"> <!-- .style1 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; } .style2 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 16px; color: #333333; } --> </style> </head> <body> <h2 align="center" class="style2">Kemaskini Maklumat Pengawas </h2> <p> <?php if ($_GET['msg']) { echo "<p style=\"color:#FF0000\"><strong> Your content has been updated!</strong></p>"; } $show = "SELECT * FROM pengawas WHERE PengawasID='$_GET[PengawasID]'"; $result = mysql_query($show); while ($show = mysql_fetch_array ($result)) { //$PengawasID = $show['PengawasID']; $Name = $show['Nama']; $kp = $show['KP']; $jawatan = $show['Jawatan']; $gred = $show['Gred']; $lantik1 = $show['Tlantik']; $sah1 = $show['Tsah']; $alamat =$show['alamat']; $poskod = $show['poskod']; $bandar = $show['bandar']; $notel = $show['notel']; $notelp = $show['nofax']; $hp = $show['nohp1']; } ?> <form action="update.php?update=yes" method="post"> <table width="99%" border="0" cellspacing="1" cellpadding="1"> <tr> <th width="34%" class="text" scope="row"><div align="left" class="style1">Nama:</div></th> <td width="66%"> <input name="name" type="text" id="name" value="<?php echo $Nama; ?>"/> </td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No.Kad Pengenalan :</div></th> <td><input name="kp" type="text" value="<?php echo $KP; ?>" /> <label></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Jawatan : </div></th> <td><label> <input name="jawatan" type="text" id="jawatan" value="<?php echo $Jawatan;?>" /> </label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Gred Jawatan </div></th> <td><label> <input name="gred" type="text" value="<?php echo $Gred;?>" /> </label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Tarikh dilantik ke jawatan sekarang : </div></th> <td><label> <input name="lantik1" type="text" value="<?php echo $Tlantik;?>" /> </label> <label></label> <label></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Tarikh disahkan ke jawatan sekarang :</div></th> <td><label> <input name="sah1" type="text" value="<?php echo $Tsah;?>" /> </label> <label></label> <label></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Alamat tempat bertugas : </div></th> <td><label> <input name="alamat" type="text" value="<?php echo $alamat;?>" /> Poskod <input name="poskod" type="text" value="<?php echo $poskod;?>" /> Bandar : <input name="bandar" type="text" value="<?php echo $$bandar;?>" /> </label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No Telefon Pejabat : </div></th> <td><label> <input name="notel" type="text" value="<?php echo $notel;?>" /> </label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No Faks Pejabat : </div></th> <td><label> <input name="notelp" type="text" value="<?php echo $nofax;?>" /> </label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No Telefon Bimbit : </div></th> <td><label> <input name="textfield16" value="<?php echo $nohp1;?>" /> </label></td> </tr> <tr> <th scope="row"> </th> <td><input type="submit" name="Submit" value="Update" /> <input type="hidden" value="<?php echo $PengawasID; ?>" name="PengawasID"> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> </table> </form> <p> </p> </body> </html>[/code] Edited June 13, 2010 by Null code snippet Quote Share this post Link to post Share on other sites
slier 28 Report post Posted June 8, 2010 (edited) well aku tgk ok jer file view.php.. ko sure ke ada data dlm table pengawas ni kod yg utk update.php terlalu banyak error [code] <?php include_once ("config.php"); if(!$_POST) { if($_GET['ID']) { $show = "SELECT * FROM pengawas WHERE PengawasID='$_GET[ID]'"; $result = mysql_query($show); while($show = mysql_fetch_array ($result)) { $pengawas_id = $show['PengawasID']; $name = $show['Nama']; $kp = $show['KP']; $jawatan = $show['Jawatan']; $gred = $show['Gred']; $lantik = $show['Tlantik']; $sah = $show['Tsah']; $alamat = $show['alamat']; $poskod = $show['poskod']; $bandar = $show['bandar']; $no_tel = $show['notel']; $no_fax = $show['nofax']; $no_hp = $show['nohp1']; } } else { exit('No id has been detected'); } } else { $PengawasID = mysql_real_escape_string($_POST['pengawas_id']); $Nama = mysql_real_escape_string($_POST['name']); $KP = mysql_real_escape_string($_POST['kp']); $Jawatan = mysql_real_escape_string($_POST['jawatan']); $Gred = mysql_real_escape_string($_POST['gred']); $Tlantik = mysql_real_escape_string($_POST['lantik']); $Tsah = mysql_real_escape_string($_POST['sah']); $alamat = mysql_real_escape_string($_POST['alamat']); $poskod = mysql_real_escape_string($_POST['poskod']); $bandar = mysql_real_escape_string($_POST['bandar']); $notel = mysql_real_escape_string($_POST['no_tel']); $nofax = mysql_real_escape_string($_POST['no_fax']); $nohp = mysql_real_escape_string($_POST['no_hp']); $query = mysql_query("UPDATE pengawas SET `Nama`= '$Name', `kp`= '$KP',`Jawatan`='$jawatan', `Gred`='$gred', `Tlantik`='$lantik1', `Tsah`= '$sah1',`alamat`= '$alamat', `poskod`= '$poskod', `notel`= '$notel', `nofax`= '$notelp', `nohp1`= '$hp' WHERE PengawasID = $PengawasID")or die('Error : ' . mysql_error()); if($query) { header("Location: update.php?ID=$PengawasID&msg=done"); exit; } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd" > <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>DBexam</title> <style type="text/css"> <!-- .style1 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; } .style2 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 16px; color: #333333; } --> </style> </head> <body> <h2 align="center" class="style2">Kemaskini Maklumat Pengawas </h2> <p> <?php if($_GET['msg']) { echo "<p style=\"color:#FF0000\"><strong> Your content has been updated!</strong></p>"; } ?> <form action="update.php" method="post"> <table width="99%" border="0" cellspacing="1" cellpadding="1"> <tr> <th width="34%" class="text" scope="row"><div align="left" class="style1">Nama:</div></th> <td width="66%"><input name="name" type="text" id="name" value="<?php echo $name; ?>"/></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No.Kad Pengenalan :</div></th> <td><input name="kp" type="text" value="<?php echo $kp; ?>" /><label></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Jawatan : </div></th> <td><label><input name="jawatan" type="text" id="jawatan" value="<?php echo $jawatan;?>" /></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Gred Jawatan </div></th> <td><label><input name="gred" type="text" value="<?php echo $gred;?>" /></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Tarikh dilantik ke jawatan sekarang : </div></th> <td><label><input name="lantik" type="text" value="<?php echo $lantik;?>" /></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Tarikh disahkan ke jawatan sekarang :</div></th> <td><label><input name="sah" type="text" value="<?php echo $sah;?>" /></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">Alamat tempat bertugas : </div></th> <td> <label> <input name="alamat" type="text" value="<?php echo $alamat;?>" /> Poskod : <input name="poskod" type="text" value="<?php echo $poskod;?>" /> Bandar : <input name="bandar" type="text" value="<?php echo $bandar;?>" /> </label> </td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No Telefon Pejabat : </div></th> <td><label><input name="no_tel" type="text" value="<?php echo $no_tel;?>" /></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No Faks Pejabat : </div></th> <td><label><input name="no_fax" type="text" value="<?php echo $no_fax;?>" /></label></td> </tr> <tr> <th class="text" scope="row"><div align="left" class="style1">No Telefon Bimbit : </div></th> <td><label><input name="no_hp" value="<?php echo $no_hp;?>" /></label></td> </tr> <tr> <th scope="row"> </th> <td> <input type="submit" name="Submit" value="Update" /> <input type="hidden" value="<?php echo $pengawas_id; ?>" name="pengawas_id"> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> <tr> <th scope="row"> </th> <td> </td> </tr> </table> </form> </body> </html> [/code] Edited June 8, 2010 by slier Quote Share this post Link to post Share on other sites
BasicCX 27 Report post Posted June 8, 2010 Itu dia sifu kita. Quote Share this post Link to post Share on other sites
sue_irna 1 Report post Posted June 9, 2010 bila run..No id has been detected. which part sepatutnya saya tukar yerk...table & field saya seperti dlm gambar yg saya attchkan.. http://www.4shared.com/photo/firS7DsA/phpmyadmin.html tq Quote Share this post Link to post Share on other sites
slier 28 Report post Posted June 9, 2010 [quote name='sue_irna' date='09 June 2010 - 11:13 PM' timestamp='1276096430' post='1036012'] bila run..No id has been detected. which part sepatutnya saya tukar yerk...table & field saya seperti dlm gambar yg saya attchkan.. http://www.4shared.com/photo/firS7DsA/phpmyadmin.html tq [/quote] aku suspect xda data dalam table pengawas gbr yg ko tunjuk tu gbr table structure.. ko try browse table tu..ada data ke Quote Share this post Link to post Share on other sites
sue_irna 1 Report post Posted June 9, 2010 [quote name='slier' date='09 June 2010 - 11:21 PM' timestamp='1276096862' post='1036015'] aku suspect xda data dalam table pengawas gbr yg ko tunjuk tu gbr table structure.. ko try browse table tu..ada data ke [/quote] Quote Share this post Link to post Share on other sites
sue_irna 1 Report post Posted June 9, 2010 ada...data ada dlm table pengawas tu...masalah saya kat view.php dan update.php tu...bila i view data (view.php) ada 1 link update kat situ..tapi dia tak bawa nilai ke page update.php..saya sharekan file berserta db..saya create db guna phpmyadmin.Klu u pakai phpmyadmin..boleh paste kan table tu dlm mysql>data http://www.4shared.com/file/vKObnP3o/add-update-deletephp.html harap u dapat membantu membetulkan... TQ Quote Share this post Link to post Share on other sites
johnburn 6 Report post Posted June 28, 2010 [quote name='sue_irna' date='06 June 2010 - 09:14 AM' timestamp='1275786873' post='1035156'] hi...sesapa yang biasa buat php, harap dapat membantu menyelesaikan error yang saya ada ni... Notice: Undefined index: add in D:\xampplite\htdocs\Login\peperiksaan\ add-delete-update\add.php on line 4 Notice: Undefined index: msg in D:\xampplite\htdocs\Login\peperiksaan\ add-delete-update\add.php on line 47 Saya tak tau cam mana nak define index : add tu...dalam page ni..sepatutnya dia akan display data dari database dalam textfield (bentuk borang) dalam page yg sama saya boleh mengemaskini data yang ada tu... Code saya ialah dalam file : update.php [/quote] gnti semua [b]if ($_GET['blabla'])[/b] jadi [b]if ([color="#0000FF"]isset[/color]($_GET['blabla']))[/b] nanti xkuar la undefined index pnya notice tu Quote Share this post Link to post Share on other sites