i have made page remove different elements of site, reason it's not working... event though set fmenu - integer, because is. when run code below, gives me:
fatal error: call member function bind_param() on non-object in c:\users\joonas\desktop\le kerouac\root\admin\remove.php on line 44
code(php):
include_once('../php/conndbprepared.php'); mysqli_set_charset($mysqli, 'utf8'); //anti mysql injection precautions $menu = mysqli_real_escape_string($mysqli, $menu); $sql = "remove menu fmenu = ?"; $stmt = $mysqli->prepare($sql); $stmt->bind_param("i", $menu); if($stmt->execute()) { $stmt->close(); echo ' <script type="text/javascript"> window.location.replace("../admin/admintable.php?page=main&message=removesuccessmenu"); </script> '; } else { echo ' <script type="text/javascript"> $(document).ready(function() { $("#screencover").slidetoggle("slow"); $("#closepopup").click(function() { $("#screencover").slidetoggle("slow"); settimeout(resetpage, 600); }); }); function resetpage() { window.location.replace("../admin/admintable.php?page=main"); } </script> <div id="screencover" style="display:none;"> <div id="popup"> <div id="closepopupmain"> <p id="closepopup"><a href="#">x</a></p> </div> <p id="failure">le menu n\'a pas éte enlevée! cause: erreur '.mysqli_errno($mysqli).": ".mysqli_error($mysqli).'</p> </div> </div>'; }
there no remove keyword in mysql, use delete :
delete menu fmenu = ?
Comments
Post a Comment