forms - Inserting drop down value into MySQL table -

-

i have site, people supposed able arrange meetings users within system. i'm having difficulties getting start , endtime form appear in mysql database, i'm using timestamp format saving values. me figuring out i'm going wrong?

<?php $page_title = "create event";      //check if form has been submitted     if (isset($_post['submitted'])) {      $errors = array(); //initialize error array      // check event name     if (empty($_post['event_name'])) {         $errors[] = 'you have not given event name.';      } else {         $en = trim($_post['event_name']);     }      // check event location     if (empty($_post['location'])) {         $errors[] = 'you have not determined meeting taking place.';      } else {         $l = trim($_post['location']); }      if (empty($_post['starttime'])) {         $errors[] = 'you have not determined when meeting starting.';      } else {         $s = trim($_post['starttime']); }     if (empty($_post['endtime'])) {         $errors[] = 'you have not determined when meeting ending.';      } else {         $e = trim($_post['endtime']); }      if (empty($errors)) { // if ok                  // create event in database                  // require_once                 ('../mysqli_connect.php'); // db connect                  // make query                 $host="mysql.itu.dk";                 $username="tklo";                 $password="cave57waits49";                 $db_name="project_cluster";                 $tbl_name="events";                  mysql_connect("$host", "$username", "$password") or die ("cannot connect");                 mysql_select_db("$db_name") or die ("cannot select database");                  $sql="insert $tbl_name (event_name, location, starttime, endtime)values('$en', '$l', '$s', '$e')";                 $result=mysql_query($sql);                  if($result){                 echo "succesfull";                 echo "<br>";                 echo "<a href='newevent.php'>back main page</a>";                 }                  else {                 echo "error";                 }                 mysql_close();                 }     else {     echo '<h2>error!</h2>                 <p class="error">the following error(s) occured:<br />';                 foreach ($errors $msg) { // print each error                 echo " - $msg<br />\n";                 }                 }                                }   ?>         <form action="newevent.php" method="post">         <p>name event: <input type="text" name="event_name" value="<?php if(isset($_post['event_name'])) echo $_post['event_name']; ?>" /></p>         <p>where meeting taking place: <input type="text" name="location" value="<?php if(isset($_post['location'])) echo $_post['location']; ?>" /></p>         <p>beginning of event <input type="text" name="starttime" value="<?php if(isset($_post['starttime'])) echo $_post['starttime']; ?>" /></p>         <p>end of event <input type="text" name="endtime" value="<?php if(isset($_post['endtime'])) echo $_post['endtime']; ?>" /></p>          <input type="submit" value="go" />         <input type="hidden" name="submitted" value="true" />         </form>


Comments

Post a Comment

Popular posts from this blog

Perl - how to grep a block of text from a file -

-
it can in xml or text format. how in general grep block of text in perl? <track type="ws"> <range> <rangestart>0</rangestart> <rangeend>146.912</rangeend> <locationindex>0</locationindex> <propertyindex>0</propertyindex> </range> </track> <track type="ps" id="1"> <range> <rangestart>0</rangestart> <rangeend>146.912</rangeend> <locationindex>1</locationindex> <propertyindex>1</propertyindex> </range> </track> i want grep type="ps" , till </range> . one solution open file, read line line , match block. open(fh, "file.txt"); foreach $line (<fh>) { if ($line =~ m/type="cc"(.*?)<\/range>/) { print $1; } } but there more optimal solution without reading file line l
Read more

delphi - How to remove all the grips on a coolbar if I have several coolbands? -

-
Image
if set mycoolbar.fixedorder true,only grip on first band hidden. well,if use delphi 7 create vcl forms application,then put coolbar on , create 3 coolbans hold other controls,only grip , top coolbands can hidden setting mycoolbar.fixedorder:=true. i've uploaded picture make things clear. you got fixedorder property wrong. fixed property not allow bands rearranged if set true . setting property of coolbar true keep user changing bands order @ runtime, user can still move , resize bands. can give advice can do, actual solution problem, well, have wait answer. my advice use 3 coolbars in row , setting "fixedorder" property true , bandborderstyle bsnone . way grip hidden on of them. about property, it's not bug of ide, actual preference of property.
Read more

javascript - Animating array of divs; only the final element is modified -

-
this baffling me @ moment. i'm experienced programmer looking throw bit of surprise fiancee on countdown page our wedding. desired effect simulated confetti falling behind main page. setup follows: i have array of divs in javascript. each div absolutely positioned on page. have interval set updates every 50 or milliseconds. on each tick, run loop on array of divs, , calculations , update positions. problem problem having, however, though can see divs created, stored array, , modified (in case, each has slight randomized rotation) during initialization phase, once tick update position starts, div stored in whatever last slot of array gets position updated. tried hard-coding each div index testing purposes, strictly last element update position. upon printing current "left" , "top" style values each div before , after calculations shows value has been changed, no visible change noticeable. here's basic code: javascript var container;
Read more