PHP make_insert_sql示例

示例#1

文件： search.php 项目： TopGrd/newxb

 function add($type, $type_id, $content)
 {
     global $db;
     $content = $this->chinese_words($content);
     $sql = make_insert_sql($this->table, array('type' => $type, 'type_id' => $type_id, 'content' => $content));
     return $db->query($sql);
 }

示例#2

文件： model.php 项目： TopGrd/newxb

 function add($data = array())
 {
     global $db;
     check_allowed(str_replace(LZ_MYSQL_PREFIX, '', $this->table), 'add', LZ_RESPONSE == 'text');
     $sql = make_insert_sql($this->table, $data);
     if ($db->query($sql)) {
         return $db->insert_id();
     } else {
         return false;
     }
 }

示例#3

文件： cache.php 项目： TopGrd/newxb

 function add($data)
 {
     global $db;
     !$data['uri'] && ($data['uri'] = $this->get_uri());
     $data['create_time'] = time();
     if (!$data['ttl']) {
         $data['ttl'] = 120;
     }
     $content = $data['content'];
     $order_id = 0;
     $c = substr($content, 0, 20000);
     while ($c) {
         $data['content'] = $c;
         $data['order_id'] = $order_id;
         $sql = make_insert_sql($this->table, $data);
         $r = $db->query($sql);
         if (!$r) {
             break;
         }
         $order_id++;
         $c = substr($content, $order_id * 20000, 20000);
     }
     return $r;
 }

示例#4

文件： admin_book.php 项目： antsmallant/coreapp

 //pecho($net);
 //update `lxq_book` set date=update_date,time=update_date
 if (empty($id)) {
     $edit = '添加';
     $dbarr['uid'] = $_SESSION["uid"];
     $dbarr['update_date'] = $update_date;
     $dbarr['item'] = $item;
     $dbarr['item_txt'] = $item_txt;
     $dbarr['remark'] = $remark;
     $dbarr['ccy'] = $ccy;
     $dbarr['amount'] = $amount;
     $dbarr['net'] = $net + $amount;
     $dbarr['otype'] = $otype;
     $dbarr['date'] = date('Y-m-d', strtotime($update_date));
     $dbarr['time'] = date('H:i:s', strtotime($update_date));
     $sql = make_insert_sql("{$tablepre}book", $dbarr);
 } else {
     $dbarr['update_date'] = $update_date;
     $dbarr['item'] = $item;
     $dbarr['item_txt'] = $item_txt;
     $dbarr['remark'] = $remark;
     $dbarr['ccy'] = $ccy;
     $dbarr['amount'] = $amount;
     $dbarr['net'] = $net + $amount;
     $dbarr['otype'] = $otype;
     $dbarr['date'] = date('Y-m-d', strtotime($update_date));
     $dbarr['time'] = date('H:i:s', strtotime($update_date));
     $where['id'] = $id;
     $sql = make_update_sql("{$tablepre}book", $dbarr, $where);
     $edit = '修改';
 }

示例#5

文件： csv.php 项目： antsmallant/coreapp

CSV格式
name,email,home_phone,office_phone,remarks
903老乡,,,13826520745,
Jone,,,8.6150720373E+12,
*/
$file = 'D:\\steven\\222.csv';
$files = file_get_contents($file);
$files = explode("\r\n", $files);
foreach ($files as &$v) {
    $v = explode(",", $v);
}
foreach ($files as $k => $v) {
    if ($k > 0) {
        foreach ($files[0] as $kk => $kv) {
            $csvs[$k - 1][$kv] = $v[$kk];
        }
    }
}
$time = time();
foreach ($csvs as $v) {
    $v['user_id'] = 1;
    $v['user_id'] = 1;
    $v['create_date'] = date('Y-m-d', $time);
    $v['create_time'] = date('H:i:s', $time);
    $v['update_date'] = date('Y-m-d', $time);
    $v['update_time'] = date('H:i:s', $time);
    $sql = make_insert_sql('mdb_address', $v);
    echo $sql . ';<br>';
}
//echo '<pre>';
//print_r($csvs);