如何在php块中编写mysql查询 [英] How to write mysql quries in php block

问题描述

function insert()
{
$con=mysql_connect("localhost","root","123");
if(!$con)
{
die('COULD NOT CONNECT'.mysql_error());
}
else
{
mysql_select_db("class",$con);
$cmd=mysql_query("insert into myclass values('$_REQUEST[sname]','$_REQUEST[sage]','$_REQUEST[std]','$_REQUEST[sec]','$_REQUEST[per]')",$con);
}
}
insert();


function delete()
{
$con=mysql_connect("localhost","root","123");
if(!$con)
{
die('COULD NOT CONNECT'.mysql_error());
}
else
{
mysql_select_db("class",$con);
$cmd=mysql_query("delete from myclass where name='$_REQUEST[sname]'",$con);
}
}
delete();


function update()
{
$con=mysql_connect("localhost","root","123");
if(!$con)
{
die('COULD NOT CONNECT'.mysql_error());
}
else
{
mysql_select_db("class",$con);
$cmd=mysql_query("update myclass set per='$_REQUEST[per]' where name='$_REQUEST[sname]'",$con);
}
}
update();
?>

这是我的代码.但这并不执行用户单击的按钮.默认情况下，它执行此功能中的任何一个.它无法正常运行正确的按钮事件...任何人都可以帮助我....

This is my code. But this is not execute the user clicked button enent. It defaultly execute any one of this funtion. it''s not working the correct button event...any one help me....

推荐答案

con = mysql_connect( localhost"， root "， 123")； if(！

con=mysql_connect("localhost","root","123"); if(!

con) { die(' 可能无法连接' .mysql_error()); } 其他 { mysql_select_db(" ，

con) { die('COULD NOT CONNECT'.mysql_error()); } else { mysql_select_db("class",

con);

这篇关于如何在php块中编写mysql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！