php基础之连接mysql数据库和查询数据

$con=mysql_connect($dbhostip,$username,$userpassword) or die("Unable to connect to the MySQL!");
$db = mysql_select_db($dbdatabasename,$con);
//履行语句
$qres=mysql_query("SELECT id,GoodsName FROM user");
//提取一条数据
11 $row=mysql_fetch_row($result);//mysql_fetch_row只能提取出查询成果的第一条记载
//提取多条记载
$reslist = array();
$i=0;
while($row = mysql_fetch_row($res)){
   $reslist[$i] = $row;
   $i++;
  }
mysql_close($con);