Uqhagamshelwa njani kwisiseko sedatha seMySQL? Umbhalo we-PHP ukudibanisa kumzekelo wesiseko sedatha ye-MySQL

Indlela yokudibanisaMySQL database? uqhagamshelo lweskripthi se-PHPMySQLumzekelo wesiseko sedata

Uqhagamshelo lweMySQL

sebenzisa udibaniso lwe-mysql yokubini

Ungasebenzisa imowudi yokubini ye-MySQL ukufaka i-mysql yomyalelo wokukhawuleza ukudibanisa kwi-database ye-MySQL.

Umzekelo

Okulandelayo ngumzekelo olula wokudibanisa kwiseva ye-mysql ukusuka kumgca womyalelo:

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

Emva kokungena ngempumelelo, i-mysql> iwindow ye-prompt window iya kuvela, kwaye unokwenza nayiphi na inkcazo ye-SQL kuyo.

Emva kokuba lo myalelo ungentla uphunyeziwe, isiphumo sokungena siphumelele ngolu hlobo lulandelayo:

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.

Kulo mzekelo ungentla, sisebenzise ingcambu yomsebenzisi ukungena kwiseva ye-mysql, ewe, ungasebenzisa nabanye abasebenzisi be-mysql ukungena.

Ukuba amalungelo omsebenzisi anele, nawuphi na umsebenzisi angenza imisebenzi ye-SQL kwi-mysql yomyalelo wefestile.

Ukuphuma kwi-mysql> ifestile yomyalelo womyalelo ungasebenzisa umyalelo wokuphuma ngolu hlobo lulandelayo:

mysql> exit
Bye

Qhagamshela kwiMySQL usebenzisa iscript sePHP

I-PHP ibonelela nge-mysqli_connect() umsebenzi wokuqhagamshela kuvimba weenkcukacha.

Umsebenzi uneeparamitha ezi-6, ubuyisela i-ID yoxhulumaniso emva koqhagamshelo oluyimpumelelo kwi-MySQL, kwaye ibuyisela i-FALSE ekungaphumeleli.

Igrama

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

Inkcazo yeParameter:

Ungasebenzisa mysqli_close () umsebenzi we-PHP ukukhulula uqhagamshelwano kwisiseko sedatha seMySQL.

Lo msebenzi uneparameter enye kuphela, isazisi soqhagamshelo lweMySQL sibuyiswe ngu mysqli_connect () umsebenzi emva kokuba uxhulumaniso lwenziwe ngempumelelo.

Igrama

bool mysqli_close ( mysqli $link )

Lo msebenzi uvala uxhulumaniso olungaqhubekiyo kumncedisi we-MySQL onxulunyaniswa ne-ID yodibaniso olukhankanyiweyo.Ukuba akukho link_identifier echaziweyo, uqhagamshelo lokugqibela oluvuliweyo luyavalwa.

ukukhawuleza:Ngokuqhelekileyo akuyomfuneko ukusebenzisa i-mysqli_close() kuba uqhagamshelo oluvulekileyo olungaqhubekiyo luvalwa ngokuzenzekelayo emva kokuba iskripthi sigqibile ukuphumeza.

Umzekelo

Ungazama lo mzekelo ulandelayo ukuqhagamshela kwiseva 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);
?>