Ошибка mysql php как модуль

I know this is a while ago but I encountered this and followed the other answers here but to no avail, I found the solution via this question (Stackoverflow Question)

Essentially just needed to edit the php.ini file (mine was found at c:xamppphpphp.ini) and uncomment these lines…

;extension=php_mysql.dll
;extension=php_mysqli.dll
;extension=php_pdo_mysql.dll

After restarting apache all was working as expected.

This article can help you Configuring PHP with MySQL for Apache 2 or IIS in Windows. Look at the section «Configure PHP and MySQL under Apache 2», point 3:

extension_dir = "c:phpextensions"      ; FOR PHP 4 ONLY 
extension_dir = "c:phpext"             ; FOR PHP 5 ONLY

You must uncomment extension_dir param line and set it to absolute path to the PHP extensions directory.

answered Jun 4, 2012 at 14:13

answered May 18, 2013 at 6:28

I had the same problem and I solved it. You can solve it too if you follow these steps:

1. you have to install PHP to C:/php
   or your current version locate it to this path and specify it as a system variable

2. then open xampp program and click config and open php.ini
   and uncomment the following lines:

   extension=pdo_mysql
   extension=pdo_mysql
   extension=openssl
   

try to change PHP version

$sudo update-alternatives --config php

if it didn’t work
change for example from PHP 5.6 => PHP 7.1

    $ sudo a2dismod php5.6
    $ sudo a2enmod php7.1  
    $ sudo service apache2 restart

answered Sep 19, 2022 at 10:55

I encountered this problem today and eventually I realize it was the comment on the line before the mysql dll’s that was causing the problem.

This is what you should have in php.ini by default for PHP 5.5.16:

;extension=php_exif.dll       Must be after mbstring as it depends on it
;extension=php_mysql.dll
;extension=php_mysqli.dll

Besides removing the semi-colons, you also need to delete the line of comment that came after php_exif.dll. This leaves you with

extension=php_exif.dll      
extension=php_mysql.dll
extension=php_mysqli.dll

This solves the problem in my case.

answered Aug 27, 2014 at 5:53

answered Sep 23, 2019 at 14:23

Its an issue of extension directory. You need to change php extension directory manually to work this.

If you are using AMPP Server, do the following

Goto settings -> PHP -> Configuration

in php7.3.ini Find, (Versions might change)

extension_dir = «» , (Already having some path)

and change value to

extension_dir = «C:Program FilesAmppsphp-7.3ext»

If you are using XAMP

Goto XAMP Settings, Apache -> PHP.ini

Find, extension_dir = in php.ini, and set path of the php extension folder of your local machine. See the below example.

extension_dir = «C:phpext» (Check your path properly)

answered Apr 25, 2020 at 3:47

In my case, I had a similar issue after full installation of Debian 10.

Commandline:
php -v show I am using php7.4 but print phpinfo() gives me php7.3

Solution: Disable php7.3 Enable php7.4

   $ a2dismod php7.3
    
   $ a2enmod php7.4
    
   $ update-alternatives --set php /usr/bin/php7.4
   $ update-alternatives --set phar /usr/bin/phar7.4
   $ update-alternatives --set phar.phar /usr/bin/phar.phar7.4
   $ update-alternatives --set phpize /usr/bin/phpize7.4
   $ update-alternatives --set php-config /usr/bin/php-config7.4

answered Aug 16, 2020 at 22:39

Replace

include_path=C:Program Files (x86)xamppphpPEAR

with following

include_path="C:Program Files (x86)xamppphpPEAR"

i.e Add commas , i checked apache error logs it was showing syntax error so checked whole file for syntax errors.

answered Dec 20, 2020 at 22:36

Страница 1 из 2

Страница 1 из 2

I am doing a tutorial and am getting this error:

Fatal error: Class ‘MySQLi’ not found (LONG URL) on line 8

The code on line 8 is:

$mysqli = new MySQLi($db_server, $db_user, $db_pass, $db_name);

I saw online someone said to see if it was turned on in my phpinfo(), but there wasn’t anything listed in there under for «mysqli».

Also, I am running PHP version 5.2.5

How to Enable mysqli in php.ini

1. Edit/uncomment by removing ‘;'(colon) the following config in php.ini:
   1st (uncomment and add config):

   include_path = "C:phpincludes"
   

   2nd (uncomment):

   extension_dir = "ext"
   

   3rd (uncomment and edit config):

   extension=C:/PHP/ext/php_mysql.dll
   extension=C:/PHP/ext/php_mysqli.dll
   

2. Restart the IIS server
3. Make sure that mysql is running on the system.

How to load php.ini file

1. Rename any one of the file php.ini-production/php.ini-development to php.ini from C:PHP(note now the extention will be ini i.e «php.ini»).
2. After renaming to php.ini file restart server
3. See the changes in http://localhost/phpinfo.php

1. Open your PHP folder.
2. Find php.ini-development and open it.
3. Find ;extension=mysqli
4. delete the ; symbol
5. save file and change the file extension from php.ini-development to php.ini
6. Restart the server and test the code:

    if (!function_exists('mysqli_init') && !extension_loaded('mysqli')) {  
            echo 'We don't have mysqli!!!';  
     } else {  
         echo 'mysqli is installed';
     }

1. if it not working, change both extension_dir in php.ini from «ext» to «c:phpext»
   and extension=mysqli to extension=php_mysqli.dll then test again
   Remember to reset the server every time you test

For anyone using docker, I ran into this issue, and resolved it by using my own Dockerfile instead of the php:fpm image:

FROM php:fpm

RUN docker-php-ext-install mysqli

answered Apr 17, 2020 at 19:09

Seems like problem with your installation.

• Have you installed MySQLi?
• Have you activated it in php.ini?
• Restarted Apache and/or PHP-FPM?

http://www.php.net/manual/en/mysqli.installation.php

The PHP zip includes most of the commonly used extensions (*.dll on windows such as php_mysqli.dll) under the ext directory, however they are not enabled by default. You might be getting this Fatal Error when trying to use MySQLi:

( ! ) Fatal error: Uncaught Error: Class 'mysqli' not found in C:myProject class.Database.php on line 24

To enable extensions, open php.ini (you might need to first copy php.ini-development as php.ini), and un-comment (or add) these two lines:

extension_dir = "ext"

And any particular extensions you are getting Fatal Errors for, i.e. for mysqli:

extension=mysqli

answered Mar 12, 2018 at 2:26

answered Mar 23, 2019 at 0:52

I thought I might help anybody with the same problem using Namesco servers.
I have been trying to fix this problem after moving a database from my local server on home pc to namesco. They would not assist they said it was a coding issue.

• However, it was simple to fix from their CPANEl LINUX hosting
  interface.
• Click on php.
• then click on php modules and from their list of preinstalled modules just click the box for mysqli.
• Then click save. (No need to change code if it worked(s) on another server.)

Unfortunately, their support articles were a waste of time. After reading this I went to admin interface with a new determination.

Some distributions (such as Gentoo) support multiple installations of PHP, and you have to make sure you’re using one with mysqli installed and enabled.

On Gentoo, I had installed a new PHP (with the mysqli USE flag enabled), but I needed to activate the new version of PHP (since the old one must have been missing mysqli):

# eselect php list apache2
  [1]   php5.3 *
  [2]   php5.5
# eselect php set apache2 2
You have to run `/etc/init.d/apache2 restart' for the changes to take effect
# /etc/init.d/apache2 restart

I checked all above and it didn’t work for me,

There are some steps I found.

I used PHP Version 5.5.9-1ubuntu4.17 on Ubuntu 14.04

First check the folder

#ls /etc/php5/mods-available/
json.ini  mcrypt.ini  mysqli.ini  mysql.ini  mysqlnd.ini  opcache.ini  pdo.ini  pdo_mysql.ini  readline.ini  xcache.ini

If it did not contain mysqli.ini, read other answer for installing it,

Open php.ini find extension_dir

In my case , I must set extension_dir = /usr/lib/php5/20121212

And restart apache2 : /ect/init.d/apache2 restart

answered Jul 18, 2016 at 8:03

on ubuntu:

sudo apt-get install php-mysql
sudo service apache2 restart

answered Jul 25, 2018 at 17:40

on Debian 10

apt install php-mysql

/etc/init.d/apache2 restart

answered Jan 2, 2020 at 20:44

<IfModule php5_module>
    PHPINIDir "C:/xampp/php"
</IfModule>

But I’ve installed the PHP 7 and so the Apache could not load the php.ini file because there was no entry for that.
I added

<IfModule php7_module>
    PHPINIDir "C:/xampp/php"
</IfModule>

and after restart Apache all works well.

These code blocks above I found in my httpd-xampp.conf file. May it is somewhere else at your configuration.
In the same file I had changed before the settings for the php 7 as replacement for the php 5 version.

#
# PHP-Module setup
#
#LoadFile "C:/xampp/php/php5ts.dll"
#LoadModule php5_module "C:/xampp/php/php5apache2_4.dll"
LoadFile "C:/xampp/php/php7ts.dll"
LoadModule php7_module "C:/xampp/php/php7apache2_4.dll"

As you can see I have the xampp package installed but this problem was just on the Apache side.

install
phpXX-extension by PHP.
In my FreeBSD’s case:

pkg install php74-extensions

I’m using xampp and my problem was fixed once i rename:

extension_dir = "ext"

to

extension_dir = "C:xamppphpext"

PS: Don’t forget to restart apache after making this change!

answered Sep 12, 2020 at 2:27

In php.ini :

extension_dir ="c:/wamp64/bin/php/php7.4.9/ext/"

Make sure the PHP version is correct.

All you have to do is go to the php.ini file and on line 926 (depending on version) delete #. It should look like this:

;extension=ldap
;extension=mbstring
;extension=exif
extension=mysqli
;extension=oci8_12c
;extension=odbc

Save the file and open console (cmd) as administrator. Go to the path Apache24 / bin and enter httpd -k restart. This command will restart your server. After that, refresh the page and everything should work.

answered Apr 14, 2021 at 8:58

When I tried my PHP web app it was giving me the same error.

By googling I found out the MySQL plugin for the PHP server was missing with my installation. I am using Ubuntu, so when I tried MySQL plugin for PHP I found out 2 are there,

php-mysql and php<version>-mysql

I issued command — php --version in my terminal, I was having php7.4,

again I issued apt install php7.4-mysql

It worked.

answered Jul 9, 2021 at 3:35

answered Sep 2, 2021 at 10:01

If you tried all answers above and are still out of luck, then do check if the version numbers of the packages installed on your system really match:

apache2-mod_php7-7.4.33-150200.3.46.2.x86_64
php7-mysql-7.4.33-150200.3.46.2.x86_64

Once I had to do a manual installation from a different repo, which lead to certain libs not getting loaded (though their config was OK and their .ini files were getting parsed).

You can also try using

php -S <server_ip>:8080

to launch a test server and see if your missing module (mysqli) loads there. If it shows up in phpinfo there (and doesn’t in your regular configuration), then you at least know where to have a look at…

answered Apr 15 at 10:28