mysql 增的封装函数_封装函数增删改查

第一张表封装函数

define("HOST","127.0.0.1");//链接数据库

define("USER","root");//链接数据库

define("PWD","");//链接数据库密码

$conn="";

function get_conn(){//得到 $conn

global $conn;//调用$conn

$conn =

mysql_connect(HOST,USER,PWD) or die(mysql_error());

mysql_select_db("test",$conn);

mysql_query("set names

‘utf8‘");

}

//插入方法

function insert($sql){

mysql_query($sql);

}

//更改数据

function update($sql){

mysql_query($sql);

}

//删除数据

function delete($sql){

mysql_query($sql);

}

//查询数据并显示

function select($sql){

$rut = mysql_query($sql);

while($row = mysql_fetch_array($rut)){

echo $row[0];

echo

"
";

echo "
";

echo $row[1];

echo "
";

echo "
";

echo $row[2];

echo "
";

echo "
";

echo $row[3];

echo "
";

}

}

function close(){

global $conn;

mysql_close($conn);

}

?>

第二章表 调用函数

content="text/html;charset=UTF-8"/>

include"user.php";

get_conn();

//插入数据

//$sql

=insert("INSERT INTO `user`(`id`, `userName`, `nickName`, `password`) VALUES

(null,‘安安‘,‘安安‘,123)");

//更新数据

// $sql = update("UPDATE `user` SET

`id`=4,`userName`=888,`nickName`=888,`password`=888 WHERE id

=‘2‘");

//删除数据

//$sql = delete("DELETE FROM `user` WHERE id =

‘12‘");

//查询数据

$sql = select("SELECT * FROM `user`");

?>

原文：http://www.cnblogs.com/ZH1132672711/p/3728878.html