how to store html contents in database using laravel eloquent query

Question

I want to store html table into my database but it is throwing this error

array to string conversion

i'm posting html table from javascript to my php controller

var html = '<table><thead><tr><th>Product Name</th><th>Price</th></tr></thead><tbody><tr><td>Alphabet</td><td>200</td></tr></tbody></table>; 

 $.ajax({
    url:'store',
    type:'POST',
    data:{table:html},
    success:function(data){
       console.log(data)
    }
 });

laravel:posted data to be inserted

 Route::post('store',function(){

   $toStore = addslashes(['table' => $_POST['table']]);   

   \App\product_table::create($toStore);

 });

Alexey Mezenin · Accepted Answer · 2017-12-28 17:21:19Z

2

You're getting this error because addslashes() expects string and you pass an array to the function.

You can just pass request array to the create() method:

\App\product_table::create(request()->all());

If you want to use addslashes() anyway, do this:

\App\product_table::create(['table' => addslashes(request('table'))]);

answered Dec 28, 2017 at 17:21

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

Comments

YouneL · Accepted Answer · 2017-12-28 17:32:16Z

0

the addslashes function accept only strings, and you have to use Request class in order to get your submitted data:

use Illuminate\Http\Request;

...

Route::post('store',function(Request $request) {

    $toStore = ['table' => addslashes($request->input('table'))];   

    \App\product_table::create($toStore);

});

edited Dec 28, 2017 at 17:32

answered Dec 28, 2017 at 17:21

YouneL

8,3692 gold badges30 silver badges52 bronze badges

1 Comment

Alexey Mezenin Over a year ago

You've copy-pasted ['table' => addslashes(...)] from my answer, but you've forgot to remove extra ) from the end.

Collectives™ on Stack Overflow

how to store html contents in database using laravel eloquent query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related