i am trying to update database table by using checkboxes ,the code is not giving any error,but the database table is not updating. My blade code where the form is:
<body>
<h2>Reported Posts </h2>
<a href="">Back</a>
<table>
@foreach($post_reports as $post_report)
<tr>
<td>Report NO:</td>
<td></td>
<td></td>
<form method="post">
@csrf
<td><input type="checkbox" name="statusyes[]" value= >report to admin <input type="checkbox" name="statusno[]" value= >wrong report </td>
</tr>
@endforeach
<td><input type="submit" name="submit" value="Submit" /></td>
</form>
</table>
my controller code is :
I am using the status_update_reported_post function
<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Post_report;
use Illuminate\Support\Facades\DB;
class moderatorController extends Controller
{
public function index(Request $request){
return view('moderator.index');
}
public function reported_post(Request $request){
$post_reports=DB::table('Post_reports')
->where('status','moderator')->get();
return view('moderator.reported_post')-> with('post_reports',$post_reports);
}
public function status_update_reported_post(Request $request){
$statusadmin[]=$request['statusyes'];
$statuswrong[]=$request['statusno'];
$r='admin';
$wr='wrong';
foreach($statusadmin as $report_id){
DB::table('post_reports')
->where('report_id','$report_id')
->update(['status' => 'admin']);
}
foreach($statuswrong as $report_id){
DB::table('post_reports')
->where('report_id','$report_id')
->update(['status' => 'wrong']);
}
}
}
the code is working fine but there is no update in the table i dont know where the problem is, It all seems fine to me .
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire