Salve... purtroppo non riesco ad eseguire la query per fare il login:
potete aiutarmi ?
ecco i codici
login.php
Codice PHP:
<?php
@require("../config.php");
if($_SERVER['REQUEST_METHOD'] == 'POST')
{
$user = stripslashes($_POST['username']);
$password = md5(stripslashes($_POST['password']));
echo "<script>console.log(' $user $password');</script>";
if(!empty($user) && !empty($password))
{
//$query="SELECT * FROM `$random` WHERE surname='$user' AND password='$password'";
$query = "SELECT * FROM $random WHERE surname='$user' AND password='$password'";
echo "<script>console.log(\" Queri eseguita: $query\");</script>";
$sql =mysql_query($query, $conn);
if($sql)
{
echo "<script>console.log(' Queri eseguita: $sql');</script>";
$num = mysql_num_rows($sql);
echo "<script>console.log(' Valori trovati: $num');</script>";
if($num==1)
{
session_start();
$_SESSION['username'] = $user;
if(isset($_SESSION['username'])){
header("location: manage.php");
}
}
}else
{
echo "<script>console.log(' Queri non eseguita: $sql');</script>";
}
} /*if*/
else
{
echo "<script>window.location = '#error';</script>";
}/* if */
}
config.php
Codice PHP:
<?php
$conn = mysqli_connect('localhost','nome','password','nomeDB');
$random=210;
?>
Questa è la pagina di login:
Codice HTML:
<div class="container row" >
<form class="col s12 m7 l7 offset-s0 offset-m3 offset-l3 card" method="post" action="login.php">
<div class="row">
<div class="input-field col s12">
<input type="text" id="username" placeholder="Username" name="username" class="valid">
</div>
</div>
<div class="row">
<div class="input-field col s12">
<input type="password" id="password" name="password" placeholder="Password" class="valid">
</div>
</div>
<div class="row">
<div class="input-field col s12">
<input type="submit" id="submit" name="submit" value="Accedi" class="valid">
</div>
</div>
</form>
</div>