¶à·þÎñÆ÷¹²Ïísession(mysql)
<?php
/* vim: set expandtab tabstop=4 shiftwidth=4 foldmethod=marker: */
//===========================================
// ³ÌÐò£º mysql-Based Session Class
// ¹¦ÄÜ£º »ùÓÚmysql´æ´¢µÄ Session ¹¦ÄÜÀà
// ×÷Õß: yejr
// ÍøÕ¾: http://imysql.cn
// ʱ¼ä: 2007-01-05
//===========================================
/**
* ˈ̞: MySQL Session Class
* ¹¦ÄÜ: ×ÔÖ÷ʵÏÖ»ùÓÚMySQL HEAP±í´æ´¢µÄ Session ¹¦ÄÜ
* ÃèÊö: Õâ¸öÀà¾ÍÊÇʵÏÖSessionµÄ¹¦ÄÜ£¬»ù±¾ÉÏÊÇͨ¹ýÉèÖÿͻ§¶ËµÄCookieÀ´±£´æSessionID£¬
* È»ºó°ÑÓû§µÄÊý¾Ý±£´æÔÚ·þÎñÆ÷¶Ë£¬×îºóͨ¹ýCookieÖеÄSession IdÀ´È·¶¨Ò»¸öÊý¾ÝÊÇ·ñÊÇÓû§µÄ£¬
* È»ºó½øÐÐÏàÓ¦µÄÊý¾Ý²Ù×÷
*
* ×¢Òâ: ±¾Ààµ÷ÓÃÁËPEAR::DBÀà,Èç¹ûÓÐ×Ô¼ºµÄDBÀà,Ôò¿ÉÒÔÉÔ΢ÐÞ¸ÄһϴúÂë
*
* ±¸×¢£ºÊý¾Ý±í³õʼ»¯SQLÓï¾ä:
* CREATE TABLE `sessions` (
* `sid` varchar(32) NOT NULL default '',
* `session` longtext,
* `flush_dt` int unsigned NOT NULL default '0',
* PRIMARY KEY (`sid`),
* KEY `last` (`flush_dt`)
* ) ENGINE=HEAP;
*/
//É趨 SESSION ÓÐЧʱ¼ä£¬µ¥Î»ÊÇ Ãë
define('SESS_LIFTTIME', 3600);
define('DB_DSN', 'mysql://root:@localhost/test');
define('DB_NAME','test');
require_once('DB.php');
$gDb = new DB;
$gDb = DB::connect(DB_DSN, TRUE);
if (PEAR::isError($gDb))
{
die($gDb->getMessage());
}
if (!defined('MySQLSession'))
{
define('MySQLSession', TRUE);
class Usess
{
static $mSessSavePath;
static $mSessName;
static $mSessMaxTime;
static $mTblSess = 'sessions';
static $mTblSessMap;
static $mDb;
// {{{ ³õʼ»¯¹¹Ô캯Êý
/**
* ¹¹Ô캯Êý
*
* @param string $login_user µÇ¼Óû§
* @param int $login_type Óû§ÀàÐÍ
* @param string $login_sess µÇ¼SessionÖµ
* @return Esession
Ïà¹ØÎĵµ£º
mysql ´´½¨±í£º
mysql> create table user(
-> userid int(4) primary key not null auto_increment,
-> username varchar(16) not null,
-> userpassword varchar(32) not null
-> );
create table log(
logid int(4) ......
1
Ë÷ÒýµÄÒâÒ壺
Óŵ㣺
Ë÷ÒýÓÃÀ´¿ìËÙµØÑ°ÕÒÄÇЩ¾ßÓÐÌض¨ÖµµÄ¼Ç¼£¬Èç¹ûûÓÐË÷Òý£¬Ö´Ðвéѯʱ±ØÐë´ÓµÚÒ»¸ö¼Ç¼¿ªÊ¼É¨Ãè±íÖÐËùÓмǼ£¬±íÀïÃæµÄ¼Ç¼ÊýÁ¿Ô½¶à£¬Õâ¸ö²Ù×÷µÄ´ú¼Û¾ÍÔ½¸ß¡£
ȱµã£º
Ë÷ÒýÒªÕ¼ÓôÅÅ̿ռ䣻ÇÒÈκÎд²Ù×÷Éæ¼°µÄË÷Òý¸öÊý¶àµÄ»°»áÒýÆð½µËÙ£¬ÒòΪ
MySQL
²»½öÒª°Ñ¸Ä¶¯Êý¾ ......
1¡¢Ìá½»±íµ¥JavascriptÑéÖ¤
<form action="" method="post" name="myform" onsubmit="return CheckPost();">
SCRIPT language=javascript>
function CheckPost()
{
if (myform.user.value=="")
{
alert("ÇëÌîдÓû§");
myform.user.focus();
return f ......
·Ç³£³£Óõģº¾µäµÄMYSQLÓï¾ä…… php¿ªÔ´
ÕâÕæÊÇÒ»¸öºÃ¶«Î÷£ºÑ§Ï°ºÃÁ˺ÜÊÜÓõÄŶ……
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)php¿ªÔ´
Ê×ÏÈ,¼òÒ ......