Hola a todos!
Tengo un codigo php para login de usuarios.
Estaba funcionando muy bien pero de repente me dejo de funcionar
.
El error que me aparece es este:
Código PHP:
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in login.php on line 34
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in login.php on line 34
Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in login.php on line 38
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in login.php on line 38
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in login.php on line 39
Codigo login.php
Código PHP:
<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');
//-----------------------------------------------------------------------------------------------------------------------------------
// Inicializo las variables
$errorMsg = '';
$username = '';
$pass = '';
$remember = '';
if ( isset($_POST['username'])) {
$username = $_POST['username'];
$pass = $_POST['pass'];
$username = stripslashes($username);
$pass = stripslashes($pass);
$username = strip_tags($username);
$pass = strip_tags($pass);
// control de errores
if ((!$username) || (!$pass)) {
$errorMsg = 'ïUps! Parece que escribiste mal tu usuario y/o tu contraseña.';
} else { // sino hay errores
$username = mysql_real_escape_string($username); // inject mysql
//$pass = mysql_real_escape_string($pass); // injecciones mysql
$pass = md5($pass); // md5 protege las contraseñas
// consulta sql
$sql = mysql_query("SELECT * FROM users WHERE username='$username' AND password='$pass' AND email_activated='1'");
$login_check = mysql_num_rows($sql);
if($login_check > 0){
while($row = mysql_fetch_array($sql)){
if (isset($_POST['remember'])) {
$remember = $_POST['remember'];
$expire = time() + 1728000; // Expire in 20 days
$cookie_pass = sha1( sha1($username['pass']) . sha1($username['salt']) );
setcookie('username', $username['username'], $expire);
setcookie('pass', $cookie_pass, $expire);
}
// variable sesion id
$userid = $row["userid"];
$_SESSION['userid'] = $userid;
// variable sesion username
$username = $row["username"];
$_SESSION['username'] = $username;
mysql_query("UPDATE users SET last_login=now() WHERE userid='$userid' LIMIT 1");
} // cierro while
header("location: ".$_SERVER['HTTP_REFERER']); //redirige a la pagina anterior donde estaba
exit();
} else {
$errorMsg = "Datos incorrectos,los datos ingresados no existen.";
}
} // Cierro else despues del chequeo
} //Cierro el if
?>
<div id="login_box" class="login_form">
<h2>Iniciar Sesión</h2>
<form action="login.php" method="post" enctype="multipart/form-data" name="signinform" id="signinform">
<div class="label"> <font color="#FF0000"><?php print "$errorMsg"; ?></font></div>
<div class="input_block">
<div class="label">
<label for="login">Nombre de usuario</label>
</div>
<div class="field">
<input class="login_input required email" name="username" id="username" tabindex="1" type="text" />
</div>
</div>
<div class="input_block">
<div class="label">
<label for="password">Contraseña</label>
</div>
<div class="field">
<input class="login_input" name="pass" id="pass" tabindex="2" type="password" />
</div>
<div class="clearfix"></div>
</div>
<div id="login-links">
<input class="button_grey" name="login" type="submit" value="Ingresar" />
</div>
</div>
</form>
Lineas de errores:
Código PHP:
linea 34: $username = mysql_real_escape_string($username); // inject mysql
linea 38: $sql = mysql_query("SELECT * FROM vludee_users WHERE username='$username' AND password='$pass' AND email_activated='1'");
linea 39: $login_check = mysql_num_rows($sql);
Quien pueda ayudarme se los agradezco mucho!
Saludos y gracias