08. juni 2004 - 16:30
Der er
15 kommentarer og 1 løsning
hvorfor vil den ikke slette ?
hej. Hvorfor vil den ikke slette id'et i databasen ? <?php require("db.php"); ?> <div align="center" class="tekst_normal"> <p><br> <?php echo "<font class=tekst_fed>Slet alt <a href=?action=all>her.</a></font><br><br>"; if($action == "all") { mysql_query("DELETE FROM mp3"); echo "<font face=Verdana size=1>Alle Tagwall beskeder slettet!</font><br><br>"; } if($id) { mysql_query("DELETE FROM mp3 WHERE id='$id'"); echo "<b><font face=Verdana size=1>Varen blev slettet!</font></b><br><br>"; } echo "<table>\n"; $res = mysql_query("SELECT * from mp3 ORDER BY id DESC LIMIT 0, 100"); while($row = mysql_fetch_array($res)) { echo "<tr><td>"; echo "<table width='346' border='0' cellpadding='0' cellspacing='0'> <td height='26' colspan='4' background='../../images/top/menu3.jpg'><strong> $row[navn] </strong></td> </tr> <tr> <td height='67' colspan='3'> <p> $row[info] </p></td> <td width='103'><img src='$row[pic]' width='99' height='86'></td> </tr> <tr> <td background='../../images/knap/bottom.gif' width='22'><strong> <img src='../../images/knap/penge.gif' width='15' height='15'></strong></td> <td background='../../images/knap/bottom.gif' width='220'><strong>Pris: $row[pris] kr.</strong></td> <td background='../../images/knap/bottom.gif' width='1'> </td> <td width='103'><a href='?id=$row[id]'><img src='../pic/slet.gif' width='100' height='20' border='0'></a></td> </tr> </table>"; echo "</tr></td>\n"; } echo "</table>"; ?>
Annonceindlæg tema
Cloud & AI
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
Prøv at skriv: mysql_query("DELETE FROM mp3 WHERE id=".$id) or die(mysql_error());
der sker ingen ting overhovedet..
ikke engang error vil den skrive
--------------tilmp3.php-------------- <?php require("db.php"); $message = ''; if(isset($_POST['navn']) && isset($_POST['info'])) { $tid = date("d/m Y - H:i"); $_POST['navn'] = addslashes($_POST['navn']); $_POST['info'] = addslashes($_POST['info']); $_POST['pris'] = addslashes($_POST['pris']); mysql_query("INSERT INTO mp3 (navn, pic, info, pris) VALUES('$_POST[navn]', '$_POST[pic]', '$_POST[info]', '$_POST[pris]')") or die(mysql_error()); $message = "<div align='center' style='font: smaller Verdana, Geneva, Arial, Helvetica, sans-serif; color: black;'>Varen blev tilføjet.</div>"; } ?> <form action="mp3up.php" method="post" enctype="multipart/form-data"> <center><?=$message?></center> <div align="center"> <table border="0" cellspacing="0" cellpadding="0" width="417" height="165" class="tekst_normal"> <tr> <td height="19" colspan="3" class="menu" background="../pic/infomenu.jpg"> <font color="#000000"> <strong>Tilføj en ny Mp3-Afspiller</strong></font></td> </tr> <tr> <td><b>Navn : </b></td> <td colspan="2"> <input type="text" size="16" class="box" name="navn"></td> </tr> <tr> <td><strong>Pris :</strong></td> <td colspan="2"><input name="pris" type="text" class="box" id="pris" size="16"></td> </tr> <tr> <td><b>Billede :</b></td> <td colspan="2"><input name="pic" type="file" class="box" id="pic" size="16"></td> </tr> <tr> <td><b>Info :</b></td> <td colspan="2"><textarea name="info" cols="36" rows="5" class="box" id="info"></textarea></td> </tr> <tr> <td> </td> <td colspan="2"> </td> </tr> </table> <input type="submit" value="Tilføj vare" class="submit"> </div> </form> <br> <br> <table width="100%"> </table> <? mysql_close(); ?> ------------------mp3up.php------------------ <?php require("db.php"); ?> <div align="center" class="tekst_normal"> <p><br> <?php echo "<font class=tekst_fed>Slet alt <a href=?action=all>her.</a></font><br><br>"; if($action == "all") { mysql_query("DELETE FROM mp3"); echo "<font face=Verdana size=1>Alle Tagwall beskeder slettet!</font><br><br>"; } if($id) { mysql_query("DELETE FROM mp3 WHERE id='$id'"); echo "<b><font face=Verdana size=1>Varen blev slettet!</font></b><br><br>"; } echo "<table>\n"; $res = mysql_query("SELECT * from mp3 ORDER BY id DESC LIMIT 0, 100"); while($row = mysql_fetch_array($res)) { echo "<tr><td>"; echo "<table width='346' border='0' cellpadding='0' cellspacing='0'> <td height='26' colspan='4' background='../../images/top/menu3.jpg'><strong> $row[navn] </strong></td> </tr> <tr> <td height='67' colspan='3'> <p> $row[info] </p></td> <td width='103'><img src='$row[pic]' width='99' height='86'></td> </tr> <tr> <td background='../../images/knap/bottom.gif' width='22'><strong> <img src='../../images/knap/penge.gif' width='15' height='15'></strong></td> <td background='../../images/knap/bottom.gif' width='220'><strong>Pris: $row[pris] kr.</strong></td> <td background='../../images/knap/bottom.gif' width='1'> </td> <td width='103'><a href='?id=$row[id]'><img src='../pic/slet.gif' width='100' height='20' border='0'></a></td> </tr> </table>"; echo "</tr></td>\n"; } echo "</table>"; ?> --------------- Sådan ser filerne ud :'(
Men ellers er de nda vist ok: if($id) duer ikke .......................... if(isset($_GET["id"])) den duer ........................ og så brug or die (mysql_error()); ved alle query's, i hvert fald mens du tester!
Og så kan du jo prøve med flg. som det første: <?php ini_set('error_reporting', "E_ALL"); require("db.php"); ?>
nu siger den fejl på: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
08. juni 2004 - 17:58
#10
site update: <?php ini_set('error_reporting', "E_ALL"); require("db.php"); ?> <div align="center" class="tekst_normal"> <p><br> <?php if(isset($_GET["id"])) { mysql_query("DELETE FROM mp3 WHERE id=".$id) or die(mysql_error()); echo "<b><font face=Verdana size=1>Varen blev slettet!</font></b><br><br>"; } echo "<table>\n"; $res = mysql_query("SELECT * from mp3 ORDER BY id DESC LIMIT 0, 100"); while($row = mysql_fetch_array($res)) { echo "<tr><td>"; echo "<table width='346' border='0' cellpadding='0' cellspacing='0'> <td height='26' colspan='4' background='../../images/top/menu3.jpg'><strong> $row[navn] </strong></td> </tr> <tr> <td height='67' colspan='3'> <p> $row[info] </p></td> <td width='103'><img src='$row[pic]' width='99' height='86'></td> </tr> <tr> <td background='../../images/knap/bottom.gif' width='22'><strong> <img src='../../images/knap/penge.gif' width='15' height='15'></strong></td> <td background='../../images/knap/bottom.gif' width='220'><strong>Pris: $row[pris] kr.</strong></td> <td background='../../images/knap/bottom.gif' width='1'> </td> <td width='103'><a href='?id=$row[id]'><img src='../pic/slet.gif' width='100' height='20' border='0'></a></td> </tr> </table>"; echo "</tr></td>\n"; } echo "</table>"; ?>
08. juni 2004 - 18:32
#11
mysql_query("DELETE FROM mp3 WHERE id=".$id) or die(mysql_error()); -> mysql_query("DELETE FROM mp3 WHERE id='". $_GET["id"] ."'") or die(mysql_error());
08. juni 2004 - 18:58
#12
KANON det virker.. tusind tak for det !! gir du et svar og får points? ;D
08. juni 2004 - 19:07
#13
Jow da! :O) En anden ting: Brug gerne `mp3` altså ` til at omkranse de navne i din DB som du skal bruge. Så undgår du at der er opstår nogen misforståelser omkring hvad man vil. mysql_query("DELETE FROM `mp3` WHERE `id` ='". $_GET["id"] ."'") or die(mysql_error());
08. juni 2004 - 19:08
#14
nå, shit!
08. juni 2004 - 19:19
#15
du skal have mange tak :D
Vi tilbyder markedets bedste kurser inden for webudvikling