Nzira yekubatanidza kune MySQL database? PHP script yekubatanidza kune MySQL database muenzaniso

Ungabatanidza seiMySQL database? PHP script kubatanaMySQLmuenzaniso we database

MySQL kubatana

Batanidza uchishandisa mysql binary modhi

Iwe unogona kushandisa iyo MySQL binary kuti uwane iyo mysql yekuraira nekukurumidza kuti ubatanidze kune MySQL dhatabhesi.

muenzaniso

Iyi inotevera muenzaniso wakapusa wekubatanidza kune mysql server kubva pamutsetse wekuraira:

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

Mushure mekupinda kwakabudirira, iyo mysql> yekuraira hwindo ichaonekwa, uye iwe unogona kuita chero SQL chirevo pairi.

Mushure mekunge murairo uri pamusoro waitwa, iyo yakabudirira yekubuda inobuda seiyi:

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.

Mumuenzaniso wepamusoro, takashandisa mudzi wekushandisa kuti upinde kune mysql server, hongu, unogonawo kushandisa vamwe vashandisi ve mysql kupinda.

Kana maropafadzo emushandisi akakwana, chero mushandisi anogona kuita SQL mashandiro mu mysql command prompt window.

Kuti ubude mu mysql> command prompt hwindo unogona kushandisa murairo wekubuda sezvinotevera:

mysql> exit
Bye

Batanidza kuMySQL uchishandisa PHP script

PHP inopa iyo mysqli_connect () basa rekubatanidza kune dhatabhesi.

Basa racho rine 6 paramita, rinodzorera ID yekubatanidza mushure mekubudirira kwekubatana kuMySQL, uye inodzorera FALSE pakukundikana.

girama

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

Parameter Tsanangudzo:

Unogona kushandisa PHP's mysqli_close() basa kuti ubvise kubva kuMySQL dhatabhesi.

Iri basa rine parameter imwe chete, iyo MySQL yekubatanidza identifier yakadzoserwa ne mysqli_connect() basa mushure mekubudirira kwekubatana kwagadzirwa.

girama

bool mysqli_close ( mysqli $link )

Iri basa rinovhara iyo isingarambe ichibatana neMySQL server yakabatana neiyo yakataurwa yekubatanidza ID.Kana pasina link_identifier yatsanangurwa, yekupedzisira yakavhurwa yekubatanidza inovharwa.

kukurumidza:Kushandisa mysqli_close() kazhinji hazvidiwi nekuti kuvhurika kusingarambe kuchingovharwa kunovharwa otomatiki mushure mekunge script yapedza kuita.

muenzaniso

Iwe unogona kuedza inotevera muenzaniso kuti ubatanidze kune yako MySQL server:

<?
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);
?>