新手请求 php添加数据库! 急
来源:百度知道 编辑:UC知道 时间:2024/05/05 05:11:39
checklogin.php
<?
require_once('conn.php');
session_start();
$username=$_POST['username'];
$password=$_POST['password'];
$exec="select * from admin where username='".$username."'";
if($result=mysql_query($exec))
{
if($rs=mysql_fetch_object($result))
{
if($rs->password==$password)
{
$_SESSION['adminname']=$username;
header("location:index.php");
}
else
{
echo "<script>alert('密码错误!');location.href='login.php';</script>";
}
}
else
{
echo "<script>alert('用户名错误!');location.href='login.php';</script>";
}
}
else
{
echo "<script>alert('数据库连接错误!');location.href='login.php';</script>";
}
?>
<?
require_once('conn.php');
session_start();
$username=$_POST['username'];
$password=$_POST['password'];
$exec="select * from admin where username='".$username."'";
if($result=mysql_query($exec))
{
if($rs=mysql_fetch_object($result))
{
if($rs->password==$password)
{
$_SESSION['adminname']=$username;
header("location:index.php");
}
else
{
echo "<script>alert('密码错误!');location.href='login.php';</script>";
}
}
else
{
echo "<script>alert('用户名错误!');location.href='login.php';</script>";
}
}
else
{
echo "<script>alert('数据库连接错误!');location.href='login.php';</script>";
}
?>
程序好像没有问题呀,在数据库里当然得建表了
新的数据库 shop 后 要怎么做? 不太理解你这句是什么意思 ??
mysql_connect("*", "*", "*") or
die("Could not connect: " . mysql_error());
mysql_query("SET character_set_connection='gbk', character_set_results='gbk', character_set_client=binary");
mysql_query("SET sql_mode=''");
mysql_select_db("shop");
//这个是单条数据显示的
function doSql($sql)
{
$result = mysql_query($sql);
if ($result)
{
$row = mysql_fetch_array($result);
return $row;
}
return 0;
}
//这个是多条数据的
function getRowArrayBySQL($sql)
{
$out = array();
if($sql)
{
if(function_exists('err')) {
$result = mysql_query($sql) or die("function getRowArrayBySQL() err".err($sql));
}
<