Ejemplos de DB_connect::fetch_array en PHP

Ejemplo n.º 1

Archivo: crc32-convert.php Proyecto: BackupTheBerlios/ewebuki-svn

    URL: http://www.chaos.de
*/
////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if ($debugging[html_enable]) {
    $debugging[ausgabe] .= "[ ** {$main_script_name} ** ]" . $debugging[char];
}
// hallo zur datenbank
$db = new DB_connect();
$connect = $db->connect();
if ($debugging[html_enable]) {
    $debugging[ausgabe] .= "data connect: " . $connect . $debugging[char];
}
$sql = "SELECT * FROM site_text WHERE tname like '%.%' and crc32='0'";
$result = $db->query($sql, 2);
$update_count = 0;
while ($data = $db->fetch_array($result, 1)) {
    echo "Found: " . $data[tid] . " " . $data[label] . " " . $data[tname] . "<br>";
    $tname = explode(".", $data[tname]);
    $newtname = crc32("/" . $tname[0]) . "." . $tname[1];
    $sql = "UPDATE site_text SET tname='" . $newtname . "', crc32='-1' WHERE tid=" . $data[tid];
    if (count($tname) > 2) {
        echo "Daten von " . $data[label] . " - " . $data[tname] . " inkombatibel! - Konvertierung fehlgeschlagen!<br>";
    } else {
        if ($debugging[html_enable]) {
            $debugging[ausgabe] .= "sql: " . $sql . $debugging[char];
        }
        $insertresult = $db->query($sql, 2);
        if ($insertresult) {
            $update_count++;
        }
    }