PHP操作資料庫：insert create 操作_PHP教程

/* 2011.7.27

*/

$demos =new Demo();
$dbname="create database tools";
$dbtabla="create table admin(name varchar(200),pass varchar(200))";
$values="insert into admin values('Feihacker','tools')";
$demos->CreateDB($dbname);
$demos->CreateDB($dbtabla,"tools");
$demos->CreateDB($values,"tools");
class Demo
{ /*執行插入操作
*/
public function CreateDB($sql,$name){
$conn =mysql_connect("localhost","root","root");//建立連線物件
if(!empty($name)) //建立表 //判斷是否為空白
{
mysql_select_db($name,$conn); //選定資料庫
if(!mysql_query($sql)){ echo"error". mysql_error();} //mysql_query();執行sql語句
mysql_close($conn); //關閉串連
}
else
{
if(!mysql_query($sql)){ echo"error". mysql_error();}
mysql_close($conn);
}
}

}

?>
from:菲 blog

http://www.bkjia.com/PHPjc/478704.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/478704.htmlTechArticle?php /* 2011.7.27 */ $demos =new Demo(); $dbname=create database tools; $dbtabla=create table admin(name varchar(200),pass varchar(200)); $values=insert into admin values(Feihacker...

