Figured it out right after I posted: $query = $database->prepare(‘SELECT * FROM table WHERE column LIKE ?’); $query->execute(array(‘value%’)); while ($results = $query->fetch()) { echo $results[‘column’]; }
From the manual entry for PDOStatement::bindParam: [With bindParam] Unlike PDOStatement::bindValue(), the variable is bound as a reference and will only be evaluated at the time that PDOStatement::execute() is called. So, for example: $sex = ‘male’; $s = $dbh->prepare(‘SELECT name FROM students WHERE sex = :sex’); $s->bindParam(‘:sex’, $sex); // use bindParam to bind the variable $sex … Read more
$sql = “SELECT count(*) FROM `table` WHERE foo = ?”; $result = $con->prepare($sql); $result->execute([$bar]); $number_of_rows = $result->fetchColumn(); Not the most elegant way to do it, plus it involves an extra query. PDO has PDOStatement::rowCount(), which apparently does not work in MySql. What a pain. From the PDO Doc: For most databases, PDOStatement::rowCount() does not return … Read more
PDOException “could not find driver”
The goal As I see it, your aim in this case is twofold: create and maintain a single/reusable connection per database make sure that the connection has been set up properly Solution I would recommend to use both anonymous function and factory pattern for dealing with PDO connection. The use of it would looks like … Read more
setAttribute will cause PDO to throw up errors or exceptions – the latest when you execute the query. For emulated prepared statements, there is no check in prepare(): Emulated prepared statements does not communicate with the database server so PDO::prepare() does not check the statement. But there will be one in execute() when the query … Read more
PDO is not good with such things. You need to create a string with placeholders dynamically and insert it into the query, while binding array values the usual way. With positional placeholders it would be like this: $in = str_repeat(‘?,’, count($in_array) – 1) . ‘?’; $sql = “SELECT * FROM my_table WHERE my_value IN ($in)”; … Read more
As I know, PDO_MYSQLND replaced PDO_MYSQL in PHP 5.3. Confusing part is that name is still PDO_MYSQL. So now ND is default driver for MySQL+PDO. Overall, to execute multiple queries at once you need: PHP 5.3+ mysqlnd Emulated prepared statements. Make sure PDO::ATTR_EMULATE_PREPARES is set to 1 (default). Alternatively you can avoid using prepared statements … Read more
PDO query fails but I can’t see any errors. How to get an error message from PDO? To be able to see database errors, one have to set PDO errmode to exceptions. Exceptions are better than regular errors in many ways: they always contains a stack trace, they can be caught using try..catch or handled … Read more
I remember having this problem before. Cast the value to an integer before passing it to the bind function. I think this solves it. $fetchPictures->bindValue(‘:skip’, (int) trim($_GET[‘skip’]), PDO::PARAM_INT);