Change $sqlUpdate = “UPDATE `annonces` SET `etat` = `offline`… to $sqlUpdate = “UPDATE `annonces` SET `etat` = ‘offline’… Put quotes around “offline”, and it should work. 0 solved Update query with PHP and PDO doesn’t work [closed]
You are setting the query before you add the filter to the query string. // Get the results from the query $query->setQuery($sqlSelect) ->setParameter(‘startMonth’, $startMonth) ->setParameter(‘endMonth’, $endMonth); if (!empty($filter)) { $sqlSelect .= ‘AND LOG.VALUE LIKE :filter ‘; $query->setParameter(‘filter’, ‘%’.$filter.’%’); } You are setting the query to $sqlSelect and aftwards appending the filter part after setting the … Read more
This is nothing related to PDO. You might wanna do this: for ($i = 0; $i < count($tijdlijn); $i++) print_r ($tijdlijn[$i][‘bericht’]); Or in a better way: foreach ($tijdlijn as $tijd) print_r ($tijd[‘bericht’]); 0 solved How to show all arrays without numbers etc
I’m using MYSQL Workbench right now to build my database, do I need to build my database differently now to use MYSQLI or is MYSQLI just the syntax for connecting to the database. No. You do not need to build your database again. MYSQLI is a set of functions to establish a relation with any … Read more
The error message indicates that a MySQL connection via socket is tried (which is not supported). In the context of Laravel (artisan), you probably want to use a different / the correct environment. Eg: php artisan migrate –env=production (or whatever environment). See here. 5 solved PDOException SQLSTATE[HY000] [2002] No such file or directory
Both your PHP and your MySQL syntax have problems. First, your SQL statement needs to be surrounded by quotes. Secondly, the syntax for LOAD DATA INFILE is incorrect. Try this: $stmt=$db->prepare(“LOAD DATA INFILE ‘insert.txt’ into table `Info`”); $stmt->execute(); See the MySQL docs for LOAD DATA INFILE for more options. You’ll probably need to specify your … Read more
Missing Comma (,) in this line. Due to which bound variables were not matching. $req = $pdo->prepare(“INSERT INTO t_events_changes …. Values (… :new_standby_start:old_standby_end, … )”); ^ here missing comma Change it to, :new_standby_start,:old_standby_end, 2 solved Cant solve this : Invalid parameter number: number of bound variables does not match [closed]
throw new Exception(“id not supplied”); This line throws the exception that causes the fatal error you’re seeing. It’s run under this condition: if(!isset($id)){ So obviously, the condition matches, which means that the $id variable is not set. Also, extract($_REQUEST) is extremely bad practice. Simple scope example: function foo($a) { $a = 5; echo $a; //5 … Read more
There is an error in your function function showCart() { $cart = $_SESSION[“cart”]; if ($cart) { $output = explode(“,”,$cart); $content = array(); // FAULT HERE MAYBE ? foreach ($products as $product) { Your foreach used $products but you do not have this variable. You need to assign that variable the way you do in the … Read more
edit: as the Colonel indicated, apparently this (no longer?) works with LIMIT clauses. If you’re using simple queries / are not that bothered with type: function fetchAll(){ $args = func_get_args(); $query = array_shift($args);//’SELECT * FROM users WHERE status=? LIMIT ?,?’ //you’ll need a reference to your PDO instance $pdo somewhere…. $stmt = $pdo->prepare($query); $stmt->execute($args); return … Read more