public function __construct()
{
$conn = new mysql_db('localhost', 'sol_empleo', 'sol.empleo', 'sol_empleo');
$recs = $conn->query_all('SELECT id,pais,codigo ' . 'FROM paises ', array());
foreach ($recs as $value) {
$this->paises[$value['id']] = array('pais' => $value['pais'], 'codigo' => $value['codigo']);
}
}
public static function getConnection()
{
if (!isset(self::$P_Instance)) {
$c = __CLASS__;
self::$P_Instance = new $c();
}
return self::$P_Instance;
}
/**
* Connect to the database.
*/
function connect()
{
$this->db = mysql_db::getConnection();
if (isset($this->config['database']['username']) && isset($this->config['database']['password'])) {
if (!$this->db->connect($this->config['database'])) {
$this->_err_code = 100;
$this->_err_msg = 'Could not connect to database server';
}
}
}
static function getInstance()
{
if (self::$instance === false) {
switch (self::getType()) {
case 'mysql':
mysql_db::$host = self::$host;
mysql_db::$user = self::$user;
mysql_db::$pwd = self::$pwd;
mysql_db::$dbname = self::$dbname;
self::$instance = mysql_db::getInstance();
break;
default:
die('No database of type ' . self::getType() . ' found');
}
}
return self::$instance;
}
public function __construct($strategy)
{
$dbm = array('mysql', 'mysqli', 'pgsql');
if (in_array($strategy, $dbm) === false) {
throw new Exception('Invalid parameter for Data Base Strategy');
}
try {
switch ($strategy) {
case 'mysql':
$this->strategy = mysql_db::getInstance();
break;
case 'mysqli':
$this->strategy = mysqli_db::getInstance();
break;
case 'pgsql':
$this->strategy = pgsql_db::getInstance();
break;
}
} catch (Exception $e) {
echo $e->getMessage();
}
}
<?php
// configuration
require "../includes/config.php";
require "../includes/accountService.php";
$db = new mysql_db(SERVER, USERNAME, PASSWORD, DATABASE);
$errortext_contact = "";
$errortext_friend = "";
$errortext_foe = "";
//apache config set REQUEST_METHOD GET as default, automatically add / after the linke
if ($_SERVER["REQUEST_METHOD"] == "GET") {
if (!empty($_GET["contact"])) {
rmExist($_SESSION["username"], $_GET["contact"]);
$errortext_contact = "remove " . $_GET["contact"] . " from contact list successfully";
} else {
if (!empty($_GET["friend"])) {
rmExist($_SESSION["username"], $_GET["friend"]);
$errortext_friend = "remove " . $_GET["friend"] . " from friend list successfully";
} else {
if (!empty($_GET["foe"])) {
rmExist($_SESSION["username"], $_GET["foe"]);
$errortext_foe = "remove " . $_GET["foe"] . " from foe list successfully";
}
}
}
$contacts = getContacts($_SESSION["username"]);
$friends = getFriends($_SESSION["username"]);
$foes = getFoes($_SESSION["username"]);
render("contact_template.php", ["contacts" => $contacts, "friends" => $friends, "foes" => $foes, "errortext_contact" => $errortext_contact, "errortext_friend" => $errortext_friend, "errortext_foe" => $errortext_foe, "titile" => "Contact"]);
} else {
if ($_SERVER["REQUEST_METHOD"] == "POST") {
<h1>Pruebas de base de datos</h1>
<?php
include 'extensions/db/dbscheme.class.php';
include 'extensions/db/mysql_db.plugin.php';
include 'extensions/db/db.php';
/*db::connect('name1', 'mysql', 'localhost', 'pruebas', 'root', 'test');
db::createcommand('SELECT * FROM alumnos', 'name1')->execute();
*/
$db = new mysql_db();
$db->connect('localhost', 'pruebas', 'root', 'test');
$t = $db->createcommand('SELECT * FROM alumnos', 'name1');
while ($row = mysql_fetch_assoc($t)) {
print_r($row);
echo '<hr />';
}
echo '<h2>Other</h2>';
$db2 = new mysql_db();
$db2->connect('localhost', 'arrayzone', 'root', 'test');
$t = $db2->createcommand('SELECT * FROM az_users', 'name1');
while ($row = mysql_fetch_assoc($t)) {
print_r($row);
echo '<hr />';
}
/*echo '<h2>Another</h2>';
$t = $db->select(array('*'))->from(array('cargos'));
while ($row = mysql_fetch_assoc($t)) {
print_r($row);
echo '<hr />';
}*/
/**
* 将当前系统的会员同步给UCenter
* 规则
* 1. 保证 easethink 中有的会员 ucenter 中必需存在，并同步密码
* 2. 重名会员以 easethink 中的会员资料为准，并将原ucenter中的会员资料记录到log中
* 3. ucenter中存在的会员。easethink中如不存在暂不处理。
*/
private function import_user()
{
if (file_exists(APP_ROOT_PATH . "public/uc_config.php")) {
require_once APP_ROOT_PATH . "public/uc_config.php";
$ucdb = new mysql_db(UC_DBHOST, UC_DBUSER, UC_DBPW, UC_DBNAME, UC_DBCHARSET);
$result = array('status' => 1, 'msg' => '');
/*$uc_user = $ucdb->getAll("select * from ".UC_DBTABLEPRE."members");
$et_user = $GLOBALS['db']->getAll("select * from ".DB_PREFIX."user");
print_r($uc_user);
print_r($et_user);
exit;*/
require_once APP_ROOT_PATH . "system/utils/logger.php";
$query = $GLOBALS['db']->query("SELECT * FROM " . DB_PREFIX . "user ORDER BY `id` ASC");
while ($data = $GLOBALS['db']->fetch_array($query)) {
if (UC_CHARSET != 'utf-8') {
$data['user_name'] = iconv("utf-8", UC_CHARSET, $data['user_name']);
$data['user_pwd'] = iconv("utf-8", UC_CHARSET, $data['user_pwd']);
$data['email'] = iconv("utf-8", UC_CHARSET, $data['email']);
}
$salt = rand(100000, 999999);
$password = md5($data['user_pwd'] . $salt);
$data['user_name'] = addslashes($data['user_name']);
$uc_userinfo = $ucdb->getRow("SELECT * FROM " . UC_DBTABLEPRE . "members WHERE `username`='" . $data['user_name'] . "'");
if (!$uc_userinfo) {
$ucdb->query("INSERT INTO " . UC_DBTABLEPRE . "members SET username='******'user_name'] . "', password='******', email='" . $data['email'] . "', regdate='" . $data['create_time'] . "', salt='{$salt}'", 'SILENT');
$integrate_id = intval($ucdb->insert_id());
$GLOBALS['db']->query("update " . DB_PREFIX . "user set integrate_id = " . $integrate_id . " where id = " . $data['id']);
} else {
//存在同名会员
//开始记录原系统同的同名数据
$data_str = implode("|", $data);
logger::record($data_str);
logger::save();
$GLOBALS['db']->query("update " . DB_PREFIX . "user set integrate_id = " . $uc_userinfo['uid'] . ",user_pwd = '' where id = " . $data['id']);
//清空原密码，等待同步登录时与ucenter同步
}
}
unset($query);
}
return $result;
}
</div>
<div id="maindiv_middle" class="maindiv_middle">
<div id="wordlist" class="officelist">
<span>OFFICE文件列表:</span>
<table class="tabletitle">
<tr><td width="25%">文 件 标 题</td><td width="30%">文 件 类 型</td><td width="20%">文 件 大 小</td><td width="25%">相 关 操 作</td></tr>
<?php
require 'connectionInfo.php';
//添加引用文件
mb_internal_encoding('utf-8');
// $query = 'select * from '.$officeFileInfoTableName.' order by filetype;'; //写入sql语句
$query = 'select * from ' . $officeFileInfoTableName;
//写入sql语句
/* Example */
//<!--读取数据库中的文件-->
$DB = new mysql_db();
//建立数据库辅助类
$DB->sql_connect($ip, $sqlname, $sqlpw, $dbname);
//建立一个新连接
$DB->query($query);
//执行sql
$rs = $DB->sql_result();
/* 处理结果集 */
while ($row = mysql_fetch_array($rs, MYSQL_BOTH)) {
// echo "<tr><td>{$row['id']}</td><td>{$row['filename']}</td><td>{$row['filetype']}</td><td>{$row['filesize']}</td><td><a href=\'javascript:showFileEditPage(\"FileEdit.php?FileId={{$row['id']}}\",900,800);\' > 编辑 </a></td></tr>";
echo '<tr><td>' . $row['filename'] . '</td><td>' . $row['filetype'] . '</td><td>' . $row['filesize'] . '</td><td><a href="javascript:showFileEditPage(\'FileEdit.php?FileId=' . $row['id'] . '\',900,800);">编辑</a></td></tr>';
}
?>
<tr><td> </td><td> </td><td> </td><td> </td></tr>
</table>
<table>
public function install($config_seralized)
{
$config = unserialize($config_seralized);
if ($config['IS_LATIN1'] == 2) {
$config['DB_CHARSET'] = 'latin1';
}
if (!@mysql_pconnect($config['DB_HOST'], $config['DB_USER'], $config['DB_PASS'])) {
$result['status'] = 0;
$result['msg'] = '无法连接数据库';
return $result;
} else {
$pwdb = new mysql_db($config['DB_HOST'], $config['DB_USER'], $config['DB_PASS'], $config['DB_NAME'], $config['DB_CHARSET']);
//开始将easethink的会员导入到pw中
$query = $GLOBALS['db']->query("SELECT * FROM " . DB_PREFIX . "user ORDER BY `id` ASC");
while ($data = $GLOBALS['db']->fetch_array($query)) {
$pw_userinfo = $pwdb->getRow("SELECT * FROM " . $config['PREFIX'] . "members WHERE `username`='" . $data['user_name'] . "'");
if (!$pw_userinfo) {
$pwdb->query("INSERT INTO " . $config['PREFIX'] . "members SET username='******'user_name'] . "', password='******'user_pwd'] . "', email='" . $data['email'] . "', regdate='" . $data['create_time'] . "'", 'SILENT');
$integrate_id = intval($pwdb->insert_id());
$GLOBALS['db']->query("update " . DB_PREFIX . "user set integrate_id = " . $integrate_id . " where id = " . $data['id']);
} else {
//存在同名会员
$data['user_name'] = $data['user_name'] . $config['SUFFIX'];
$pwdb->query("INSERT INTO " . $config['PREFIX'] . "members SET username='******'user_name'] . "', password='******'user_pwd'] . "', email='" . $data['email'] . "', regdate='" . $data['create_time'] . "'", 'SILENT');
$integrate_id = intval($pwdb->insert_id());
$GLOBALS['db']->query("update " . DB_PREFIX . "user set integrate_id = " . $integrate_id . " where id = " . $data['id']);
}
/* 更新memberdata表 */
$sql = 'INSERT INTO ' . $config['PREFIX'] . 'memberdata set uid = ' . $integrate_id;
$pwdb->query($sql, "SILENT");
}
unset($query);
$result['status'] = 1;
return $result;
}
}
function update_sys_config()
{
$filename = APP_ROOT_PATH . "public/sys_config.php";
if (!file_exists($filename)) {
//定义DB
require APP_ROOT_PATH . 'system/db/db.php';
$dbcfg = (require APP_ROOT_PATH . "public/db_config.php");
define('DB_PREFIX', $dbcfg['DB_PREFIX']);
if (!file_exists(APP_ROOT_PATH . 'public/runtime/app/db_caches/')) {
mkdir(APP_ROOT_PATH . 'public/runtime/app/db_caches/', 0777);
}
$pconnect = false;
$db = new mysql_db($dbcfg['DB_HOST'] . ":" . $dbcfg['DB_PORT'], $dbcfg['DB_USER'], $dbcfg['DB_PWD'], $dbcfg['DB_NAME'], 'utf8', $pconnect);
//end 定义DB
$sys_configs = $db->getAll("select * from " . DB_PREFIX . "conf");
$config_str = "<?php\n";
$config_str .= "return array(\n";
foreach ($sys_configs as $k => $v) {
$config_str .= "'" . $v['name'] . "'=>'" . addslashes($v['value']) . "',\n";
}
$config_str .= ");\n ?>";
file_put_contents($filename, $config_str);
$url = APP_ROOT . "/";
app_redirect($url);
}
}
<?php
require 'connectionInfo.php';
//实现方式不包括删除重复的文件，而是不让他们重名。
$uploaddir = $relativePdfFileUrl;
if (array_key_exists('uploadPdf', $_FILES)) {
if ($_FILES['uploadHtml']['size'] < 1024 * 1024 * 4) {
$mResult = 0;
$mSql = 'select max(id)+1 as MaxID from ' . $pdfFileInfoTableName . ';';
$DB = new mysql_db();
$DB->sql_connect($ip, $sqlname, $sqlpw, $dbname);
//建立一个新连接
$DB->query($mSql);
$rs = $DB->sql_result();
while ($row = mysql_fetch_array($rs, MYSQL_BOTH)) {
$mResult = $row['MaxID'];
if ($mResult == 0) {
$mResult = 1;
}
}
$uploadfile = $uploaddir . $mResult . '.' . $_FILES['uploadPdf']['name'];
if (is_uploaded_file($_FILES['uploadPdf']['tmp_name'])) {
$uploadfile1 = mb_convert_encoding($uploadfile, "GB2312", "UTF-8");
if (move_uploaded_file($_FILES['uploadPdf']['tmp_name'], $uploadfile1)) {
// print '大小为：（'.$_FILES['uploadPdf']['size'].')';
$pdfFileName = $_FILES['uploadPdf']['name'];
$pdffileSize = $_FILES['uploadPdf']['size'];
print "成功保存文件:" . $_FILES['uploadPdf']['name'] . ".大小:" . $_FILES['uploadPdf']['size'] . "字节<br>";
$SqlStr = 'insert into ' . $pdfFileInfoTableName . ' (id,pdffilename,pdffilepath,filesize)values(' . $mResult . ',"' . $pdfFileName . '","' . $uploadfile . '",' . $pdffileSize . ')';
// print $SqlStr;
$rs = $DB->query($SqlStr);
public function getMenu()
{
$conn = new mysql_db('localhost', 'sol_empleo', 'sol.empleo', 'sol_empleo');
return $conn->query_all('SELECT ' . 'menu.id, menu.leyenda ' . 'FROM ' . 'menu, perfil_menu, usuarios ' . 'WHERE ' . ' usuarios.id = ? and perfil_menu.perfil = usuarios.perfil and menu.id = perfil_menu.menu', array($this->id));
}
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<title>PHP Google Charts</title>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<link href="http://netdna.bootstrapcdn.com/twitter-bootstrap/2.2.2/css/bootstrap-combined.min.css" rel="stylesheet">
</head>
<body>
<h1>PHP Google Charts</h1>
<?php
require_once 'classes/classGRAPH.php';
require_once 'classes/classDB.php';
$hostname = "<host>:<port>";
$username = "******";
$password = "******";
$dbname = "<database>";
$objDB = new mysql_db();
$objDB->sql_connect($hostname, $username, $password, $dbname);
$ColumnChart = new Graph();
$ColumnChart->set_graphTitle("Hits Summary");
$ColumnChart->set_graphXLabel("Hour");
$ColumnChart->set_graphYLabel("Total Hits");
$ColumnChart->set_chartColumns(array("Hour", "Total Hits"));
$result = $objDB->query("select Hour(datetime) as hour, count(*) as hits from hits group by 1 order by 1 desc;");
$index = 0;
while ($line = $objDB->fetch_row($result)) {
$rows[$index][0] = $line['hour'];
$rows[$index][1] = $line['hits'];
$index++;
}
$ColumnChart->set_chartRows($rows);
$ColumnChart->set_chartGraph("ColumnChart");
public static function getDb($n)
{
if (!Model::$DB) {
$db = new mysql_db();
$db->sql_connect(ooxx::get('DB_HOST'), ooxx::get('DB_USER'), ooxx::get('DB_PWD'), ooxx::get('DB_NAME'));
Model::$DB = $db;
} else {
$db = Model::$DB;
}
$db->_sql = array();
$db->_sql['table'] = $n;
return $db;
}
$array1[0] = "treatise_name";
$array1[1] = "treatise_asort";
$array1[2] = "treatise_word_c";
$array1[3] = "treatise_write_c";
$array1[4] = "treatise_kind";
$array1[5] = "treatise_punit";
$array1[6] = "treatise_parea";
$array1[7] = "treatise_isbn";
$array1[8] = "treatise_ptime_y";
$array1[9] = "treatise_ptime_m";
$array1[10] = "treatise_remark";
$array1[11] = "treatise_book21";
$array1[12] = "treatise_book115";
$array1[13] = "treatise_book15";
$array1[14] = "treatise_lock";
$db = new mysql_db($hostname, $dbusername, $dbpassword, $dataname);
$db->db_connect();
$table = "sns_group_treatise";
$field = "id";
$value1 = $_POST['tid'];
$basic_user = $_POST['basic_user'];
$view = $_POST['view'];
$nums = 15;
$resu = $db->db_edit($table, $field, $value1, $array, $array1, $nums);
if ($resu) {
echo "<script language=javascript>\n";
echo "alert('数据成功审核')\n";
echo "location.assign('{$page}?basicuser={$basic_user}&view={$view}')\n";
echo "</script>\n";
exit;
} else {
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
#This code provided by:
#Andreas Hadiyono (andre.hadiyono@gmail.com)
#Gunadarma University
//define ("__DIR__","/srv/www/htdocs/core");
require_once __DIR__ . '/../config/config.php';
require_once __DIR__ . '/../utility/database/mysql_db.php';
require_once __DIR__ . '/../utility/utilityCode.php';
//Untuk Model
require_once __DIR__ . '/../model/modelUser.php';
//Akhir Model
$CONFIG = new config();
$DB = new mysql_db();
$UTILITY = new utilityCode();
$USER = new modelUser();
$id = $_POST['Login'];
//echo "ID=$id";
if (isset($id)) {
$user_name1 = $_POST['username'];
$user_pass1 = $UTILITY->sha512($_POST['password']);
$pass = $_POST['password'];
// echo "$user_pass1";
// exit;
if (!$user_pass1 || !$user_name1) {
$UTILITY->popup_message("Maaf anda harus login terlebih dahulu!");
$UTILITY->location_goto(".");
} else {
//$data = array("username" => "$user_name1", "status_user" => 1);
<?php
define('MYSQL_HOSTNAME', 'localhost');
define('MYSQL_USERNAME', 'root');
define('MYSQL_PASSWORD', 'Sycamore');
define('MYSQL_DATABASE', 'pawful');
require_once 'mysql_db.class.php';
$db = new mysql_db();
$db->connect(MYSQL_HOSTNAME, MYSQL_USERNAME, MYSQL_PASSWORD) or die(mysql_error());
$db->select_db(MYSQL_DATABASE) or die(mysql_error());
$db->set_magic_quotes_off();
?>
