I was working on an edit user page and this error appeared: Fatal error: Uncaught PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match the number of tokens in C:\Program Files\xampp\htdocs\ecommerce\admin\members.php:115 Stack trace: #0 C:\Program Files\xampp\htdocs\ecommerce\admin\members.php(115): PDOStatement->execute(Array) #1 {main} thrown in C:\Program Files\xampp\htdocs\ecommerce\admin\members.php on line 115 <?php /* manage members page */… Read More Fatal error: Uncaught PDOException: SQLSTATE[HY093] (2)

I need to batch update balances of some users in members table, how should mysql query be? MembersArray = array(1,3,4); AmountToBeAdded = 10; members id. balance 1. 45 2. 15 3. 0 4. 120 5. 80 Thanks already for your help >Solution : UPDATE members SET balance = balance + 10 WHERE members.id IN(1,3,4)

I have connected to the db and able to update a record. I have a variable named "action" that is either "update" or "add". I use it in a switch statement to set my query to either "SELECT" or "INSERT". SELECT statement works. INSERT statement does not. I get this error on $pdo->execute($data). PHP Fatal… Read More Why deos PDO SELECT Work but BASIC INSERT fails?

I need to convert a while of a fetch of data in PDO into a for loop. The for loop don’t have to be a foreach but something like that: for($count = 0; ………; $count++){} How can i do that? My code now is: while ($row = $stmt -> fetch(PDO::FETCH_ASSOC)){ print("<tr>"); print("<td>".$row[‘name’]."</td>"); print("<td>".$row[‘surname’]."</td>"); print("<td>".$row[‘dateOfBirth’]."</td>"); print("</tr>");… Read More Iterate over a fetch call with PDO

this might be a silly question, but I struggle with it a lot. I usually have very long MySQL Insert statements which take many arguments. The arguments are all represented by question marks. Because of that, my code gets very confusing when I have to add more arguments in the middle. (EDIT: Can’t add all… Read More How to format long MySQL Insert-Statements

I have a connection to a database that looks something like this: $data_source_name = "mysql:host=$db_host;dbname=$db_name"; $database_connection = new PDO($data_source_name, $db_username, $db_password); The execution looks something like this: $stmt= $database_connection->prepare($sql); $stmt->execute([$name, $email]); I’m trying to set up a condition like this: if ( database connection fails ) { // error handling } But this code doesn’t… Read More Using IF conditional statements with PDO

Entire project – https://github.com/steve-davey/phpsqliteconnect (config file is out of date though) This is the config file: <?php namespace App; class Config { /** * path to the sqlite file */ const PATH_TO_SQLITE_FILE = ‘db/DeviceAssetRegister.db’; } /* Database credentials. Assuming you are running MySQL server with default setting (user ‘root’ with no password) */ define(‘DB_SERVER’, ‘localhost’);… Read More Trying to create PHP CRUD app using PDO but getting Undefined type 'App\PDO' in config file

Maybe this is a bad question but Ive been trying for so long and Im not sure what Im doing wrong so I thought I might ask for help. I need to do a Sign In form. First I needed to verify if the email and password of a certain user match so I created… Read More PDO query does not return anything