berikut cara seting password di slims senayan adalah tanggal lahir secara massala

pertama, perlu diketahui, tanggal lahir di slims di simpan dengan format yyyy-mm-yy

Misalnnya lahir 11 Januari 1992, maka pada tabel member di kolom birth_date tersimpan 1992-01-11

nah kita akan settting passwordnnya menjadi tanggal lahir namun dengan format yyymmdd

misalnnya:
member_name : Erwan Setyo Budi
member_id : 1234
birth_date : 1992-02-13

Saya ingin password login anggotannya adalah
member_id : 1234
password : 13021992

berikut kodennya

<?php
// Koneksi database
$host = "localhost";
$user = "root"; 
$pass = "root"; 
$db = "indramayu"; // ganti dengan nama database SLiMS Anda

$conn = new mysqli($host, $user, $pass, $db);

if ($conn->connect_error) {
    die("Koneksi gagal: " . $conn->connect_error);
}

echo "===================================\n";
echo "UPDATE PASSWORD FORMAT DDMMYYYY\n";
echo "===================================\n\n";
echo "Koneksi berhasil!\n\n";

// Ambil semua member yang memiliki tanggal lahir
$sql = "SELECT member_id, birth_date FROM member WHERE birth_date IS NOT NULL";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $sukses = 0;
    $gagal = 0;
    
    echo "Memproses " . $result->num_rows . " member...\n\n";
    
    while($row = $result->fetch_assoc()) {
        $member_id = $row['member_id'];
        $birth_date = $row['birth_date']; // Format: YYYY-MM-DD
        
        // Konversi ke format DDMMYYYY
        // Contoh: 2026-02-06 → 06022026
        $date_parts = explode('-', $birth_date);
        $year = $date_parts[0];
        $month = $date_parts[1];
        $day = $date_parts[2];
        
        // Format DDMMYYYY
        $plain_password = $day . $month . $year; // Hasil: 06022026
        
        // Buat hash bcrypt
        $hashed_password = password_hash($plain_password, PASSWORD_BCRYPT);
        
        // Update password
        $update_sql = "UPDATE member SET mpasswd = '$hashed_password' WHERE member_id = '$member_id'";
        
        if ($conn->query($update_sql) === TRUE) {
            $sukses++;
            echo "✓ Member: $member_id\n";
            echo "  Birth date: $birth_date → Password: $plain_password\n";
            echo "  Hash: " . substr($hashed_password, 0, 30) . "...\n\n";
        } else {
            $gagal++;
            echo "✗ Member $member_id: GAGAL - " . $conn->error . "\n\n";
        }
    }
    
    echo "===================================\n";
    echo "SUMMARY:\n";
    echo "Total member: " . $result->num_rows . "\n";
    echo "Berhasil: $sukses\n";
    echo "Gagal: $gagal\n";
    echo "===================================\n";
    
    // Tampilkan contoh untuk verifikasi
    echo "\nCONTOH PASSWORD BARU:\n";
    echo "Birth date: 2026-02-06 → Password: 06022026\n";
    echo "Birth date: 1992-01-11 → Password: 11011992\n";
    echo "Birth date: 1988-12-25 → Password: 25121988\n";
    
} else {
    echo "Tidak ada data member dengan tanggal lahir\n";
}

$conn->close();
?>

Panggil kode itu di server dengan urlutama/updatepassword.php