if ($_POST["admin"]!=""){
$admin=$_POST["admin"];
$pwd=$_POST["pwd"];
$conn = new com("ADODB.Connection");
$connstr="DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath("../../YCHB85SAD87/#YCHB85SAD87.mdb");
$conn->open($connstr);
$sql="select * from admin where admin='$admin' and pwd='$pwd'";
$rs = new com("ADODB.RecordSet");
$rs->Open($sql,$conn,1,1);
if(! $rs->eof){
session_start();
$_SESSION['username']=$rs['username'];
echo "<script>alert('登录成功!');window.location='main1.asp';</script>";
}
else{
echo "<script>alert('登录失败!');history.back();</script>";
}
}
Warning: (null)(): Invoke() failed: 发生意外。 Source: Microsoft OLE DB Provider for ODBC Drivers Description: 操作已被取消。Warning: (null)(): Invoke() failed: 发生意外。 Source: ADODB.Recordset Description: 连接无法用于执行此操作。在此上下文中它可能已被关闭或无效。
新手求helpPHPSQL
$admin=$_POST["admin"];
$pwd=$_POST["pwd"];
$conn = new com("ADODB.Connection");
$connstr="DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath("../../YCHB85SAD87/#YCHB85SAD87.mdb");
$conn->open($connstr);
$sql="select * from admin where admin='$admin' and pwd='$pwd'";
$rs = new com("ADODB.RecordSet");
$rs->Open($sql,$conn,1,1);
if(! $rs->eof){
session_start();
$_SESSION['username']=$rs['username'];
echo "<script>alert('登录成功!');window.location='main1.asp';</script>";
}
else{
echo "<script>alert('登录失败!');history.back();</script>";
}
}
Warning: (null)(): Invoke() failed: 发生意外。 Source: Microsoft OLE DB Provider for ODBC Drivers Description: 操作已被取消。Warning: (null)(): Invoke() failed: 发生意外。 Source: ADODB.Recordset Description: 连接无法用于执行此操作。在此上下文中它可能已被关闭或无效。
新手求helpPHPSQL
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货