php 链接 sql server,php 链接sql server

最新推荐文章于 2024-07-23 09:02:58 发布

木陌APPLE

最新推荐文章于 2024-07-23 09:02:58 发布

阅读量50

点赞数

文章标签： php 链接 sql server

PHP 数据库连接 MD5加密 SQL查询用户登录验证

关键词由CSDN通过智能技术生成

在

$this->load->view('config'); $dbhost = $this->config->item("dbhost"); $dbuser = $this->config->item("dbuser"); $dbpass = $this->config->item("dbpass"); $msdb=mssql_connect($dbhost,$dbuser,$dbpass); mssql_select_db("QPAccountsDB",$msdb); $account = $_POST['user']; $LogonPass = md5($_POST['password']); $sql = "select Accounts from AccountsInfo where Accounts = '$account' and LogonPass = '$LogonPass' "; //echo $sql."
"; $result = mssql_query($sql, $msdb); $row = mssql_fetch_array($result, MSSQL_ASSOC); //$row = mssql_fetch_array($result, MSSQL_ASSOC) mysql_free_result($result); mssql_close($msdb); //echo $row; if(!empty($row)){ $redirect = base_url('account/message')."?status=success"; $newdata = array( 'username' => $this->encrypt->encode($row['Accounts']), 'id' => $this->encrypt->encode($row['UserID']), 'logged_in' => TRUE ); $this->session->set_userdata($newdata); //echo $this->encrypt->decode($this->session->userdata('username')); header("Location:".$redirect); }else{ $redirect = base_url('customer/login')."?status=fail"; header("Location:".$redirect); }