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.
PHP Varibles Help
Moderator: General Moderators
Re: PHP Varibles Help
Code: Select all
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./Database1.mdb").[b]";";[/b]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'];
}