id stucode stuaddress sturoom stutime
1 22 35# n502 201005
2 22 35# n502 201007
3 12 45# n501 201005
4 22 35# n502 201005
5 22 35# n502 201005
6 12 45# n501 201009
7 12 65# n401 201010
8 22 35# n502 201005
9 22 34# n502 201005
10 32 35# n512 201005
11 22 34# n502 201007
12 32 55 ......
Á½¸ö±í£º
²úÆ·ÀàÐͱí tnclass £ºID£¬name
²úÆ·±í tbproduct £ºID£¬title£¬classid(classid¾ÍÊDZítbclassµÄÄǸöID),author£¬src
ÏÖÔÚÒª¸ù¾ÝÒ»¸ö²úÆ·µÄ id ÏÔʾÕâ¸ö²úÆ·µÄËùÓÐÐÅÏ¢
²úÆ·±êÌ⣬²úÆ·ÀàÐÍ£¬²úÆ··¢²¼ÈË,²úƷͼƬ
µ«ÎҵĽá¹ûÏÔʾ²úÆ·ÀàÐ͵ÄÊÇidºÅ1¡¢2¡¢3¡¢4£¬ÆäËüµÄûÎÊÌ⣬ÇóÖú¸÷λ°ïÎÒ¸Äһϣ¬ ......
±íA
ORDER, DATETIME, QTY
B00056, 5/11/2010£¬100
B00056, 5/12/2010£¬200
B00056, 5/13/2010£¬300
Çó¾²Ì¬SQLÓï¾äʵÏÖÈçÏÂЧ¹û,лл
ORDER, REMARK
B00056£¬ 5/11/2010 100£¬5/12/2010 200£¬5/13/2010 300
http://topic.csdn.net/u/20080805/08/aa1cc594-fe80-4bac-8e40-e1ece2d3a78d.html
SQL code:
- ......
Ò»¸ö±í£¬×ֶκÍÄÚÈÝÈçÏ£º
name
a
b
c
d
¼ÙÉèÕâÊǸöÇò¶ÓµÄ¶ÓÃû±í£¬Ã¿¸öÇò¶ÓÒªÓëÆäËüÈýÖ§¶Ó½øÐÐÒ»´Î±ÈÈü£¬ÇëÓÃÒ»¸ösqlÓï¾äÁгö±ÈÈüµÄ×éºÏ
ÿ¸öÇò¶ÓÒªÓëÆäËüÈýÖ§¶Ó½øÐÐÒ»´Î±ÈÈü
×ܵÄÿ´ÎÊÇËĶԣ¬Äã×ÜÊýÒ²ÊÇËĶԣ¬²»¾Í¸ÕºÃÒ»×éÂ𣿻¹ÊÇÄãÌṩµÄÊý¾ÝÓÐÎÊÌ⣿
SQL code:
--> Éú³É²âÊÔÊý¾Ý±í: [tb]
IF OBJECT_ ......
ÈçºÎÓÃphp׼ȷͳ¼ÆÖÐÓ¢ÎÄ×ÖÊýÄØ£¿ÎÒ»¹Ã»ÓÐÕÒµ½ºÜºÃµÄ°ì·¨£¬Çó½Ì
function ccStrLen($str) #¼ÆËãÖÐÓ¢ÎÄ»ìºÏ×Ö·û´®µÄ³¤¶È
{
$ccLen=0;
$ascLen=strlen($str);
$ind=0;
$hasCC=ereg("[xA1-xFE]",$str); #ÅжÏÊÇ·ñÓкº×Ö
$hasAsc=ereg("[x01-xA0]",$str) ......
ºÃ¾ÍûÓиãPHPÁ˰¡£¬¸Ð¾õ¸ã¼¼Êõûʲôǰ;£¬ÒÔǰÉÏ´óѧµÄʱºò¶Ô³ÌÐòºÜÓÐÈÈÇ飬µ«ÊÇÏÖÔÚ¹¤×÷ÁË£¬µ¥Î»Àï¸ù±¾Óò»ÉÏÕâ¶«Î÷£¬¾Í°ÑPHP¸øµÍüÁË£¬×î½üµ¥Î»¸ã¼¾¶È¿¼ÊÔ£¬Áìµ¼ÈÃ×öÒ»¸ö¿¼ÊÔϵͳ£¬²Å°ÑPHPÓÖÖØÐÂÓÃÆðÀ´£¬¸Ð¾õºÃÇ×Çа¡£¬PHPµÄÈ·ÊǺܺõıà³ÌÓïÑÔ°¡£¬ÁíÍâÏëÎÊһϴó¼Ò£¬PHP³ÌÐòÔ±ÏÖÔÚ´ýÓöÔõôÑù°¡£¬ÎÒÃǵ¥Î»Ð§Òæ²»ÔõôºÃ£ ......