ת×Ô:
http://blog.csdn.net/web_gus/archive/2004/10/11/132122.aspx
Select
ÓÃ;£º
´ÓÖ¸¶¨±íÖÐÈ¡³öÖ¸¶¨µÄÁеÄÊý¾Ý
Óï·¨£º
SELECT column_name(s) from table_name
½âÊÍ£º
´ÓÊý¾Ý¿âÖÐѡȡ×ÊÁÏÁУ¬²¢ÔÊÐí´ÓÒ»»ò¶à¸ö×ÊÁϱíÖУ¬Ñ¡È¡Ò»»ò¶à¸ö×ÊÁÏÁлò×ÊÁÏÐС£
SELECT
³ÂÊöʽµÄÍêÕûÓï·¨Ï൱¸´ÔÓ£¬µ«Ö÷Òª×Ó¾ä¿ÉժҪΪ£º
SELECT select_list
[ INTO new_table ]
from table_source
[ WHERE search_condition ]
[ GROUP BY group_by_expression ]
[ HAVING search_condition ]
[ ORDER BY order_expression [ ASC | DESC ] ]
Àý£º
“Persons”
±íÖеÄÊý¾ÝÓÐ
LastName
FirstName
Address
City
Hansen
Ola
Timoteivn 10
Sandnes
Svendson
Tove
Borgvn 23
Sandnes
Pettersen
Kari
Storgt 20
Stavanger
Ñ¡³ö×Ö¶ÎÃû
”
LastName
”
¡¢
”
FirstName
”
µÄÊý¾Ý
SELECT LastName,FirstName from Persons
·µ»Ø½á¹û
:
LastName
FirstName
Hansen
Ola
Svendson
Tove
Pettersen
Kari
Ñ¡³öËùÓÐ×ֶεÄÊý¾Ý
SELECT * from Persons
·µ»Ø½á¹û
:
Last ......
ÔÌûµØÖ·£ºhttp://www.phpma.com/english/20071215/640.html
Description
array explode
( string separator, string string [, int limit])phpma.com
Returns an array of strings, each of which is a substring of string
formed by splitting it on boundaries formed by the string separator
. If limit
is set, the returned array will contain a maximum of limit
elements with the last element containing the rest of string
.
If separator
is an empty string (""), explode()
will return FALSE
. If separator
contains a value that is not contained in string
, then explode()
will return an array containing string
.
If the limit
parameter is negative, all components except the last limit
are returned. This feature was added in PHP
5.1.0
.
Although implode()
can, for historical reasons, accept its parameters in either order, explode()
cannot. You must ensure that the separator
argument comes before the string
argument.
×¢:
The limit
parameter was added ......
time()ÔÚPHPÖÐÊǵõ½Ò»¸öÊý×Ö,Õâ¸öÊý×Ö±íʾ´Ó1970-01-01µ½ÏÖÔÚ¹²×ßÁ˶àÉÙÃë,ºÜÆæ¹Ö°É
²»¹ýÕâÑù·½±ã¼ÆËã,
ÒªÕÒ³öǰһÌìµÄʱ¼ä¾ÍÊÇ time()-60*60*24;
ÒªÕÒ³öǰһÄêµÄʱ¼ä¾ÍÊÇ time()-60*60*24*365
ÄÇôÈçºÎ°ÑÕâ¸öÊý×Ö»»³ÉÈÕÆÚ¸ñÊ½ÄØ,¾ÍÒªÓõ½dateº¯ÊýÁË
$t=time();
echo date("Y-m-d H:i:s",$t);
a - "am" »ò "pm"
A - "AM" »ò "PM"
B - Swatch Internet Time£¨¡¾ÒëÕß×¢¡¿²Î¼û http://swatch.com/alu_beat/fs_itime.html£©
d - Ô·ÝÖеĵڼ¸Ì죬ÓÐǰµ¼ÁãµÄ 2 λÊý×Ö£¬ÀýÈç "01" to "31"
D - ÐÇÆÚÖеĵڼ¸Ì죬Îı¾±íʾ£¬3 ¸ö×Öĸ£¬ÀýÈç "Fri"
F - Ô·ݣ¬ÍêÕûµÄÎı¾¸ñʽ£¬ÀýÈç "January"
g - Ð¡Ê ......
²âÊÔ£ºhttp://www.yincode.com
Óû§£ºtest1 test2 test3
ÃÜÂ룺123456
=======================================
2010/01/12/18:54:24
=======================================
¹È¸èä¯ÀÀÆ÷ä¯ÀÀ²»Õý³£
main.js
function getData(u,m,callBack){
var ru=u+"&r="+Math.random();
$("loading").style.display="";
new Ajax.Request(ru,{
method:m,
encoding:"GBK",
onSuccess:callBack,
onComplete:function(){
$("loading").style.display="none";
},
onFailure:function(){
alert("ÇëÇó³ö´íÁË£¡");
}
});
}
Request ÎÞ·¨µ÷Óú¯Êý ......
import flash.net.FileFilter;
import flash.net.FileReferenceList;
import fl.controls.Button;
import flash.events.MouseEvent;
import flash.events.Event;
import flash.events.ProgressEvent;
import flash.events.HTTPStatusEvent;
import flash.display.Loader;
import flash.net.URLRequest;
var choose_button:Button=new Button();
var upload_button:Button=new Button();
var loader:Loader=new Loader();
var reference_list:FileReferenceList=new FileReferenceList();
var url:URLRequest=new URLRequest("http://localhost/flashupload.php");
choose_button.label="Ñ¡ÔñÎļþ";
upload_button.label="ÉÏ´«Îļþ";
upload_button.move(100,50);
addChild(choose_button);
choose_button.move(300,100);
addChild(upload_button);
addChild(loader);
choose_button.addEventListener(MouseEvent.CLICK,choose_file);
upload_button.addEventListener(MouseEvent.CLICK,upload_start);
reference_list.addEventListener(Event.SELECT, selectHandle);
reference_list.addEventListener(Event.CANCEL, cancelHandl ......
import flash.net.FileFilter;
import flash.net.FileReferenceList;
import fl.controls.Button;
import flash.events.MouseEvent;
import flash.events.Event;
import flash.events.ProgressEvent;
import flash.events.HTTPStatusEvent;
import flash.display.Loader;
import flash.net.URLRequest;
var choose_button:Button=new Button();
var upload_button:Button=new Button();
var loader:Loader=new Loader();
var reference_list:FileReferenceList=new FileReferenceList();
var url:URLRequest=new URLRequest("http://localhost/flashupload.php");
choose_button.label="Ñ¡ÔñÎļþ";
upload_button.label="ÉÏ´«Îļþ";
upload_button.move(100,50);
addChild(choose_button);
choose_button.move(300,100);
addChild(upload_button);
addChild(loader);
choose_button.addEventListener(MouseEvent.CLICK,choose_file);
upload_button.addEventListener(MouseEvent.CLICK,upload_start);
reference_list.addEventListener(Event.SELECT, selectHandle);
reference_list.addEventListener(Event.CANCEL, cancelHandl ......
__autoload($classname){
}
µ±PHPÕÒ²»µ½ÀàÎļþ»áµ÷ÓÃÕâ¸ö·½·¨£¬µ±×¢²áÁË×Ô¼ºµÄº¯Êý»ò·½·¨Ê±£¬PHP²»»áµ÷ÓÃ__autoload()º¯Êý£¬¶ø»áµ÷ÓÃ×Ô¶¨ÒåµÄº¯Êý
spl_autoload_register('func_name');
spl_autoload_register(array('class_name','method_name')); ......