mysql 链接 与关闭

show processlist; 显示链接数据库的进程

php链接数据库

<?php

$db_host='113.0.42.163:3306';
$db_database='test';
$db_username='root';
$db_password='root';
$connection=mysql_connect($db_host,$db_username,$db_password)or die(mysql_error());//连接到数据库

if (mysql_create_db("my_db")) {
print ("Database created successfully\n");
} else {
printf ("Error creating database: %s\n", mysql_error());
}

?>

报错

this is test-mysql-con
Fatal error: Call to undefined function mysql_create_db() in D:\Documents\Desktop\jiagou\php\php-5\test\emysqlc.php on line 9

或者

<?php
echo "this is test-mysql-con";
$db_host='113.0.42.163:3306';
//$db_database='test';
$db_username='root';
$db_password='root';
$con=mysql_connect($db_host,$db_username,$db_password);//连接到数据库
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
$sql = "CREATE DATABASE my_db";
if (mysql_query($sql,$con))
  {
  echo "Database my_db created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }
?>

关闭链接

关闭连接

脚本一结束，就会关闭连接。如需提前关闭连接，请使用 mysql_close() 函数。

<?php
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

// some code

mysql_close($con);               //******关闭链接**************
?>