Littafin Adireshi
Yadda ake haɗawa zuwa rumbun adana bayanai na MySQL ? Misalin amfani da rubutun PHP don haɗawa zuwa rumbun adana bayanai na MySQL .
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:
| Matsayi | bayanin |
|---|---|
| rundunar | Na zaɓi.Yana ƙayyade sunan mai masauki ko adireshin IP. |
| sunan mai amfani | Na zaɓi.Yana ƙayyade sunan mai amfani na MySQL. |
| password | Na zaɓi.Yana ƙayyade kalmar sirri ta MySQL. |
| db suna | Na zaɓi.Yana ƙayyadad da tsoffin bayanai don amfani. |
| tashar jiragen ruwa | Na zaɓi.Yana ƙayyade lambar tashar jiragen ruwa don ƙoƙarin haɗi zuwa uwar garken MySQL. |
| soket | Na zaɓi.Yana ƙayyade soket ko bututu mai suna don amfani. |
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.
Lura: Yawanci ba kwa buƙatar amfani da mysqli_close(), saboda duk wani haɗin da ba ya tsayawa zai rufe ta atomatik bayan an gama aiwatar da rubutun.
misali
Kuna iya gwada misalin mai zuwa don haɗawa zuwa uwar garken MySQL:
haɗi zuwa 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);
?>Da fatan, labarin "Yadda Ake Haɗawa da Bayanan MySQL? Misalin Rubutun PHP na Haɗawa da Bayanan MySQL," wanda aka raba a shafin yanar gizon Chen Weiliang ( https://www.chenweiliang.com/ ), zai taimaka muku.
Ku ji daɗin raba wannan labarin ta hanyar haɗin yanar gizo: https://www.chenweiliang.com/cwl-456.html
