Ungaxhuma kanjani ku-database ye-MySQL? Isikripthi se-PHP sokuxhuma kusibonelo sedatha ye-MySQL

Ungaxhuma kanjaniMySQL database? Uxhumano lweskripthi se-PHPMySQLisibonelo sesizindalwazi

Uxhumano lwe-MySQL

Xhuma usebenzisa imodi kanambambili ye-mysql

Ungasebenzisa imodi kanambambili ye-MySQL ukuze ufake umyalo we-mysql ukuze uxhume kusizindalwazi se-MySQL.

Isibonelo

Okulandelayo isibonelo esilula sokuxhuma kuseva ye-mysql kusuka kumugqa womyalo:

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

Ngemuva kokungena ngempumelelo, iwindi le-mysql> lomyalo lizovela, futhi ungenza noma yisiphi isitatimende se-SQL kuso.

Ngemva kokukhishwa komyalo ongenhla, umphumela wokungena ophumelelayo umi kanje:

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.

Esibonelweni esingenhla, sisebenzise umsebenzisi wempande ukungena kuseva ye-mysql, vele, ungasebenzisa abanye abasebenzisi be-mysql ukungena.

Uma amalungelo omsebenzisi anele, noma yimuphi umsebenzisi angenza imisebenzi ye-SQL kuwindi lomyalo we-mysql.

Ukuphuma ku-mysql> iwindi le-command prompt ungasebenzisa umyalo wokuphuma ngale ndlela elandelayo:

mysql> exit
Bye

Xhuma ku-MySQL usebenzisa umbhalo we-PHP

I-PHP inikeza umsebenzi we-mysqli_connect() ukuze uxhume kusizindalwazi.

Umsebenzi unamapharamitha angu-6, ubuyisela i-ID yokuxhuma ngemva kokuxhumeka okuyimpumelelo ku-MySQL, futhi ubuyisela FALSE ekuhlulekeni.

uhlelo lolimi

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

Incazelo yepharamitha:

Ungasebenzisa umsebenzi we-mysqli_close() we-PHP ukuze unqamule kusizindalwazi se-MySQL.

Lo msebenzi unepharamitha eyodwa kuphela, isihlonzi soxhumano lwe-MySQL esibuyiswe umsebenzi we-mysqli_connect() ngemva kokwakhiwa kokuxhumana okuyimpumelelo.

uhlelo lolimi

bool mysqli_close ( mysqli $link )

Lo msebenzi uvala uxhumano olungaqhubeki kuseva ye-MySQL ehlotshaniswa ne-ID yokuxhumana eshiwo.Uma kungekho link_identifier eshiwo, ukuxhumana kokugcina okuvuliwe kuyavalwa.

ngokushesha:Ngokuvamile akudingekile ukusebenzisa i-mysqli_close() ngoba ukuxhumeka okuvulekile okungaphezi kuvalwa ngokuzenzakalelayo ngemva kokuba iskripthi siqede ukusebenza.

Isibonelo

Ungazama lesi sibonelo esilandelayo ukuze uxhume kuseva yakho ye-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);
?>