Lately I ve stumbled upon an error in a lib that used to work just fine, and I ll be damned if I can figure out where it is. The code sample is below, and I apologize for the debug stuff that s ...

I want to be able to make classes which extend the MySQLi class to perform all its SQL queries. $mysql = new mysqli( localhost , root , password , database ) or die( error connecting to the ...

I am familiar with using PHP to perform mySQL queries. However, I have been using reg exps as protection against injection attacks. After reading several questions/answers here on SO, I ve decided to ...

I want to set a variable to use in a mysqli query. This doesn t quite work. Prior to mysqli I used to set query calls. I played around with db->multi_query($sql) with no luck. Anyone out there ...

$query = "UPDATE kids_entry SET entries=? WHERE parentsemail=?"; $stmt1 = mysqli_prepare($connection, $query); mysqli_stmt_bind_param($stmt1, is ,$entries,$parentsemail); mysqli_execute($stmt1); if(...

I have a problem where my prepared statement appears to only be returning the number of rows returned rather than the value of the row. Below is my code. I did try google for this but it doesn t tell ...

I am trying to list out all records from a database that have not expired. i have a jobs listing site being developed, i have code to grab all the active job details from the database and list out. ...

I currently have a list of things to update in the given mysqli query: $insert = mysqli_query($db,"UPDATE `tbl_perms` SET `1` = " . mysqli_real_escape_string($db,$_POST[ permsA_1 ]) . " , `2` = ...