- 论坛徽章:
- 0
|
本帖最后由 frank533 于 2012-04-12 16:31 编辑
一段验证用户登录的代码如下:
- <?php
- if (empty($_POST["username"]) && empty($_POST["password"])) {
- echo '<script>alert(" ' . $username_pass_empty_error . ' "); history.go(-1); ' . '</script>';
- } else {
- $username = $_POST["username"];
- $password = $_POST["password"];
- $sqltest = "select count(*) from sc_admin where username = ' ".$username." ' ";
- $testrst = $conn->query($sqltest);
- if ($testrst > 0) {
- $sqlstr = "select * from sc_admin where username = ' ".$username." ' and password = ' ".$password." ' ";
- $rst = $conn->query($sqlstr);
- if (!$rst -> EOF) {
- if ($rst -> fields[5] == 0) {
- $_SESSION["id"] = $rst -> fields[0];
- $_SESSION["name"] = $rst -> fields[1];
- $_SESSION["roles"] = $rst -> fields[5];
- $_SESSION["lasttime"] = $rst -> fields[3];
- $logindate = date("Y-m-d") . date("G:i");
- $logincount = $rst -> fields[4];
- $logincount++;
- $sqlstrud = "update sc_admin set logincount=' ".$logincount." ' , lastlogindate=' ".$logindate." ' where id=' ".$_SESSION['id']." ' ";
- $conn->query($sqlstrud);
- echo "<meta http-equiv=\"refresh\" content=\"2; url=index.php \" />";
- } else if ($rst -> fields[5] == 1) {
- echo '<script>alert("用户被冻结"); history.go(-1); ' . '</script>';
- } else {
- echo '<script>alert("密码错误"); history.go(-1); ' . '</script>';
- }
- }
- } echo '<script>alert("用户不存在"); history.go(-1); ' . '</script>';
- }
- ?>
复制代码 mysql数据库中是有数据的,在mysql里面都能执行上面代码中的sql语句,返回数据也正常,可是现在的问题是这段php始终无法从mysql数据库中取出数据,点击提交后总是返回用户不存在的错误。
登陆表单提交的内容已经验证过,没有问题。
请各位指点一下问题在哪里?php与mysql的连接也是对的。连接代码如下:- <?php
- $host = "localhost";
- $database = "test";
- $dbname = "test";
- $dbpass = "12345678";
- $conn = @mysqli_connect($host, $dbname, $dbpass);
- if (!$conn) {
- echo "$connectdb_error";
- exit;
- }
- $selectdb = mysqli_select_db($conn, $database);
- if (!$selectdb) {
- echo "$selectdb_error" ;
- exit;
- }
- ?>
复制代码 |
|