<?php
/* public: 数据库连接参数 */
$Host = "localhost";
$DB = "guipao";
$User = "root";
$Password = "123456";
/* 建立连接、选择数据库*/
$conn=mysql_connect($Host, $User, $Password, $DB);$code=$_POST["checkcode"]; //验证码
$user=$_POST["user"]; //用户名
$Pass=$_POST["Pass"]; //密码//判断验证码
Session_start();
if($code!=$_SESSION["Checknum"])
{
echo "<script>alert('验证码不正确');history.go(-1);</script>";
exit(0);
}//连接数据库,判断用户名和密码是否正确
$conn=mysql_connect($Host, $User, $Password, $DB) or print(mysql_error());
echo $conn;
echo "<br>";
$sql="select * from adminlist where adminname='".$user."' and psw='".$Pass."' ";
echo $sql;
$rs=mysql_query($sql) or print(mysql_error());;
echo $rs;
?>
mysql_query的错误提示:No database selected数据库连接是通的输出连接ID Resource id #4
sql语句是正确的,select * from adminlist where adminname='admin' and psw='admin'
/* public: 数据库连接参数 */
$Host = "localhost";
$DB = "guipao";
$User = "root";
$Password = "123456";
/* 建立连接、选择数据库*/
$conn=mysql_connect($Host, $User, $Password, $DB);$code=$_POST["checkcode"]; //验证码
$user=$_POST["user"]; //用户名
$Pass=$_POST["Pass"]; //密码//判断验证码
Session_start();
if($code!=$_SESSION["Checknum"])
{
echo "<script>alert('验证码不正确');history.go(-1);</script>";
exit(0);
}//连接数据库,判断用户名和密码是否正确
$conn=mysql_connect($Host, $User, $Password, $DB) or print(mysql_error());
echo $conn;
echo "<br>";
$sql="select * from adminlist where adminname='".$user."' and psw='".$Pass."' ";
echo $sql;
$rs=mysql_query($sql) or print(mysql_error());;
echo $rs;
?>
mysql_query的错误提示:No database selected数据库连接是通的输出连接ID Resource id #4
sql语句是正确的,select * from adminlist where adminname='admin' and psw='admin'
$conn=mysql_connect($Host, $User, $Password);
mysql_select_db($db,$conn);
var $dbname;//数据库名称
var $dbhost;//数据库地址
var $dbusername;//数据库用户名
var $dbpassword;//数据库密码
var $setnames;//数据库密码 function MysqlConnector(){
$this->dbname = "besttripcn"; //还是想写个set()方法来封装"私有"变量
$this->dbhost = "localhost";
$this->dbusername = "root";
$this->dbpassword = "123456";
$this->setnames="gbk";
} function connectMySql(){
$openconn = mysql_pconnect($this->dbhost,$this->dbusername,$this->dbpassword ) or die("can not connect to mysql database!");
mysql_query("SET NAMES '".$this->setnames."'",$openconn);
mysql_select_db($this->dbname,$openconn);
return $openconn;
}}
$mysql_connector = new MysqlConnector();
$conn = $mysql_connector->connectMySql();$rs = mysql_query("select * from admin",$conn);$arr=array();
$b=array();
while($row = mysql_fetch_array($rs)){
// print ($row->id .".".$row->name.".".$row->age."<br/>");
$b['id']=$row["id"];
$b['username']=$row["username"];
$b['admin1']=$row["admin1"];
$arr[]=$b;
}
print_r($arr);