PHP db_req_reg示例

示例#1

文件： osm_to_mysql.php 项目： bottookku/botto

<?php

require_once __DIR__ . "/../../function/db_api.php";
if (file_exists('xml.txt')) {
    $xml = simplexml_load_file('xml.txt');
    foreach ($xml->node as $sss) {
        //ДОБАВЛЕНИЕ точек...
        //УБРАТЬ ЛИШНИЕ ЗНАКИ..... иначе в интеджер не поместится...
        $d1 = "INSERT INTO `polygon_geo` (`polygon_geo_id`, `long`, `lat`) VALUES ('" . substr($sss['id'], 4, 10) . "', '" . $sss['lon'] . "', '" . $sss['lat'] . "');";
        db_req_reg($d1);
    }
    foreach ($xml->way as $ss) {
        //ДОБАВЛЕНИЕ ИМЕН РАЙОНОВ
        $ss123 = "INSERT INTO `polygon_name` (`polygon_name_id`, `polygon_name`) VALUES ('" . substr($ss['id'], 4, 10) . "', '" . $ss->tag['v'] . "')";
        db_req_reg($ss123);
    }
    foreach ($xml->way as $ss) {
        foreach ($ss->nd as $rrr) {
            $id = intval(substr($rrr['ref'], 4, 10));
            foreach ($xml->node as $sss) {
                $fff = intval(substr($sss['id'], 4, 10));
                if ($fff == $id) {
                    $d2 = "INSERT INTO `polygon` (`polygon_name_id`, `polygon_geo_id`) VALUES ('" . substr($ss['id'], 4, 10) . "', '" . $fff . "');";
                    db_req_reg($d2);
                }
            }
        }
    }
}

示例#2

文件： api.php 项目： bottookku/botto

         $ans = array("ans" => "ok", "msg" => $ret);
         setcookie("user", $input['name'], time() + 9000000);
         setcookie("pass", $input['pass'], time() + 9000000);
         echo json_encode($ans);
     } else {
         $ans = array("ans" => "error", "msg" => $ret);
         echo json_encode($ans);
     }
 }
 ////проверка куков....
 if ($input['id'] == "cookie") {
     $req = "SELECT * FROM `taxist` WHERE `username`='{$input['user']}';";
     $ret = db_req($req);
     if ($ret[pass_taxist] == $input['pass'] && !$input['user'] == "") {
         $req = "UPDATE `taxist` SET `online`=1 WHERE `username`={$input['user']};";
         $ret = db_req_reg($req);
         $ans = array("ans" => "ok", "msg" => $ret);
         echo json_encode($ans);
     } else {
         $ans = array("ans" => "error");
         echo json_encode($ans);
     }
 }
 ////////////
 ///если нажато кнопка старт
 ///////////
 if ($input['id'] == "start") {
     $req = "SELECT * FROM `taxist` WHERE `username`='{$input['user']}';";
     $ret = db_req($req);
     /////////
     ///зачемто проверяет пароль