php+sql : masalah coding

progmania · #1 (**permalink**) 25-08-2003, 10:58 AM

assalamualaikum... & hello all...

mintak tolong skit leh tak? tolong tgkkan coding saya kat bawah nih... aper yg tak kena.... bahagian print "selamat datang, $nama";---> output: selamat datang resource#3. macam mana saya nak tukar resource#3 tu jadi username yg diinputkan @ username dr database...... terima kasih...

Quote:

<?php
include("log_query.php");

$con = mysql_connect($server, $user, $pass)or die("Sambungan ke server gagal! ".mysql_error());

$db="employee";
mysql_select_db($db, $con);

$dbid = mysql_query("SELECT emp_id from log");
$dbname = mysql_query("SELECT emp_name from log");

$pwd = $_POST["pass"];
$nama = $_POST["name"];

if ($pwd = $dbid && $nama = $dbname)
{
print "Selamat Datang, $nama" ;
}
elseif ($pwd != $dbid || $nama != $dbname)
{
print "Masukkan nama dan password yang betul";
}
else
{
print "Sila dapatkan nama dan katalaluan yg betul dari pihak Admin";
}

mysql_close($con);

?>

lcf · #2 (**permalink**) 25-08-2003, 02:04 PM

tukar:
if ($pwd = $dbid && $nama = $dbname)

kepada:
if (($pwd == $dbid) && ($nama == $dbname))

lcf · #3 (**permalink**) 25-08-2003, 02:08 PM

well, basically your code is wrong.

The following code...

PHP Code:


			
$dbid = mysql_query("SELECT emp_id from log");

$dbname = mysql_query("SELECT emp_name from log");

will return ALL the emp_id and emp_name in the tables... the return results cannot use to check the user name and password without looping in.

progmania · #4 (**permalink**) 25-08-2003, 03:46 PM

heheh.... well thanks....

i'll try to refer to internet tutorial, but still cant understand... the coding is very long.... so i just try to do it my self. i just wanna do a simple coding by myself.. so i can understand all the steps. ive been doin this coding since last week... but still havent finish it. i dont want to just copy coding from internet and paste it. i wanna do it my self. i think thats the best way to learn... eventhough it might take a long time to finished just one coding but i think its worthed.

anyway thanks for your guide...

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
masalah online	meiji	Website Programming	3	28-01-2005 08:43 PM
Masalah dengan SWISH 2.0 ~~!!	Movexz	Mamak Stall	6	13-09-2003 05:23 PM
masalah session_start();	lktt	Website Programming	1	31-07-2003 10:09 PM
Masalah PHP guna DWMX	lktt	Website Programming	1	25-07-2003 01:25 AM
Masalah Skit	mshahir	Website Programming	1	14-03-2003 09:25 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)