示例#1
0
$records = array();
$rows = 10;
$self = $_SERVER["PHP_SELF"];
$total_rows = 0;
try {
    $db = new rdb("", "", "", true);
} catch (Exception $e) {
    $messages = $e->getMessage();
    if (empty($messages) === false) {
        die(sprintf(HTML_LAYOUT, $self, $messages));
    }
}
try {
    $records = $db->read(SQL_SELECT_RECORDS_ALL);
    $total_rows = count($records);
    $random_ids = random_records($records, $rows);
    if (count($random_ids) > 0) {
        foreach ($random_ids as $index => $random_id) {
            $data = array(":" . KEY_NUMBER_DECIMAL => random_decimal(), ":" . KEY_NUMBER_INTEGER => random_integer(), ":" . KEY_STRING_SIXTYFOUR => random_string(), ":" . KEY_ID => $random_id);
            $affected = $db->update($data, SQL_UPDATE_RECORD_BY_ID);
        }
    }
} catch (Exception $e) {
    $messages .= $e->getMessage();
}
$content = sprintf(HTML_UPDATE_HEADER, $rows);
$messages = $db->dump_messages() . $messages;
if (empty($messages) === false) {
    $content .= sprintf(HTML_PRE, $messages);
}
echo sprintf(HTML_LAYOUT, $self, $content);