Yadda za a haɗa zuwa MySQL database? Rubutun PHP don haɗawa zuwa misali database MySQL

Yadda ake haɗawaMySQL database? Haɗin rubutun PHPMySQLmisali database

MySQL haɗi

amfani da mysql binary connection

Kuna iya amfani da yanayin binary na MySQL don shigar da umarni na mysql don haɗawa zuwa bayanan MySQL.

misali

Mai zuwa shine misali mai sauƙi na haɗawa zuwa uwar garken mysql daga layin umarni:

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

Bayan shiga cikin nasara, taga mai sauri na mysql> zai bayyana, kuma zaku iya aiwatar da duk wata sanarwa ta SQL akanta.

Bayan an aiwatar da umarnin da ke sama, nasarar shigar da aka samu shine kamar haka:

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.

A cikin misalin da ke sama, mun yi amfani da tushen mai amfani don shiga cikin uwar garken mysql, ba shakka, kuna iya amfani da sauran masu amfani da mysql don shiga.

Idan gata mai amfani ta wadatar, kowane mai amfani zai iya aiwatar da ayyukan SQL a cikin taga gaggawar umarni na mysql.

Don fita daga mysql> umarni da sauri za ku iya amfani da umarnin fita kamar haka:

mysql> exit
Bye

Haɗa zuwa MySQL ta amfani da rubutun PHP

PHP yana ba da aikin mysqli_connect() don haɗawa zuwa bayanan bayanai.

Aikin yana da sigogi 6, yana dawo da ID na haɗin gwiwa bayan haɗin haɗin gwiwa zuwa MySQL, kuma yana dawo da FALSE akan gazawar.

nahawu

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

Siffar Siga:

Kuna iya amfani da aikin mysqli_close() na PHP don cire haɗin yanar gizon MySQL.

Wannan aikin yana da siga guda ɗaya kawai, mai gano haɗin MySQL wanda aikin mysqli_connect() ya dawo bayan an ƙirƙiri haɗin kai mai nasara.

nahawu

bool mysqli_close ( mysqli $link )

Wannan aikin yana rufe haɗin da ba na dindindin ba zuwa uwar garken MySQL mai alaƙa da ƙayyadadden ID na haɗin haɗin.Idan ba a kayyade link_identifier ba, buɗe haɗin yanar gizo na ƙarshe yana rufe.

m:Yawancin lokaci ba lallai ba ne a yi amfani da mysqli_close() saboda buɗe hanyoyin haɗin da ba su dawwama suna rufe ta atomatik bayan rubutun ya gama aiwatarwa.

misali

Kuna iya gwada misalin mai zuwa don haɗawa zuwa uwar garken 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);
?>