Jump to content

Inserting date into database


unplugged_web

Recommended Posts

I'm trying to build a calendar of sorts where people can add in their own events. Most of it works except for the date field always uses today's date.

I've got this:

public function saveAction(Request $request, Application $app)  {    $event = $request->get('form')['event'];     if ($event) {      $dd = Cb2bLatestEventsQuery::create()        ->filterByEvent($event)        ->findOneOrCreate();      $dd->setEventDate(date('Y-m-d'));      $dd->setEvent($event);      $dd->save();    }     return $app->redirect('/latest_events');  }

but it uses today's date. I've tried changing it to this:

public function saveAction(Request $request, Application $app)  {    $event = $request->get('form')['event'];     if ($event) {      $dd = Cb2bLatestEventsQuery::create()        ->filterByEvent($event)        ->findOneOrCreate();      $dd->setEventDate(get('form')['event_date']);      $dd->setEvent($event);      $dd->save();    }     return $app->redirect('/latest_events');  }

which gives this error:

[14-Jul-2014 15:29:00 Europe/London] PHP Fatal error: Call to undefined function Cb2bLatestEventsControllerget() in /home/ubuntu/web/src/LatestEvents/Controller/LatestEventsController.php on line 57

line 57 is:

      $dd->setEventDate(get('form')['event_date']);

and this:

public function saveAction(Request $request, Application $app)  {    $event = $request->get('form')['event']    $event_date = $request->get('form')['event_date'];     if ($event) {      $dd = Cb2bLatestEventsQuery::create()        ->filterByEvent($event) //       ->filterByDate(array('date'=>event_date('Y-m-d 00:00'), 'date'=>event_date('Y-m-d 23:59')))        ->findOneOrCreate();      $dd->setEventDate(array($event_date);      $dd->setEvent($event);      $dd->save();    }     return $app->redirect('/latest_events');  }

but this gives me the error:

 

[14-Jul-2014 15:01:04 Europe/London] PHP Parse error: syntax error, unexpected '$event_date' (T_VARIABLE) in /home/ubuntu/web/src/LatestEvents/Controller/LatestEventsController.php on line 52

Line 52 is:

    $event_date = $request->get('form')['event_date'];

I've tried so many different ways of but no matter what I do it either throws up an error or inserts today's date.

The form where people add the events looks like this:

<form method="post" id="events">  <div class="form-group"><label for="form_event_date" class="required control-label">Event date</label><input type="text" id="form_event_date" name="form[event_date]" required="required" class="form-control"></div><div class="form-group"><label for="form_event" class="required control-label">Event</label><textarea id="form_event" name="form[event]" required="required" class="form-control"></textarea></div><input type="hidden" id="form__token" name="form[_token]" class="form-control" value="292270f1fedc80a05e8f4607a90bf00dd4857a30">  <div class="form-group">    <button type="submit" class="btn btn-success">Save</button>  </div></form>
Edited by thehappyappy
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...