<?php class MyPDOStatement extends PDOStatement { protected $_debugValues = null; protected function __construct() { // need this empty construct()! } public function execute($values=array()) { $this->_debugValues = $values; try { $t = parent::execute($values); // maybe do some logging here? } catch (PDOException $e) { // maybe do some logging here? throw $e; } return $t; } … Read more
Try $q->rowCount(). Prepared statements will return the number of affected rows via that method.
You’re throwing away a result row when you do $sth->fetchColumn(). That’s not how you check if there are any results. You do if ($sth->rowCount() > 0) { … got results … } else { echo ‘nothing’; } Relevant documentation is here: PDOStatement::rowCount
You can use sudo apt-get install php7-mysql or sudo apt-get install php5-mysql or sudo apt-get install php-mysql This worked for me.
On Ubuntu you should be able to install the necessary PDO parts from apt using sudo apt-get install php5-mysql There is no limitation between using PDO and mysql_ simultaneously. You will however need to create two connections to your DB, one with mysql_ and one using PDO.
Both extensions internally use EG(persistent_list) to store the persistent connection handle. But they create different hashes/keys for this list, so they can’t find entries of the respective other extension. The mysql extension creates keys of the form “mysql_<host&port>_<user>…” while pdo builds “PDO:DBH:DSN=<dsn>:<user>:….”. The hashes are used almost like array-keys in a php script. (Over-)simplyfied example: … Read more
I believe this is mentioned in the original question that was reference in this one. However there is actually supposed to be a method for retrieving this data. PDOStatement::debugDumpParams However it isn’t currently working as documented. There is a bug report and patch submitted for it here http://bugs.php.net/bug.php?id=52384 in case anyone is interested in voting … Read more
It’s not duplicates, it’s just the current FETCH_MODE you’re using. To get as associative keys only you need to specify as such; by default it fetches as both. Use like so: $query->fetchAll(PDO::FETCH_NUM); // to fetch with numeric indexes $query->fetchAll(PDO::FETCH_ASSOC); // to fetch with associative indexes fetchAll docs fetch docs
Change LIMIT :offset, :limit to LIMIT ?, ? and $stmt->bindParam(‘:offset’, $offset, PDO::PARAM_INT); $stmt->bindParam(‘:limit’, $limit, PDO::PARAM_INT); to: $stmt->bindValue($index+1, $offset, PDO::PARAM_INT); $stmt->bindValue($index+2, $limit, PDO::PARAM_INT);
1st question: Using count COUNT(), internally the server(MySQL) will process the request differently. When doing COUNT(), the server(MySQL) will only allocate memory to store the result of the count. When using $row=$SQL->rowCount(); the server (Apache/PHP) will process the entire result set, allocate memory for all those results, and put the server in fetching mode, which … Read more