Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¶à·þÎñÆ÷¹²Ïí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º¯Êý¸üÐÂmemcached

Memcached Functions for MYSQL¹Ù·½Ö÷Ò³£º
https://launchpad.net/memcached-udfs
Á½Æª»ù±¾ÎÄÕ£º
http://www.libing.name/2009/02/06/mysql-map-data-to-memcached.html
http://www.libing.name/2008/02/26/mysql-map-memcached.html
°²×°ºÍÑéÖ¤µÄSQLÓï¾ä£º
http://hg.tangent.org/memcached_functions_mysql/file/7 ......

phpѧϰ±Ê¼Ç£¨12£©:PHP+MYSQLÁôÑ԰壨ÉÏ

require()  Óë  require_once()
    
      ͨ³£·ÅÔÚ PHP ³ÌÐòµÄ×îÇ°Ãæ£¬PHP ³ÌÐòÔÚÖ´ÐÐǰ£¬¾Í»áÏȶÁÈë require
ËùÖ¸¶¨ÒýÈëµÄÎļþ£¬Èç¹û³öÏÖ´íÎóÊÇÖÂÃüµÄ¡£
nclude()  Óë  include_once()
    
    &n ......

MYSQL ʼþµ÷¶ÈµÄÀý×Ó

1.SET GLOBAL event_scheduler = ON;
2.show processlist;
3.´´½¨Ò»¸ö±í test Ö÷Òª×Ö¶Î no,name,sex,age
4.¶Ô¸Ã±í²åÈ缸ÌõÊý¾Ý
5.´´½¨´æ´¢¹ý³Ìadd_age
drop procedure if exists add_age;
delimiter|
create procedure add_age()
begin
  start transaction;
  update eventtest set age = age +1;
&n ......

phpѧϰ±Ê¼Ç£¨12£©:PHP+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ÓëÊÂÎñ


MySQL5.X¶¼ÒѾ­·¢²¼ºÃ¾ÃÁË£¬µ«ÊÇ»¹ÓкܶàÈËÈÏΪMySQLÊDz»Ö§³ÖÊÂÎñ´¦ÀíµÄ£¬Õâ²»µÃ²»¹ÖËûÃÇÊǹª¹ÑÎŵ쬯äʵ£¬Ö»ÒªÄãµÄMySQL°æ±¾
Ö§³ÖBDB»òInnoDB±íÀàÐÍ£¬ÄÇôÄãµÄMySQL¾Í¾ßÓÐÊÂÎñ´¦ÀíµÄÄÜÁ¦¡£ÕâÀïÃæ£¬ÓÖÒÔInnoDB±íÀàÐÍÓõÄ×î¶à£¬ËäÈ»ºóÀ´·¢ÉúÁËÖîÈçOracleÊÕ
¹ºInnoDBµÈÁîMySQL²»Ë¬µÄÊÂÇ飬µ«ÄÇЩÉÌÒµÉϵĶ·ÕùÓë¼¼ÊõÎÞ¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ