matt.sisto Posted May 3, 2009 Share Posted May 3, 2009 Hi all I am struggling trying to get the result of an sql statement to define the value of a variable, when I echo out the value it just says: Resource id #3. Any help appreciated. <?php session_start(); if (!isset($_SESSION['username'])) { header("Location: login.php"); exit(); } require "dbconn2.php"; $email_address = mysql_real_escape_string($_POST['email_address']); $unit = $_POST['unit']; $service = $_POST['service']; $quantity = $_POST['quantity']; $con_id1 = $_POST['con_id1']; $con_id2 = $_POST['con_id2']; $con_id3 = $_POST['con_id3']; $extra_info = $_POST['extra_info']; $start_time_hr = $_POST['start_time_hr']; $start_time_min = $_POST['start_time_min']; $time_sec = '00'; $address_first_line = mysql_real_escape_string($_POST['address_first_line']); $post_code = $_POST['post_code']; $country = mysql_real_escape_string($_POST['country']); $month = mysql_real_escape_string($_POST["month"]); $day = $_POST["day"]; $year = $_POST["year"]; $event_start = $year."-".$month."-".$day." ".$_POST["event_start"]; $start_time = $start_time_hr.":".$start_time_min.":".$time_sec." ".$_POST["start_time"]; if ($unit == 'Day' && $quantity >= 1 && $quantity <= 7) { $d = (int) $quantity; $event_end = strtotime("+$d Days", strtotime($event_start)); $end_date = date('D j M Y', $event_end); $end_Time =$start_time; } else if ($unit == 'Hour' && $quantity >= 1 && $quantity <= 7) { $h = (int) $quantity; $end_time = strtotime("+$h Hours", strtotime($start_time)); $end_Time = date('G:i:s', $end_time); $end_date = $event_start; } $sql = "SELECT client_id FROM client WHERE email_address= '$email_address'"; $result1= mysql_query($sql, $connection) or die ("Couldn't perform query $sql <br />".mysql_error()); //This is where the issue lies while ($row = mysql_fetch_assoc($result1)) { $client_id = $row; } $sql = "INSERT INTO calendar_events VALUES (0,'".$event_start."','".$end_date."','".$client_id."','".$service."','".$unit."','".$quantity."','".$start_time."','".$end_Time."','".$con_id1."','".$con_id2."','".$con_id3."','".$address_first_line."','".$post_code."','".$country."','".$extra_info."')"; echo $sql; $result = mysql_query ($sql, $connection) or die ("Couldn't perform query $sql <br />".mysql_error()); header("Location: bookingform.php"); exit(); ?> <html> <head> <title>Book</title> </head> <body> </body> </html> Link to comment https://forums.phpfreaks.com/topic/156645-solved-using-stored-data-to-define-a-variable-value/ Share on other sites More sharing options...
matt.sisto Posted May 3, 2009 Author Share Posted May 3, 2009 I have now changed it to this. Which is now working. <?php session_start(); if (!isset($_SESSION['username'])) { header("Location: login.php"); exit(); } require "dbconn2.php"; $email_address = mysql_real_escape_string($_POST['email_address']); $unit = $_POST['unit']; $service = $_POST['service']; $quantity = $_POST['quantity']; $con_id1 = $_POST['con_id1']; $con_id2 = $_POST['con_id2']; $con_id3 = $_POST['con_id3']; $extra_info = $_POST['extra_info']; $start_time_hr = $_POST['start_time_hr']; $start_time_min = $_POST['start_time_min']; $time_sec = '00'; $address_first_line = mysql_real_escape_string($_POST['address_first_line']); $post_code = $_POST['post_code']; $country = mysql_real_escape_string($_POST['country']); $month = mysql_real_escape_string($_POST["month"]); $day = $_POST["day"]; $year = $_POST["year"]; $event_start = $year."-".$month."-".$day." ".$_POST["event_start"]; $start_time = $start_time_hr.":".$start_time_min.":".$time_sec." ".$_POST["start_time"]; if ($unit == 'Day' && $quantity >= 1 && $quantity <= 7) { $d = (int) $quantity; $event_end = strtotime("+$d Days", strtotime($event_start)); $end_date = date('D j M Y', $event_end); $end_Time =$start_time; } else if ($unit == 'Hour' && $quantity >= 1 && $quantity <= 7) { $h = (int) $quantity; $end_time = strtotime("+$h Hours", strtotime($start_time)); $end_Time = date('G:i:s', $end_time); $end_date = $event_start; } $sql = "SELECT client_id FROM client WHERE email_address= '$email_address'"; $result1= mysql_query($sql, $connection) or die ("Couldn't perform query $sql <br />".mysql_error()); $result = mysql_query( "SELECT SUM(client_id) FROM client" ); if($result) { $client_id = mysql_result($result, 0); } else { die(mysql_error()); // replace with desired error-handling functionality } $sql = "INSERT INTO calendar_events VALUES (0,'".$event_start."','".$end_date."','".$client_id."','".$service."','".$unit."','".$quantity."','".$start_time."','".$end_Time."','".$con_id1."','".$con_id2."','".$con_id3."','".$address_first_line."','".$post_code."','".$country."','".$extra_info."')"; echo $sql; $result = mysql_query ($sql, $connection) or die ("Couldn't perform query $sql <br />".mysql_error()); header("Location: bookingform.php"); exit(); ?> <html> <head> <title>Book</title> </head> <body> </body> </html> Link to comment https://forums.phpfreaks.com/topic/156645-solved-using-stored-data-to-define-a-variable-value/#findComment-824823 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.