dimanche 26 octobre 2014

Cannot validate right? Why? New to PDO


Vote count:

0




I cant seem to validate right when i have an empty field or when the username is wrong or doesnt match. please any help or pointing me would be very helpful. I tried (empty but it doesnt seem to work when i fill in one field and the other is empty its says all fields are empty. and for the wrong credentials its not working at all.


INDEX.PHP



<?php
session_start();
include_once 'php/classes/class.user.php';

$user = new User();
$log = $_SESSION['uid'];

if ($user->get_session($log)){
header("Location: profile.php?uid=".$log."");
}

if (isset($_REQUEST['submit'])) {
extract($_REQUEST);
$login = $user->check_login($emailusername, $password);

if(!empty($login)){

if($emailusername != $login){

if($password != $login){
if ($login) {
// Registration Success
$log_id = $_SESSION['uid'];
header("location: profile.php?uid=".$log_id."");

}
}else
echo "Incorrect Password";

}else
echo "Incorrect Email";

}else
echo "Fill in fields";
}
?>


USERS.PHP



<?php


include "db_config.php";



class User{

public $db;

public function __construct(){
$this->db = new mysqli(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);

if(mysqli_connect_errno()) {
echo "Error: Could not connect to database.";
exit;
}
}

/*** for login process ***/
public function check_login($emailusername, $password){

$password = md5($password);
$sql2="SELECT uid from users WHERE uemail='$emailusername' or uname='$emailusername' and upass='$password'";

//checking if the username is available in the table
$result = mysqli_query($this->db,$sql2);
$user_data = mysqli_fetch_array($result);
$count_row = $result->num_rows;

if ($count_row == 1) {
// this login var will use for the session thing
session_start();
$emaildb == $_SESSION['uemail'];
$_SESSION['login'] = true;
$_SESSION['uid'] = $user_data['uid'];
return true;
}
else{
return false;
}
}
/*** for showing the username or fullname ***/

public function get_fullname($uid){
$sql = "SELECT * FROM users WHERE uid = $uid";
$result = mysqli_query($this->db, $sql);
$user_data = mysqli_fetch_array($result);

echo $user_data['fullname'], "<br/>";
echo $user_data['uemail'], "<br/>";
echo $user_data['uid'], "<br/>";
}

public function check_user($uid){

$sql5 = "SELECT * from users WHERE uid='$uid'";
$result1 = mysqli_query($this->db, $sql5);
$count_row1 = $result1->num_rows;

return ($count_row1 == 1);

}

/*** starting the session ***/
public function get_session(){
return $_SESSION['login'];
}

public function user_logout() {
$_SESSION['login'] = FALSE;
session_destroy();
}

}


asked 3 mins ago







Cannot validate right? Why? New to PDO

Aucun commentaire:

Enregistrer un commentaire