PHP Phalcon\Db\Adapter\Pdo Sqlite::fetchAll Examples

Example #1

File: setarea.php Project: xw716825/git_back

//威宁彝族回族苗族自治县
//改变初中
$sqlite_chuzhong = new Sqlite(['dbname' => 'db/chuzhong_area.db']);
$sql = "select sch_name,pro_name,city_name,area_name from school_area";
$chuzhong = $sqlite_chuzhong->fetchAll($sql);
$length = count($chuzhong);
//$mysql->begin();
foreach ($chuzhong as $key => $val) {
    $val['pro_name'] = (int) $val['pro_name'];
    $val['city_name'] = (int) $val['city_name'];
    $val['area_name'] = (int) $val['area_name'];
    $sql = "update school set pro_code='{$val['pro_name']}',city_code='{$val['city_name']}',area_code='{$val['area_name']}' where sch_name='{$val['sch_name']}' and sch_type=3";
    $mysql->execute($sql);
    echo "初中数据 {$length}/{$key}\n";
}
//$mysql->commit();
//改变高中
$sqlite_gaozhong = new Sqlite(['dbname' => 'db/gaozhong_area.db']);
$sql = "select sch_name,pro_name,city_name,area_name from school_area";
$gaozhong = $sqlite_gaozhong->fetchAll($sql);
$length = count($gaozhong);
//$mysql->begin();
foreach ($gaozhong as $key => $val) {
    $val['pro_name'] = (int) $val['pro_name'];
    $val['city_name'] = (int) $val['city_name'];
    $val['area_name'] = (int) $val['area_name'];
    $sql = "update school set pro_code='{$val['pro_name']}',city_code='{$val['city_name']}',area_code='{$val['area_name']}' where sch_name='{$val['sch_name']}' and sch_type=4";
    $mysql->execute($sql);
    echo "高中数据 {$length}/{$key}\n";
}
//$mysql->commit();