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
0
votes
1 answer

How to count returned rows number without using get_result() in mysqli?

I am using GoDaddy shared hosting plan and looks like there are some issues on using the mysqli and mysqlnd in all versions of PHP 7,7.1,7.2, and 7.3 on their hosting. After many tries on changing and updating PHP versions and modules I, eventually,…
Mona Coder
  • 6,212
  • 18
  • 66
  • 128
0
votes
1 answer

Should I need to explictly cast hard-coded values in UNION joins for ints not to end up as strings using mysqlnd?

Using MariaDB 10.3.9 and given the following query: SELECT photoId FROM photos WHERE photoId = 123; using PDO and mysqlnd in php var_dump will give int(123), as expected. But if I change the query to SELECT photoId FROM photos WHERE photoId = 123 …
Codemonkey
  • 4,455
  • 5
  • 44
  • 76
0
votes
1 answer

How to make Mysqlnd_ms run each query on a different instance

I have an AWS RDS with 1 read replica (total 2 instances). I'm planning to install mysqlnd_ms plugin so that I can have my request pointed to the database servers in round robin fashion. I have 2 basic questions which I couldn't find direct answers…
Saikiran
  • 756
  • 2
  • 11
  • 29
0
votes
1 answer

how to fix get_result and fetch_assoc with bind_result and fetch(wtithout getting Null)?

i'm working on a project base on a tutorial, looks like my host can't fully support mysqlnd for using get_result. so after i've did some researches, i've found solution in using bind_result, after hours i've tried to fix it and still nothing. please…
0
votes
0 answers

How to "disable" mysqlnd native type cast support in PHP

Backstory We are migrating our projects codebase from PHP 5.3 to PHP 7.0 on a CentOS 6 platform. The old stack uses Apache with PHP 5.3 libphp module + libmysql and the new stack uses Nginx with PHP 7.0 FPM + mysqlnd. We have them configured to run…
Karl Viiburg
  • 832
  • 10
  • 34
0
votes
1 answer

Missing mysql api extension in mysqlnd driver

I have a variant of this question. Everything was working fine on my development machine (Mac) but I had to reinstall php with homebrew because I needed the '--with-homebrew-curl' option. PHP got updated from 5.6.18 to 5.6.30. Now the old mysql…
Dagligleder
  • 451
  • 5
  • 14
0
votes
0 answers

Is there any need for mysqlnd if im only writing PDO?

Is there any need for mysqlnd if im only writing PDO? Im aking because i have been stressing myself out dealing with my host provider trying to get mysqlnd to work. is it easier to just to write pdo instead of procedural php?
user7951652
0
votes
1 answer

update mysqlnd_ms configuration without restarting

Is there a way to update the mysqlnd_ms configuration on a Linux server (PHP-FPM) without forcing a restart? For example, if I add or remove a slave database, I'd like that to be updated in the PHP-FPM server without forcing a restart.
Kae Verens
  • 4,076
  • 3
  • 21
  • 41
0
votes
0 answers

PHP Fatal error: Call to undefined method mysqli_stmt::get_result() being enabled mysqlnd

I am getting an error in my rest api while calling $stmt->get_result(). PHP Fatal error: Call to undefined method mysqli_stmt::get_result() The previous questions about this suggest to enable mysqlnd driver. I have done that in my godaddy…
Bera
  • 145
  • 1
  • 2
  • 11
0
votes
0 answers

Can't install mysqlnd_uh_set_connection_proxy() in php

I try to install mysqlnd_uh_set_connection_proxy() to monitor sql query. However, It doesn't work. It shows a warning. Warning: mysqlnd_uh_set_connection_proxy(): (Mysqlnd User Handler) You must be using mysqli with mysqlnd. This extension is a…
0
votes
1 answer

Php $num_rows not working after installing Mysqlnd

I'm trying to get my $num_rows working. It had been working, and now it's not. Reading this site it was suggested I install MySqlnd on my server because some things like fetch_array and get_result were not working and now it's like I wish I'd never…
CHarris
  • 2,693
  • 8
  • 45
  • 71
0
votes
3 answers

How to enable mysqli with PHP 7?

I have the latest version of Apache (Apache 2.4), latest version of PHP (PHP7), and latest version of MySQL (not sure the version but I have WorkBench version 6.3). In the past, when I checked if my PHP was working by this line of code
Vince
  • 2,596
  • 11
  • 43
  • 76
0
votes
0 answers

PHP SLIM framework/mysql mysqlnd issue on live server

Here is the link. You need to register and login to view this page... You can use sample fake email id for it. Thnx :) I am using PHP SLIM framework to create API & the code is working fine on localhost but its giving following error on…
0
votes
0 answers

php5-mysqlnd not installed on ubuntu

I have already install "mysql". Now, i want to installed or enabled "mysqlnd". for that i used sudo apt-get install php5-mysqlnd But following out put appears on terminal. Reading package lists... Done Building dependency tree Reading state…
Harish Mahajan
  • 3,254
  • 4
  • 27
  • 49
0
votes
0 answers

get_result() doesn't work on my web host

My webhost server is using libmysqlclient as the driver. Currently the only way that they can support MySQLND is via a VPS / dedicated server. And i don't want that. I'm using php 7 btw... This is a similar code that i am using. $stmt =…
James Allan
  • 280
  • 5
  • 18
1 2 3
8 9