DaniWeb Forum Index > Web Development > PHP

Login session

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

Last »

•

Join Date: Mar 2008

Posts: 63

Reputation: sukhy_1 is an unknown quantity at this point

Solved Threads: 3

sukhy_1

Offline

Junior Poster in Training

Login session

Mar 29th, 2008

Hello does anyone know how to bring details from a database into a textbox? becuase ive got the login working and it displays whos logged in but i want the postcode to appear in a textbox, the postcode is kept in mysql table called address.

/after connecting to mysql

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$query  = "SELECT * FROM StudentRecords WHERE Email= '".$myusername."'";	
$result = mysql_query($query);
 
<td><input type="text" name="PickupAddressPostCode"</td>
$query  = "SELECT * FROM StudentRecords WHERE Email= '".$myusername."'";	
$result = mysql_query($query);

<td><input type="text" name="PickupAddressPostCode"</td>

Last edited by peter_budo; Mar 30th, 2008 at 6:19 am. Reason: Keep It Organized - please use [code] tags

•

Join Date: Mar 2008

Posts: 154

Reputation: Suomedia is an unknown quantity at this point

Solved Threads: 19

Suomedia

Offline

Junior Poster

Re: Login session

Mar 29th, 2008

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$query = "SELECT address_code FROM address WHERE userID= '".$myuserID."'";
$result = mysql_query($query);
 
<td><input type="text" name="PickupAddressPostCode" value="<?php echo $result['address_code']; ?>" /></td>
$query = "SELECT address_code FROM address WHERE userID= '".$myuserID."'";
$result = mysql_query($query);

<td><input type="text" name="PickupAddressPostCode" value="<?php echo $result['address_code']; ?>" /></td>

Matti Ressler
Suomedia

Last edited by Suomedia; Mar 29th, 2008 at 12:24 pm.

If you want your dreams to come true, the first thing you must do is to wake up....
Suomedia - Dynamic Content Management

•

Join Date: Mar 2008

Posts: 63

Reputation: sukhy_1 is an unknown quantity at this point

Solved Threads: 3

sukhy_1

Offline

Junior Poster in Training

Re: Login session

Mar 29th, 2008

thank u

•

Join Date: Mar 2008

Posts: 154

Reputation: Suomedia is an unknown quantity at this point

Solved Threads: 19

Suomedia

Offline

Junior Poster

Re: Login session

Mar 29th, 2008

Mark as solved

If you want your dreams to come true, the first thing you must do is to wake up....
Suomedia - Dynamic Content Management

•

Join Date: Mar 2008

Posts: 63

Reputation: sukhy_1 is an unknown quantity at this point

Solved Threads: 3

sukhy_1

Offline

Junior Poster in Training

Re: Login session

Mar 29th, 2008

Its meant to select the postcode from the address table where the email matchs the login name which is myusername. and then display postcode in the textbox. it connects to database but in the textbox what the postcode is meant to appear in it says...
<br /><b>Notice</b>: Undefined variable: result in <b>/home/public_html/book.php</b> on line <b>79</b><br />

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<? 
$query = "SELECT PostCode FROM address WHERE
Email= '".$myusername."'";
$result = mysql_query($query);
?>
 
line 79 is here 
<td><input type="text" name="PickPostCode" value="<?php echo 
$result['PostCode ']; ?>" /></td>
<? 
$query = "SELECT PostCode FROM address WHERE
Email= '".$myusername."'";
$result = mysql_query($query);
?>

line 79 is here 
<td><input type="text" name="PickPostCode" value="<?php echo 
$result['PostCode ']; ?>" /></td>

Last edited by peter_budo; Mar 30th, 2008 at 6:19 am. Reason: Keep It Organized - please use [code] tags

•

Join Date: Mar 2008

Posts: 154

Reputation: Suomedia is an unknown quantity at this point

Solved Threads: 19

Suomedia

Offline

Junior Poster

Re: Login session

Mar 29th, 2008

You need to connect to mySQL, select the database, make the query, fetch the result with mysql_fetch_array() and close the connection.

Matti Ressler
Suomedia

If you want your dreams to come true, the first thing you must do is to wake up....
Suomedia - Dynamic Content Management

•

Join Date: Mar 2008

Posts: 63

Reputation: sukhy_1 is an unknown quantity at this point

Solved Threads: 3

sukhy_1

Offline

Junior Poster in Training

Re: Login session

Mar 29th, 2008

ive got the connection the database connection and everything working expect that 1 notice

•

Join Date: Nov 2007

Posts: 3,760

Reputation: nav33n is a jewel in the rough

Solved Threads: 332

nav33n

Offline

Senior Poster

Re: Login session

Mar 29th, 2008

•

Originally Posted by Suomedia

Help with Code Tags

PHP Syntax (Toggle Plain Text)
$query = "SELECT address_code FROM address WHERE userID= '".$myuserID."'";
$result = mysql_query($query);
 
<td><input type="text" name="PickupAddressPostCode" value="<?php echo $result['address_code']; ?>" /></td>
$query = "SELECT address_code FROM address WHERE userID= '".$myuserID."'"; $result = mysql_query($query); <td><input type="text" name="PickupAddressPostCode" value="<?php echo $result['address_code']; ?>" /></td>
Matti Ressler
Suomedia

That should actually be

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$query = "SELECT address_code FROM address WHERE userID= '".$myuserID."'";
$result = mysql_query($query);
$row = mysql_fech_array($result); //or while($row = mysql_fetch_array($result)) if your query returns more than 1 row
<td><input type="text" name="PickupAddressPostCode" value="<?php echo $row['address_code']; ?>" /></td>
$query = "SELECT address_code FROM address WHERE userID= '".$myuserID."'";
$result = mysql_query($query);
$row = mysql_fech_array($result); //or while($row = mysql_fetch_array($result)) if your query returns more than 1 row
<td><input type="text" name="PickupAddressPostCode" value="<?php echo $row['address_code']; ?>" /></td>