Stack Overflow
Stack Overflow

Questions tagged [mysqlnd]

The MySQL native driver for PHP (mysqlnd) is a drop-in replacement for the MySQL Client Library (libmysql) for the PHP script language.

Because MySQL Native Driver is written as a PHP extension, it is tightly coupled to the workings of PHP.

This leads to gains in efficiency, especially when it comes to memory usage, as the driver uses the PHP memory management system. It also supports the PHP memory limit. Using MySQL Native Driver leads to comparable or better performance than using MySQL Client Library, it always ensures the most efficient use of memory. One example of the memory efficiency is the fact that when using the MySQL Client Library, each row is stored in memory twice, whereas with the MySQL Native Driver each row is only stored once in memory.

126 questions
2
votes
0 answers

What is causing this PHP warning for the mysqli_poll function?

I'm using the MySQL native driver for PHP to make asynchronous, parallel queries from a PHP application to a MySQL DB. I have a function that receives an array of query strings and executes them in parallel. For whatever reason though, in one…
HartleySan
  • 7,404
  • 14
  • 66
  • 119
2
votes
0 answers

Compile mysqli with mysqlnd to use as dynamic extension?

Can I compile mysqli with mysqlnd to use as a dynamic extension? I would need to do this for linux from a windows machine (though I could use a linux distro if needed). WHY? Because my hosting provider is dumb. mysqlnd should be the default driver…
user2782001
  • 3,380
  • 3
  • 22
  • 41
2
votes
1 answer

Is it possible to configure Mysqlnd Api Extension from htaccess?

I am using Hostinger free hosting and they don't provide PHP settings page to configure the php.ini . Recently I came up with an error Uncaught Error: Call to undefined method mysqli_stmt::get_result() I did a little bit of research on why this…
silverFoxA
  • 4,549
  • 7
  • 33
  • 73
2
votes
2 answers

No mysqli_stmt_get_result() with mysqlnd

My prepared statements work just fine in MAMP with PHP 5.4 and no need to tweak php.ini. On my GoDaddy site, the same code fails with: Fatal error: Call to undefined function mysqli_stmt_get_result(). My GoDaddy info.php shows the following as…
Frank A.
  • 51
  • 7
2
votes
2 answers

Uncaught Error: Call to undefined method mysqli_stmt::get_result() in mamp

I am running MAMP on windows. php_mysqli.dll is enabled in the php.ini file. Along with that, in php info it says the mysqlnd is enabled: Here is what my php looks like: $connection = connect(); if($stmt = $connection->prepare("SELECT * FROM…
Tsangares
  • 780
  • 1
  • 9
  • 27
2
votes
1 answer

Morphing from mysql to mysqli

I am a little perplexed by the mysqli interface in PHP. When I set out yesterday to change my old mysql code to mysqli, the docs steered me down the road of ::prepare, ::bind_params and ::execute. In my efforts to deal with the results, I ended up…
Ollie2893
  • 427
  • 1
  • 5
  • 11
2
votes
1 answer

Is there a way to change what library mysqli uses with just the php.ini?

So I try to run the following code on a shared hosting.
usbpc102
  • 1,137
  • 13
  • 25
2
votes
0 answers

mysqlnd_qc storage handler choice

I am trying to install mysqlnd_qc on our production server (I don't know if a good decision but I went for it) I managed to get it installed and run. So far so good. My only concern is : Is it ok to use the default storage handler. I know they…
Ip ziet
  • 307
  • 2
  • 13
2
votes
1 answer

PHP PDO returning inconsistent results for SELECT FOUND_ROWS()

I have an issue with PHP/PDO and MySQL When I run a query with SQL_CALC_FOUND_ROWS and then select FOUND_ROWS(), 80% of the time its returning 0, and the rest of the time FOUND_ROWS is accurate I've reduced it to a simple test loop, but this works…
carpii
  • 1,917
  • 4
  • 20
  • 24
2
votes
2 answers

How to Share a MySQL connection between 2 different PHP Processes

I have an unusual case, my website runs two totally different PHP process through a sandbox. I have the normal website running through fastcgi and in the middle that fastcgi process executes one sandboxed script through cli. Both those processes…
Satake
  • 883
  • 7
  • 11
2
votes
1 answer

PHP PDO FOUND_ROWS() returns 0

We use PDO connector on product environment and recently we facing a new issue. Somehow the mysql FOUND_ROWS() returns 0 I have also tried to run the SQL queries manually in mysql console but FOUND_ROWS() returns correct count in console. What i…
oliver nadj
  • 788
  • 7
  • 21
2
votes
0 answers

Can't use Get_result or fetch_assoc, mysqlnd not on shared servers

Hostgator and Webhostingpad have both told me that mysqlnd is their default to which I have found the libmysqlclient is their default driver, So I am having a troubled time trying to get my prepared statements to function properly without using…
Solarplex
  • 107
  • 2
  • 9
2
votes
2 answers

PHP mysqli_stmt::get_result() is undefined method

Researching, looking on stackoverflow, looking through Google, I have found several people with the same problem, and the solution generally is "Available only with mysqlnd." And so I look around and poked at some code, but as far as I can tell,…
smts
  • 3,585
  • 1
  • 16
  • 14
2
votes
2 answers

phpinfo says MySQLnd is the active driver or am i confused

When i try to use the getAttribute function i get this error: Call to a member function getAttribute() on a non-object. It appears that mysqlnd is enabled but i can't use get_result() either, any idea? This has really been bothering me lately. On…
cooking good
  • 1,416
  • 1
  • 14
  • 17
2
votes
0 answers

mysqlnd: Cannot connect to MySQL 5.5.24, old_passwords is Off

I have two enviroments: Dev: Windows 7, PHP 5.3.24, Apache 2.2.24 Production: Linux, PHP 5.4.10, Apache Both connects to a remote MySQL 5.5.24 Server. Remote connections are allowed. I replaced all mysql functions to mysqli. In production it…
Marcelo Pascual
  • 810
  • 8
  • 20
1 2
3
…
8 9