英文:
How do I deal with my database id when I enter the id data to continue the data that has been deleted
问题
这是我的控制器代码：
<?phpnamespace App\Http\Controllers;use App\Models\User;use App\Models\Datakaryawan;use Illuminate\Http\Request;use Illuminate\Support\Facades\DB;use Illuminate\Support\Facades\Auth;use Illuminate\Support\Facades\Session;class DatakaryawanController extends Controller{public function index(){$data = Datakaryawan::paginate(4);return view('data-karyawan', ['data' => $data]);}public function create(){$data = Datakaryawan::all();return view('data-karyawan-add', ['data' => $data]);}public function store(Request $request){$data = Datakaryawan::create($request->all());if ($data) {Session::flash('status', 'success');Session::flash('message', 'Berhasil menambah data karyawan');}return redirect('data-karyawan');}public function edit(Request $request, $id){$id = Datakaryawan::findorfail($id);return view('data-karyawan-edit', ['id' => $id]);}public function update(Request $request, $id){$id = Datakaryawan::findorfail($id);$id->update($request->all());return redirect('/data-karyawan');}public function destroy($id){Datakaryawan::where('id', $id)->delete();return redirect()->to('/data-karyawan')->with('success', 'Berhasil menghapus data karyawan');}}
这是默认视图：
当我删除它时，ID 是 1，ID 2 不会变成 ID 1，而仍然是 ID 2：
之后，我添加了新数据，ID 会跟随现有表格：
英文:
This is my controller code
<?phpnamespace App\Http\Controllers;use App\Models\User;use App\Models\Datakaryawan;use Illuminate\Http\Request;use Illuminate\Support\Facades\DB;use Illuminate\Support\Facades\Auth;use Illuminate\Support\Facades\Session;class DatakaryawanController extends Controller{public function index(){$data = Datakaryawan::paginate(4);return view('data-karyawan', ['data' => $data]);}public function create(){$data = Datakaryawan::all();return view('data-karyawan-add', ['data' => $data]);}public function store(Request $request){$data = Datakaryawan::create($request->all());if ($data) {Session::flash('status', 'success');Session::flash('message', 'Berhasil menambah data karyawan');}return redirect('data-karyawan');}public function edit(Request $request, $id){$id = Datakaryawan::findorfail($id);return view('data-karyawan-edit', ['id' => $id]);}public function update(Request $request, $id){$id = Datakaryawan::findorfail($id);$id->update($request->all());return redirect('/data-karyawan');}public function destroy($id){Datakaryawan::where('id', $id)->delete();return redirect()->to('/data-karyawan')->with('success', 'Berhasil menghapus data karyawan');}}
This is the default view
When I delete it, the id is 1, the id 2 doesn't become id 1, but it stays id 2
After that I added new data, and the id instead follows the existing table
答案1
得分: 1
这是数据库的行为方式。
我猜你有一个包含foreach循环的刀片文件，在其中你获取特定项，然后调用类似$item->id的东西。只需将其更改为$loop->index，你应该可以获得你想要的行为。
当你请求删除/更新行的数据时，请不要使用$loop->index，而是使用实际的ID，你可以将ID添加到数据属性中，例如：
<div class="row" data-id="{{$item->id}}"...
英文:
This is how the database behaves.
I guess you have a blade file with a foreach loop where you get the specific item and then you call something like $item->id. Just change that to $loop->index and you should get the behaviour you want.
when you request delete/update the data of a row don't use this $loop->index but use the actual id, you can just add the id in a data attribute like for example:
<div class"row" data-id="{{$item->id}}"...
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论