[教程]PHP实现Mysql的操作
2012/7/22 18:44:00 人气 287 怀旧国机论坛一、连接和关闭数据库
1.连接数据库
php通过mysql提供的API与mysql连接。mysql提供了两个用于连接数据库的函数,格式如下:
int mysql_connect(string[hostname[:port][:/path/to/socket]],string[username],string [password]);
int mysql_pconnect(string[hostname[:port][:/path/to/socket]],string[username],string[password]);
示例:
=mysql_connect(“localhost“,“username“,“password“);
echo .“
“;
=mysql_pconnect(“lcoalhost“,“username“,“password“);
echo .“
“;
?>
2.关闭数据库连接
格式如下:
int mysql_close(int[link_identifier])
示例:
[code=php]
=mysql_close(“localhost“,“username“,“password“);
echo .“
“;
=mysql_close();
echo ;
?>
[/code]
二、创建、选择、删除数据库
如下格式:
1.int mysql_*_db(string datebase_name,int[link_identifier])
2.int mysql_*_db(string datebase_name,int[link_identifier])
3.int mysql_*_db(string datebase_name,int[link_identifier])
示例:
=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[link_identifier]);
int mysql_db_query(strint datebase_name,string query,int[link_identifier])
示例:
=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!
“;
}
}
}
?>
1.连接数据库
php通过mysql提供的API与mysql连接。mysql提供了两个用于连接数据库的函数,格式如下:
int mysql_connect(string[hostname[:port][:/path/to/socket]],string[username],string [password]);
int mysql_pconnect(string[hostname[:port][:/path/to/socket]],string[username],string[password]);
示例:
=mysql_connect(“localhost“,“username“,“password“);
echo .“
“;
=mysql_pconnect(“lcoalhost“,“username“,“password“);
echo .“
“;
?>
2.关闭数据库连接
格式如下:
int mysql_close(int[link_identifier])
示例:
[code=php]
=mysql_close(“localhost“,“username“,“password“);
echo .“
“;
=mysql_close();
echo ;
?>
[/code]
二、创建、选择、删除数据库
如下格式:
1.int mysql_*_db(string datebase_name,int[link_identifier])
2.int mysql_*_db(string datebase_name,int[link_identifier])
3.int mysql_*_db(string datebase_name,int[link_identifier])
示例:
=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[link_identifier]);
int mysql_db_query(strint datebase_name,string query,int[link_identifier])
示例:
=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!
“;
}
}
}
?>
绝客网:http://jkniu.com
沙发 | 『惜缘』→淰℉天堂卍海07-22 19:04 看过了 |
发表回复