51.Çëд³öÊý¾ÝÀàÐÍ(int char varchar datetime text)µÄÒâ˼£»ÇëÎÊ varchar ºÍ charÓÐʲôÇø±ð£¿
´ð£º
1¡¢Int ÕûÐÎ
2¡¢Char×Ö·ûÐÍ
3¡¢Varchar ¿É±ä³¤¶È×Ö·ûÐÍ
4¡¢Datetime ʱ¼äÈÕÆÚÄÚÊ¡
5¡¢Text Îı¾ÀàÐÍ
6¡¢Varchar Êǿɱ䳤¶ÈÀàÐÍ£¬Õ¼ÓõĿռäÊÇ×Ö·û´®µÄ³¤¶È+1£¬¶øcharÊǹ̶¨³¤¶È×Ö·û´®ÀàÐÍ£¬¶¨ÒåÁ˶àÉÙ¿Õ¼ä¾ÍÕ¼ÓöàÉٿռ䡣
52.MyISAM ºÍ InnoDB µÄ»ù±¾Çø±ð£¿
´ð£º
MYISAM²»Ö§³ÖÍâ¼üºÍÊÂÎñ´¦Àí£¬²ÉÓñíËø»úÖÆ£¬²éѯËÙ¶ÈÉԿ죬Êý¾Ý´æ´¢ÎļþÓÐ3¸ö£¬InnoDBÖ§³ÖÍâ¼üºÍÊÂÎñ´¦Àí£¬²ÉÓÃÐÐËø»úÖÆ£¬²éѯËٶȱÈMYISAMÉÔÂý£¬Êý¾Ý´æ´¢ÎļþÖ»ÓÐÒ»¸ö¡£
53.²»Ê¹ÓÃcookieÏò¿Í»§¶Ë·¢ËÍÒ»¸öcookie.
´ð£º
$value=¡±111¡å;
header(¡°Set-Cookie:name=$value¡±);
echo $_COOKIE['name'];
54.ÏßÐÔ±íºÍ˳Ðò±íµÄÇø±ð£¿
´ð£º
1¡¢ÏßÐÔ±í°üÀ¨Ë³Ðò±íºÍÁ´±í¡£
2¡¢Ë³Ðò±íÖеÄÔªËصĵØÖ·ÊÇÁ¬ÐøµÄ£¬Á´±íÀïÃæ½ÚµãµÄµØÖ·²»ÊÇÁ¬ÐøµÄ£¬ÊÇͨ¹ýÖ¸ÕëÁ¬ÆðÀ´µÄ¡£
55.ÈçºÎʵÏÖ¶à¸öḬ̈߳²È«µÄдÈëÒ»¸öÎļþÊý¾Ý¡£
´ð£º
²ÉÓÃËø»úÖÆ£¬µ±Ò»¸öÓû§ÔÚ¶Ô´ËÎļþ½øÐжÁдÈë²Ù×÷ʱ£¬½«´ËÎļþËø¶¨£¬²Ù×÷Íê±Ïºó½â³ýËø¶¨£¬ÔÚ¸ÃÓû§½øÐжÁдÈë²Ù×÷¹ý³ÌÖУ¬ÆäËûÓû§²»ÄܲÙ×÷´ËÎļþ£¬ÐèÒªÅŶӵȴý¡£
56.isset()ºÍempty() Çø±ð£¬¶Ô²»Í¬Êý¾ÝµÄÅжϽá¹û£¬$a=0;$a=¡¯0¡ä;$a=¡±;$a=false;$a=null;
IssetÅжϱäÁ¿ÊÇ·ñ´æÔÚ£¬Èç¹û´æÔÚÔò·µ»ØÕ棬emptyÅжϱäÁ¿ÊÇ·ñΪ¿Õ£¬Èç¹ûΪ¿ÕÔò·µ»ØÕæ¡£
´ð£º
IssetÅжϣºtrue,true,true,true,false¡£
EmptyÅжϣºtrue,true,true,true,true¡£
57.ʲôÊÇÂú¶þ²æÊ÷£¿Ê²Ã´ÊÂÍêÈ«¶þ²æÊ÷£¿
´ð£º
Âú¶þ²æÊ÷£º³ýÁËÒ¶×Ó½ÚµãÍâµÄËùÓнڵ㶼ÓÐÁ½¸ö×ӽڵ㡣
ÍêÈ«¶þ²æÊ÷£ºÃ¿¸ö½Úµã×î¶àÓÐÁ½¸ö×ӽڵ㣬ȱÓÒ²»È±×󣬶øÇÒ×î¶àÖ»ÄÜȱÉÙÒ»¸öÒ¶×ӽڵ㡣
58.ÈçºÎÔÚÒ³ÃæÖ®¼ä´«µÝ±äÁ¿(ÖÁÉÙÁ½ÖÖ·½Ê½)
´ð£º
GET,POST,COOKIE,SESSION
59.д³öÆ¥ÅäURLµÄÕýÔò±í´ïʽ.
´ð£º
/^http:\/\/www\.([\w]+)\.([\w]+)$/
60.Çëд³ö³£¼ûµÄÅÅÐòËã·¨(ÖÁÉÙÈýÖÖ)£¬²¢ÓÃPHPʵÏÖðÅÝÅÅÐò£¬½«Êý×é$a = array()°´ÕÕ´ÓСµ½´óµÄ·½Ê½½øÐÐÅÅÐò¡£
´ð£º
ðÅÝÅÅÐò·¨£¬¿ìËÙÅÅÐò·¨£¬²åÈëÅÅÐò·¨(һάÊý×é)¡£
ðÅÝ£º
$a=array(1,9,34,78,2,11,5);
Function maopao($arr){
$count=count($arr);
For($i=0;$i<$count;$i++)
{
For($j=$count-2;$j>=$i;$j¨C)
{
If($arr[$j]>$arr[$j+1])
{
$tmp=$arr[$j];
$arr[$j]=$arr[$j+1];
$arr[$j+1]=$tmp;
}
}
}
}
61.ÔÚÊý¾Ý¿âtestÖеÄÒ»¸ö±ístudent£¬×Ö¶ÎÊÇname£¬class£¬score¡£·Ö±ð´ú±íÐÕÃû¡¢ËùÔڰ༶£¬·ÖÊý¡£
´ð£º
1) ѧ³öÿ¸ö°à¼¶ÖеÄѧÉú£¬°´Õճɼ¨½µÐòÅÅÐò;
2) ²é³öÿ¸ö°àµÄ¼°¸ñÈËÊýºÍ²»¼°¸ñÈËÊý£¬¸ñʽΪ£ºclass¡¢¼°¸ñÈËÊý¡¢²»¼°¸ñÈËÊý£»
3) ÓÃPHPдÈëÁ¬½ÓÊý¾Ý¿â(¡°localhost¡±,¡±msuser¡±,¡±mspass¡±)¡¢Ö´ÐÐÒÔÉÏSQL¡¢ÏÔʾ½á¹û¡¢ÅжϴíÎ󡢹رÕÊý¾Ý¿âµÄ¹ý³Ì£»
1¡¢select * from student order by score desc;
2¡¢Select A.class,A.¼°¸ñÈËÊý,B.²»¼°¸ñÈËÊý from (select class, count(*) as ¡¯¼°¸ñÈËÊý¡® from student where score>=60 group by class) as A,(select class,count(*) as ¡¯²»¼°¸ñÈËÊý¡® from student where score<60 group by class) as B where A.class=B.class;
3¡¢$conn=mysql_connect(¡®localhost¡¯,'root¡¯,¡¯12345¡ä);
Mysql_select_db(¡®test¡¯);
$sql=¡±";
$result=Mysql_query($sql);
Mysql_close();
62.ftp://pub.foo.bar.com:2121/incoming/rls.sfv Çë¸ø³öÕâ¸öURL¸÷²¿·ÖµÄÒâÒå
´ð£º
1¡¢ftp:// ;ʹÓõÄÐÒéÊÇ£ºftp
2¡¢Pub.foo.bar.com ÊÇÓòÃû
3¡¢2121 ÊÇʹÓõĶ˿Ú
4¡¢Incoming/rls.sfv Êǵ±Ç°·ÃÎʵÄÎļþ¡£
63.ÇëÁгö4¸ö³£ÓõÄHTML±êÇ©Ãû
´ð£º
64.ÏÂÁв»ÊôÓÚjava scriptÓï·¨¹Ø¼ü/±£Áô×ÖµÄÊÇ B
A. var
B. $
C. function
D. while
65.ÏÂÁв»ÊôÓÚJavascrip DOM²Ù×÷ʼþµÄÊÇ C
A. onclick
B. onkeydown
C. onbodyload
D. onmouseover
66.Çëд³ö5¸ö³£ÓõÄunix²Ù×÷ÃüÁî¡£
´ð£º
1¡¢Ls -l
2¡¢tar -zxvf
3¡¢Touch
4¡¢Cat
5¡¢Mkdir
6¡¢rm
67.Çëд³öÒÔÏÂ5¸öUNIXϵͳÅäÖÃÎļþ/·þÎñµÄ×÷Óá£
´ð£º
/etc/passwd /etc/hosts /etc/fstab crontab sshd
1¡¢/etc/passwd £ºÓû§ÐÅÏ¢Îļþ£¬ÆäÖаüº¬Óû§Ãû¡¢Óû§ÊÇ·ñÓÐÃÜÂë¡¢Óû§ID¼°Óû§ËùÊô×é
2¡¢/etc/hosts£ºÖ÷»úÃûÊý¾Ý¿â£¬°üIPµØÖ·¡¢Ö÷»úÃû»òÓòÃû¡¢±ðÃûµÈÐÅÏ¢£¬ÔÚ´ËÎļþÖÐÌí¼Ó¼Ç¼¿ÉÈƹýDNS
3¡¢/etc/fstab ±£´æÁËϵͳËùÓзÖÇøÐÅÏ¢µÄÅäÖÃÎļþ¡£
4¡¢Crontab ¼Æ»®ÈÎÎñÃüÁî
5¡¢Sshd Ô¶³ÌÁ¬½Ó¹ÜÀíÃüÁî
68.Çëд³ö5¸ö³£ÓõÄSQL²Ù×÷¹Ø¼ü×Ö¡£
´ð£º
Select ,update, delete, insert into, create ,group by ,order by
69.ÇëÁгö5¸ö³£ÓõÄPHP²Ù×÷MySQLµÄº¯Êý
´ð£º
1¡¢Mysql_connect()
2¡¢Mysql_select_db()
3¡¢Mysql_query()
4¡¢Mysql_fetch_row()
5¡¢Mysql_close()
70.Çëд³öÏÂÃæMySQLÊý¾ÝÀàÐͱí´ïµÄÒâÒå¡£
´ð£º
1¡¢int(10) ÕûÊýÀàÐÍ£¬³¤¶È10λ
2¡¢char(16) ×Ö·ûÀàÐÍ£¬³¤¶È16λ
3¡¢varchar(16) ¿É±ä³¤¶È×Ö·ûÀàÐÍ£¬³¤¶È16λ
4¡¢Datetime ʱ¼äÈÕÆÚÀàÐÍ
5¡¢Text ´ó×Ö·û´®ÀàÐÍ
71.ÓÐÁ½ÕÅÊý¾Ý±í£¬±íuser(id, name)¼Ç¼ÁËÓû§µÄIDºÍêdzƣ¬±íarticle(id, title, content, time)¼Ç¼ÁËÓû§·¢±íµÄÎÄÕ±êÌâ¡¢ÄÚÈݺÍʱ¼ä£¬Ð´Ò»¸öSQLÓï¾ä´òÓ¡³öÿ¸öÓû§µÄêdzƼ°Æä·¢±íµÄÎÄÕÂ×ÜÊý¡£
´ð£º
Select user.name,A.id,A.×ÜÊý from user,(select id,count(*) as ¡¯×ÜÊý¡® from article group by id) as A where user.id=A.id;
72.ÏÂÁÐPHPº¯ÊýÖв»ÄÜÖ±½ÓÔÚÒ³ÃæÊä³ö×Ö·û´®µÄº¯ÊýÊÇ B
A