Php实现mysql查询

安装php、php-common包，还要安装php-mysql，当然mysql是必须安装的。实现代码如下：

<?php

  $username="root";

  $userpass="";

  $dbhost='localhost';

  $dbdatabase="test";

  $query = "SELECT * FROM proxy";

  $db = connect($dbhost,$username,$userpass);

  $res = sql_exc($db,$query);

  var_dump($res);

  function connect($dbhost,$username,$userpass)

  {

      $db_connect=mysql_connect($dbhost,$username,$userpass); //or die("Unable to connect to the MySQL!");

      if($db_connect){echo "connected,success!\n";}

      else{echo "o,connect failed\n";}

      return $db_connect;

  }

 

  function sql_exc($db,$query)

  {

      global $dbdatabase;

      mysql_select_db($dbdatabase,$db);

      $result = mysql_query($query);

      $res = mysql_fetch_array($result);

      return $res;

  }

 

 ?>