cannot view data from MySQL
hello jooria
i'm beginner in php. last time i modify php script that need to set register_global ON but last week my website was hack by someone. so i turn OFF register_global. but now i cannot view data from MySQL. i try to modify but still not appear. here is my website link http://www.adap.com.my/infox.php?id=239 TQ for your time and for your help. i really appreciate. AZMI <?php include ("include/dbconnect.php"); //================================================== $sql = "SELECT * FROM $table WHERE id = '$id'"; $q = mysql_query($sql); $f = mysql_fetch_array($q); $sql = "UPDATE $table SET klik = klik+'1' WHERE id = '$id'"; mysql_query($sql); //================================================== if ('$id') { $result = mysql_query("SELECT * FROM $table WHERE id='$id' ",$db); $links = mysql_fetch_array($result); $id = $links["id"]; $tajuk = $links["tajuk"]; $kategori = $links["kategori"]; $tarikh = $links["tarikh"]; $penuh = $links["penuh"]; $tag = $links["tag"]; $linktag = $links["linktag"]; $sumber = $links["sumber"]; $tarikhkemaskini = $links["tarikhkemaskini"]; $klik = $links["klik"]; //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++// //FILTER BAD WORD //http://www.weberdev.com/get_example-3991.html //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++// include('filter.php'); // This will replace all bad words with their replacements.$any is 1 if it found any $result = Filter($penuh,1); //+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++// echo "<span class=titleadap>$tajuk </span><br>"; echo "<table width=97% border=0 cellspacing=0 cellpadding=0>"; echo "<tr>"; if ($tag=="" || $tag=="<br>") { echo "<td><span class=footer>$oleh $tarikh | <a href='segmen.php?kategori=$kategori' class='navblue'>$kategori</a></span></td>"; } else { echo "<td><span class=footer>$oleh $tarikh | <a href='$linktag' class='navblue'>$tag</a></span></td>"; } echo "</tr>"; echo "<tr>"; echo "<td><br><span class=content>$penuh<br><br></span></td>"; echo "</tr>"; if ($sumber=="") { echo ""; } else { echo "<tr>"; echo "<td><span class=content><b><font color=#FF0000>Penafian:</font> Artikel/Info ini disalin dari laman web <a href='$sumber' target='blank' class='navblue'>$sumber</a>. Pihak Portal Pendidikan tidak bertanggungjawab terhadap isi kandungannya.</b></span></td>"; echo "</tr>"; } echo "</table>"; echo "<br><font face=tahoma color=#666666 size=1><a href='javascript:back();' class='nav'>kembali ke laman utama</a></font>"; echo "<br><br><font face=tahoma color=#666666 size=1>entri ini sudah $klik kali dibaca</font>"; if ($tarikhkemaskini=="0" || $tarikhkemaskini=="") { echo ""; } else { echo "<br><font face=tahoma color=#333333 size=1>dikemaskini pada $tarikhkemaskini</font>"; } } else { echo "Mungkin ada kesilapan pada laman web ini."; echo "<a href='index.php'>Sila kembali ke bahagian utama.</a>"; } ?>
1 Answer
alhamdulillah. problem solved
i add this code. before this cannot detect id number. $id = $_GET[\'id\']; TQ for your help AZMI Posted: miecreation 1 of 1 people found this answer helpful. Did you? Yes No good word "alhamdulillah", and sorry for the long time you wait any help we here and use intval($_GET['id']) for more Security |
© Advanced Web Core. All rights reserved
are you sure that $table variable is set?
September 22, 2011