一、连接和关闭数据库
1.连接数据库
php通过mysql提供的API与mysql连接。mysql提供了两个用于连接数据库的函数，格式如下：
int mysql_connect(string[hostname],string,string );
int mysql_pconnect(string[hostname],string,string);
示例：
=mysql_connect(“localhost“,“username“,“password“);
echo .“
“;
=mysql_pconnect(“lcoalhost“,“username“,“password“);
echo .“
“;
?>
2.关闭数据库连接
格式如下：
int mysql_close(int)
示例：
=mysql_close(“localhost“,“username“,“password“);
echo .“
“;
=mysql_close();
echo ;
?>
二、创建、选择、删除数据库
如下格式：
1.int mysql_*_db(string datebase_name,int)
2.int mysql_*_db(string datebase_name,int)
3.int mysql_*_db(string datebase_name,int)
示例：
=mysql_connect(“localhost“,“username“,“password“);
if()
{
//建立数据库
=mysql_*_db(“books“,);
if(!)
echo “* datebase failed!
“;
else{
echo “* datebase sueccessfully!
“;
//选择数据库
=mysql_*_db(“books“,);
if(!*_db)
echo “* datebase failed!
“;
else
echo “* datebase sueccessfully!
“;
//删除数据库
=mysql_dorp_db(“books“,);
if(!)
echo “* datebase failed!
“;
else
echo “* datebase sueccessfully!
“;
}
}
?>
三、增删改数据
1.提交sql语句
int mysql_query(string query,int);
int mysql_db_query(strint datebase_name,string query,int)
示例：
=mysql_connect(“localhost“,“username“,“password“);
if()
{
//建立数据库
=mysql_*_db(“books“,);
if(!)
echo “* datebase failed!
“;
else{
echo“* datebase sueccessfully!
“;
//选择数据库
=mysql_*_db(“books“,);
//创建表computers
=“* table computers(“;
.=“id int(3) auto_increment not null primary key,“;
.=“name char(10) not null,“;
.=“price float default 0,“;
.=“publish_date date)“;
echo .“
“;
=mysql_query();
if(!)
echo “* table failed!
“;
else{
echo “* table successfully!
“;
//插入一条记录
=“* into computers(name,price,publish_date)“;
.=“values(‘数据结构‘,20.00,‘2001-1-1‘)“;
echo .“
“;
=mysql_query();
if(!)
echo “* date failed!
“;
else
echo “* date successfully!
“;
//修改记录
=“* computers “;
.=“set price=price+2 “;
.=“where name=‘数据结构‘“;
echo .“
“;
=mysql_query();
if(!)
echo “* data failed!
“;
else
echo “* data successfully!
“;
//删除记录
=“* from computers “;
.=“where name=‘数据结构‘“;
echo .“
“;
=mysql_query();
if(!)
echo “* data failed!
“;
else
echo “* date successfully!
“;
}
}
}
?>