| mo tanya abang2 master
skrip ini salah dimna yah soalnya ada tulisan
"Notice: Undefined variable: localhost in C:\xampp\htdocs\latihan\log\checklogin.php on line 10
Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\latihan\log\checklogin.php on line 10 cannot connect" |
|
| ini Skripnya <?php
ob_start(); $host="localhost"; // Host name $username="root"; // Mysql username $password="root"; // Mysql password $db_name="test"; // Database name $tbl_name="members"; // Table name
// Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$members")or die("cannot select DB");
// Define $myusername and $mypassword $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword'];
// 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); $sql="SELECT * FROM $members WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql);
// Mysql_num_row is counting table row $count=mysql_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:login_success.php"); } else { echo "Wrong Username or Password"; } ob_end_flush(); ?> |
|
| maklum lagi nyoba2 aja bang master |
|
| tadi ada kasus yg mirip..itu emg dipakein password gitu?? kalo settingan defaultnya maah gada..coba kosongin variable password-nya.. |
|
| udah masih aja sama |
|
| klo boleh tau variable $members isinya apa ya? |
|
| mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$members")or die("cannot select DB"); <--- variablenya koq ditulis sebagai string? |
|
| untuk undefined mustinya di define dulu misal $members = NULL; diatas nya ... |
|
| maklum ane blom ngerti . .masi ecek2 hehehe . .tlong biar ane ngerti . . :D |
|
| mysql_select_db("$members") >> bukannya nama db nya "test" ya? kug $members??? |
|
| dibikin gini aja gan.. mysql_connect($host, $username, $password)or die("cannot connect"); mysql_select_db($members)or die ("cannot select DB"); |
|
| saya jga msih newbie, tp saya coba cek2, itu password nya emg udh di rubah jdi root ? terus sama yang ini : mysql_select_db("$members") //$members dari mana y ? mungkin mksd nya $db_name |
|
| apa gak begini ya harusnya mysql_select_db($db_name) |
|
| anyway,,$members teh apaan yaak?? bukannya variable databasenya $db_name yaak?? |
|
| iyah kalo begtu gimana? |
|
| tetep gosong hasilnya |
|
| mysql_select_db("$members") <<baris ini diganti sama mysql_select_db($db_name) |
|
| mysql_connect($host, $username, $password)or die ("cannot connect"); mysql_select_db($db_name)or die ("cannot select DB"); |
|
| <?php ob_start(); $basefolder="nama_folder"; $dbhost="localhost"; $dbuser="user_db"; $dbpass="pss_db"; $dbname="nm_db"; $base_url="http://localhost/".$basefolder."/"; $con=mysql_connect($dbhost,$dbuser,$dbpass) or die(mysql_error()); $rs=mysql_select_db($dbname); ?> |
|
| coba ganti kyak di atas, bisa kagak |
|
| jangan diapit pake tanda " " gan,,itu kan uda variabel,,klo diapit tanda petik ntar jadinya string lagi,,beda isinya ntar :D |
|
| nm_folder (folder yg di targetin) user_db (user untuk masuk ke phpmyadmin) pss_db (pss utk msuk ke phpmyadmin) nm_db (nama database yg ente buat) |
|
| tetep aja |
|
| tetep "Notice: Undefined variable: localhost in C:\xampp\htdocs\latihan\log\ch ecklogin.php on line 10 Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localho st' (using password: YES) in C:\xampp \htdocs\latihan\log\checklogin.php on line 10 cannot connect" ?? gada yg berubah sama sekali?? |
|
| coba cek di checklogin.php baris ke 10 amati bener" itu scrip belum semua |
|
| Dastan Munaf coba kamu tunjukkan script php terakhir yg kamu buat |