ciao a tutti io dovrei realizzare un login con le sessioni e un database che contiene tutti i dati allora la pagina php è questa.
<?php
session_start();
include "php\conn_reg_serv.php";
if(isset($_POST['submit'])) {
$query="SELECT username,password FROM user".
"WHERE username ='".$_POST['username']."'".
"AND password=(PASSWORD('".$_POST['password']."'))";
$result=mysql_query($query)
or die(mysql_error());
if(mysql_num_rows($result)==1) {
$_SESSION['user']=$_POST['username'];
$_SESSION['pass']=$_POST['password'];
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>home page WEB SOLUTION PORTAL</title>
<link href="stile.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div class="layout" id="menu">
<div class="lay-info">
<div class="info-ora">
<?php include "php\data.php"; ?>
</div>
<div class="info-sito">
mappa del sito |
informazioni |
praivacy
</div>
</div>
<div class="lay-top">
<div class="lay-logo">
<object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="140" height="70" title="logo">
<param name="movie" value="logo.swf" />
<param name="quality" value="high" />
<embed src="logo.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="140" height="70"></embed>
</object>
</div>
<div class="lay-banner">
</div>
</div>
<div class="lay-bar">
<div class="bar-login">
<?php
if($_SESSION['logged']==1) {
echo"bravo";
}else{
echo "<form action=\"home.php\" method=\"post\">";
echo "<p id=\"log-label\">user</p>";
echo "<input type=\"text\" name=\"username\" id=\"log-input\" />";
echo "<p id=\"log-label\">password</p>";
echo "<input type=\"text\" name=\"password\" id=\"log-input\" />";
echo "<input type=\"submit\" value=\"entra\" name=\"submit\" id=\"log-submit\" />";
echo "</form>";
}
?>
</div>
<div class="bar-personal-menu">
registrati. |
ho dimenticato la password.
</div>
</div>
<div class="lay-left">
<ul id="menu">
HOME PAGE
CONTATTI
CATALOGO
HOSTING
DOWNLOAD
[/list]
</div>
<div class="lay-right">
</div>
</div>
</body>
</html>
e cosi vorrei avviare una sessione per mostrare ciò che desidero però l'errore che mi da è il seguente!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='user'AND password=(PASSWORD('pass'))' at line 1
come si puo risolveri il problema.?
Rispondi quotando
