problem with php

[powell]

ce button submit ngn reset tu asing kn jdi 2 column/table yg berbeza..klu x boleh, try tukar both jdi hypertext link..

 

[ruzana]

nape dye kua mcm ni ea???

 

[anuar76]

mule2 wat html..
now sume da tukr jadi php,,
gune apache,,
sbb sy gune xampp

erm, jap, skrg kalau submit form keluar yg bawah ni?

<?php

$mysql_server = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "sistem_aduan_kerosakan_ict";

$conn = mysql_connect($mysql_server, $mysql_user, $mysql_password);

mysql_select_db($mysql_database, $conn);


// username and password sent from form
$myusername=$_POST['username'];
$mypassword=$_POST['password'];

// encrypt password 
$encrypted_mypassword=md5($mypassword);

$sql="SELECT * FROM pengguna WHERE username='$myusername' and password='$encrypted_mypassword'";
$result=mysql_query($sql);


// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);


// If result matched $myusername and $mypassword, table row must be 1 row

if(mysql_num_rows($result) > 0){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_start();
$_SESSION['username'] = $myusername;
$_SESSION['password'] = $mypassword;
header("location:berjaya semak.php");
}
else {
echo "Username dan Kata Laluan salah";
}
?>

 

[ruzana]

ce button submit ngn reset tu asing kn jdi 2 column/table yg berbeza..klu x boleh, try tukar both jdi hypertext link..

da buat,,still same,,

 

[ruzana]

erm, jap, skrg kalau submit form keluar yg bawah ni?

<?php

$mysql_server = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "sistem_aduan_kerosakan_ict";

$conn = mysql_connect($mysql_server, $mysql_user, $mysql_password);

mysql_select_db($mysql_database, $conn);


// username and password sent from form
$myusername=$_POST['username'];
$mypassword=$_POST['password'];

// encrypt password 
$encrypted_mypassword=md5($mypassword);

$sql="SELECT * FROM pengguna WHERE username='$myusername' and password='$encrypted_mypassword'";
$result=mysql_query($sql);


// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);


// If result matched $myusername and $mypassword, table row must be 1 row

if(mysql_num_rows($result) > 0){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_start();
$_SESSION['username'] = $myusername;
$_SESSION['password'] = $mypassword;
header("location:berjaya semak.php");
}
else {
echo "Username dan Kata Laluan salah";
}
?>

mule2 kua y tu,,tp td da btolkan,,last2 klua mcm ni,,kenape ea

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\sistem_aduan_kerosakan_ict\prog\login berjaya.php on line 33
Username dan Kata Laluan salah

 

[anuar76]

mule2 kua y tu,,tp td da btolkan,,last2 klua mcm ni,,kenape ea

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\sistem_aduan_kerosakan_ict\prog\login berjaya.php on line 33
Username dan Kata Laluan salah

Username and password yg dicuba tu takde dlm mysql db la ya? Kalau guna username and password yg ada dlm mysql db ada error tak?

 

[ruzana]

still kua error

 

[powell]

susah gak nk tolon..klu depan mata, boleh nk godek2..tgu otai2/pro la ye tt...gud luck anyway..

 

[anuar76]

kalau slh gune pwd msti dye kua ade error

Kalau gitu cuba modify code jadi ni

<?php

$mysql_server = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "sistem_aduan_kerosakan_ict";

$conn = mysql_connect($mysql_server, $mysql_user, $mysql_password);

mysql_select_db($mysql_database, $conn);


// username and password sent from form
$myusername=$_POST['username'];
$mypassword=$_POST['password'];

// encrypt password 
$encrypted_mypassword=md5($mypassword);

$sql="SELECT * FROM pengguna WHERE username='$myusername' and password='$encrypted_mypassword'";
$result=mysql_query($sql);


// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);


// If result matched $myusername and $mypassword, table row must be 1 row
if($result){
	if(mysql_num_rows($result) > 0){
	// Register $myusername, $mypassword and redirect to file "login_success.php"
	session_start();
	$_SESSION['username'] = $myusername;
	$_SESSION['password'] = $mypassword;
	header("location:berjaya semak.php");
	}
}else {
      echo "Username dan Kata Laluan salah";
}
?>

 

[ruzana]

Kalau gitu cuba modify code jadi ni

<?php

$mysql_server = "localhost";
$mysql_user = "root";
$mysql_password = "";
$mysql_database = "sistem_aduan_kerosakan_ict";

$conn = mysql_connect($mysql_server, $mysql_user, $mysql_password);

mysql_select_db($mysql_database, $conn);


// username and password sent from form
$myusername=$_POST['username'];
$mypassword=$_POST['password'];

// encrypt password 
$encrypted_mypassword=md5($mypassword);

$sql="SELECT * FROM pengguna WHERE username='$myusername' and password='$encrypted_mypassword'";
$result=mysql_query($sql);


// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);


// If result matched $myusername and $mypassword, table row must be 1 row
if($result){
	if(mysql_num_rows($result) > 0){
	// Register $myusername, $mypassword and redirect to file "login_success.php"
	session_start();
	$_SESSION['username'] = $myusername;
	$_SESSION['password'] = $mypassword;
	header("location:berjaya semak.php");
	}
}else {
      echo "Username dan Kata Laluan salah";
}
?>

sy dah try..tp bile masukkan katalaluan ngn username same ngn dalam databse,still dye ckp slh msuk pwd n kata laluan