Trouble with time in a form.. inserting into database..

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
033
Forum Newbie
Posts: 1
Joined: Sat Jun 29, 2002 6:16 am
Location: San Francisco, CA

Trouble with time in a form.. inserting into database..

Post by 033 »

I'm having three select boxes... 0-12, 0-59, AM (1)/PM(2). Then if it's PM I add 12.. the time isn't showing up correctly when I display or open it back to edit. Anyone have a better way to do this? I'm stuck.

$num_rows = mysql_num_rows($result);
if ($num_rows > 0) {
echo "Event already exists.<br>\n";
echo "<br><a href=\"javascript:history.go(-1)\">Go back</a><br>\n";
} else {

if ($HTTP_POST_VARS['opentimeampm'] == 2)
$HTTP_POST_VARS['opentimehour'] += $HTTP_POST_VARS['opentimehour'] + 12;
$opentime = $HTTP_POST_VARS['opentimehour'].":".$HTTP_POST_VARS['opentimemin'].":00";

if ($HTTP_POST_VARS['closetimeampm'] == 2)
$HTTP_POST_VARS['closetimehour'] += 12;
$closetime = $HTTP_POST_VARS['closetimehour'].":".$HTTP_POST_VARS['closetimemin'].":00";

$datemodified = date("Y-m-d H:i:s");

$query = "INSERT INTO event_events VALUES ('','$HTTP_POST_VARS[title]','$HTTP_POST_VARS[headliner]','$HTTP_POST_VARS[talent]','$HTTP_POST_VARS[description]','$HTTP_POST_VARS[date]','$HTTP_POST_VARS[url]','$HTTP_POST_VARS[url_tickets]','$HTTP_POST_VARS[email]','$HTTP_POST_VARS[price]','$HTTP_POST_VARS[info_lines]','$opentime','$closetime','$HTTP_POST_VARS[venue_capacity]','$HTTP_POST_VARS[venue_name]','$HTTP_POST_VARS[venue_address]','$HTTP_POST_VARS[venue_city]','$HTTP_POST_VARS[venue_state]','$HTTP_POST_VARS[venue_zip]','$HTTP_POST_VARS[age]','$datemodified','$HTTP_POST_VARS[id]','$HTTP_POST_VARS[catid]','$HTTP_POST_VARS[regionid]')";

$result = mysql_query($query, $link);
echo("Event added.<br>\n");
echo("<br><a href=\"promoter.php\">Back to promoter index</a><br>\n");
User avatar
hob_goblin
Forum Regular
Posts: 978
Joined: Sun Apr 28, 2002 9:53 pm
Contact:

Post by hob_goblin »

instead of

Code: Select all

if ($HTTP_POST_VARS&#1111;'opentimeampm'] == 2) 
$HTTP_POST_VARS&#1111;'opentimehour'] += $HTTP_POST_VARS&#1111;'opentimehour'] + 12; 
$opentime = $HTTP_POST_VARS&#1111;'opentimehour'].":".$HTTP_POST_VARS&#1111;'opentimemin'].":00"; 

if ($HTTP_POST_VARS&#1111;'closetimeampm'] == 2) 
$HTTP_POST_VARS&#1111;'closetimehour'] += 12; 
$closetime = $HTTP_POST_VARS&#1111;'closetimehour'].":".$HTTP_POST_VARS&#1111;'closetimemin'].":00";
try

Code: Select all

if ($HTTP_POST_VARS&#1111;'opentimeampm'] == "2")&#123;
$HTTP_POST_VARS&#1111;'opentimehour'] = $HTTP_POST_VAR&#1111;'opentimehour'] + 12; 
$opentime = $HTTP_POST_VARS&#1111;'opentimehour'].":".$HTTP_POST_VARS&#1111;'opentimemin'].":00"; 

if ($HTTP_POST_VARS&#1111;'closetimeampm'] == "2")&#123;
$HTTP_POST_VARS&#1111;'closetimehour'] = $HTTP_POST_VARS&#1111;'closetimehour'] + 12; 
$closetime = $HTTP_POST_VARS&#1111;'closetimehour'].":".$HTTP_POST_VARS&#1111;'closetimemin'].":00"; 
&#125;
Post Reply