php5.5 mysql链接_PHP 5.5.0版以前的php+mysql的连接方法

PHP 5.5.0版以前的php+mysql的连接方法

一、基础操作

发起会话

$conn = @mysql_connect($host,$name,$pwd);

选择数据库

@mysql_select_db($db,$conn);

设置参数(如：编码)

mysql_query("set names gb2312"); //设置编码

操作(CURL)

关闭会话

mysql_close($conn);

二、封装类库

目录

| pro 项目目录

| -- | mysql.php

| -- | index.php

文件mysql.php

//PHP 5.5.0版以前

class mysql {

private $host = 'localhost'; //服务器地址

private $name = 'root'; //登录账号

private $pwd = 'root'; //登录密码

private $db = 'db'; //数据库名称

private $conn = ''; //数据库连接资源

private $result = ''; //结果集

private $msg = ''; //返回结果

private $fields; //返回字段

private $fieldsNum = 0; //返回字段数

private $rowsNum = 0; //返回结果数

private $rowsRst = ''; //返回单条记录的字段数组

private $filesArray = array(); //返回字段数组

private $rowsArray = array(); //返回结果数组

function __construct($host='',$name='',$pwd='',$db=''){

if(!empty($host)) $this->host = $host;

if(!empty($name)) $this->name = $name;

if(!empty($pwd)) $this->pwd = $pwd;

if(!empty($db)) $this->db = $db;

$this->init_conn();

}

//连接数据库

function init_conn(){

$this->conn = @mysql_connect($this->host,$this->name,$this->pwd);

@mysql_select_db($this->db,$this->conn);

mysql_query("set names gb2312"); //设置编码

}

//查询结果

function mysql_query_rst($sql){

if($this->conn == '') $this->init_conn();

$this->result = @mysql_query($sql,$this->conn);

}

//返回查询记录数函数

function getRowsNum($sql){

$this->mysql_query_rst($sql);

if(mysql_errno() == 0){

return @mysql_num_rows($this->result);

}else{

return '';

}

}

//取得记录数函数

function getRowsRst($sql){

$this->mysql_query_rst($sql);

if(mysql_errno() == 0){

$this->rewsRst = mysql_fetch_array($this->result,MYSQL_ASSOC);

return $this->rewsRst;

}else{

return '';

}

}

//取得记录数组(多条记录)

function getRowsArray($sql){

$this->mysql_query_rst($sql);

if(mysql_errno() == 0){

while($row = mysql_fetch_array($this->result,MYSQL_ASSOC)){

$this->rowsArray[] = $row;

}

return $this->rowsArray;

}else{

return '';

}

}

//返回更新、删除、添加的记录数函数

function uidRst($sql){

if($this->conn == '') $this->init_conn();

@mysql_query($sql);

$this->rowsNum = @mysql_affected_rows();

if(mysql_errno() == 0){

return $this->rowsNum;

}else{

return '';

}

}

//释放结果集函数

function close_rst(){

mysql_free_result($this->result);

$this->msg = '';

$this->fieldsNum = 0;

$this->rowsNum = 0;

$this->filesArray = '';

$this->rowsArray = '';

}

//关闭数据库函数

function close_conn(){

$this->close_rst();

mysql_close($this->conn);

$this->conn = '';

}

}

?>

文件index.php

//使用方法

require_once('mysql.php');

$mysql = new mysql();

$sql = "SELECT * FROM `user` WHERE id=1";

var_dump($opmysql->getRowsRst($sql));

die();

?>