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); }
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; } }
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; }
//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 = '修改'; }
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);