MySQLi Insert Record - not storing ID in session?
MySQLi Insert Record - not storing ID in session? I read through the possible threads that you guys had listed; I will post the insert code and I did add the
<?php @session_start(); ?>
the the page I want to use the session and the binding =s tab did not show any session variables:
Here's my insert code and the session I set is in fact "scheduleID"
$InsertQuery = new WA_MySQLi_Query($nav);
$InsertQuery->Action = "insert";
$InsertQuery->Table = "schedule";
$InsertQuery->bindColumn("firstname", "s", "".((isset($_POST["firstname"]))?$_POST["firstname"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("lastname", "s", "".((isset($_POST["lastname"]))?$_POST["lastname"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("email", "s", "".((isset($_POST["email"]))?$_POST["email"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("address1", "s", "".((isset($_POST["address1"]))?$_POST["address1"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("address2", "s", "".((isset($_POST["address2"]))?$_POST["address2"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("city", "s", "".((isset($_POST["city"]))?$_POST["city"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("state", "s", "".((isset($_POST["state"]))?$_POST["state"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("zipcode", "s", "".((isset($_FILES["zip"]))?$_FILES["zip"][""]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("scheduledate", "s", "".((isset($_POST["scheduledate"]))?$_POST["scheduledate"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("scheduletype", "s", "".((isset($_POST["scheduletype"]))?$_POST["scheduletype"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("starttime", "s", "".((isset($_POST["starttime"]))?$_POST["starttime"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("startseconds", "s", "".((isset($_POST["startseconds"]))?$_POST["startseconds"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("endtime", "s", "".((isset($_POST["endtime"]))?$_POST["endtime"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("endseconds", "s", "".((isset($_POST["endseconds"]))?$_POST["endseconds"]:"") ."", "WA_DEFAULT");
$InsertQuery->bindColumn("planname", "s", "".((isset($_POST["planname"]))?$_POST["planname"]:"") ."", "WA_DEFAULT");
$InsertQuery->saveInSession("scheduleID");
$InsertQuery->execute();
$InsertGoTo = "Basic Service Plan Summary - Pass.php";
if (function_exists("rel2abs")) $InsertGoTo = $InsertGoTo?rel2abs($InsertGoTo,dirname(__FILE__)):"";
$InsertQuery->redirect($InsertGoTo);