<?php
#載入預設系統
include_once "libraries/load.php";
#執行應用程式
$keyid = !empty($_GET['keyid']) ? $_GET['keyid'] : 0;
if (!empty($_GET['keyid'])) {
$userdata['definfo'] = dbconn::get_oneusr($_GET['keyid']);
$userdata['othinfo'] = dbconn::get_usruid($_GET['keyid']);
$count = dbconn::count_comkey($userdata['othinfo']['usr_makekey']);
$userdata['count'] = $count['countn'];
} else {
$userdata['othinfo']['usr_makekey'] = '';
}
/*
<!--meta property="og:image" content="http://www.bubutrip.com.tw/event/2015Anniversary/resources/images/fb_share.jpg"></meta-->
<!--meta property="og:image" content="http://theme.jake.tw/fb_share.jpg"></meta-->
*/
?>
<html lang="en">
<head>
<meta charset="utf-8">
<meta property="og:locale" content="zh_TW" />
<meta property="og:type" content="website" />
<meta property="og:site_name" content="BuBuTrip週年慶，我的住宿券要靠你!" />
<meta property="og:title" content="BuBuTrip週年慶，我的住宿券要靠你!" />
<meta property="og:url" content="http://www.bubutrip.com.tw/event/2015Anniversary/fbsharer2.php">
<meta property="og:description" content="新朋友註冊成功後，除了能替好友累積中獎機會，還可抽7-11佰元禮券。同時也會產生專屬招待碼，抽親子住宿券喔！" />
</head>
<body></body>
<?php
#載入預設系統
include_once "libraries/load.php";
#執行應用程式
$userdata['definfo'] = dbconn::get_oneusr($_SESSION['user']['id']);
$userdata['othinfo'] = dbconn::get_usruid($_SESSION['user']['id']);
$userdata['count'] = dbconn::count_member_xu($_SESSION['user']['id']);
#載入View
if ($_SESSION['checkmobile'] == 1) {
$view = 'views/mobile/m.index.php';
} else {
$view = 'views/web/index.php';
}
include_once $view;
public static function make_newkey()
{
$status = 0;
$key = '';
while ($status == 0) {
$str = '';
for ($i = 1; $i <= 15; $i++) {
$n = rand(1, 3);
switch ($n) {
case 1:
$str = $str . chr(rand(65, 90));
#大寫英文
break;
case 2:
$str = $str . chr(rand(97, 122));
#小寫英文
break;
case 3:
$str = $str . chr(rand(48, 57));
#數字
break;
}
}
$keydata = '';
$keydata = dbconn::get_usrkey($str);
if (empty($keydata)) {
$status = 1;
}
}
return $str;
}
<?php
ini_set('display_errors', 1);
error_reporting(E_ERROR);
error_reporting(E_ALL || ~E_NOTICE);
include_once "lib/libdb.php";
include_once "lib/libmodlist.php";
date_default_timezone_set('Asia/Seoul');
//ini_set( 'include_path', ini_get('include_path').':../lib:../lib/jpgraph' );
//session_start();
header('Content-Type: text/html; charset=utf-8');
$DB = new dbconn("roomreserve", "localhost", "root", "medinfo");
$colors = array("#0072bc", "#00a651", "#f7941d", "ff66cc", "9999ff", "33ccff", "ccff33");
$confroom_group = array("2층 회의실" => array("2층 2303 회의실 1(원형)", "2층 2302 회의실 2", "2층 2301 회의실 3"), "3층 회의실" => array("3층 3301 회의실 1(원형)", "3층 3220 소회의실 1", "3층 3221 소회의실 2", "3층 3222 소회의실 3"), "4층 회의실" => array("4층 4301 회의실 1(원형)", "4층 4220 소회의실 1", "4층 4221 소회의실 2", "4층 4222 소회의실 3"));
$confroom = array("2층 2303 회의실 1(원형)", "2층 2302 회의실 2", "2층 2301 회의실 3", "3층 3301 회의실 1(원형)", "3층 3220 소회의실 1", "3층 3221 소회의실 2", "3층 3222 소회의실 3", "4층 4301 회의실 1(원형)", "4층 4220 소회의실 1", "4층 4221 소회의실 2", "4층 4222 소회의실 3");
${$key} = "1dasd12WESA12dsaasd456TGDFsd";
$table = $DB->table("deviceinfo");
list($room_name) = $table->selectfetch("", "di_room", "di_ip='" . $_SERVER["REMOTE_ADDR"] . "'");
//$room_name = "2층 2303 회의실 1(원형)";
function time_format($time_str)
{
$time = substr($time_str, 0, 5);
$apm = substr($time_str, 6, 2);
list($h, $m) = explode(":", $time);
if ($apm == "PM") {
$h += 12;
}
return sprintf("%02d%02d", $h, $m);
}
function time_human($time_str)
{
<?php
header('Access-Control-Allow-Origin: *');
header("Access-Control-Allow-Headers: Origin, X-Requested-With, Content-Type, Accept");
require 'clases/dbconn.inc';
//Conexión a la BD
$query = new dbconn();
$query->init();
$query->OpenDataBase();
$data_back = json_decode(file_get_contents('php://input'));
$nombres = utf8_decode($data_back->{nombres});
$edad = utf8_decode($data_back->{edad});
$dni = utf8_decode($data_back->{dni});
$telefono = utf8_decode($data_back->{telefono});
$correo = utf8_decode($data_back->{correo});
$mega = utf8_decode($data_back->{mega});
if ($nombres != "") {
$query->OpenDataBaseQuery("insert into usuario (nombres,dni,telefono,correo,mega,edad) values ('{$nombres}','{$dni}', '{$telefono}','{$correo}', '{$mega}', '{$edad}');");
}
echo "Registro completo";
$member = dbconn::getmemusr($username);
if (empty($member)) {
dbconn::go_showmsg('帳號不存在');
exit;
}
if ($member['User_status'] != 'T') {
dbconn::go_showmsg('帳號未啟用！');
exit;
}
if (md5(md5($password) . $member['User_salt']) != $member['User_passwd']) {
dbconn::go_showmsg('帳號與密碼不匹配！');
exit;
}
$_SESSION['eventadm:uid'] = $member['id'];
$_SESSION['eventadm:acc'] = $member['User_acc'];
dbconn::go_showmsg('', '/event/admin');
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<link rel="shortcut icon" href="assets/img/favicon.png">
<title>BuBuTrip 活動管理後臺</title>
<link href="http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,400italic,700,800" rel="stylesheet" type="text/css">
<link href="http://fonts.googleapis.com/css?family=Raleway:300,200,100" rel="stylesheet" type="text/css">
<link href="http://fonts.googleapis.com/css?family=Open+Sans+Condensed:300,700" rel="stylesheet" type="text/css">
<link href="assets/lib/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
<?php
// this php file include code for connecting to the database
include '../con_mysql.php';
$con = new dbconn();
$con->getcon();
// this includes all classes and functions
include 'adminclass.php';
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta name="author" content="S.R.U.K.Senanayake" />
<title>View Exam Results</title>
<style type="text/css">
<!--
body {
background-image: url(../Images/background.jpg);
background-repeat:repeat;
width:100%;
font-family:arial;
font-size: 20px;
}
.style1 {color: #FFFFFF}
body,td,th {
color: #000000;
}
.style2 {
<?php
error_reporting(E_ALL);
ini_set('display_errors', 'On');
require '../../inc/config.php';
require 'defconfig.php';
#################################
defconfig::checkusrlogin();
$tickets = dbconn::query_all_tripname();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<link rel="shortcut icon" href="assets/img/favicon.png">
<title>BuBuTrip 活動管理後臺</title>
<link href="http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,400italic,700,800" rel="stylesheet" type="text/css">
<link href="http://fonts.googleapis.com/css?family=Raleway:300,200,100" rel="stylesheet" type="text/css">
<link href="http://fonts.googleapis.com/css?family=Open+Sans+Condensed:300,700" rel="stylesheet" type="text/css">
<link href="assets/lib/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="assets/lib/font-awesome/css/font-awesome.min.css">
<!--if lt IE 9script(src='https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js')
-->
<link rel="stylesheet" type="text/css" href="assets/lib/jquery.nanoscroller/css/nanoscroller.css">
<link rel="stylesheet" type="text/css" href="assets/lib/jquery.datatables/plugins/bootstrap/3/dataTables.bootstrap.css"/>
<link href="assets/css/style.css" rel="stylesheet">
</head>
<body>
imagecolortransparent($im,$back_color);
imagefill($im,0,0,$back_color);
$text_color = imagecolorallocate($im, 0, 0, 0);
$font_width = ( $font_size ) * $word_strlen;
$font_height = ( $font_size );
$x = 2;#( $width - $font_width ) / 2 ;
$y = 31;#( $height - $font_height ) / 2 ;
imagettftext($im, $font_size, 0, $x, $y, $text_color, "font/unifont-8.0.01.ttf", $word );
$imgname = dbconn::make_img_name( $user_id );
$imgurl = "makeimg/".$imgname.".png";
imagepng($im,$imgurl);
imagedestroy($im);
*/
$imgurl = "makeimg/def.jpg";
$imgkey = true;
dbconn::inserttripname($user_id, $postdata['mascotName'], $postdata['mean'], $imgurl);
}
}
}
?>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="google-site-verification" content="" />
<meta name="description" content="親子自駕旅遊網BuBuTrip吉祥物誕生了~一起來幫可愛的小飛鼠取名字吧！價值$30,000元旅遊券，將送給最具創意的你！">
<meta name="keywords" content="BuBuTrip、親子自駕旅遊網、吉祥物、命名我最會獎、$30,000元、旅遊券、放鬆一「夏」、我最幸運獎、命名活動、抽獎、100位幸運得主、$160元、插畫作家afu、日本製森林系紙膠帶、彩虹森林、小飛鼠、Dyson戴森無線吸塵器、捷安特滑步車" />
<meta name="url" content="http://www.bubutrip.com.tw/" />
<meta property="og:locale" content="zh_TW" />
<meta property="og:site_name" content="BuBuTrip小飛鼠吉祥物 等你取好名！" />
<meta property="og:title" content="BuBuTrip小飛鼠吉祥物 等你取好名！" />
}
error_reporting(0);
define('Online', true);
error_reporting(0);
break;
default:
header('HTTP/1.1 503 Service Unavailable.', TRUE, 503);
echo 'The application environment is not set correctly.';
exit(1);
// EXIT_ERROR
}
if (Online) {
include_once "../event_config_by_jake.php";
require '../../inc/config.php';
require PATH_INC . '/class_user.php';
include_once "../dbconn.php";
define('imgurl', 'http://az823916.vo.msecnd.net');
} else {
define('WEB_PROTOCOL', $_SERVER['SERVER_PORT'] == '443' || isset($_SERVER['HTTP_X_FORWARDED_PROTO']) && $_SERVER['HTTP_X_FORWARDED_PROTO'] == 'https' ? 'https://' : 'http://');
define('URL_BASE', '');
define('WEB_ROOT', WEB_PROTOCOL . $_SERVER['SERVER_NAME'] . URL_BASE);
define('FB_APPID', '853302524700193');
define('FB_SECRET', '4282553f36fb28178e30d51a79ea7007');
}
include_once "libraries/config.php";
include_once "libraries/common.php";
include_once "libraries/database.php";
include_once "libraries/api.php";
include_once "libraries/My_phpmailer.php";
dbconn::checkmobile2();
//$_SESSION['checkmobile'] = 0;
public static function query_user($uid = 0)
{
if (empty($_SESSION['admin:uid'])) {
return 0;
}
if (!is_numeric($uid)) {
return 3;
}
$query = "select * from `tk_tripuser` where id = '" . $_SESSION['admin:uid'] . "';";
$result = dbconn::defdb_getRow($query);
}
<?php
error_reporting(E_ALL);
ini_set('display_errors', 'On');
require '../../inc/config.php';
require 'defconfig.php';
#################################
defconfig::checkusrlogin();
$members = dbconn::query_allmemneweve();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<link rel="shortcut icon" href="assets/img/favicon.png">
<title>BuBuTrip 活動管理後臺</title>
<link href="http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,400italic,700,800" rel="stylesheet" type="text/css">
<link href="http://fonts.googleapis.com/css?family=Raleway:300,200,100" rel="stylesheet" type="text/css">
<link href="http://fonts.googleapis.com/css?family=Open+Sans+Condensed:300,700" rel="stylesheet" type="text/css">
<link href="assets/lib/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="assets/lib/font-awesome/css/font-awesome.min.css">
<!--if lt IE 9script(src='https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js')
-->
<link rel="stylesheet" type="text/css" href="assets/lib/jquery.nanoscroller/css/nanoscroller.css">
<link rel="stylesheet" type="text/css" href="assets/lib/jquery.datatables/plugins/bootstrap/3/dataTables.bootstrap.css"/>
<link href="assets/css/style.css" rel="stylesheet">
</head>
<body>
<?php
error_reporting(E_ALL);
ini_set('display_errors', 'On');
require '../../inc/config.php';
require 'defconfig.php';
#################################
defconfig::checkusrlogin();
#取所有參與的會員資料
$members = dbconn::query_all_mem();
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<link rel="shortcut icon" href="assets/img/favicon.png">
<title>BuBuTrip 活動管理後臺</title>
<link href="http://fonts.googleapis.com/css?family=Open+Sans:400,300,600,400italic,700,800" rel="stylesheet" type="text/css">
<link href="http://fonts.googleapis.com/css?family=Raleway:300,200,100" rel="stylesheet" type="text/css">
<link href="http://fonts.googleapis.com/css?family=Open+Sans+Condensed:300,700" rel="stylesheet" type="text/css">
<link href="assets/lib/bootstrap/dist/css/bootstrap.min.css" rel="stylesheet">
<link rel="stylesheet" href="assets/lib/font-awesome/css/font-awesome.min.css">
<!--if lt IE 9script(src='https://oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js')
-->
<link rel="stylesheet" type="text/css" href="assets/lib/jquery.nanoscroller/css/nanoscroller.css">
<link rel="stylesheet" type="text/css" href="assets/lib/jquery.datatables/plugins/bootstrap/3/dataTables.bootstrap.css"/>
<link href="assets/css/style.css" rel="stylesheet">
</head>
session_start();
error_reporting(E_ALL);
ini_set('display_errors', 'On');
require '../../inc/config.php';
require PATH_INC . '/class_user.php';
require '../dbconn.php';
$user_id = User::getId();
//使用者編號
$memberloginkey = false;
if (!empty($user_id)) {
$memberloginkey = true;
$userdata = dbconn::getUserById($user_id);
$userfbdata = dbconn::getFBUserById($user_id);
$is_new_user = isset($_SESSION['is_new_user']) ? $_SESSION['is_new_user'] : 0;
dbconn::insertMem($user_id, $is_new_user);
$oldtripname = dbconn::checktripname($user_id);
} else {
//強制設定登入後導回頁面
$_SESSION['login:next:tag'] = 'event';
$_SESSION['login:next'] = "/event/BuBuTripName/m.final.php";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="google-site-verification" content="" />
<meta name="description" content="親子自駕旅遊網BuBuTrip吉祥物誕生了~一起來幫可愛的小飛鼠取名字吧！價值$30,000元旅遊券，將送給最具創意的你！">
<meta name="keywords" content="BuBuTrip、親子自駕旅遊網、吉祥物、命名我最會獎、$30,000元、旅遊券、放鬆一「夏」、我最幸運獎、命名活動、抽獎、100位幸運得主、$160元、插畫作家afu、日本製森林系紙膠帶、彩虹森林、小飛鼠、Dyson戴森無線吸塵器、捷安特滑步車" />
<meta name="url" content="http://www.bubutrip.com.tw/" />
/**
* Install schema into the database
*
* @param string $filename location of database schema file
* @param dbconn $conn connection to database
* @param string $type type of database, currently mysql or pgsql
*
* @return boolean - indicating success or failure
*/
function runDbScript($filename, $conn, $type = 'mysqli')
{
$sql = trim(file_get_contents(INSTALLDIR . '/db/' . $filename));
$stmts = explode(';', $sql);
foreach ($stmts as $stmt) {
$stmt = trim($stmt);
if (!mb_strlen($stmt)) {
continue;
}
// FIXME: use PEAR::DB or PDO instead of our own switch
switch ($type) {
case 'mysqli':
$res = $conn->query($stmt);
if ($res === false) {
$error = $conn->error();
}
break;
case 'pgsql':
$res = pg_query($conn, $stmt);
if ($res === false) {
$error = pg_last_error();
}
break;
default:
$this->updateStatus("runDbScript() error: unknown database type " . $type . " provided.");
}
if ($res === false) {
$this->updateStatus("ERROR ({$error}) for SQL '{$stmt}'");
return $res;
}
}
return true;
}
$mcrypt->setkey($key);
$mcrypt->setMode($mode);
if (!isJson($eventobj)) {
$errinfo = array('status' => 2, 'msg' => 'data err.', 'alert' => '貼心提醒：APP請更新至最新版或再重新嘗試一次');
print_r(json_encode($errinfo));
exit;
}
$eventarray = json_decode($eventobj);
if (!empty($eventarray->user_id)) {
$infoarray['user_id'] = $mcrypt->testdecrypt($key, $eventarray->user_id);
}
if (!empty($eventarray->device_id)) {
$infoarray['device_id'] = $mcrypt->testdecrypt($key, $eventarray->device_id);
}
if (empty($infoarray['user_id']) or empty($infoarray['device_id'])) {
$errinfo = array('status' => 3, 'msg' => 'parse err.', 'alert' => '資料有誤,請重新嘗試一次');
print_r(json_encode($errinfo));
exit;
}
$updateevent = dbconn::insert_user_driveinfo($infoarray);
if ($updateevent == 1) {
$errinfo = array('status' => 0, 'msg' => 'http://www.bubutrip.com.tw/event/2015Anniversary/get_score_done.php', 'alert' => '領取成功！');
print_r(json_encode($errinfo));
exit;
} else {
$errinfo = array('status' => 4, 'msg' => 'data exist.', 'alert' => '您已經領過栗子囉');
print_r(json_encode($errinfo));
exit;
}
}
}
error_reporting(E_ALL);
ini_set('display_errors', 'On');
require '../../inc/config.php';
require PATH_INC . '/class_user.php';
require '../dbconn.php';
#var_dump(FB_APPID); //fb app id
#var_dump(FB_SECRET); //fb app secret
$user_id = User::getId();
//使用者編號
$memberloginkey = false;
if (!empty($user_id)) {
$memberloginkey = true;
$userdata = dbconn::getUserById($user_id);
$userfbdata = dbconn::getFBUserById($user_id);
$is_new_user = isset($_SESSION['is_new_user']) ? $_SESSION['is_new_user'] : 0;
dbconn::insertMem($user_id, $is_new_user);
} else {
//強制設定登入後導回頁面
$_SESSION['login:next:tag'] = 'event';
$_SESSION['login:next'] = "/event/BuBuTripName/m.index.php";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="google-site-verification" content="" />
<meta name="description" content="親子自駕旅遊網BuBuTrip吉祥物誕生了~一起來幫可愛的小飛鼠取名字吧！價值$30,000元旅遊券，將送給最具創意的你！">
<meta name="keywords" content="BuBuTrip、親子自駕旅遊網、吉祥物、命名我最會獎、$30,000元、旅遊券、放鬆一「夏」、我最幸運獎、命名活動、抽獎、100位幸運得主、$160元、插畫作家afu、日本製森林系紙膠帶、彩虹森林、小飛鼠、Dyson戴森無線吸塵器、捷安特滑步車" />
<meta name="url" content="http://www.bubutrip.com.tw/" />
/**
* Connection to database. This release works with MySQL
* @param none
* @return none
* @access private
*/
function _connect()
{
$this->_report('Connecting to database', 30);
$settings = array('hostname' => $this->sDBHost, 'username' => $this->sDBUser, 'password' => $this->sDBPwd, 'socket' => $this->sDBSocket, 'database' => $this->sDBName);
$GLOBALS['settings'] = $settings;
$this->rLink = dbconn::instance($settings);
$this->rLink->query("SET NAMES 'utf8'");
return $this->rLink;
}
require PATH_INC . '/class_user.php';
require '../dbconn.php';
if (!empty($_GET['offerme2_click'])) {
$_SESSION['offerme2_click'] = $_GET['offerme2_click'];
}
$user_id = User::getId();
//使用者編號
$memberloginkey = false;
$is_new_user = isset($_SESSION['is_new_user']) ? $_SESSION['is_new_user'] : 0;
if (!empty($user_id)) {
$memberloginkey = true;
$memberloginkey = true;
$userdata = dbconn::getUserById($user_id);
$userfbdata = dbconn::getFBUserById($user_id);
dbconn::insertMem($user_id, $is_new_user);
$hi_ticket_str = dbconn::make_ticket(0, $user_id, $is_new_user);
} else {
//強制設定登入後導回頁面
$_SESSION['login:next:tag'] = 'event';
$_SESSION['login:next'] = "/event/BuBuTripTicket/m.register.php?ticket=1";
}
?>
<html lang="en">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<meta name="google-site-verification" content="" />
<meta name="description" content="親子自駕旅遊網BuBuTrip吉祥物誕生了！9/13(日)在台北市立動物園將隆重與大家相見~我們將帶來好玩的互動遊戲，有野餐墊、扇子、名信片、冰淇淋、爆米花多項好禮送給你！更棒的是，活動現場會送出Dyson戴森無線吸塵器(價值$27,900元)一台！另外，還會抽出兩部小朋友界最夯的捷安特滑步車(價值$3,280)，心動了就千萬別錯過，等你喔~">
<meta name="keywords" content="BuBuTrip、親子自駕旅遊網、吉祥物、Dyson戴森無線吸塵器、捷安特滑步車、野餐墊、扇子、名信片、冰淇淋、爆米花、台北市立動物園" />
<meta name="url" content="http://www.bubutrip.com.tw/" />
<meta property="og:locale" content="zh_TW" />
$starttime = time();
while (!feof($fp) && time() < $starttime + 5) {
$_SESSION['ca_pic']['data'] .= fread($fp, 8192);
}
fclose($fp);
}
$_SESSION['ca_pic']['dirty'] = true;
}
}
break;
case "reset":
unset($_SESSION['ca_pic']);
break;
}
if (!isset($_SESSION['ca_pic'])) {
$_SESSION['ca_pic'] = array();
$_SESSION['ca_pic']['dirty'] = false;
$db = new dbconn();
$return = $db->query("SELECT picture FROM pictures WHERE id=" . $_SESSION['ca_id']);
if ($db->row_count($return) > 0) {
$_SESSION['ca_pic']['in_db'] = true;
$arr = $db->fetch_row($return);
$_SESSION['ca_pic']['data'] = $arr[0];
} else {
$_SESSION['ca_pic']['in_db'] = false;
$fp = fopen("unknown.jpg", "rb");
$_SESSION['ca_pic']['data'] = fread($fp, 906240);
fclose($fp);
}
}
echo $_SESSION['ca_pic']['data'];
<!DOCTYPE html>
<LINK HREF="style.css" REL="stylesheet" TYPE="text/css">
<html>
<?php
include "database.php";
include "autos.php";
$db = new dbconn();
$conn = $db->getDb();
mysqli_select_db($conn, "autos");
$sql = "SELECT * FROM autowbshp";
if (isset($_POST['submit'])) {
$maxprijs = $_POST["maxprijs"];
$minprijs = $_POST["minprijs"];
if ($_POST['minprijs'] == "") {
$minprijs = 0;
}
if ($_POST['maxprijs'] == "") {
$maxprijs = 999999999999999;
//2147483647
}
$merk = $_POST["select"];
if ($_POST['select'] == "Kies een merk") {
$sql = "SELECT * FROM autowbshp WHERE autoprijs <= '{$maxprijs}' AND autoprijs >= '{$minprijs}'";
} else {
$sql = "SELECT * FROM autowbshp WHERE automerk = '{$merk}' AND autoprijs <= '{$maxprijs}' AND autoprijs >= '{$minprijs}'";
}
}
$result = $connection->query($sql);
?>
session_start();
error_reporting(E_ALL);
ini_set('display_errors', 'On');
require '../../inc/config.php';
require PATH_INC . '/class_user.php';
require '../dbconn.php';
require '../PHPMailer/PHPMailerAutoload.php';
if (!empty($_GET['offerme2_click'])) {
$_SESSION['offerme2_click'] = $_GET['offerme2_click'];
}
if (isset($_SESSION['offerme2_click'])) {
$mem_ticketclick = $_SESSION['offerme2_click'];
} else {
$mem_ticketclick = '';
}
dbconn::checkmobile();
#var_dump(FB_APPID); //fb app id
#var_dump(FB_SECRET); //fb app secret
$user_id = User::getId();
//使用者編號
$user_name = User::getName();
$hi_ticket_str = false;
$ticket_str = false;
$memberloginkey = false;
$is_new_user = isset($_SESSION['is_new_user']) ? $_SESSION['is_new_user'] : 0;
if (!empty($user_id)) {
$memberloginkey = true;
/*
$userdata = dbconn::getUserById( $user_id );
$userfbdata = dbconn::getFBUserById( $user_id );
dbconn::insertMem( $user_id , $is_new_user );
