Momwe mungalumikizire ku database ya MySQL? PHP script kuti mulumikizane ndi MySQL database chitsanzo

Momwe mungalumikizireMySQL database? PHP script kulumikizanaMySQLchitsanzo cha database

Kulumikizana kwa MySQL

Lumikizani pogwiritsa ntchito njira ya binary ya mysql

Mutha kugwiritsa ntchito binary ya MySQL kuti mupeze mysql command prompt kuti mulumikizane ndi database ya MySQL.

Chitsanzo

Chotsatira ndi chitsanzo chosavuta cholumikizira ku seva ya mysql kuchokera pamzere wolamula:

[root@host]# mysql -u root -p
Enter password:******

Pambuyo polowera bwino, zenera la mysql> command prompt liwoneka, ndipo mutha kuchita mawu aliwonse a SQL pamenepo.

Lamulo ili pamwambapa litaperekedwa, zotuluka zolowera bwino zili motere:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2854760 to server version: 5.0.9

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

Muchitsanzo pamwambapa, tidagwiritsa ntchito mizu kuti tilowe mu seva ya mysql, inde, mutha kugwiritsanso ntchito ogwiritsa ntchito ena a mysql kuti alowe.

Ngati mwayi wogwiritsa ntchito uli wokwanira, wogwiritsa ntchito aliyense akhoza kuchita SQL pawindo la mysql.

Kuti mutuluke pa mysql> command prompt window mutha kugwiritsa ntchito lamulo lotuluka motere:

mysql> exit
Bye

Lumikizani ku MySQL pogwiritsa ntchito PHP script

PHP imapereka mysqli_connect() ntchito kuti igwirizane ndi database.

Ntchitoyi ili ndi magawo 6, imabweretsanso ID yolumikizira pambuyo polumikizana bwino ndi MySQL, ndikubwezeretsa FALSE pakulephera.

galamala

mysqli_connect(host,username,password,dbname,port,socket);

Kufotokozera kwa Parameter:

Mutha kugwiritsa ntchito mysqli_close() ntchito ya PHP kuti muchotse ku database ya MySQL.

Ntchitoyi ili ndi gawo limodzi lokha, chozindikiritsa cholumikizira cha MySQL chobwezeredwa ndi mysqli_connect() ntchito pambuyo polumikizana bwino.

galamala

bool mysqli_close ( mysqli $link )

Ntchitoyi imatseka kulumikizidwa kosakhazikika kwa seva ya MySQL yolumikizidwa ndi ID yolumikizana yomwe yatchulidwa.Ngati palibe link_identifier yotchulidwa, kulumikizana komaliza kotsegula kumatsekedwa.

mwamsanga:Kugwiritsa ntchito mysqli_close() nthawi zambiri sikofunikira chifukwa kulumikizana kosakhazikika kumangotsekedwa script ikamaliza.

Chitsanzo

Mutha kuyesa zotsatirazi kuti mulumikizane ndi seva yanu ya MySQL:

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接失败: ' . mysqli_error($conn));
}
echo '连接成功';
mysqli_select_db($conn, 'chenweiliang' );
mysqli_close($conn);
?>