Scratch

nathanprocks · 2012-01-20 00:52:42

ok... i have made a login system for my page creator. (i haven't made the registration part yet.) i have a database. it has id, username, password and email. i also have 1 row where id=0, username=test, password=test and email=test@testthing.test. i have the code:

Code:

$id = mysql_query("SELECT id FROM $tbl_name WHERE username='$myusername'");
$email = mysql_query("SELECT email FROM $tbl_name WHERE username='$myusername'");

... and i have the code:

Code:

<table style="font-size:18; margin:auto; color:yellow;">
<tr><td>User ID: </td><td><? echo $_SESSION["id"]; ?></td></tr>
<tr><td>Email: </td><td><? echo $_SESSION["email"]; ?></td></tr>
</table>

in another page... when i try to login, it goes to profile page and it says User ID: 0 and Email: 0... what i am doing wrong?

nathanprocks · 2012-01-20 01:38:50

anyone?

TRocket · 2012-01-20 01:46:45

you need to pass mysql_query a a mysql connection( the result of running mysql_connect)

nathanprocks · 2012-01-20 01:51:26

TRocket wrote:
you need to pass mysql_query a a mysql connection( the result of running mysql_connect)

you mean this?

Code:

mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

TRocket · 2012-01-20 02:04:34

nathanprocks wrote:
TRocket wrote:
you need to pass mysql_query a a mysql connection( the result of running mysql_connect)
you mean this?
Code:
mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");

yes

fg123 · 2012-01-20 02:15:54

You also need to use sessions if you are working with multiple pages.

nathanprocks · 2012-01-20 03:14:40

fg123 wrote:
You also need to use sessions if you are working with multiple pages.

i am lol

Magnie · 2012-01-20 10:28:28

You need to use mysql_fetch_array($array) like:

Code:

$result = mysql_query("SELECT id FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$id = $row['id'];

$result = mysql_query("SELECT email FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$email = $row['email'];

or to simplify the process:

Code:

$result = mysql_query("SELECT * FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$id = $row['id'];
$email = $row['email'];

nathanprocks · 2012-01-20 18:49:30

Magnie wrote:

You need to use mysql_fetch_array($array) like:

Code:

$result = mysql_query("SELECT id FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$id = $row['id'];

$result = mysql_query("SELECT email FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$email = $row['email'];

or to simplify the process:

Code:

$result = mysql_query("SELECT * FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$id = $row['id'];
$email = $row['email'];

ok i will try that smile

EDIT: still does not work sad ...

Code:

Fatal error: Call to undefined function mysql_fetch_result() in /home/cassiedr/public_html/easypage/checklogin.php on line 25

Last edited by nathanprocks (2012-01-20 18:58:31)

Magnie · 2012-01-20 19:10:56

nathanprocks wrote:

Magnie wrote:

You need to use mysql_fetch_array($array) like:

Code:

$result = mysql_query("SELECT id FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$id = $row['id'];

$result = mysql_query("SELECT email FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$email = $row['email'];

or to simplify the process:

Code:

$result = mysql_query("SELECT * FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$id = $row['id'];
$email = $row['email'];

ok i will try that smile

EDIT: still does not work sad ...

Code:

Fatal error: Call to undefined function mysql_fetch_result() in /home/cassiedr/public_html/easypage/checklogin.php on line 25

Whoops, I meant mysql_fetch_array($result).

Code:

$result = mysql_query("SELECT id FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_array($result);
$id = $row['id'];

$result = mysql_query("SELECT email FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_array($result);
$email = $row['email'];

Code:

$result = mysql_query("SELECT * FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_array($result);
$id = $row['id'];
$email = $row['email'];

nathanprocks · 2012-01-20 19:14:13

Magnie wrote:

nathanprocks wrote:

Magnie wrote:

You need to use mysql_fetch_array($array) like:

Code:

$result = mysql_query("SELECT id FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$id = $row['id'];

$result = mysql_query("SELECT email FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$email = $row['email'];

or to simplify the process:

Code:

$result = mysql_query("SELECT * FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_result($result);
$id = $row['id'];
$email = $row['email'];

ok i will try that smile

EDIT: still does not work sad ...

Code:

Fatal error: Call to undefined function mysql_fetch_result() in /home/cassiedr/public_html/easypage/checklogin.php on line 25

Whoops, I meant mysql_fetch_array($result).

Code:

$result = mysql_query("SELECT id FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_array($result);
$id = $row['id'];

$result = mysql_query("SELECT email FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_array($result);
$email = $row['email'];

Code:

$result = mysql_query("SELECT * FROM $tbl_name WHERE username='$myusername'");
$row = mysql_fetch_array($result);
$id = $row['id'];
$email = $row['email'];

yay it works. thanks big_smile

Magnie · 2012-01-20 19:16:11

nathanprocks wrote:
yay it works. thanks

No problem. smile

Scratch

archived forums

#1 2012-01-20 00:52:42

help with PHP and SQL

Code:

Code:

#2 2012-01-20 01:38:50

Re: help with PHP and SQL

#3 2012-01-20 01:46:45

Re: help with PHP and SQL

#4 2012-01-20 01:51:26

Re: help with PHP and SQL

TRocket wrote:

Code:

#5 2012-01-20 02:04:34

Re: help with PHP and SQL

nathanprocks wrote:

TRocket wrote:

Code:

#6 2012-01-20 02:15:54

Re: help with PHP and SQL

#7 2012-01-20 03:14:40

Re: help with PHP and SQL

fg123 wrote:

#8 2012-01-20 10:28:28

Re: help with PHP and SQL

Code:

Code:

#9 2012-01-20 18:49:30

Re: help with PHP and SQL

Magnie wrote:

Code:

Code:

Code:

#10 2012-01-20 19:10:56

Re: help with PHP and SQL

nathanprocks wrote:

Magnie wrote:

Code:

Code:

Code:

Code:

Code:

#11 2012-01-20 19:14:13

Re: help with PHP and SQL

Magnie wrote:

nathanprocks wrote:

Magnie wrote:

Code:

Code:

Code:

Code:

Code:

#12 2012-01-20 19:16:11

Re: help with PHP and SQL

nathanprocks wrote:

Board footer