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');
}
