$connect=mssql_pconnect("localhost","sa",""); mssql_select_db($database,$connect);//连接成功了吗?//选择了数据库了吗?? //echo $datebase;出来看看; if($xuan=="create"){ $query="create table mary (a int,b int)"; } if($xuan=="insert"){ $query="insert into mary values('$a','$b')"; } if($xuan=="updata"){ $query="updata mary set $a=$c"; } if($xuan=="drop"){ $query="drop mary"; }改成if($xuan=="create"){ $query="create table mary (a int,b int)"; } else if($xuan=="insert"){ $query="insert into mary values('$a','$b')"; } else if($xuan=="updata"){ $query="updata mary set $a=$c"; } else if($xuan=="drop"){ $query="drop mary"; }
$connect=mssql_pconnect("localhost","sa",""); mssql_select_db($database,$connect);//连接成功了吗?//选择了数据库了吗?? //echo $datebase;出来看看; if($xuan=="create"){ $query="create table mary (a int,b int)"; } if($xuan=="insert"){ $query="insert into mary values('$a','$b')"; } if($xuan=="updata"){ $query="updata mary set $a=$c"; } if($xuan=="drop"){ $query="drop mary"; }改成if($xuan=="create"){ $query="create table mary (a int,b int)"; } else if($xuan=="insert"){ $query="insert into mary values('$a','$b')"; } else if($xuan=="updata"){ $query="updata mary set $a=$c"; } else if($xuan=="drop"){ $query="drop mary"; }
<option value=create>创建</option>
<option value=insert>插入</option>
<option value=updata>更新</option>
<option value=drop>删除</option>
</select>
mssql_select_db($database,$connect);//连接成功了吗?//选择了数据库了吗??
//echo $datebase;出来看看;
if($xuan=="create"){
$query="create table mary (a int,b int)";
}
if($xuan=="insert"){
$query="insert into mary values('$a','$b')";
}
if($xuan=="updata"){
$query="updata mary set $a=$c";
}
if($xuan=="drop"){
$query="drop mary";
}改成if($xuan=="create"){
$query="create table mary (a int,b int)";
}
else if($xuan=="insert"){
$query="insert into mary values('$a','$b')";
}
else if($xuan=="updata"){
$query="updata mary set $a=$c";
}
else if($xuan=="drop"){
$query="drop mary";
}
mssql_select_db($database,$connect);//连接成功了吗?//选择了数据库了吗??
//echo $datebase;出来看看;
if($xuan=="create"){
$query="create table mary (a int,b int)";
}
if($xuan=="insert"){
$query="insert into mary values('$a','$b')";
}
if($xuan=="updata"){
$query="updata mary set $a=$c";
}
if($xuan=="drop"){
$query="drop mary";
}改成if($xuan=="create"){
$query="create table mary (a int,b int)";
}
else if($xuan=="insert"){
$query="insert into mary values('$a','$b')";
}
else if($xuan=="updata"){
$query="updata mary set $a=$c";
}
else if($xuan=="drop"){
$query="drop mary";
}
<body>
<form name="form1" action=2.php method=post>
数据库:<input name=database size=13><br>
值:<input name=a size=7> <input name=b size=7><br>
更新值:<input name=c size=7>
<select name=xuan>
<option value=create>创建</option>
<option value=insert>插入</option>
<option value=updata>更新</option>
<option value=drop>删除</option>
</select><br>
<input type=submit name=submit value=ok>
</body>
</html>这个是我做的连接数据库如下:
<?php
$connect=mssql_pconnect("localhost","sa","");
mssql_select_db($database,$connect);//连接成功了吗?//选择了数据库了吗??
//echo $datebase;出来看看;
if($xuan=="create"){
$query="create table mary (a int,b int)";
}
else if($xuan=="insert"){
$query="insert into mary values('$a','$b')";
}
else if($xuan=="updata"){
$query="updata mary set $a=$c";
}
else if($xuan=="drop"){
$query="drop mary";
}
//echo $query看看执行什么,
$result=mssql_query($query);
if($result){
echo "ok"
}else{
echo "false"
}
?>