php MYSQL

PHP MYSQL

• 数据库连接

   <?
   	//mysql扩展
   	$like = mysql_connect('host','DB_name','DB_password')
  
   	//mysqli扩展
   	$like = mysqli_connect('host','DB_name','DB_password')
  
   	//PDO扩展
   	$dsn = 'mysql:dbname=dbName;host=IP';
   	$user = 'dbuser';
   	$pass = 'dbpassword';
   	$dbh = new PDO($dsn,$user,$pass);
  
   ?>
  

• 例：

   <?php
   	$link = mysql_connect('127.0.0.1', 'code1', '') or die('数据库连接失败');
   	//选择数据库
   	mysql_select_db('code1');
   	//声明编码
   	mysql_query("set names 'utf8'");
   	//执行语句
   	$result = mysql_query('select * from user limit 1');
   	//从结果集中取得一行作为关联数组
   	$row = mysql_fetch_assoc($result);
   	//打印数组
   	print_r($row);
   	//关闭数据库
   	mysql_close($link);