Kedu ka esi jikọọ na MySQL nchekwa data? PHP script jikọọ na MySQL nchekwa data atụ

Otu esi jikọọMySQL nchekwa data? Njikọ ederede PHPMySQLnchekwa data atụ

MySQL njikọ

jiri mysql ọnụọgụ abụọ njikọ

Ị nwere ike iji ọnọdụ ọnụọgụ abụọ MySQL tinye iwu mysql ozugbo iji jikọọ na nchekwa data MySQL.

ihe atụ

Ihe a bụ ọmụmaatụ dị mfe nke ijikọ na ihe nkesa mysql site na ahịrị iwu:

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

Mgbe ịbanyechara nke ọma, windo mysql> iwu ga-apụta, ma ị nwere ike mebie nkwupụta SQL ọ bụla na ya.

Mgbe emechara iwu a dị n'elu, mmepụta nbanye na-aga nke ọma bụ nke a:

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.

N'ihe atụ dị n'elu, anyị jiri onye ọrụ mgbọrọgwụ banye na ihe nkesa mysql, n'ezie, ị nwekwara ike iji ndị ọrụ mysql ndị ọzọ banye.

Ọ bụrụ na ikike onye ọrụ zuru oke, onye ọrụ ọ bụla nwere ike ịrụ ọrụ SQL na mpio ngwa ngwa mysql.

Iji pụọ na windo mysql> iwu ozugbo ị nwere ike iji iwu ọpụpụ dị ka ndị a:

mysql> exit
Bye

Jikọọ na MySQL site na iji PHP script

PHP na-enye ọrụ mysqli_connect() iji jikọọ na nchekwa data.

Ọrụ ahụ nwere paramita 6, weghachite ID njikọ mgbe njikọ MySQL na-aga nke ọma, wee laghachi FALSE na ọdịda.

ụtọ asụsụ

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

Nkọwa parameter:

Ị nwere ike iji PHP's mysqli_close() ọrụ kwụsịrị na MySQL nchekwa data.

Ọrụ a nwere naanị otu paramita, ihe njirimara njikọ MySQL weghachiri site na ọrụ mysqli_connect() mgbe emechara njikọ na-aga nke ọma.

ụtọ asụsụ

bool mysqli_close ( mysqli $link )

Ọrụ a na-emechi njikọ na-adịghị adịgide adịgide na sava MySQL jikọtara ya na NJ njikọ akọwapụtara.Ọ bụrụ na akọwapụtaghị link_identifier, njikọ mepere emepe ikpeazụ na-emechi.

ozugbo:Ọ naghị adị mkpa iji mysqli_close() n'ihi na a na-emechi njikọ na-adịghị adịgide adịgide na-akpaghị aka mgbe edemede ahụ mechara.

ihe atụ

Ị nwere ike ịnwale ihe atụ a iji jikọọ na sava MySQL gị:

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