<?php
session_start();
$authnum=$_SESSION['authnum'];
$serverName = "ACER"; //数据库服务器地址
$uid = "admain"; //数据库用户名
$pwd = "1234"; //数据库密码
$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"单位员工房产管理系统");
$conn = sqlsrv_connect($serverName, $connectionInfo);
$username=$_POST["textfield"];
$password=$_POST["textfield2"];
$radio=$_POST["RadioGroup1"];
if($conn == false)
{
echo "连接失败!";
die( print_r(sqlsrv_errors(),true));
}else if($username==''){
echo"用户名为空!";
header("Refresh:5;url=loading.php");
}
else if($password==''){
echo"密码为空!";
header("Refresh:5;url=loading.php");
}
else if(isset($_POST['textfild3']))
{
if(strcmp($_POST['authinput'],$_SESSION['authnum'])==0)
echo"验证码错误!";
}
else if($radio=="员工"){
$sql="select * from loading_yuangong where eusername=$username and epassword=$password";
$params = array();
$options = array( "Scrollable" =>SQLSRV_CURSOR_KEYSET );
$stmt = sqlsrv_query($conn,$sql,$params,$options);
$row_count = sqlsrv_num_rows($stmt);
if($row_count>0){
echo"登录成功!";
session_start();
$_SESSION["username"]=$username;
header("Refresh:5;url=yuangong.php");
}
else{
echo"用户名或密码错误,请重新输入!";
//header("Refresh:5;url=loading.php");
}
if($stmt==false){
die( print_r( sqlsrv_errors(), true));
}
}
session_start();
$authnum=$_SESSION['authnum'];
$serverName = "ACER"; //数据库服务器地址
$uid = "admain"; //数据库用户名
$pwd = "1234"; //数据库密码
$connectionInfo = array("UID"=>$uid, "PWD"=>$pwd, "Database"=>"单位员工房产管理系统");
$conn = sqlsrv_connect($serverName, $connectionInfo);
$username=$_POST["textfield"];
$password=$_POST["textfield2"];
$radio=$_POST["RadioGroup1"];
if($conn == false)
{
echo "连接失败!";
die( print_r(sqlsrv_errors(),true));
}else if($username==''){
echo"用户名为空!";
header("Refresh:5;url=loading.php");
}
else if($password==''){
echo"密码为空!";
header("Refresh:5;url=loading.php");
}
else if(isset($_POST['textfild3']))
{
if(strcmp($_POST['authinput'],$_SESSION['authnum'])==0)
echo"验证码错误!";
}
else if($radio=="员工"){
$sql="select * from loading_yuangong where eusername=$username and epassword=$password";
$params = array();
$options = array( "Scrollable" =>SQLSRV_CURSOR_KEYSET );
$stmt = sqlsrv_query($conn,$sql,$params,$options);
$row_count = sqlsrv_num_rows($stmt);
if($row_count>0){
echo"登录成功!";
session_start();
$_SESSION["username"]=$username;
header("Refresh:5;url=yuangong.php");
}
else{
echo"用户名或密码错误,请重新输入!";
//header("Refresh:5;url=loading.php");
}
if($stmt==false){
die( print_r( sqlsrv_errors(), true));
}
}
解决方案 »
- 问这段真正是什么意思 ?preg_match('#^([^:]+): (.*)\s+$#', $str, $match
- 如何为帖子生成一个自己的页面?
- php 正则取双引号内容
- 谁也看过PHP和MySQL Web 开发 武欣翻译的书啊,上面例子都过不了??
- 刚升级到Mysql5,为什么同一语句,执行时间相差如此的大?
- flush()在Windows平台下是否无效?
- *.html和*.php(无数据库操作)速度会相差多少?
- 请各位大侠帮忙,超难问题!急!!!!
- =========PHP发EMAIL问题.==========在线等待
- 用PHP发电子邮件的问题
- PHP怎么实现点击从数据库读出的新闻标题后能进入另一个页面并显示相应的新闻内容数据
- 求助!正则式
错误信息指示 $stmt 不对
也就是 $stmt = sqlsrv_query($conn,$sql,$params,$options); 出错了
你不去看错在哪里,跑这里问人家怎么能行?我们有没有你的数据库,怎么知道会出什么错?
只纠结代码有何用?