Question

php高手来封装一段代码

把下面的文件上传功能给封装了，是php面向对象的要正确的，在线等说直接弄个函数粘贴的死远
<?php
$con=mysql_connect("localhost","root","000");
mysql_select_db("wode",$con);
$pd=md5("$_POST[userpasswd]");
$sql="INSERT INTO zhuce(`username`,`userpasswd`,`qqhao`,`xingbie`,`mail`,`mail1`)
VALUES
('$_POST[username]','$pd','$_POST[qqhao]','$_POST[xingbie]','$_POST[mail]','$_POST[mail1]');";
echo $sql;
mysql_query($sql);
mysql_close($con);
?>

Answer 1

<?PHP
class conn{
private $con;
private $Host="localhost";
private $User="root";
private $Password="000";
private $Db="wode";
private $sql;
function dbsql($host,$user,$pwd,$dbname){ //定义数据库连接
$host=$this->Host;
$user=$this->User;
$pwd=$this->Password;
$dbname=$this->Db;
$con=mysql_connect($host,$user,$pwd);
mysql_select_db($dbname,$con);
return true;
}
function insert($strsql){ //定义插入方法
if(empty($strsql)){
return false;
}
$con=$this->con;
$results=mysql_query($strsql,$con);
return $results;
}
}
?>
//方法调用
$sql=$sql="INSERT INTO zhuce(`username`,`userpasswd`,`qqhao`,`xingbie`,`mail`,`mail1`)
VALUES
('$_POST[username]','$pd','$_POST[qqhao]','$_POST[xingbie]','$_POST[mail]','$_POST[mail1]');";
$c=new conn();
$c->insert($sql);

Answer 2

PHPCHINA 康盛产品工程师就业班祝您成功 先上班后还款 qq1257458734