奋斗足迹|崔玉松

 
<?php
/* Redirect to a different page in the current directory that was requested */
$host = $_SERVER['HTTP_HOST'];
$uri = rtrim(dirname($_SERVER['PHP_SELF']), '/\');
$extra = 'mypage.php';
header("Location: http://$host$uri/$extra");
exit;
?>

if($db=mysql_connect( $host,$userName,$passwd))

 
if($db=mysql_connect( $this->host,$this->userName,$this->passwd))

<?php
/**
 * 数据库操作类
 */
 
class MySql {
 
	var $user,$pass,$host,$db;
	var $id,$data,$fields,$row,$row_num,$insertid,$version,$query_num=0;
 
	function MySql($host,$user,$pass,$db)
	{
		$this->host = $host;
		$this->pass = $pass;
		$this->user = $user;
		$this->db = $db;
		$this->dbconnect($this->host, $this->user, $this->pass);
		$this->selectdb($this->db);
 
	}
	function dbconnect($host,$user,$pass)
	{
		$this->id = @ mysql_connect($host,$user,$pass) OR
		sysMsg("连接数据库失败,可能是mysql数据库用户名或密码错误");
	}
	function selectdb($db)
	{
		@ mysql_select_db($db,$this->id) OR sysMsg("未找到指定数据库");
	}
 
	function query($sql)
	{
		$query = @ mysql_query($sql,$this->id)
		OR sysMsg("SQL语句执行错误：$sql <br />".$this->geterror());
		$this->query_num();
		return $query;
	}
 
	function fetch_array($query)
	{
		$this->data = @mysql_fetch_array($query);
		return $this->data;
	}
	function query_num()
	{
		$this->query_num++;
	}
	function num_fields($query)
	{
		$this->fields = @mysql_num_fields($query);
		return $this->fields;
	}
	function fetch_row($query)
	{
		$this->row = @mysql_fetch_row($query);
		return $this->row;
	}
 
	function num_rows($query)
	{
		$this->row_num = @mysql_num_rows($query);
		return $this->row_num;
	}
 
	function insert_id()
	{
		$this->insertid = mysql_insert_id();
		return $this->insertid;
	}
 
	function fetch_one_array($sql)
	{
		$query = $this->query($sql);
		$this->data = $this->fetch_array($query);
		return $this->data;
	}
	function geterror()
	{
		return mysql_error();
	}
}
 
?>

<?php
  class OperateDB
  {
  // 	var 	$db;
   	static $host="localhost";
   	static $user="root";
   	static $passwd="";
 
 
   	//连接数据库
    public	function OpenDB()
    {
    	try
    	{
    		if($db=mysql_connect( $host,$user,$passwd))
    		{
    			return $db;
    		}
    		else
    		{
    			throw new exception("Sorry,could not connect to mysql.");
    		}
    	}
    	catch(exception $e)
    	{
    		echo $e->getmessage();
    	}
    }
    //选择数据库
    public function SelectDB($whichdb,$db)
    {
    	try
    	{
 
    		if(!mysql_select_db($whichdb,$db))
    		{
    			throw new exception("Sorry,database could not be opened.");
    		}
 
    	}
    	catch(exception $e)
    	{
    		echo $e->getmessage();
    	}
 
    }
    public function CloseDB($db)
    {
    	mysql_close($db);
    }
 
    public function Query($queryString)
    {
    	if($mysquery=mysql_query("$queryString"))
    	{
    		return $mysquery;
    	}
    	else
    	{
    		echo mysql_error();
    	}
    }
 
 
 
  }
?>