mysql - php mysqli prepared statement remove query issue -


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