Caute, mam takyto kod ( nizsie ) ktory ma bez problemov prihlasi, ak zadam zle meno a heslo, mal by vypisat hlasku 'Bad user or password', overuje sa to ce num_rows, co sa bezproblemov udeje ak zadam spravne udaje, avsak ked ma platit s nespavnymi udajmi != 1 tak nespravi nic, iba vypise bielu obrazovku...
User.Class.php
Kód:
<?php
/**
* Description of User
*
* @author jan
*/
class User{
public $logged;
private $dbins;
public function __construct(){
$logged = isset($_SESSION['logged']) ? $_SESSION['logged'] : null;
echo $this->logged = $logged;
}
public function login($db){
$this->dbins = $db;
$user = $_POST['user'];
$passwd = $_POST['passwd'];
if(!empty($user) && $passwd){
//echo "bum";
$passwd = md5($passwd);
//echo $passwd;
$result = $this->dbins->exQuery("SELECT * FROM users WHERE name='$user' AND passwd='$passwd'", 1);
$num_rows = mysql_num_rows($result) or die(mysql_error());
echo "pocet riadkov:". $num_rows."<br>";
if($num_rows != 1){
//echo $num_rows;
//echo $_SESSION['logged'] = 1;
echo "<div class='error'>Bad user or password</div>";
//echo "<div class='error'>Bad user or password</div>";
//$_SESSION['logged'] = 0;
}
else{
$_SESSION['logged'] = 1;
echo "<div class='info'>Congratulations, you are now logged in.
<a href='index.php'> Continue on main page</a></div>";
}
}
}
public function qLog(){
if($this->logged != 1){
header("Location: nolog.php");
}
else{
echo "<div class='info'><a href='logout.php'>Logout</a></div>";
}
}
}
?>
Database.Class.php
Kód:
<?php
/**
* Description of Database
*
* @author jan
*/
class Database {
public $connection;
public $database;
public $qString = array();
public $mquery;
//public $collation;
//pripojenie, vyber databazy, nastavenie kodovania
public function __construct($db_server, $db_user, $db_passwd, $db_name, $collation){
$this->connection = mysql_connect($db_server, $db_user, $db_passwd);
if(!$this->connection){
$this->mError();
}
$this->database = mysql_select_db($db_name);
if(!$this->database){
$this->mError();
}
$setCollation = $this->exQuery("SET NAMES $collation", 1);
}
//vykonanie dopytu, pridanie do $qString pola pre debugovanie, ak je parameter dva == 1 => vykona realne query
public function exQuery($qString, $true){
array_push($this->qString, htmlspecialchars($qString));
if($true == 1){
return $this->mquery = mysql_query($qString);
if(!$this->mquery){
$this->mError();
}
}
}
//jednotny vypis chyb
public function mError(){
echo "<div class='error'><span class='error'>ERROR: </span>". mysql_error() ."</div>";
}
public function debugdb(){
echo "<div class='error'><u>Queries:</u><br>";
print_r(array_values($this->qString));
echo "</div>";
}
//public function __destruct(){
// $free = mysql_free_result($this->mquery);
// $close = mysql_close($this->connection);
//}
}
?>
mysql_num_rows vrati nulu, a zatym mam or die(mysql_error()) 
Choď na stránku: