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
1
vote
1 answer

How to connect in PHP to a MySQL database without getting errors due to cPanel?

This basic commands: new mysqli($servername, $username, $password); mysqli_connect($servername, $username, $password); are blocked in PHP 8.2+ with Uncaught Error: Class "mysqli" not found or Uncaught Error: Call to undefined function…
LWC
  • 1,084
  • 1
  • 10
  • 28
1
vote
1 answer

Cannot save emojis in utf8mb3 tables… Overnight, since MariaDB 10.6 update and switching to nd_mysqli

Before, using MariaDB 10.5 and mysqli, I had plenty of old WordPress website on utf8mb3 tables where I can successfully save a wide range of Emojis in the database. Now since I switched to MariaDB 10.6 and nd_mysqli, if the database and tables are…
Nicolas Laruelle - EasyHoster
  • 37
  • 1
  • 7
1
vote
0 answers

Does mysqli_get_client_stats send requests to sql server

This method is supplied since mysqlnd: http://php.net/manual/fr/function.mysqli-get-client-stats.php It allows to get a lot of statistics (byte_received...) Are these information collected at query time (while sending the sql request, maybe they…
nemenems
  • 1,064
  • 2
  • 9
  • 27
1
vote
0 answers

Installing mysqlnd_qc plugin

I need to install the mysqlnd_qc plugin. So, what I achieved yet is installing MySQL Native Driver, Apache.. etc. and that's all. How I tried to install? With PECL, using this pecl install mysqlnd_qc-1.2.0.tar command in terminal. But compilation…
Newbie32
  • 11
  • 3
1
vote
1 answer

num_rows alternative for webspace without MySQLnd

It seems the company I host my webserver with doesn't have MySQLnd installed (or at least not on my server). This means that in php I can not use $stmt->get_result(), which means I can not use $result->num_rows(). I instead have to use…
Jans Rautenbach
  • 394
  • 4
  • 13
1
vote
0 answers

phpmysqlnd_ms plugin does not load

The mysqlnd_ms plugin is not being detected by my PHP5.5 setup. I've installed mysqlnd and enabled it with PDO and mysqli. > php -m | grep mysqlnd mysqlnd It shows up in php -i > php -i > dump; vim dump mysqlnd mysqlnd => enabled Version =>…
Adil
  • 2,092
  • 3
  • 25
  • 35
1
vote
1 answer

PHP/MySQL Header and Client Library Mismatch

I am currently using local MAMP setup on a Windows PC to connect to a MySQL database. But running the following code throws an error. CODE: $connection = mysqli_connect($host, $user, $pass, $dbname); ERROR: Warning: mysqli_connect(): Headers and…
eArshdeep
  • 29
  • 5
1
vote
0 answers

MYSQLI_ASYNC available with prepared statements in PHP?

Utilizing the MySQL Native Driver, you can use the MYSQLI_ASYNC flag with the mysqli_query function to make parallel, asynchronous MySQL DB calls. I get how all that works, but what I'd really like to be able to do is somehow use the MYSQLI_ASYNC…
HartleySan
  • 7,404
  • 14
  • 66
  • 119
1
vote
1 answer

MySQL with ND connection failover with PhalconPHP/PDO

In this part of Mysql-nd manual is described how to implement recommended way of failing over when loosing connection to slave MySQL server. I'am willing to implement it in PhalconPHP. As I have couple of important projects using Phalcon and…
yergo
  • 4,761
  • 2
  • 19
  • 41
1
vote
3 answers

PHP: install mysqlnd_ms fail : make: *** [php_mysqlnd_ms.lo] error 1

I'm installing mysqlnd_ms package for php, but the make command reported an error: make: *** [php_mysqlnd_ms.lo] Error 1 ERROR: `make' failed my PHP version: [root@uoo insFile]# php -v PHP 5.6.12 (cli) (built: Aug 30 2015 00:04:44) Copyright (c)…
sis
  • 68
  • 9
1
vote
1 answer

mysqlnd driver has only one api extension (pdo_mysql)

After checking phpinfo() I saw that mysqlnd driver installed on linux (php 5.4) has only one API extension (pdo_mysql), but I also want to be able to work with mysqli. How do I associate mysqlnd driver with mysqli extension? I guess I can fix this…
Boy
  • 1,182
  • 2
  • 11
  • 28
1
vote
1 answer

Undefined method mysqli_stmt::get_result() with fetch_assoc()

I am working on a login and register android project. I tried different solutions for this PHP error, but none of them helped me. I'm getting this error: Call to undefined method mysqli_stmt::get_result() in ... on line 59 And line 59 is: $user =…
user5216964
1
vote
1 answer

how can I mysqlnd work with php?

i use php 5.2 but it doesn't support mysqlnd. so I changed php with 5.3.7 but I can't handle it...what's wrong with it version info OS window7 PHP 5.3.7v Mysql 5.1.39 Apache 2.2.14
tldjssla
  • 21
  • 5
1
vote
1 answer

How to use phpMyAdmin with mysqlnd

When I run my php code with full error reporting I get : Warning: mysqli::mysqli(): Headers and client library minor version mismatch. I found out that I should switch to mysqlnd by uninstalling mysqli as it is discussed here: Headers and client…
Dr. Ehsan Ali
  • 4,735
  • 4
  • 23
  • 37
1
vote
1 answer

MySQL PDO empty result set when ATTR_EMULATE_PREPARES set to false and query is killed

When PDO::ATTR_EMULATE_PREPARES is set to false and your query get killed (e.g. MySQL Workbench -> Client Connections -> Right click -> Kill query) during state: "Sending data", PDO "query" or "execute" methods, returns empty PDOStatement. PDO…
Tom Raganowicz
  • 2,169
  • 5
  • 27
  • 41
1 2 3
…
8 9