Mam poniższy skrypt sprawdzający logowanie i wyskakuje mi taki błąd:
[:error] [pid 3065] [client :47369] PHP Notice: Undefined variable: row in /home/web/qgwc/site/2checklogin.php on line 21, referer: http://localhost/qgwc/site/2main_login.php
<?php
$host="127.0.0.1"; // Host name
$username="ccc"; // Mysql username
$password="ccc"; // Mysql password
$db_name="postgres"; // Database name
$tbl_name="users"; // Table name
// Connect to server and select databse.
$conn_string = "host=127.0.0.1 dbname=postgres port=5432 user=vvvv password=vvv";
$dbconn4 = pg_connect($conn_string) or die ('connection failed');
// username and password sent from form
$myusername=$_POST['myusername'];
$mypassword=$_POST['mypassword'];
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = $row['login'];
$mypassword = $row['haslo'];
$sql="SELECT * FROM $tbl_name WHERE login='$myusername' and haslo='$mypassword'";
$result=pg_query($sql);
// Mysql_num_row is counting table row
$count=pg_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row
if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
header("location:1login_success.php");
}
else {
echo "Wrong Username or Password";
}
?>