Saving a datepicker value to database in laravel

Question

I have this input in my form... I need to store the date picked from it, but I get a null value when I submit

<script type="text/javascript">
   $(function() {
       $( "#datepicker" ).datepicker();
   });
</script>

<input type="text" required="" placeholder="When are You Coming Back" name="datepicker2"  id="datepicker2" value="" name="datepicker2" class="txt">

am I missing something?? when I submit I don't get any values in the database, I am using laravel5

class LeaveController extends Controller
{
     public function ApplyLeave(Request $request)
    {

        Auth::user()->sent()->create([
            'tel'       => $request->tel,
            'email'    => $request->email,
            'start' => $request->datepicker,
            'end'       => $request->datepicker1,
            'supervisor'    => $request->supervisor,
            'department' => $request->department,
            'name'    => $request->name,
            'adress' => $request->adress,
        ]);   
        return view('home');
   }

your input name is datepicker2 but in your request object you calling without a number and with number 1. — Sysix, Jan 19 '17 at 18:04

score 14 · Accepted Answer · answered Jan 19 '17 at 18:05

14

Parsing dates should work:

'start' => Carbon::parse($request->datepicker),
'end' => Carbon::parse($request->datepicker1),

Also, it's a good idea to put start and end to the $dates array.

answered Jan 19 '17 at 18:05

Alexey Mezenin

158,981
26
290
279

Class 'App\Http\Controllers\Carbon' not found error – Sir George Jan 19 '17 at 18:17
Either import it at the top like this `use Carbon\Carbon` or call it like this: `\Carbon\Carbon::parse(...)` – DevK Jan 19 '17 at 18:26
OOps DateTime::__construct(): Failed to parse time string (dfg) at position 0 (d): The timezone could not be found in the database..sorry for my poor debuging skills though – Sir George Jan 19 '17 at 18:27
As @JayminPanchal answered, you'll need to convert the datepicker output format to `Y-m-d` format. There's plenty of ways to do it (server, client). A good start would be telling us what format is your datepicker outputting. – DevK Jan 19 '17 at 18:31
how do i get that?? how do i print the output? – Sir George Jan 19 '17 at 18:39
01/06/2017 after i pick a date it looks like this – Sir George Jan 19 '17 at 18:41
@SirGeorge I've just tried and `Carbon::parse('01/06/2017')` parses this date to `2017-01-06`. – Alexey Mezenin Jan 19 '17 at 18:44
there is no error now, but my start and end columns are still empty? its like i dint even pick a date – Sir George Jan 19 '17 at 18:47
if i check my columns in the db, its written NULL my datatype in the db is "date" – Sir George Jan 19 '17 at 18:49
1

i got it thanks guys .. i appreciate stack overflow very mmuch..thanks again – Sir George Jan 19 '17 at 18:51

score 1 · Answer 2 · answered Jan 19 '17 at 18:08

You need to convert your date to the format the DB accept like Y-m-d i.e. 2017-01-19.

Try to convert it before storing in DB

like,

public function ApplyLeave(Request $request){

    Auth::user()->sent()->create([
        'tel'       => $request->tel,
        'email'    => $request->email,
        'start' => date("Y-m-d", strtotime($request->datepicker)),
        'end'       => date("Y-m-d", strtotime($request->datepicker1)),
        'supervisor'    => $request->supervisor,
        'department' => $request->department,
        'name'    => $request->name,
        'adress' => $request->adress,
    ]);   
    return view('home');
}

still empty..is it because i set the default value to null?? — Sir George, Jan 19 '17 at 18:17
just print the value of `$request->datepicker` `$request->datepicker1` and post it so that we can help you more — Jaymin Panchal, Jan 19 '17 at 18:18

score 1 · Answer 3 · edited May 23 '17 at 12:01

1

Use strtotime() on your first date then date('Y-m-d') to convert it back:

$time = strtotime('10/16/2003');

$newformat = date('Y-m-d',$time);

echo $newformat;

// 2003-10-16

Converting string to Date and DateTime

edited May 23 '17 at 12:01

Community

1
1

answered Jan 19 '17 at 19:45

Saving a datepicker value to database in laravel

3 Answers3