¼òµ¥µÄPHP²Ù×÷MysqlÀà
<?php
/*
* Ãû³Æ : MySQLÊý¾Ý¿â»ù±¾²Ù×÷
* ×÷Õß : pjx
* °æ±¾ : v 2010/02/25 v 1.0
* ˵Ã÷ : ¸ÃÀàÓÃÓÚ¶ÔMySQL×öһЩ¼òµ¥µÄ²Ù×÷
* ʾÀý £º
* ʵÀý => $db = new DB_MYSQL($database),´ò¸ö$databaseÊý¾Ý¿â
* ²éѯÊý¾Ý¿â => $db->query($sql_str),²éѯ$sql_strÓï¾ä
* »ñµÃÐнá¹û => $db->get_rows_result();
* »ñµÃÐÐÊý => $db->get_rows();
* »ñµÃÁнá¹û => $db->get_files_result();
* »ñµÃÁÐÊý => $db->get_files();
* ÊͷŽá¹û¼¯ => $db->free();
* ²éѯ²¢»ñµÃÐнá¹û(ÐèʵÀý OP_MYSQL($database)) => query_and_get_rows($sql_str);
* ²éѯ²¢»ñµÃÐнá¹û(ÐèʵÀý OP_MYSQL($database)) => query_and_get_files($sql_str);
**/
class DB_MYSQL{
/*
* host : Ö÷»úÃû»òµØÖ·
* db : Êý¾Ý¿â
* user : Êý¾Ý¿âÓû§Ãû
* pw : Êý¾Ý¿âÓû§ÃÜÂë
* */
var $host = "localhost";
var $db = "";
var $user = "root";
var $pw = "";
/*
* link_id : Êý¾Ý¿âÁ¬½ÓµÄid
* query_id : Êý¾Ý¿â²éѯµÄid
* error : Õë¶ÔÓû§µÄ´íÎóÏûÏ¢
* error_mysql : Êý¾Ý¿â·µ»ØµÄ´íÎóÏûÏ¢,Õë¶Ô³ÌÐòÔ±
* rows : ½á¹ûÐÐÊý
* files : ½á¹ûÁÐÊý
* result_rows : Ðнá¹û¼¯
* result_files : Áнá¹û¼¯
*/
var $link_id = 0;
var $query_id = 0;
var $error = "";
var $error_mysql = "";
var $rows = 0;
var $files = 0;
var $result_rows = array();
var $result_files = array();
var $mysql_char = "utf8";
function __construct($d="",$h="",$u="",$p=""){
&
Ïà¹ØÎĵµ£º
½ñÌìµÄѧϰÄÚÈÝÊÇsqliteºÍPDO mysql¡£
ÓÃ×Ô¼ºµÄ»°ËµËµÁ½¸ö¶«Î÷°É£º
sqliteËãÊÇÒ»ÖÖ²»ÏµÍ³µÄÊý¾Ý¿â´æ´¢·½Ê½£¬ËüµÄ´æ·Å¸ñʽÊÇÒ»¸ö.dbºó׺µÄÎļþ£¬ÔÚphpÖÐËü´æ·ÅÔÚµ±Ç°µÄĿ¼Ï£¬Ã²ËƲ»ÓÃÓû§ÃûÃÜÂ룬°²È«ÐԽϵͣ¬È´±È½Ï·½±ã¡£PHP5ÖÐ×Ô´øµÄһЩϵͳº¯Êý£¬¶¼ÊÇÒÔsqlite_¿ªÍ·µÄ¡£
PDOÈ«³ÆPHP Data Object£¬¹ËÃû˼Òå¾ÍÊÇPHPµÄÒ ......
EClipse for PHP ÖÐÎÄÂÒÂëÎÊÌâ
UTF-8 ¸ñʽµÄphp,ÖÐÎͼÊÇÂÒÂë.
Èç¹û´ËʱÔÚEClipseÖÐÊäÈëÖÐÎÄ»áÓÐ CP1252 ´íÎó( CP1252²»Ö§³Öxxxx )
½â¾ö·½·¨:
windows->preferences->general ´ò¿ªµã»÷workspace ´ËʱÓÒ²à³öÏÖtext file encoding¾ÍÊÇÎı¾±àÂë default cp1252 µã»÷other ÏÂÀ²Ëµ¥ Ñ¡ÔñUTF-8 Ñ¡Ôñ¼´¿É±àÒë ......
¹ØÓÚ·ÖÒ³µÄÓÅ»¯¡£
ÎÒÃÇÖªµÀ£¬ÔÚMySQLÖзÖÒ³ºÜ¼òµ¥£¬Ö±½ÓLIMIT page_no,page_total ¾Í¿ÉÒÔÁË¡£
¿ÉÊǵ±¼Ç¼ÊýÂýÂýÔö´óʱ£¬Ëý¾Í²»ÄÇôºÃʹÁË¡£
ÕâÀïÎÒÃÇ´´½¨ÕªÒª±íÀ´¼Ç¼ҳÂëºÍÔ±íÖ®¼äµÄ¹ØÁª¡£
ÏÂÃæÎª²âÊÔÊý¾Ý¡£
Ô±í£º
CREATE TABLE `t_group` (
`id` int(11) NOT NULL auto_increment,
`money` decim ......
1 MySQLÖ§³Öenum,ºÍsetÀàÐÍ£¬SQL Server²»Ö§³Ö
¡¡¡¡2 MySQL²»Ö§³Önchar,nvarchar,ntextÀàÐÍ
¡¡¡¡3 MySQLµÄµÝÔöÓï¾äÊÇAUTO_INCREMENT£¬¶øMS SQLÊÇidentity(1,1)
¡¡¡¡4 MS SQLĬÈϵ½´¦±í´´½¨Óï¾äµÄĬÈÏÖµ±íʾÊÇ((0)),¶øÔÚMySQLÀïÃæÊDz»ÔÊÐí´øÁ½À¨ºÅµÄ
¡¡¡¡5 MySQLÐèҪΪ±íÖ¸¶¨´æ´¢ÀàÐÍ
¡¡¡¡6 MS SQLʶ±ð·ûÊÇ[],[type]±íÊ ......
ËѼ¯²»È«£¬Á´½ÓûÓÐÈ«²¿²âÊÔ£¬´ó²¿·Ö¿ÉÓÃ
Easy Template System
http://ets.sourceforge.net/
http://ets.sourceforge.net/ets.pdf
http://prdownloads.sourceforge.net/ets/ets305b.zip?download
Smarty
http://smarty.php.net/
FastTemplate
http://www.thewebmasters.net/php/FastTemplate.phtml
http://www ......