converttimes.php

#!/usr/bin/php

<?php
    //übertragescript

    echo "START\n";

    include('dbconnect.php');

    $getazdata = $dbc->query("select * from az_data where length(maID) > 4 order by azdID, datum_ab desc;");
    $insertstr = "insert into az_time values ";
    foreach($getazdata as $azdata){
        if($azdata['mon']) $insertstr .= "('$azdata[azdID]', 1, '$azdata[azstart]', '$azdata[azende]', '$azdata[kz1start]', '$azdata[kz1ende]', '$azdata[kz2start]', '$azdata[kz2ende]'), ";
        if($azdata['die']) $insertstr .= "('$azdata[azdID]', 2, '$azdata[azstart]', '$azdata[azende]', '$azdata[kz1start]', '$azdata[kz1ende]', '$azdata[kz2start]', '$azdata[kz2ende]'), ";
        if($azdata['mit']) $insertstr .= "('$azdata[azdID]', 3, '$azdata[azstart]', '$azdata[azende]', '$azdata[kz1start]', '$azdata[kz1ende]', '$azdata[kz2start]', '$azdata[kz2ende]'), ";
        if($azdata['don']) $insertstr .= "('$azdata[azdID]', 4, '$azdata[azstart]', '$azdata[azende]', '$azdata[kz1start]', '$azdata[kz1ende]', '$azdata[kz2start]', '$azdata[kz2ende]'), ";
        if($azdata['fre']) $insertstr .= "('$azdata[azdID]', 5, '$azdata[azstart]', '$azdata[azende]', '$azdata[kz1start]', '$azdata[kz1ende]', '$azdata[kz2start]', '$azdata[kz2ende]'), ";
        if($azdata['sam']) $insertstr .= "('$azdata[azdID]', 6, '$azdata[azstart]', '$azdata[azende]', '$azdata[kz1start]', '$azdata[kz1ende]', '$azdata[kz2start]', '$azdata[kz2ende]'), ";
        if($azdata['son']) $insertstr .= "('$azdata[azdID]', 7, '$azdata[azstart]', '$azdata[azende]', '$azdata[kz1start]', '$azdata[kz1ende]', '$azdata[kz2start]', '$azdata[kz2ende]'), ";
    }
    $insertstr = substr($insertstr, 0, -2);
    $insertstr .= ";";
    echo $insertstr."\n";

    $dbc->query($insertstr);
    if($dbc->error) echo $dbc->error . "\n";
    echo "DONE\n";
?>