我是php编程的新手,在尝试创建一个登录php脚本以将其与我的mysql数据库连接时遇到了很多麻烦(我已经创建了一个数据库)
我收到错误:
我的数据库内容是:
Id_Enseignant
Nom_Enseignant
Prenom_Enseignant
mail_enseignant
Mot_de_passe 14 hh hhs hhss
这是我的php脚本:
警告:mysql_num_rows()要求参数1为resource,布尔值在第16行的C:''examplep''htdocs''University''login.php 中给定
第16行是这一行:
if(mysql_num_rows($sql) == 1){
再加上它在提交按钮旁边显示的内容:"; } ?>
<?php
require_once('init.php');
include_once("scripts/connect.php");
$login_error = "";
$email = "";
$password= "";
if(isset($_GET['login'])){
$email = strip_tags(mysql_real_escape_string($_POST['email']));
$password = strip_tags(mysql_real_escape_string($_POST['password']));
$sql = mysql_query("SELECT mail_enseignant,Nom_Enseignant,Mot_de_passe FROM enseignant WHERE email='".$email."' AND password='".$password."' LIMIT 1");
if(mysql_num_rows($sql) == 1){
$row = mysql_fetch_asooc($sql);
$_SESSION['mail_enseignant'] = $row['mail_enseignant'];
$_SESSION['Nom_Enseignant'] = $row['Nom_Enseignant'];
$_SESSION['Mot_de_passe'] = $row['Mot_de_passe'];
header("Location: index.php");
exit();
} else {
$login_error="invalid Information...";
}
}
?>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="EN" lang="EN" dir="ltr">
<head profile="http://gmpg.org/xfn/11">
<title>Département Math-Info</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta http-equiv="imagetoolbar" content="no" />
<link rel="stylesheet" href="styles/layout.css" type="text/css" />
</head>
<body id="top">
<div class="wrapper row1">
<div id="header" class="clear">
<div class="fl_left">
<h1><a href="index.php">Département Math-Info</a></h1>
<p>Just Pour Vous</p>
</div>
<form action="#" method="post" id="login">
<a href="login.php"><h4>Enseignant Login<h4></a>
</form>
</div>
</div>
<!-- ####################################################################################################### -->
<div class="wrapper row2">
<div id="topnav">
<ul>
<li><a href="index.php">Homepage</a></li>
<li class="active"><a href="style-demo.php">Contact Us</a></li>
<li><a href="nouveaute.php"> Nouveauté</a></li>
<li><a href="note-off.php">NOTE TAB</a></li>
<li class="last"><a href="gallery.php">Gallery</a></li>
</ul>
<div class="clear"></div>
</div>
</div>
<!-- ####################################################################################################### -->
<div class="wrapper row4">
<div id="container" class="center">
<!-- ####################################################################################################### -->
<h3>Ensiegnant Login Below</h3>
<form action="?login" method="post" >
<fieldset>
<legend>Enseingant Login</legend>
<p>Mail_Ens: <input type="text" name="email" value="<?php echo $email;?>" /></p>
<p>Password: <input type="password" name="password" value="<?php echo $password;?>" /></p>
<p>
<?phpif (isset($login_error) && ($login_error != ""){
echo "<font color='#ff0000' style='margin-right: 10px;'".$login_error."</font>";
}?>
<input type="submit" value="Login Enseignant" name="submit_login"/></p>
<!-- <input type="image" src="images/sign_in.gif" id="signin" alt="Sign In" />-->
</fieldset>
</form>
<!-- ####################################################################################################### -->
<div class="clear"></div>
</div>
</div>
<!-- ####################################################################################################### -->
<div class="wrapper row5">
<div id="footer" class="clear">
<!-- ####################################################################################################### -->
<div class="foot_contact">
<h2>University Name Here</h2>
<address>
Address Line 1<br />
Address Line 2<br />
Town/City<br />
Postcode/Zip
</address>
<ul>
<li><strong>Tel:</strong> xxxxx xxxxxxxxxx</li>
<li><strong>Fax:</strong> xxxxx xxxxxxxxxx</li>
<li class="last"><strong>Email:</strong> <a href="#">contact@mydomain.com</a></li>
</ul>
</div>
<div class="footbox">
<h2>Administration</h2>
<ul>
<li><a href="#">Disclaimer</a></li>
<li><a href="#">Accessibility</a></li>
<li><a href="#">Freedom of Information</a></li>
<li><a href="#">Website Privacy</a></li>
<li><a href="#">Press Release Information</a></li>
<li><a href="#">Annual Report</a></li>
<li><a href="#">Financial Statements</a></li>
<li><a href="#">Job Vacancies</a></li>
<li class="last"><a href="#">Semester Dates</a></li>
</ul>
</div>
<div class="footbox">
<h2>Link Block 2</h2>
<ul>
<li><a href="#">Schools and Colleges</a></li>
<li><a href="#">Student Activities</a></li>
<li><a href="#">Student Affairs</a></li>
<li><a href="#">Student Development</a></li>
<li><a href="#">Student Financial Services</a></li>
<li><a href="#">Student Group Directory</a></li>
<li><a href="#">Student Life</a></li>
<li><a href="#">International Students</a></li>
<li class="last"><a href="#">Global Learning</a></li>
</ul>
</div>
<div class="footbox last">
<h2>Link Block 3</h2>
<ul>
<li><a href="#">Academic Advisory</a></li>
<li><a href="#">Academic Assistance</a></li>
<li><a href="#">Academic Calendars</a></li>
<li><a href="#">Academics Office</a></li>
<li><a href="#">Administration</a></li>
<li><a href="#">Adult Learners</a></li>
<li><a href="#">Alumni Chapters</a></li>
<li><a href="#">Alumni Events</a></li>
<li class="last"><a href="#">Residential Colleges</a></li>
</ul>
</div>
<!-- ####################################################################################################### -->
</div>
</div>
<!-- ####################################################################################################### -->
<div class="wrapper">
<div id="copyright" class="clear">
<p class="fl_left">Copyright © 2013 - All Rights Reserved - <a href="#">Domain Name</a></p>
<p class="fl_right">Template by <a href="http://www.os-templates.com/" title="Free Website Templates">OS Templates</a></p>
</div>
</div>
</body>
</html>
对于初学者来说,重写这一行(您漏掉了一个括号):
<?phpif (isset($login_error) && ($login_error != ""){
作为:
<?php if (isset($login_error) && ($login_error != "")) {
此外,更改:
$row = mysql_fetch_asooc($sql);
至:
$row = mysql_fetch_assoc($sql);
此外,字体已弃用。。。尝试p或h1等。