µ±Ë÷ÒýËùÔÚÒ³ÃæµÄ»ùÓÚÖ÷¹Ø¼ü×ÖµÄÂ߼˳Ðò£¬ºÍÊý¾ÝÎļþÖеÄÎïÀí˳Ðò²»Æ¥Åäʱ£¬Ë鯬¾Í²úÉúÁË¡£ËùÓеÄÒ¶¼¶Ò³°üº¬ÁËÖ¸Ïòǰһ¸öºÍºóÒ»¸öÒ³µÄÖ¸Õë¡£ÕâÑù¾Í
ÐγÉÒ»¸öË«Á´±í¡£ÀíÏëÇé¿öÏ£¬Êý¾ÝÎļþÖÐÒ³µÄÎïÀí˳Ðò»áºÍÂ߼˳ÐòÆ¥Åä¡£Õû¸ö´ÅÅ̵Ť×÷ÐÔÄÜÔÚÎïÀí˳ÐòÆ¥ÅäÂ߼˳Ðòʱ½«ÏÔÖøÌáÉý¡£¶ÔÄ³Ð©ÌØ¶¨µÄ²éѯ¶øÑÔ£¬
Õ⽫´øÀ´¼«¼ÑµÄÐÔÄÜ¡£µ±ÎïÀíÅÅÐòºÍÂß¼ÅÅÐò²»Æ¥Åäʱ£¬´ÅÅ̵Ť×÷ÐÔÄÜ»á±äµÃµÍЧ£¬ÕâÊÇÒòΪ´ÅÍ·±ØÐëÏòǰºÍÏòºóÒÆ¶¯À´²éÕÒË÷Òý£¬¶ø²»ÊÇÖ»Ïóij¸öµ¥Ò»·½ÏòÀ´ËÑ
Ë÷¡£Ë鯬»áÓ°ÏìI/OÐÔÄÜ£¬²»¹ý¶ÔÓÚλÓÚSQL ServerÊý¾Ý»º³åÄÚµÄÊý¾ÝÒ³¶øÑÔ£¬Ë鯬²¢²»»á´øÀ´ÈκÎÓ°Ïì¡£
ÔÚË÷ÒýË鯬ÕûÀíǰ£¬ÇëÈ·±£ÏµÍ³×ÊÔ´µÄһЩÎÊÌ⣬±ÈÈçÎïÀí´ÅÅÌË鯬£¬²»ºÏÀíµÄ»ù´¡½á¹¹µÈÒòËØ»á¸øÐÔÄÜ´øÀ´¸ºÃæÓ°Ï죬²Î¿´KB935089£ºÊ¹Óà Defrag ¹ÜÀíÆ÷¿ÉÒÔ such as Exchange Server »ò SQL Server Êý¾Ý¿â·þÎñÆ÷µÄ¾í½øÐÐË鯬ÕûÀí
¡£
DBCC SHOWCONTIGÊÇÏÔʾָ¶¨µÄ±íµÄÊý¾ÝºÍË÷ÒýµÄË鯬ÐÅÏ¢¡£µ±ÔËÐиÃÃüÁîʱ£¬ÒªÌرð×¢ÒâÂß¼Ë鯬(Logical Fragmentation)ºÍÒ³ÃܶÈ(Page Density)Á½¸öÖ¸±ê¡£
Page Scanned-ɨÃèÒ³Êý£º
Èç¹ûÄãÖªµÀÐеĽüËÆ³ß´çºÍ±í»òË÷ÒýÀïµÄÐÐÊý£¬ÄÇôÄã¿ÉÒÔ¹À¼Æ³öË÷ÒýÀïµÄÒ³Êý¡£¿´¿´É¨ÃèÒ ......
×÷Ϊһ¸öÈ«ÐµĻ¥ÁªÍøÏîÄ¿£¬ÓÐʱºò»áÃæÁÙÒ»¸öÑ¡ÔñʲôÑùµÄ¿ª·¢ÓïÑÔµÄÎÊÌâ¡£
ÎÒ˵µÄÕâ¸öÓÐʱºò£¬ÆäʵÊÇÖ¸ÏÖÓеÄÍŶÓÖУ¬Ã»Óм¼Êõ¿ª·¢µÄ³ÉÔ±µÄÇé¿ö¡£Èç¹ûÒѾÓÐÁËÒ»¸ö»òÕß¶à¸ö¼¼Êõ¿ª·¢ÈËÔ±£¬µ±È»ÊÇÑ¡ÔñÏÖÓгÉÔ±×îÊìϤºÍ×îÉó¤µÄÓïÑÔÁË¡£
ÄÇô¶ÔÓÚÒ»¸ö»¹Ã»Óм¼Êõ³ÉÔ±µÄÍŶӣ¬Ó¦¸ÃÑ¡ÔñʲôÑùµÄ¿ª·¢ÓïÑÔÄØ£¿»Ø´ðÕâ¸öÎÊÌ⣬Ê×ÏÈÓ¦¸Ã¸ãÇå³þÑ¡Ôñ¿ª·¢ÓïÑÔµÄʱºòÓ¦¸Ã´ÓÄÄЩ·½Ã濼ÂÇ£¿
ÎÒÈÏΪ×÷Ϊһ¸öÏîĿѡÔñ¿ª·¢ÓïÑÔÓ¦¸Ã¿¼ÂǼ¸¸ö·½Ã棺
1¡¢³É±¾
Ò»¸ö»¥ÁªÍøµÄÏîÄ¿£¬¿ª·¢ÍùÍùÊÇǰÆÚͶÈëµÄ´óÍ·£¬¶ø´ó¶àÊý´´ÒµÍŶÓǰÆÚµÄ×ʽ𶼲»ÊǺܳäÔ££¬ÈçºÎ¿ØÖÆ¿ª·¢³É±¾£¬¾Í³ÉΪһ¸öÐèÒª¿¼ÂǵÄÎÊÌâ¡£¿ª·¢³É±¾ÓÖ°üÀ¨¿ª·¢ÈËÔ±³É±¾ÒÔ¼°¿ª·¢×ÊÔ´³É±¾£¨¿ª·¢É豸¡¢·þÎñÆ÷´ø¿í×ÊÔ´µÈµÈ£©£»
2¡¢Ð§ÂÊ
ÏÖÔڵĻ¥ÁªÍø·¢Õ¹£¬Ê±¼äÊÇ×î´óµÄ³É±¾£¬ÊÇ·ñÄܹ»¿ìËٵĿª·¢³ö¿ÉÉÏÏߵIJúÆ·£¬ÍùÍù³ÉΪÏîÄ¿ÊÇ·ñÄܹ»»ñµÃ³É¹¦µÄÒ»¸öÖØÒªÒòËØ£»
3¡¢¿ÉÀ©Õ¹ÐÔ
ºÜ¶àÏîÄ¿¶¼ÊÇ·Ö½×¶ÎʵʩµÄ£¬Èç¹ûÒ»¸öÏîÄ¿µÄ¿ª·¢ÓïÑԵĿÉÀ©Õ¹ÐÔ²»Ç¿£¬¿ÉÄÜ»á¶ÔÏîÄ¿ºóÆÚµÄʵʩ´øÀ´¾Þ´óµÄÂé·³¡£
4¡¢¿ÉÒÆÖ²ÐÔ
×÷Ϊ·þÎñÆ÷ƽ̨£¬ÔçÆÚÓÃWINDOWSÊDZȽϷ½±ã¡¢¿ìËÙ¡¢“ʡǮ”£¨Ö÷ÒªÊÇά»¤³É±¾£©µÄ£¬µ«Êǵ±Ò»¸öÏîÄ¿ÉÏÉýµ½Ò»¶¨½×¶ÎµÄʱºò£ ......
ÒÔÏÂÊÇÀûÓÃphpʵÏÖÖÐÎÄˮӡµÄ´úÂë¡£
<?php
Header("Content-type: image/png"); /*֪ͨä¯ÀÀÆ÷,ÒªÊä³öͼÏñ*/
$im = imagecreate(400 , 300); /*¶¨ÒåͼÏñµÄ´óС*/
$gray = ImageColorAllocate($im , 235 , 235 , 235);
$pink = ImageColorAllocate($im, 255 , 128 , 255);
/*
$fontfile = "C:\WINDOWS\Fonts\SIMHEI.TTF";
²»ºÃÒâ˼,Õâ¾äÀÏÊÇÕ³ÉϺóÒ»Ìá½»¾Í¶ªÁË,²»ÖªµÀÊÇÔõô»ØÊÂ,Ïë²âÊÔµÄÅóÓÑÃǽ«×¢ÊÍÈ¥ÁËÏÖ²âÊÔ°É
*/
/* $fontfile ×ÖÌåµÄ·¾¶,ÊÓ²Ù×÷ϵͳ¶ø¶¨,¿ÉÒÔÊÇ simhei.ttf(ºÚÌå) , SIMKAI.TTF(¿¬Ìå) , SIMFANG.TTF(·ÂËÎ) ,SIMSUN.TTC(ËÎÌå&ÐÂËÎÌå) µÈ GD Ö§³ÖµÄÖÐÎÄ×ÖÌå*/
$str = iconv('GB2312','UTF-8','php°®ºÃÕßphpfans.net'); /*½« gb2312 µÄ×Ö·û¼¯×ª»»³É UTF-8 µÄ×Ö·û*/
ImageTTFText($im, 30, 0, 50, 140, $pink , $fontfile , $str);
/* ¼ÓÈëÖÐÎÄˮӡ */
Imagepng($im);
ImageDestroy($im);
?>
<?php
header("Content-typ ......
ÎÒÃÇÔÚдÓû§ÑéÖ¤Ò³Ãæ£¬Èç×¢²á£¬µÇ¼µÄʱºò£¬ÎªÁ˼ÓÇ¿Óû§µÇ¼µÄ°²È«ÐÔ£¬Ìí¼ÓÑéÖ¤ÂëÑéÖ¤¡£
ÑéÖ¤Âëͨ¹ýGDÉú³ÉPNGͼƬ£¬²¢°Ñ$randvalËæ»úÊý×Ö¸³¸ø$_SESSION['login_check_num']£¬ÔÚͨ¹ýÓû§ÊäÈëµÄ$_POST½øÐбȽϣ¬À´ÅжÏÊÇ·ñÕýÈ·¡£´ïµ½ÐèҪʵÏֵŦÄÜ£¬ÐèÒªÐÞ¸Äphp.iniÎļþ£¬Ê¹phpÖ§³ÖGD¿â¡£
<?php
//µ÷ÓôËÒ³Ãæ£¬Èç¹ûÏÂÃæµÄʽ×Ó³ÉÁ¢£¬ÔòÉú³ÉÑéÖ¤ÂëͼƬ
if($_GET["action"]=="verifycode")
{
rand_create();
}
//ÑéÖ¤ÂëͼƬÉú³É
function rand_create()
{
//֪ͨä¯ÀÀÆ÷½«ÒªÊä³öPNGͼƬ
Header("Content-type: image/PNG");
//×¼±¸ºÃËæ»úÊý·¢ÉúÆ÷ÖÖ×Ó
srand((double)microtime()*1000000);
//×¼±¸Í¼Æ¬µÄÏà¹Ø²ÎÊý
$im = imagecreate(62,20);
$black = ImageColorAllocate($im, 0,0,0); //RGBºÚÉ«±êʶ·û
$white = ImageColorAllocate($im, 255,255,255); //RGB°×É«±êʶ·û
$gray = ImageColorAllocate($im, 200,200,200); //RGB»ÒÉ«±êʶ·û
......
¶¨ÒåºÍÓ÷¨
filter_var() º¯Êýͨ¹ýÖ¸¶¨µÄ¹ýÂËÆ÷¹ýÂ˱äÁ¿¡£
Èç¹û³É¹¦£¬Ôò·µ»ØÒѹýÂ˵ÄÊý¾Ý£¬Èç¹ûʧ°Ü£¬Ôò·µ»Ø false¡£
Óï·¨
filter_var(variable, filter, options)
²ÎÊýÃèÊö
variable
±ØÐè¡£¹æ¶¨Òª¹ýÂ˵ıäÁ¿¡£
filter
¿ÉÑ¡¡£¹æ¶¨ÒªÊ¹ÓõĹýÂËÆ÷µÄ ID¡£
options
¹æ¶¨°üº¬±êÖ¾/Ñ¡ÏîµÄÊý×é¡£¼ì²éÿ¸ö¹ýÂËÆ÷¿ÉÄܵıêÖ¾ºÍÑ¡Ïî¡£
ÌáʾºÍ×¢ÊÍ
Ìáʾ£º²Î¼ûÍêÕûµÄ PHP Filter ²Î¿¼Êֲᣬ²é¿´¿ÉÓë¸Ãº¯ÊýһͬʹÓõĹýÂËÆ÷¡£
Àý×Ó
<?php
if(!filter_var("someone@example....com", FILTER_VALIDATE_EMAIL))
{
echo("E-mail is not valid");
}
else
{
echo("E-mail is valid");
}
?>
Êä³öÀàËÆ£º
E-mail is not valid
PHP Filter ¼ò½éPHP ¹ýÂËÆ÷ÓÃÓÚ¶ÔÀ´×Էǰ²È«À´Ô´µÄÊý¾Ý£¨±ÈÈçÓû§ÊäÈ룩½øÐÐÑéÖ¤ºÍ¹ýÂË¡£°²×°filter º¯ÊýÊÇ PHP ºËÐĵÄ×é³É²¿·Ö¡£ÎÞÐè°²×°¼´¿ÉʹÓÃÕâЩº¯Êý¡£PHP Filter º¯ÊýPHP£ºÖ¸Ê¾Ö§³Ö¸Ãº¯ÊýµÄ×îÔçµÄ PHP °æ±¾¡£º¯ÊýÃèÊöPHPfilter_has_var()¼ì²éÊÇ·ñ´æÔÚÖ¸¶¨ÊäÈëÀàÐ͵ıäÁ¿¡£5filter_id()·µ»ØÖ¸¶¨¹ýÂËÆ÷µÄ ID ºÅ¡£5filter_input()´Ó½Å±¾Íⲿ»ñÈ¡ÊäÈ룬²¢½øÐйýÂË¡£5filter_input_array()´Ó½Å±¾Íâ ......
1£¬¶¨Òåheader()Í·²¿Êä³ö¸ñʽ
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:finlename=php.xls");
vnd.ms-excel -----¶¨ÒåÊä³öÎļþ¸ñ
php.xls ---------¶¨ÒåÊä³öµÄÎļþÃû
2£¬Êä³ö±àÂëºÍÖ§³ÖµÄ¸ñʽ
(1) Ö§³ÖÆÕͨ¸ñʽµÄcsvÎı¾¹æ·¶£¬ÒÔ¿Õ¸ñºÍ»»ÐÐÀ´Ê¶±ð
³£Óãº\t \nÌî³ä¿Õ°×ºÍ»»ÐÐ
(2) Ö§³Ö¼òµ¥µÄhtml´úÂëºÍ±í¸ñ¹æ·¶
³£Óãºtable¹æ·¶£¬±í¸ñºÏ²¢¹æ·¶£¬Font±êÇ©¹æ·¶
===================================================
¼òµ¥µÄÀý×Ó£º
<?php
header("Content-type:application/vnd.ms-excel");
header("Content-Dispositon:finlename=php.xls");
//ÕâÊÇÒ»¸öcvsÎı¾¹æ·¶
/*
echo "A1\t B1\t C1\n";
echo "A2\t B2\t C2\n";
echo "A3\t B3\t C3\n";
*/
?>
<!--ÕâÊÇhtml´úÂëºÍ±í¸ñ¹æ·¶-->
<table border="1">
<tr>
<td>id</td>
<td><font colo ......