static function getInstance($servername, $dbname, $username, $password) { if (!self::$zjhobj) { self::$zjhobj = new ZjhSql($servername, $dbname, $username, $password); } return self::$zjhobj; }
<?php require_once 'fun.php'; require_once 'zjhsql.php'; require_once 'reserve.php'; require_once 'user.php'; require_once 'admin.php'; require_once 'recommend.php'; require_once 'rebate.php'; session_start(); date_default_timezone_set('PRC'); $db = ZjhSql::getInstance(SERVERNAME, DATABASE, USERNAME, PASSWORD); //预约页面 function reserve() { echo template('reserve.php', array(), false); } function login() { echo template('login.php'); } function adminLogin() { $reservename = getvar('username', 'post'); $pass = getvar('pass', 'post'); if (strlen($reservename) >= 5 && strlen($pass) > 5) { $admin = new Admin(); $row = $admin->findOne($reservename, md5($pass)); if ($row) { setvar('admin', $row['username']); //session
<?php // error_reporting(0); require '../engine/zjhsql.php'; $db = ZjhSql::getInstance('localhost', 'aida', 'root', ''); //获取省 function retObj($data) { $html = file_get_contents("http://japi.zto.cn/zto/api_utf8/baseArea?msg_type=GET_AREA&data=" . $data); return json_decode("[" . $html . "]")[0]; } function logs($str) { echo $str; echo "<br/>"; } set_time_limit(0); $province = retObj(0); if ($province->message == '') { $provinces = $province->result; foreach ($provinces as $key => $value) { $db->exec('insert into `provinces` set provinceid=?,province=?', array($value->code, $value->fullName)); $city = retObj($value->code); logs($value->code . $value->fullName); if ($city->message == '') { $cities = $city->result; foreach ($cities as $k => $v) { logs($v->code . $v->fullName); $db->exec('insert into `cities` set cityid=?,city=?,provinceid=?', array($v->code, $v->fullName, $value->code)); $area = retObj($v->code); if ($area->message == '') {
<?php /* require('../config.php'); require('../class/handle.php'); echo post_recommend('fjsdlkfldksjflk','14852335895','张明亮'); */ require '../class/zjhsql.php'; $db = ZjhSql::getInstance('localhost', 'zjh', 'root', ''); $post =& $_POST; // if(count($post)){ // $name = $post['name']; // $db->exec('insert into `user_01` set name=?',$name); // } $result = $db->queryOne('select * from `user_01`'); var_dump($result); $db->exec('update `user_01` set name=?', 'haha'); // function getName($length=3){ // $str = "abcdefghijklmnopqrstuvwxyz"; // $ret = ""; // for($i = 0;$i<$length;$i++){ // $pos = rand(0,25); // $ret = $ret.substr($str,$pos,1); // } // return $ret; // } // function getPhone($length=11){ // $str = "1234567890"; // $ret = "1"; // for($i = 0;$i<$length-1;$i++){ // $pos = rand(0,9);
public function __construct() { $this->db = ZjhSql::getInstance('192.168.10.100', 'accountant', 'user', '@mecaiwu'); }