PHP Varibles Help

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
hewstone
Forum Newbie
Posts: 14
Joined: Fri Nov 14, 2008 10:57 am

PHP Varibles Help

Post by hewstone »

I have a problem is passing the values accoss in the SQL in the PHP code below. The $z varible will get a value from the session, the $z value will then be used in the SQL. However the value dose get passed across to the SQL code.


<?
$db_conn = new COM("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./Database1.mdb").";";
$db_conn->open($connstr);
$z = $_SESSION['user'];
$MySql = "SELECT * FROM users_details WHERE user_id = (SELECT users_id FROM users_login WHERE Username = '$z')";
$rs = $db_conn->Execute($MySql);

while(!$rs->EOF){
$user_id = $rs->Fields("user_id")->value;
$surname = $rs->Fields("surname")->value;
$forname = $rs->Fields("forname")->value;
$DOB = $rs->Fields("DOB")->value;
$gender = $rs->Fields("gender")->value;
$email= $rs->Fields("email")->value;

?>

Any ideas how i can passed the value across, or is there another meathod of doing this?

Thanks in advance for your help.
tech603
Forum Commoner
Posts: 84
Joined: Thu Mar 19, 2009 12:27 am

Re: PHP Varibles Help

Post by tech603 »

Code: Select all

$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./Database1.mdb").[b]";";[/b]
Are you terminating two strings here? in the above i would probably start the main string in single quotes so your double quotes don't need to be escaped


Also just a suggestion you should always first check to make sure that value is present before defining it.

Code: Select all

 
if(isset($_SESSION['user'])){
$z = $_SESSION['user'];
}
 
Hope that helps.
Post Reply