Laravel Not Inserting Json Data Into MySQL

Question

Please see the code below, can't figure out what is wrong but insert is not happening... any ideas on how to debug/fix

Laravel - Controller

namespace App\Http\Controllers;

use App\Models\PhoneContactsPhonesModel;
use Illuminate\Http\Request;

class CreatePhoneContactsController extends Controller
{
    public function create(Request $request, $id)
    {

        $users = new PhoneContactsPhonesModel;
        $json = dd(json_decode($request->getContent(), true));

        foreach ($json as $key => $value) {

            $users->mysql_user_id = $id;
            $users->phone = $key;
            $users->name = $value;
            $users->save();

        }

    }
}

Laravel - Route

Route::post('create_phone_contacts/{id}', 'CreatePhoneContactsController@create');

Something is wrong with foreach loop - it seems to be working well with hardcoded values outside the loop

You're using dd(). That function will dump the value and terminate the execution of the script, so the foreach loop will never be executed.. — M. Eriksson
– M. Eriksson, Commented Nov 21, 2019 at 6:21
ok removing dd just inserts only 1 row - which is the last row — DragonFire
– DragonFire, Commented Nov 21, 2019 at 6:22
That's because you're just updating and saving the same object over and over on each iteration. Are you trying to update existing users or create new ones? — M. Eriksson
– M. Eriksson, Commented Nov 21, 2019 at 6:23

Arun J · Accepted Answer · 2019-11-21 12:00:17Z

4

Remove dd() and create object in for loop. This will solve your issue.

namespace App\Http\Controllers;
use App\Models\PhoneContactsPhonesModel;
use Illuminate\Http\Request;

class CreatePhoneContactsController extends Controller
{
    public function create(Request $request, $id)
    {  
        $json = json_decode($request->getContent(), true);
        foreach ($json as $key => $value) {
            $users = new PhoneContactsPhonesModel;// ---> here
            $users->mysql_user_id = $id;
            $users->phone = $key;
            $users->name = $value;
            $users->save();
        }
    }
}

edited Nov 21, 2019 at 12:00

Arun J

6834 gold badges15 silver badges27 bronze badges

answered Nov 21, 2019 at 6:25

Nikhil G

2,50617 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Arun J · Accepted Answer · 2019-11-21 12:05:39Z

1

All you have to do is, remove dd() from your code.

Change this

$json = dd(json_decode($request->getContent(), true));  //change here

To this

$json = json_decode($request->getContent(), true); //change this remove dd()

It'll work..

edited Nov 21, 2019 at 12:05

Arun J

6834 gold badges15 silver badges27 bronze badges

answered Nov 21, 2019 at 6:33

VIKAS KATARIYA

6,0153 gold badges19 silver badges37 bronze badges

Collectives™ on Stack Overflow

Laravel Not Inserting Json Data Into MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related