PHP 7找不到MySQLi [英] PHP 7 cannot find MySQLi

问题描述

由于某些原因，Windows 7无法找到MySQL安装.我已经尝试了很多事情，但收效甚微.

For some reason, Windows 7 is unable to find the MySQL install. I've tried quite a few things to little or no avail.

我想使用以下代码使用php连接到我的MySQL数据库:

I want to connect to my MySQL database with php using this code:

$con = new mysqli($server_name,$mysql_user,$mysql_pass,$db_name);
if($con->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
else{
    echo "<h3> Database Connected <h3>";
}

当我连接时，会收到以下错误消息:

When I do connect, I receive this error message:

致命错误:未捕获错误:在C:\ Apache \ htdocs \ test_connection.php:8中找不到类'mysqli'堆栈跟踪:#0 {main}在C:\ Apache \ htdocs \ test_connection.php中抛出8

Fatal error: Uncaught Error: Class 'mysqli' not found in C:\Apache\htdocs\test_connection.php:8 Stack trace: #0 {main} thrown in C:\Apache\htdocs\test_connection.php on line 8

我运行了这段代码，返回的结果是我没有加载mysqli:

I ran this code and it returns that I don't have mysqli loaded:

if (!function_exists('mysqli_init') && !extension_loaded('mysqli')) {
    echo 'We don\'t have mysqli!!! ';
} else {
    echo 'Phew we have it!';
}

我添加了

extension_dir = "C:\php\ext"

和

extension=php_mysqli.dll 

同时php.ini-development和php.ini-production

我的扩展程序位于

C:\php\ext

，我在该文件夹中也有php_mysqli.dll文件.

and I also have the php_mysqli.dll file in that folder.

我已经在Apache中httpd.exe文件的末尾添加了以下代码

I have added the following code to the end of my httpd.exe file in Apache

LoadModule php7_module "c:/php/php7apache2_4.dll"
AddHandler application/x-httpd-php .php
PHPIniDir "c:/php"

推荐答案

更改

LoadModule php7_module "c:/php/php7apache2_4.dll"

到

LoadModule php7_module /php/php7apache2_4.dll

和

PHPIniDir "c:/php"

到

PHPIniDir /php

我为这个问题奋战了好几天，答案很简单.

I fought this problem for days and the answer was that simple.

这篇关于PHP 7找不到MySQLi的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！