You could also say: SELECT wrd FROM tablename WHERE wrd LIKE CONCAT(:partial, ‘%’) to do the string joining at the MySQL end, not that there’s any particular reason to in this case. Things get a bit more tricky if the partial wrd you are looking for can itself contain a percent or underscore character (since … Read more
BIT column is a binary type in mysql (though it’s documented as numeric type – that’s not precisely true) and I advise to avoid it due to problems with client libraries (which PDO issue proves). You will spare yourself a lot of trouble if you modify type of column to TINYINT(1) TINYINT(1) will of course … Read more
The problem is that bindParam requires a reference. It binds the variable to the statement, not the value. Since the variable in a foreach loop is unset at the end of each iteration, you can’t use the code in the question. You can do the following, using a reference in the foreach: foreach ($reindex as … Read more
PDO is always installed for php 5.1+. You can check for specific db drivers that are installed or not using phpinfo(); You could try to check for specific drivers using @Mark Baker idea and checking for specific constants; var_dump(defined(PDO::MYSQL_ATTR_LOCAL_INFILE)); // mysql var_dump(PDO::FB_ATTR_TIME_FORMAT)); // firebird Note that not all drivers have specific constants defined so phpinfo() … Read more
In other DB abstraction frameworks in other languages it can be used for things like making sure you’re doing the proper escaping for in-lining values (for drivers that don’t support proper bound parameters) and improving network efficiency by making sure numbers are binary packed appropriately (given protocol support). It looks like in PDO, it doesn’t … Read more
Here is an example for using PDO to connect to a DB, to tell it to throw Exceptions instead of php errors (will help with your debugging), and using parameterised statements instead of substituting dynamic values into the query yourself (highly recommended): // connect to PDO $pdo = new PDO(“mysql:host=localhost;dbname=test”, “user”, “password”); // the following … Read more
At the basic level the mysql, mysqli and PDO extensions all answer the question how do I talk to the database? They all provide functions and functionality to connect to a database and send and retrieve data from it. You can use them all at the same time establishing several connections to the database at … Read more
fear my google-fu $pdo = new PDO( ‘mysql:host=mysql.example.com;dbname=example_db’, “username”, “password”, array(PDO::MYSQL_ATTR_INIT_COMMAND => “SET NAMES utf8”)); first hit 😉
I would venture to say the problem is with wait_timeout. It is set to 30 seconds on my shared host and on my localhost is set for 28800. I found that I can change it for the session, so you can issue the query: SET session wait_timeout=28800 UPDATE The OP determined that he also needed … Read more
Use $link = null to let PDO know it can close the connection. PHP: PDO Connections & Connection Management Upon successful connection to the database, an instance of the PDO class is returned to your script. The connection remains active for the lifetime of that PDO object. To close the connection, you need to destroy … Read more