function create_db_instance()
{
require 'db_settings.php';
try {
$db = new CMySQL();
$db->connect($db_server, $db_username, $db_password);
$db->selectDatabase($db_database);
return $db;
} catch (Exception $e) {
echo 'Virhe tietokantayhteydessä!';
}
return null;
}
*
* Dolphin is free software. This work is licensed under a Creative Commons Attribution 3.0 License.
* http://creativecommons.org/licenses/by/3.0/
*
* Dolphin is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
* without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the Creative Commons Attribution 3.0 License for more details.
* You should have received a copy of the Creative Commons Attribution 3.0 License along with Dolphin,
* see license.txt file; if not, write to marketing@boonex.com
***************************************************************************/
require_once "header.inc.php";
require_once BX_DIRECTORY_PATH_INC . 'utils.inc.php';
define('DB_FULL_VISUAL_PROCESSING', true);
define('DB_FULL_DEBUG_MODE', false);
define('DB_DO_EMAIL_ERROR_REPORT', true);
$MySQL = new CMySQL();
if (!$MySQL->connect()) {
genMySQLErr('Database connect failed');
}
if (!$MySQL->select_db()) {
genMySQLErr('Database select failed');
}
db_res("SET NAMES 'utf8'");
$cacheParam = array();
class CMySQL
{
var $host = DATABASE_HOST;
var $sock = DATABASE_SOCK;
var $port = DATABASE_PORT;
var $user = DATABASE_USER;
var $passwd = DATABASE_PASS;
$data_cities[] = $aValues['city'] . "\n";
}
echo json_encode($data_cities);
} elseif ($_REQUEST['field_name'] == 'region') {
$country = $_GET['country'];
// Получаем Страну
$region = $_GET['term'];
// Получаем вводимые данные в поля город\
$sql = "SELECT region.region_name_ru as region\n FROM region_ as region\n JOIN country_ as country ON country.country_name_ru = {$country}\n WHERE region.id_country = country.id\n AND region.region_name_ru LIKE '{$region}%'\n ORDER BY country_name_ru";
$mysql = new CMySQL();
// Объявляем экземпляр класса для работы с БД
$aItemInfo = $mysql->getAll($sql);
// Получаем все записи, соответствующие запросу
foreach ($aItemInfo as $aValues) {
$data_regions[] = $aValues['region'] . "\n";
}
echo json_encode($data_regions);
} elseif ($_REQUEST['field_name'] == 'country') {
$sParam = $_GET['term'];
// Получаем вводимые данные в поля страна
$sql = "SELECT country_name_ru FROM country_ WHERE country_name_ru LIKE '{$sParam}%' ORDER BY country_name_ru";
$mysql = new CMySQL();
// Объявляем экземпляр класса для работы с БД
$aItemInfo = $mysql->getAll($sql);
// Получаем все записи, соответствующие запросу
foreach ($aItemInfo as $aValues) {
$data[] = $aValues['country_name_ru'] . "\n";
}
echo json_encode($data);
//Возвращаем массив со списком стран
}
<?php
$appid = 'wxde7a1c3c9b803601';
$appsecret = 'd4624c36b6795d1d99dcf0547af5443d';
require_once "wxsdk.php";
require_once "mysql.php";
$mySQL = new CMySQL('bdm207399638.my3w.com', 'bdm207399638_db', 'bdm207399638', 'woshitooth10');
$openid = $_GET['openid'];
$wxsdk = new CWXSDK($appid, $appsecret);
if (isset($openid)) {
$result = $mySQL->Query("select * from BogusWXFriendsUser where openid = '{$openid}'");
$user_info = $mySQL->FetchObject($result);
} else {
$user_info = $wxsdk->GetUserInfo();
$result = $mySQL->Query("select * from BogusWXFriendsUser where openid = '{$user_info->openid}'");
if (mysql_num_rows($result)) {
$mySQL->Query("update BogusWXFriendsUser set nickname = '{$user_info->nickname}', headimgurl = '{$user_info->headimgurl}' where openid = '{$user_info->openid}'");
} else {
$curTime = date('Y-m-d H:i:s');
$mySQL->Query("insert into BogusWXFriendsUser (openid, nickname, headimgurl, sex, addtime) value ('{$user_info->openid}', '{$user_info->nickname}', '{$user_info->headimgurl}', '{$user_info->sex}', '{$curTime}')");
}
}
//echo '<pre>';
//print_r(time());
//print_r(435345);
//echo '</pre>';
//获得微信js的配置数据
$wxShareConfig = $wxsdk->GetWXShareJSConfigData();
//输出网页内容
include_once 'main.html';
//定义js使用的变量
