/** * Renders the addon author ranking * * @return string */ public function getTopDevelopersWidgetMarker() { $top5 = $this->db->get_results("SELECT *, COUNT( provider_name ) AS counttotal FROM addon WHERE 1=1 " . $this->configuration['addonExcludeClause'] . " GROUP BY provider_name ORDER BY counttotal DESC LIMIT 9"); $counter = 0; $iconMap = array(1 => 'gold.png', 2 => 'silver.png', 3 => 'bronze.png'); if (is_array($top5) && count($top5)) { $developers = ''; foreach ($top5 as $top5s) { $author = cleanupAuthorName($top5s->provider_name); $counter++; $icon = 'images/' . (isset($iconMap[$counter]) ? $iconMap[$counter] : $counter . '.png'); $developers .= "<li><img src='{$icon}' height='20' width='20' alt='Rank {$counter}' /><a href='" . createLinkUrl('author', $author) . "' title='Show all addons from this author'> " . substr($author, 0, 15) . " ({$top5s->counttotal} uploads)</a></li>"; } return $this->makeWidget('Top developers', '<ul class="topDevelopers">' . $developers . '</ul>'); } return ''; }
function getUserData($secreatCode, $token, $device) { if (isset($secreatCode)) { global $dbhost; global $dbuser; global $dbpassword; global $db; $deviceId = isset($_POST['deviceId']) ? $_POST['deviceId'] : ''; $code = explode('_', $secreatCode); $userdb = new ezSQL_mysql($dbuser, $dbpassword, $code[0], $dbhost); $query = "SELECT * FROM `user_info` WHERE `uniqueCode`= '" . $secreatCode . "'"; $result = $userdb->get_results($query, ARRAY_A); if (!empty($result)) { if ($result[0]['deviceId'] == '' && $deviceId !== '') { $updateDeviceIdQuery = "UPDATE `user_info` SET `deviceId`= '" . $deviceId . "',`token`= '" . $token . "',`devicetype`= '" . $device . "' WHERE `uniqueCode`= '" . $secreatCode . "'"; $userdb->query($updateDeviceIdQuery); $query1 = "SELECT `contactno` FROM `admin_database_info` WHERE `admindatabase`= '{$code['0']}" . "'"; $result1 = $db->get_results($query1, ARRAY_A); unset($result[0]['password']); unset($result[0]['deviceId']); $data = $result[0]; $data['admin_contactNo'] = $result1[0]['contactno']; $data['admin_jid'] = $code[0]; $final['data'] = $data; $final['status'] = TRUE; echo json_encode($final); exit; } elseif ($result[0]['deviceId'] !== '' && $result[0]['deviceId'] == $deviceId) { $query1 = "SELECT `contactno` FROM `admin_database_info` WHERE `admindatabase`= '{$code['0']}" . "'"; $result1 = $db->get_results($query1, ARRAY_A); unset($result[0]['password']); unset($result[0]['deviceId']); $data = $result[0]; $data['admin_contactNo'] = $result1[0]['contactno']; $data['admin_jid'] = $code[0]; $final['data'] = $data; $final['status'] = TRUE; echo json_encode($final); exit; } elseif ($result[0]['deviceId'] !== '' && $result[0]['deviceId'] !== $deviceId) { $data['status'] = FALSE; $data['message'] = 'This account is already registered with another device'; echo json_encode($data); exit; } else { $data['status'] = FALSE; $data['message'] = 'device id not found'; echo json_encode($data); exit; } } else { $data['status'] = FALSE; $data['message'] = 'Secret code is invalid!'; echo json_encode($data); exit; } } }
} //发送信息 if ($flag == "sendMsg") { $sql = "INSERT INTO messageinfo(msgContent,msgSender,msgReceiver) VALUES('{$chatMsg}', '{$curuserid}', '{$receiverId}')"; $res = $db->query($sql); if ($res) { echo "ok"; } else { echo "fail"; } die; } //接受信息 if ($flag == "getunreadMsg") { $sql = "SELECT * FROM messageinfo,userinfo where msgReceiver='" . $curuserid . "' and msgState='unread' and userinfo.id=messageinfo.msgSender"; $res = $db->get_results($sql); if ($res) { echo json_encode($res); } else { echo "fail"; } die; } //将信息设为已读 if ($flag == "setRead") { $sql = "UPDATE messageinfo SET msgState='read' WHERE msgReceiver = '" . $curuserid . "' and msgSender='" . $setReadSenderid . "' "; $res = $db->query($sql); if ($res) { echo "ok"; } else { echo "fail";
Load up Libraries **/ include_once "../libs/ez_sql_core.php"; include_once "../libs/ez_sql_mysql.php"; include_once "../libs/myfunctions.php"; // MySQL Connection $mysql_server = $db_host . ":" . $db_port; // server details $db = new ezSQL_mysql($db_user, $db_pass, $db_name, $mysql_server); // Username , password , DB $debug = false; // no debug by default. // Table Checking... $my_tables = $db->get_results("SHOW TABLES LIKE '%user%'", ARRAY_N); // query db for user table if (!$my_tables) { // We have no tables, better create some.... /** TABLE DEF: id = unique user id tw_at = Twitter Access Token tw_sec = Twitter Secret Token tw_account = Array of account info we want/store from Twitter rs_wh = Rack Space Web Hook (Secret Token) rs_account = Array of account info we want/store from Rack Space **/
<?php // ezSQL require_once 'libs/ez_sql_core.php'; require_once 'libs/ez_sql_mysql.php'; // Zebra Pagination require_once 'libs/Zebra_Pagination.php'; $conn = new ezSQL_mysql('root', '', 'jvs_tutoriales'); $total_paises = $conn->get_var('SELECT count(*) FROM paises'); $resultados = 6; $paginacion = new Zebra_Pagination(); $paginacion->records($total_paises); $paginacion->records_per_page($resultados); // Quitar ceros en numeros con 1 digito en paginacion $paginacion->padding(false); $paises = $conn->get_results('SELECT * FROM paises LIMIT ' . ($paginacion->get_page() - 1) * $resultados . ', ' . $resultados); ?> <!DOCTYPE html> <html lang="es"> <head> <meta charset="utf-8"> <title>JV Software | Tutorial 14</title> <link rel="stylesheet" href="http://twitter.github.com/bootstrap/1.4.0/bootstrap.min.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script> <style> .mostrar-mas { text-align: center; background-color: #D9EDF7; border: 1px solid #BCE8F1; } .mostrar-mas a {
$db = new ezSQL_mysql('db_user', 'db_pass', 'db_name'); // Cache expiry $db->cache_timeout = 24; // Note: this is hours // Specify a cache dir. Path is taken from calling script $db->cache_dir = 'ezsql_cache'; // (1. You must create this dir. first!) // (2. Might need to do chmod 775) // Global override setting to turn disc caching off // (but not on) $db->use_disk_cache = true; // By wrapping up queries you can ensure that the default // is NOT to cache unless specified $db->cache_queries = true; // At last.. a query! $db->get_results("SHOW TABLES"); $db->debug(); // Select * from use $db->get_results("SELECT * FROM User"); $db->debug(); // This ensures only the above querys are cached $db->cache_queries = false; // This query is NOT cached $db->get_results("SELECT * FROM User LIMIT 0,1"); $db->debug(); /* Of course, if you want to cache EVERYTHING just do.. $db = new ezSQL_mysql('db_user', 'db_pass', 'db_name'); $db->use_disk_cache = true; $db->cache_queries = true; $db->cache_timeout = 24;
<th style="width: 5%;">Dirección</th> <th style="width: 5%;">Editar</th> <th style="width: 5%;">Eliminar</th> </tr> </thead> <tbody > <?php $conn = new ezSQL_mysql(DB_USER, DB_PASS, DB_NAME); $total_usuarios = $conn->get_var('SELECT count(*) FROM user'); $resultados = 10; $paginacion = new Zebra_Pagination(); $paginacion->records($total_usuarios); $paginacion->records_per_page($resultados); // Quitar ceros en numeros con 1 digito en paginacion $paginacion->padding(false); $usuarios = $conn->get_results('SELECT * FROM user LIMIT ' . ($paginacion->get_page() - 1) * $resultados . ', ' . $resultados); foreach ($usuarios as $users) { echo ' <tr > <td>' . $users->names . '</td> <td>' . $users->last_names . '</td> <td>' . $users->email . '</td> <td>' . $users->cel_phone . '</td> <td>' . $users->address . '</td> <td><a href="?view=usuario&mode=edit&id_user='******'" class="btn btn-success" data-toggle="modal" data-target="?view=usuario"><span class="glyphicon glyphicon-pencil"></span></a> </td> <td> <a href="#" class="btn btn-danger" onclick="DeleteItem(\'¿Está seguro de eliminar este usuario?\',\'?view=usuario&mode=delete&id_user='******'\')"><span class="glyphicon glyphicon-trash"></span></a> </td> </tr>'; } ?>
} else { if ($page == 2 or $page == 3) { if ($param_x == '0') { $page = 0; } } else { $page = 0; } } } // Cool, validated parameters exist, this doesn't mean they are truly valid however if ($page == 1) { // Start search query page $playername = $db->escape($param_x); $sql = "SELECT * FROM " . $config->my_war3source_table . " WHERE lower(concat(name)) like lower('%" . $playername . "%') LIMIT 20"; $result = $db->get_results($sql); $sql = "SELECT shortname,name FROM " . $config->my_war3sourceraces_table; $races = $db->get_results($sql); //$db->debug(); ?> <table class="players_table"> <a href="index.php"><p style="text-align:center">Back to War3 Stats Main Page</p></a> <br /> <tr class="player_row"> <td class="td_name">Name</td> <td class="td_steam">SteamID</td>
<?php include_once 'ez_sql_core.php'; include_once 'ez_sql_mysql.php'; $host = $_SERVER['SERVER_NAME']; $document_root = $_SERVER['DOCUMENT_ROOT']; $db = new ezSQL_mysql('root', '', 'mymasterstu', 'localhost'); $user_id = 3; $currentDate = "2015-10-16"; $online_users = array(); $results2 = $db->get_results('select at_id from admin where ad_id=' . $user_id . ''); if ($results2) { foreach ($results2 as $user2) { $at_id = $user2->at_id; //$online_users[]=$at_id; //echo "id=".$at_id; } } else { } $results = $db->get_results('select c.ucn_id,c.ucn_from,c.ucn_to from user_connections c where c.ucn_status=1 and ucn_from=' . $user_id . ' and "2015-10-15" in (select ucd_date from user_connection_dates where ucn_id=c.ucn_id and ucd_status=2)'); if ($results) { foreach ($results as $user) { $online_users[] = $user->ucn_id; //$online_users[]=$user->ucn_from; $online_users[] = $user->ucn_to; } } else { } $results1 = $db->get_results('select ad_id from admin where ad_id in( select distinct(ucn_to) from user_connections where ucn_from=' . $user_id . ' and ucn_status=1 ) and at_id=' . $at_id . ''); if ($results1) { foreach ($results1 as $user1) {
<?php include_once 'lib/ez_sql_core.php'; include_once 'lib/ez_sql_mysql.php'; $db = new ezSQL_mysql('root', '', 'jvs_tutoriales', 'localhost'); $productos = $db->get_results("SELECT * FROM products WHERE productName LIKE '%" . $_POST['query'] . "%'"); echo json_encode($productos);
require_once "_CmsDevCore/Admin_Glosary.php"; require_once "_CmsDevCore/SQL/shared/ez_sql_core.php"; // (MYSQL CONNECT)//////////////////////////////////////////////////////////////////////////////////// require_once "_CmsDevCore/SQL/mysql/ez_sql_mysql.php"; $SKTDB = new ezSQL_mysql(DB_USER, DB_PASSWORD, DB_NAME, DB_SERVER); $HTTP = "http://" . $_SERVER['HTTP_HOST']; $subSite = ''; $Language = 'esp'; $SitemapGenerator = array(); $SitemapGenerator['Wrap_Before'] = "\t\n"; $SitemapGenerator['Wrap_After'] = "\t\n"; $SitemapGenerator['set_Item_Template_Before'] = "<url><loc>" . $HTTP . $subSite . "/[URL]</loc><changefreq>weekly</changefreq></url>"; $SitemapGenerator['set_Item_Template_After'] = "\t\n"; $ShowHidden = " RecycleBin = '0' AND"; // Select all entries from the menu table $result = $SKTDB->get_results("SELECT ID,Title,Description,URLName,SID,Position\r\n\t\t\t\t\t\t FROM " . DB_PREFIX . "sections\r\n\t\t\t\t\t\t WHERE " . $ShowHidden . " Language = '" . $Language . "' \r\n\t\t\t\t\t\t ORDER BY SID, Position, Title", ARRAY_A); if ($result) { // Create a multidimensional array to conatin a list of items and parents $menu = array('items' => array(), 'parents' => array()); // Builds the array lists with data from the menu table foreach ($result as $items) { // Creates entry into items array with current menu item id ie. $menu['items'][1] $menu['items'][$items['ID']] = $items; // Creates entry into parents array. Parents array contains a list of all items with children $menu['parents'][$items['SID']][] = $items['ID']; } // Menu builder function, parentId 0 is the root function class_SitemapGenerator($parent, $menu, $URLNameParent) { global $SitemapGenerator; global $subSite;
$msgContent = isset($_POST["msgContent"]) ? $_POST["msgContent"] : ""; $db_msg = new ezSQL_mysql(); //验证Session信息 if ($flag == "checkSession") { $sessionid = isset($_SESSION["userid"]) ? $_SESSION["userid"] : ""; if ($sessionid == "") { echo "outline"; } else { echo "{$sessionid}"; } die; } //检测是否发来“系统消息” if ($flag == "checkSysmsg") { $sql = "select * from messageinfo where msgReceiveId = " . $userId . " and readFlag = 'unread' and msgContent like 'msg_%|%'"; $result = $db_msg->get_results($sql); if ($result) { echo json_encode($result); die; } else { die; } } //将处理过的“系统消息”改为已读 if ($flag == "hasreadSysmsg") { if ($msgFlag != "msg_talk") { $sql = "update messageinfo set readFlag = 'hasread' where id = " . $msgId . ""; $result = $db_msg->query($sql); if ($result) { echo "success"; } else {
$SKTDB = new ezSQL_mysql(DB_USER, DB_PASSWORD, DB_NAME); // Cache expiry $SKTDB->cache_timeout = 24; // Note: this is hours // Specify a cache dir. Path is taken from calling script $SKTDB->cache_dir = 'ezsql_cache'; // (1. You must create this dir. first!) // (2. Might need to do chmod 775) // Global override setting to turn disc caching off // (but not on) $SKTDB->use_disk_cache = true; // By wrapping up queries you can ensure that the default // is NOT to cache unless specified $SKTDB->cache_queries = true; // At last.. a query! $SKTDB->get_results("SHOW TABLES"); $SKTDB->debug(); // Select * from use $SKTDB->get_results("SELECT * FROM v1_content"); $SKTDB->debug(); // This ensures only the above querys are cached $SKTDB->cache_queries = false; // This query is NOT cached $SKTDB->get_results("SELECT * FROM v1_content LIMIT 0,1"); $SKTDB->debug(); /* Of course, if you want to cache EVERYTHING just do.. $SKTDB = new ezSQL_mysql('db_user', 'db_pass', 'db_name'); $SKTDB->use_disk_cache = true;
<th style="width: 25%;">Descripción</th> <th style="width: 5%;">Editar</th> <th style="width: 5%;">Eliminar</th> </tr> </thead> <tbody > <?php $conn = new ezSQL_mysql(DB_USER, DB_PASS, DB_NAME); $total_cursos = $conn->get_var('SELECT count(*) FROM cursos'); $resultados = 10; $paginacion = new Zebra_Pagination(); $paginacion->records($total_cursos); $paginacion->records_per_page($resultados); // Quitar ceros en numeros con 1 digito en paginacion $paginacion->padding(false); $lista_cursos = $conn->get_results('SELECT * FROM cursos LIMIT ' . ($paginacion->get_page() - 1) * $resultados . ', ' . $resultados); foreach ($lista_cursos as $cursos) { echo '<tr > <td>' . $cursos->ficha . '</td> <td>' . $cursos->nombre . '</td> <td>' . $cursos->descripcion . '</td> <td><a href="?view=cursos&mode=edit&id_curso=' . $cursos->id_curso . '" class="btn btn-success"><span class="glyphicon glyphicon-pencil"></span></a> </td> <td> <a href="#" class="btn btn-danger" onclick="DeleteItem(\'¿Está seguro de eliminar este usuario?\',\'?view=cursos&mode=delete&id_curso=' . $cursos->id_curso . '\')"><span class="glyphicon glyphicon-trash"></span></a> </td> </tr>'; } ?>
// David Martín :: Suki_ :: <david at sukiweb dot net>. // GNU GENERAL PUBLIC LICENSE require "config.php"; include_once "inc/ez_sql_core.php"; include_once "inc/ez_sql_mysql.php"; require "inc/functions.php"; require "inc/plugfunctions.php"; require "inc/check_behind_proxy.php"; require "inc/l10n.php"; $db = new ezSQL_mysql($config['db_user'], $config['db_password'], $config['db_database'], $config['db_server']); load_default_textdomain(); session_start(); if ($_GET["login"] == "logout") { logea("logout", "LOGOUT", $_SESSION["usuario"]); $SELECT = "SELECT * FROM usuarios " . "WHERE usuario_login='******'usuario'] . "' " . "AND usuario_id='" . $_SESSION['usuario_id'] . "'"; $result = $db->get_results($SELECT); $strCookie = base64_encode(join(':', array($result[0]->usuario_login, md5($config['domain'] . $result[0]->usuario_login . $result[0]->usuario_id . $result[0]->usuario_email)))); setcookie("bolsaPHP", $strCookie, time() - 3600); unset($_SESSION['usuario']); unset($_SESSION['nombre']); unset($_SESSION['email']); unset($_SESSION['url']); unset($_SESSION['usuario_id']); header("Cache-Control: no-cache, must-revalidate"); header("Location: index.php"); header("Expires: " . gmdate("r", time() - 3600)); header("ETag: \"logingout" . time() . "\""); die; } else { if ($_POST[login] && $_POST[password]) { $SELECT = "SELECT * FROM usuarios " . "WHERE usuario_login='******' " . "AND usuario_password='******'";
public function getRecentSession() { global $db; global $dbhost; global $dbpassword; global $dbuser; $adminemail = $admin = $_SESSION['admin_login']; $getDbName = "select `admindatabase` from `admin_database_info` WHERE `email` = '" . $adminemail . "' AND `is_active`=1"; $daName = $db->get_col($getDbName); $dbUser = new ezSQL_mysql($dbuser, $dbpassword, $daName[0], $dbhost); $count = "SELECT user_session_details.email,user_session_details.id,user_session_details.grcid,user_info.name,user_info.company FROM `user_session_details` INNER JOIN `user_info` ON user_session_details.grcid = user_info.uniqueCode ORDER BY id DESC"; $result = $dbUser->get_results($count, ARRAY_A); return $result; }
<?php require_once '../../app/Mage.php'; Mage::app('default'); include_once "../shared/ez_sql_core.php"; include_once "ez_sql_mysql.php"; $db = new ezSQL_mysql('nightingaleuser', 'elagnithgin', 'nightingale', 'localhost'); $authors = $db->get_results("SELECT * FROM Authors"); foreach ($authors as $author) { $category = Mage::getModel('catalog/category'); $category->setStoreId(0); //default/all $subcategory['entity_id'] = 10000 + (int) $author->Author_ID; $subcategory['name'] = $author->Name; $subcategory['path'] = "1/4"; $subcategory['description'] = $author->Bio; $subcategory['meta_title'] = ""; $subcategory['meta_keywords'] = $author->Meta_Keywords; $subcategory['meta_description'] = $author->Meta_Description; $subcategory['image'] = $author->Image_Thumbnail; $subcategory['landing_page'] = ""; $subcategory['display_mode'] = "PRODUCTS"; $subcategory['is_active'] = 1; $subcategory['is_anchor'] = 1; $subcategory['url_key'] = ""; $category->addData($subcategory); try { $category->save(); echo "<p><strong>" . $category->getName() . " (" . $category->getId() . ")</strong> - Category Added</p>"; } catch (Exception $e) { echo $e->getMessage() . 'Cat: ';
include_once 'lib/ez_sql_mysql.php'; // db_user / db_password / db_name / db_host $db = new ezSQL_mysql('root', 'root', $argv[3], 'localhost'); // [ // { // name, // children: [ // { player }, // { ... } // ] // }, // { ... } // ] $output = array(); // Get all teams $teams = $db->get_results("\n SELECT team\n FROM salaries\n GROUP BY team\n"); foreach ($teams as $team) { if (!is_null($team->team)) { $players = $db->get_results("\n SELECT statistics.*,\n salaries.salary\n FROM statistics\n LEFT JOIN salaries\n ON statistics.player = salaries.player\n WHERE statistics.team = '{$team->team}'\n ORDER BY statistics.team\n "); if (!is_null($players)) { $foo = new stdClass(); $foo->name = $team->team; $foo->children = $players; $output[] = $foo; } } } $filename = "data.{$argv['1']}-{$argv['2']}.json"; $path = dirname(dirname(dirname(__FILE__))) . '/app/data/' . $filename; $file = file_put_contents($path, json_encode($output)); if ($file) {
} $smarty->assign('name', $conf['title']); $smarty->assign("userId", $userId); $smarty->assign("userData", $userData); $smarty->assign("userName", $startUp->session_username); $smarty->assign("Admin", $isAdmin); $smarty->assign('userUpload', $userData->upload); $smarty->assign('userDownload', $userData->download); if (!isset($_GET["catid"])) { $_GET["catid"] = 'NULL'; } $cat_id = $_GET["catid"]; $smarty->assign('getCategoriescollapsed', $startUp->Categories('getlistcollapsed', $cat_id)); $smarty->assign('setError', 'false'); $sql = "SELECT filename FROM plugins WHERE action = '" . $db->escape(1) . "'"; $items = $db->get_results($sql, ARRAY_A); if ($items) { foreach ($items as $result_rows) { $plugins[] = $result_rows['filename']; } } else { $plugins = ''; } $hook->active_plugins = $plugins; $hook->set_hooks(array('install', 'action', 'home_page', 'new_page', 'upload_page', 'torrents_page', 'detail_page', 'registration_page', 'login_page', 'account_page', 'edit_account_page', 'user_page', 'admin_action', 'new_admin_page', 'admin_settings_page')); $hook->load_plugins(); function add_hook($tag, $function, $priority = 10) { global $hook; $hook->add_hook($tag, $function, $priority); }
<ul class="memberTab"> <li class="memberTabLi selectmemberTabLi">好友</li> <li class="memberTabLi">群</li> <li class="memberTabLi">讨论组</li> </ul> <ul class="memberTabNew"> <li class="memberTNBox selectmemTNBox"> <ul class="memberTNBU"> <li class="memberTNBULiGroup"> <?php $sqlN = "SELECT * FROM userinfo,friendsinfo WHERE userinfo.id=friendsinfo.friendid and friendsinfo.userid=" . $_SESSION["userID"]; $onlineHtml = ""; $offlineHtml = ""; $allCount = 0; $onlineCount = 0; $resN = $db->get_results($sqlN); foreach ($resN as $friend) { //在线 if ($friend->userState == "online") { $onlineHtml .= "<li class='listItem Ltq Ltqq" . $friend->friendid . "' showchatPanel='false' isshow='false'>"; $onlineHtml .= "<a href='#' class='avatar'>"; $onlineHtml .= "<img src=" . $friend->userHeadImage . ">"; $onlineHtml .= "</a>"; $onlineHtml .= "<p class='memberNick'>" . $friend->friendNoteName . "</p>"; $onlineHtml .= "<p class='memberMsg'>宇</p>"; $onlineHtml .= "</li>"; $onlineCount++; $allCount++; } elseif ($friend->userState == "offline") { //离线 $offlineHtml .= "<li class='listItem Ltq Ltqq" . $friend->friendid . "' showchatPanel='false' isshow='false'>";
/********************************************************************** * ezSQL initialisation for mySQL */ // Include ezSQL core include_once "../shared/ez_sql_core.php"; // Include ezSQL database specific component include_once "ez_sql_mysql.php"; // Initialise database object and establish a connection // at the same time - db_user / db_password / db_name / db_host $db = new ezSQL_mysql('db_user', 'db_password', 'db_name', 'db_host'); /********************************************************************** * ezSQL demo for mySQL database */ // Demo of getting a single variable from the db // (and using abstracted function sysdate) $current_time = $db->get_var("SELECT " . $db->sysdate()); print "ezSQL demo for mySQL database run @ {$current_time}"; // Print out last query and results.. $db->debug(); // Get list of tables from current database.. $my_tables = $db->get_results("SHOW TABLES", ARRAY_N); // Print out last query and results.. $db->debug(); // Loop through each row of results.. foreach ($my_tables as $table) { // Get results of DESC table.. $db->get_results("DESC {$table['0']}"); // Print out last query and results.. $db->debug(); }
"> <?php $db = new ezSQL_mysql(); $res = $db->get_row("select * from userinfo where id={$curid}"); $MyHeadImage = $res->userHeadImage; $myshuoshuo = $res->myShuoshuo; echo "\n \t\t\t\t<div class='MyHeadImage'><img src='{$MyHeadImage}' curHeadImageUrl='" . $MyHeadImage . "' class='headImg' /></div>\n \t\t\t <div class='mYXinxi'>\n \t\t\t\t\t <p class='nicheng'>" . $curnicheng . "</p>\n <div class='xinxiA'> \n <span class='qianming'>" . $myshuoshuo . "</span>\n <i class='xiugai'>修改</i>\n </div>\n \t\t\t\t</div>\n \t\t\t"; ?> </ul> <ul id="friendslist"> <ul id="onlinefriendslist"> <?php // echo $curid; $db = new ezSQL_mysql(); $res = $db->get_results("select userinfo.id,userinfo.userNickname,userinfo.userHeadImage,friendsinfo.friendNoteName,friendsinfo.friendid, friendsinfo.friendShuoshuo,userinfo.userState from userinfo,friendsinfo where userinfo.id=friendsinfo.friendid and friendsinfo.userid={$curid} "); $onlineHtml = ""; $offlineHtml = ""; if ($res) { // echo "<script>alert('d')</script>"; foreach ($res as $friend) { $curid = $friend->friendid; $curHeadImageUrl = $friend->userHeadImage; $curuserState = $friend->userState; $curfriNickname = $friend->friendNoteName; $curfrishuoshuo = $friend->friendShuoshuo; if ($curuserState == "online") { $onlineHtml .= "<li id='friendlitalk{$curid}' talkid='{$curid}' talkname='{$curfriNickname}' class='friendli' isshow='no' isappear='no' friendImg='" . $curHeadImageUrl . "'>\n \t\t\t\t\t\t\t\t\t\t\t\t\t<img src='{$curHeadImageUrl}' class='friHeadImge' />\n \t\t\t\t\t\t\t\t\t\t\t\t\t<div class='Friendxinxi'>\n <div class='FriendXX'>\n <span class='nicheng'>" . $curfriNickname . "</span>\n <span class='friendstate'>[ " . $curuserState . " ]</span>\n </div>\n \t\t\t\t\t\t\t\t\t\t \t\t\t\t<p class='qianming'>" . $curfrishuoshuo . "</p>\n \t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n \t\t\t\t\t\t\t\t \t\t </li>"; } else { $offlineHtml .= "<li id='friendlitalk{$curid}' talkid='{$curid}' talkname='{$curfriNickname}' class='friendli' isshow='no' isappear='no' friendImg='" . $curHeadImageUrl . "'>\n \t\t\t\t\t\t\t\t\t\t\t\t\t<img src='{$curHeadImageUrl}' class='friHeadImge offlinePic' />\n \t\t\t\t\t\t\t\t\t\t\t\t\t<div class='Friendxinxi'>\n \t\t\t\t\t\t\t\t\t\t \t\t\t\t<div class='FriendXX'>\n <span class='nicheng'>" . $curfriNickname . "</span>\n <span class='friendstate'>[ " . $curuserState . " ]</span>\n </div>\n \t\t\t\t\t\t\t\t\t\t \t\t\t\t <p class='qianming'>" . $curfrishuoshuo . "</p>\n \t\t\t\t\t\t\t\t\t\t\t\t\t</div>\n \t\t\t\t\t\t\t\t\t\t\t\t</li>"; }