>>>>>>>>>”.$order_id ;

if($package_id == “” )
{
header (“Location:/order-now”);
}else{
$sql_package = “select * from hoa_package where package_id=$package_id”;
$rs_package = mysqli_query($con, $sql_package);
$numrows = $rs_package->num_rows
if($numrows)
{
$record_package=mysqli_fetch_array($rs_package);
$package_id = $record_package[package_id];
$package_name = $record_package[‘package_title’];
$package_desc = $record_package[‘package_desc’];
$package_price = $record_package[‘package_price’];
$uname = $record_package[‘p_user’];
//$_SESSION [‘PACKAGE_USER_NAME’] = $uname;

$_SESSION [‘PACKAGE_USER_NAME’] = $uname;

//echo $sid;
//echo $_SESSION [‘PACKAGE_USER_NAME’];

//while ($var = each($_SESSION)) {
//printf (“Key %s has the value of: %s
“, $var[‘key’], $var[‘value’]);
//}

}
}

/*$sid = session_id() ;

$order_sql = “insert into order_details (package_id, fname, mname, lname, company_name, addr1, addr2, city, state, zip, card_number,ccv_number, card_type,exp_month, exp_year,order_date,current_session) “;
$order_sql .= ” values (‘$package_id’, ‘$fname’ , ‘$mname’,’$lname’,’$company’,’$addr1′,’$addr2′,’$city’,’$state’,’$zip’,’$card_number’,’$ccv’,’$card_type’,’$exp_month’,’$exp_year’,now(),’$sid’)”;
//echo “>>>>>>”.$order_sql;
mysqli_query ($con, $order_sql);*/

$_SESSION [‘order_id’] = $order_id;

//echo $order_id.’asd’.$sid ;

function select1($x,$y) {
if($x==$y){
return “selected”;
}
}

$state_name =””;

$sql_state_select = “select * from state_master_new order by state_name”;
$rs_state_select = mysqli_query($con, $sql_state_select);

while($record_state = mysqli_fetch_array($rs_state_select)){
$state_id = $record_state[id];

$state_name = $record_state[‘state_name’];
if ( select1($state_id,$state) !=”” ){
break;}}

//*** to display state in mail//
$get_state_name = “SELECT state_name FROM state_master_new WHERE state_id=$state”;
$sql_state_name = mysqli_query($con, $get_state_name) or die(“Invalid Query”.mysqli_error());

$res_state_name = mysqli_fetch_array($sql_state_name);
$data_state_name = $res_state_name[‘state_name’];

//*** to display state in mail//

// include ‘order_confirmation_mail.php’;
//include ‘sendOrderEmail.php’;
//include ‘mail_neworder.php’ // Added By Yogesh

?>