Learn php7 to configure mysqli and use mysqli to connect to mysql

php7Configure mysqli and use mysqli to connect to mysql

Recommended (free): PHP7

If you use wamp and lamp environments to build php web, it is generally not easy to encounter such problems:

php7 Class 'mysqli' not found in

But I recently learned about php web crawlers and data processing, so I used php7 as the crawler script directly in cmd
Please configure the path environment variable and vim before use

Downloaded from the official website The php7 windows version interpreter does not have many extensions enabled, and there is no "php.ini"!
Find the "php.ini-development" file in the downloaded and decompressed directory. This file will not work!
php7 still uses "php.ini" as the configuration file, so make a copy of it and name it "php.ini"
Modify php.ini
Remove the comments "from the following configuration statement"; ”

    extension=php_mysqli.dll

In this way, the mysqli class still cannot be found, and php.exe needs to be able to find the extension file
All default extensions are in the ext directory under the php directory, and there is a configuration in php.ini , remove the comment ";"

; Directory in which the loadable extensions (modules) reside.; http://php.net/extension-dir; extension_dir = "./"; On windows:extension_dir = "ext"

extension_dir is explained above. In the Windows system, the target directory configuration of the PHP extension file can be read. After removing it, PHP will load the extension file from the ext directory, both dll file

Next test, create a new test.php

Connect to query the database as follows:

<?php$con = new mysqli(&#39;localhost&#39;,&#39;root&#39;,&#39;&#39;,&#39;xiaohua&#39;);if(!$con)    die("connect error:".mysqli_connect_error());else
    echo "success connect mysql\n";$sql = "select distinct class_id from xiaohua_user";$rs = $con->query($sql);$c = array();while($r = $rs->fetch_row()){
    array_push($c,substr($r[0],0,4));
}$c = array_unique($c);$i=0;$zy = array();foreach($c as $row){
    array_push($zy,$row);
}
print_r($zy);$con->close();
?

The above is the detailed content of Learn php7 to configure mysqli and use mysqli to connect to mysql. For more information, please follow other related articles on the PHP Chinese website!