PHP 和 MYSQL 简单应用

<?php
/*
 * Created on 2010-11-9
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */

//数据库连接
$conn = @mysql_connect("localhost","root","") or die("连接错误");

 

//连接一个表
mysql_select_db("newdb",$conn);

 

//插入语句
//$sql = "INSERT INTO test(id,uid,regdate) values ('','php100',now())";

 

//执行
//mysql_query($sql,$conn);

 

//搜索语句

$sql = "SELECT * FROM `test`";

 

//乱码处理
mysql_query("set names 'GBK'");

 

//执行
$query = mysql_query($sql,$conn);

 

//数组化
 //$row = mysql_fetch_row($query);//数组化

 

//输出
//print_r($row);

//输出具体值

 //echo $row[1];

//
 //$row = mysql_fetch_array($query);

 //echo $row[regdate];

 //循环
 while($row = mysql_fetch_array($query)){
  echo $row[uid]."<br><br>";
 }
 echo '----------------<br>';
 echo mysql_num_rows($query);//返回 行数

 

?>