複製文字

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;
use DB;
use App\Models\Tmember;

class AdminController extends Controller
{
    
    public function Admin(){
        return view('Admin.Index');
    }

    public function AdmMemberMgt()
    {
        $users = Tmember::all(); 
        if ($users == NULL){
            return "NO DATA........";
        }else{
            return view('Admin.AdmMemberMgt', ['users' => $users]);
        }
    }
    
    public function AdmMemberDelete(Request $r)
    {
        $acc = $r->acc;

        // 查詢會員資料
        $sql = "SELECT photo FROM member WHERE acc = ?";
        $users = DB::select($sql, [$acc]);

        if (count($users) > 0) {
            $photo = $users[0]->photo;

            if (!empty($photo)) {
                $oldFile = public_path('images/' . $photo);
                $oldFile = str_replace('\\', '/', $oldFile); // 確保路徑格式正確
                print_r($oldFile);
                if (file_exists($oldFile) && is_file($oldFile)) {
                    unlink($oldFile);
                }
            }

            // 刪除帳號資料
            $deleteSql = "DELETE FROM member WHERE acc = ?";
            DB::delete($deleteSql, [$acc]);

            return redirect("Admin/AdmMemberMgt")->with('success', '會員已刪除');
        } else {
            return redirect("Admin/AdmMemberMgt")->with('error', '查無此帳號');
        }
    }

}