📁 File Manager

Dosya Düzenle: u.php

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);

include 'connect.php';

echo "Connected successfully! ";

$sql = "SELECT rid, enroll FROM prereg WHERE rid > 10161";
$result = $con->query($sql);

if (!$result) {
    die("Query failed: " . $con->error);
}

echo "Rows found: " . $result->num_rows . " ";

if ($result->num_rows > 0) {
    $updated = 0;
    while ($row = $result->fetch_assoc()) {
        $rid = $row['rid'];
        $enroll = $row['enroll'];

if (empty($enroll)) {
 echo "Skipping rid=$rid (empty enroll) ";
 continue;
 }

$bcryptHash = password_hash($enroll, PASSWORD_BCRYPT);

$stmt = $con->prepare("UPDATE prereg SET password = ? WHERE rid = ?");
        if (!$stmt) {
            die("Prepare failed: " . $con->error);
        }
        $stmt->bind_param("si", $bcryptHash, $rid);
        $stmt->execute();

if ($stmt->affected_rows > 0) {
            $updated++;
        }

$stmt->close();
    }

echo "✅ Updated $updated records.";
} else {
 echo "ℹ️ No records found where rid > 2900.";
}

$con->close();
?>

İptal