<?php session_start(); require_once 'libs/ez_sql_core.php'; require_once 'libs/ez_sql_mysql.php'; $conn = new ezSQL_mysql('root', '', 'jvs_tutoriales'); $usuario = $conn->get_row("SELECT id_usuario, nombre, apellido FROM usuarios WHERE login = '******'login'] . "' AND password = '******'pwd']) . "'"); if ($usuario) { $_SESSION['usuario_logeado'] = $usuario; echo json_encode($usuario); } else { echo json_encode(array('error' => true)); }
<title>web chat</title> <link rel="stylesheet" type="text/css" href="login.css"> <script type="text/javascript" src="js/jquery-1.9.1.min.js"></script> <script type="text/javascript" src="js/jquery-ui.min.js"></script> <script type="text/javascript" src="js/index.js"></script> </head> <body> <div id="left"> <a href="login.php?logout=yes">return</a> <ul id="Myinfo" curuserid="<?php echo $curid; ?> "> <?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) {
session_start(); $curuserid = isset($_SESSION["curuserid"]) ? $_SESSION["curuserid"] : ""; $curusername = isset($_SESSION["curusername"]) ? $_SESSION["curusername"] : ""; $flag = isset($_POST["flag"]) ? $_POST["flag"] : ""; $chatMsg = isset($_POST["chatMsg"]) ? $_POST["chatMsg"] : ""; $chatMsg = str_replace("'", "\\'", $chatMsg); $receiverId = isset($_POST["receiverId"]) ? $_POST["receiverId"] : ""; $setReadSenderid = isset($_POST["setReadSenderid"]) ? $_POST["setReadSenderid"] : ""; $userid = isset($_POST["userid"]) ? $_POST["userid"] : ""; $userpwd = isset($_POST["userpwd"]) ? $_POST["userpwd"] : ""; //验证登录 if ($flag == "checkUser") { if ($userid != "" && $userpwd != "") { $db = new ezSQL_mysql(); $sql = "select * from userinfo where id='" . $userid . "' and userpwd='" . $userpwd . "'"; $res = $db->get_row($sql); if (!$res) { echo "fail"; } else { //echo "success"; $_SESSION["curuserid"] = $userid; $_SESSION["curusername"] = $res->userNickname; $changeloginsql = "UPDATE userinfo SET userState = '在线' WHERE id = '" . $userid . "'"; $db->query($changeloginsql); header("location:../index.php?username="******"sendMsg") {
$result["room"] = $room; $result["value"] = $value; $codes = array(); for ($i = 0; $i < $amount; $i++) { $code = genCode(); $var = $db->get_var("SELECT count(*) FROM goldcode where code='{$code}'"); if (0 == $var) { $codes[$i] = $code; $db->query("INSERT INTO goldcode (code,value,game,room) VALUES ('{$code}','{$value}','{$game}','{$room}')"); } else { $i--; } } $result["codes"] = $codes; } else { if ($act = "usecode") { $row = $db->get_row("SELECT `code`,`value` FROM goldcode where " . " `code`='{$code}' and `valid`=1 and `game`='{$game}' and `room`='{$room}'"); if (null != $row) { $result["ret"] = "0"; $result["game"] = $game; $result["room"] = $room; $result["value"] = $row["value"]; $db->query("UPDATE goldcode set `user` ='{$user}',`usetime`='',`valid`=0 WHERE `code`='{$code}'"); } else { $result['ret'] = "2"; $result['msg'] = "兑换码不正确,或已使用"; } } else { } } echo json_encode($result);
<?php define('DB_USER', ''); define('DB_PASSWORD', ''); define('DB_NAME', ''); define('DB_HOST', 'localhost'); define('PLAYERS_TABLE', 'sauer_players'); require_once 'ez_sql_core.php'; require_once 'ez_sql_mysql.php'; $db = new ezSQL_mysql(DB_USER, DB_PASSWORD, DB_NAME, DB_HOST); $name = $db->escape($_GET['name']); $ip = $db->escape($_GET['ip']); $row = $db->get_row("SELECT * FROM `" . PLAYERS_TABLE . "` WHERE `name` = '{$name}' AND `ip` = '{$ip}'"); if ($row) { $db->query("UPDATE `" . PLAYERS_TABLE . "` SET `last_connect` = NOW(), `connects` = '" . ($row->connects + 1) . "' WHERE `id` = '{$row->id}'"); } else { $db->query("INSERT INTO `" . PLAYERS_TABLE . "` (`name`, `ip`, `first_connect`, `last_connect`, `connects`) VALUES('{$name}', '{$ip}', NOW(), NOW(), 1)"); } echo "Done.";
function class_SitemapGenerator($parent, $menu, $URLNameParent) { global $SitemapGenerator; global $subSite; global $Language; $html = ""; $set_Item_Template_Before = $SitemapGenerator['set_Item_Template_Before']; $set_Item_Template_After = $SitemapGenerator['set_Item_Template_After']; $PrefixURL = $subSite . $Language . '/'; require_once "db.php"; require_once "_CmsDevCore/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); if (isset($menu['parents'][$parent])) { $html .= $SitemapGenerator['Wrap_Before']; foreach ($menu['parents'][$parent] as $itemId) { if (!isset($menu['parents'][$itemId])) { $Thisitem = $set_Item_Template_Before; //$Thisitem = str_replace('[URL]',$PrefixURL.$menu['items'][$itemId]['URLName'],$Thisitem); $PSID1 = $menu['items'][$itemId]['SID']; if (isset($PSID1) && $PSID1 != '') { $ParentURLThisProd = $PSID1 . '/' . $menu['items'][$itemId]['URLName']; $PSID2 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID1}'"); if (isset($PSID2->SID) && $PSID2->SID != '') { $ParentURLThisProd = $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName']; $PSID3 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID2->SID}'"); if (isset($PSID3->SID) && $PSID3->SID != '') { $ParentURLThisProd = $PSID3->URLName . '/' . $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName']; $PSID4 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID3->SID}'"); if (isset($PSID4->SID) && $PSID4->SID != '') { $ParentURLThisProd = $PSID4->URLName . '/' . $PSID3->URLName . '/' . $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName']; } } } } $ParentURLThisProd = str_replace('//', '/', $ParentURLThisProd); $Thisitem = str_replace('[URL]', $PrefixURL . $ParentURLThisProd, $Thisitem); $html .= $Thisitem . $set_Item_Template_After . " "; $html = str_replace('Portada/', '', $html); } if (isset($menu['parents'][$itemId])) { $Thisitem = $set_Item_Template_Before; //$Thisitem = str_replace('[URL]',$PrefixURL.$menu['items'][$itemId]['URLName'],$Thisitem); $PSID1 = $menu['items'][$itemId]['SID']; if (isset($PSID1) && $PSID1 != '') { $ParentURLThisProd = $PSID1 . '/' . $menu['items'][$itemId]['URLName']; $PSID2 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID1}'"); if (isset($PSID2->SID) && $PSID2->SID != '') { $ParentURLThisProd = $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName']; $PSID3 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID2->SID}'"); if (isset($PSID3->SID) && $PSID3->SID != '') { $ParentURLThisProd = $PSID3->URLName . '/' . $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName']; $PSID4 = $SKTDB->get_row("SELECT SID, URLName FROM " . DB_PREFIX . "sections WHERE ID = '{$PSID3->SID}'"); if (isset($PSID4->SID) && $PSID4->SID != '') { $ParentURLThisProd = $PSID4->URLName . '/' . $PSID3->URLName . '/' . $PSID2->URLName . '/' . $PSID1->URLName . '/' . $menu['items'][$itemId]['URLName']; } } } } $ParentURLThisProd = str_replace('//', '/', $ParentURLThisProd); $Thisitem = str_replace('[URL]', $PrefixURL . $ParentURLThisProd, $Thisitem); $html .= $Thisitem . " "; $html .= class_SitemapGenerator($itemId, $menu, $menu['items'][$itemId]['URLName'] . '/'); $html .= $set_Item_Template_After . " "; $html = str_replace('Portada/', '', $html); } } $html .= $SitemapGenerator['Wrap_After'] . ""; } return $html; }
if ($flag == "hasreadSysmsgtalk") { //将msg_talk|XXX 改为hasread|msg_talk|XXX $sql = "update messageinfo set msgContent = concat('hasread|',msgContent) "; $sql .= "where msgSendId = " . $msgSendId . " and msgReceiveId =" . $msgReceiveId . " "; $sql .= "and readFlag = 'unread' and msgContent like 'msg_talk|%'"; $result = $db_msg->query($sql); if ($result) { echo "success"; } else { echo "fail"; } } //验证登陆信息 if ($flag == "checkUser") { $sql = "select * from userInfo where userId = " . $userId . " and userPwd = '" . $userpwd . "'"; $result = $db_msg->get_row($sql); if (!$result) { echo "fail"; } else { $_SESSION["userid"] = $result->userId; $_SESSION["username"] = $result->userName; $_SESSION["userheadimg"] = $result->userHeadImg; $_SESSION["usershuo"] = $result->userShuo; echo "success"; } die; } //清空SESSION if ($flag == "clearSession") { $_SESSION["userid"] = ""; unset($_SESSION["username"]);
<?php require_once 'lib/ez_sql_core.php'; require_once 'lib/ez_sql_mysql.php'; $db = new ezSQL_mysql('root', '', 'jvs_tutoriales'); $lista = $db->get_row("SELECT * FROM opciones WHERE id_opcion = '1'"); ?> <!DOCTYPE html> <html lang="es"> <head> <meta charset="UTF-8"> <link href="css/style.css" rel="stylesheet"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.8.13/jquery-ui.min.js"></script> <script> $(function(){ $('#lista').sortable({ placeholder: 'placeholder', update: function() { $.post('ajax.php', $(this).sortable('serialize')); } }); }); </script> <title>JV Software | Tutorial 10</title> </head> <body> <ul id="lista"> <?php if (!$lista->menu) { ?>