Submitted by mtahir04july on Tue, 01/26/2010 - 08:33
How to install and configure mysqli in php and how to enable it.
Thanks
Tahir Atique
Status:
Active
How to install and configure mysqli in php and how to enable it.
Thanks
Tahir Atique
Comments
Submitted by andreychek on Tue, 01/26/2010 - 09:57 Comment #1
Sorry, it doesn't appear that CentOS 5.x includes a PHP module with mysqli enabled in it.
One option is that you could compile PHP yourself, but I don't really recommend that ... are you certain you need mysqli support, and that the standard "mysql" module wouldn't work?
Submitted by IamJim on Fri, 12/19/2014 - 06:10 Comment #2
Morning "Batman" [Eric]
OK, almost 5 years later-back at the ranch- and using this thread as it contains the exact subject matter at hand sir.
re: Sorry, it doesn't appear that CentOS 5.x includes a PHP module with mysqli enabled in it.
Tada? It has for awhile so, here is what I see: [root@lassd ~]# locate mysqli /etc/php.d/mysqli.ini
[**** SOME OUTPUT OF ACCOUNT NAME REMOVED as well as references to what Joomla. and quite a few others utilize MySQLi for in this century ***] LoL
/usr/bin/mysqlimport /usr/lib64/php/modules/mysqli.so /usr/share/man/man1/mysqlimport.1.gz [root@lassd ~]#
re: One option is that you could compile PHP yourself, but I don't really recommend that
Have things changed on this reply?
re: ... are you certain you need mysqli support, and that the standard "mysql" module wouldn't work?
YES!!
So, in Webmin, tried to see if any type of Auto-Install/attach it to this, to no avail.
My little brain, then thinks -
Upgrade All Packages
Upgrading all packages with command yum clean all ; yum -y update ..
OK? Did this just KILL OFF the tweaks for the ProFTPd Problem?
Loaded plugins: fastestmirror Cleaning repos: base extras rpmforge updates virtualmin virtualmin-universal : vz-base vz-updates Cleaning up Everything Cleaning up list of fastest mirrors Loaded plugins: fastestmirror Setting up Update Process Determining fastest mirrors * base: repos.lax.quadranet.com * extras: repos.lax.quadranet.com * rpmforge: mirror.webnx.com * updates: repos.lax.quadranet.com Resolving Dependencies --> Running transaction check ---> Package proftpd.x86_64 0:1.3.3g-2.el6 will be updated ---> Package proftpd.x86_64 0:1.3.4a-1.el6.rf will be an update --> Finished Dependency Resolution
Dependencies Resolved
================================================================================
Package Arch Version Repository SizeUpdating: proftpd x86_64 1.3.4a-1.el6.rf rpmforge 2.0 M
Transaction SummaryUpgrade 1 Package(s)
Total download size: 2.0 M Downloading Packages: Running rpm_check_debug Running Transaction Test Transaction Test Succeeded Running Transaction
Updating : proftpd-1.3.4a-1.el6.rf.x86_64 1/2
Cleanup : proftpd-1.3.3g-2.el6.x86_64 2/2
Verifying : proftpd-1.3.4a-1.el6.rf.x86_64 1/2
Verifying : proftpd-1.3.3g-2.el6.x86_64 2/2
Updated: proftpd.x86_64 0:1.3.4a-1.el6.rf
Complete!
.. upgrade complete.
Submitted by andreychek on Fri, 12/19/2014 - 10:32 Comment #3
The "mysqli" PHP module does come with CentOS 6, and likely 7. It's part of the php-mysql package.
In your case, it looks like you're using a third party repository though... you'd want to be careful with that, it can cause a number of issues, including ProFTPd not working properly. If you're having problems with ProFTPd now, take a peek at the article titled "Why does PHP / ProFTPd no longer work after performing updates? (I'm using CentOS, and enabled third party repositories)" here:
https://virtualmin.com/documentation/system/faq
The mysqli module actually comes with the standard PHP versions included with CentOS now, so you wouldn't actually need a third party repo.