Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

PHP¹ØÓÚSQLserverÊý¾Ý¿âÖÐntext×ֶζÁÈ¡

    СµÜÎÒÔÚserver2000Êý¾Ý¿âarticle±íµ¥ÖÐÓÐÒ»¸öÀàÐÍÊÇ¡®ntext¡¯µÄ×ֶΣ¬×Ö¶ÎÃûÊÇcontext¡£´Ë×Ö¶ÎÊÇÓÃÀ´´æ·ÅÎÄÕÂÄÚÈݵģ¬ÎÒÓÃphp¶ÁÈ¡´Ë×Ö¶ÎÄÚÈÝÓÃÓï¾ä£ºPHP code:
$result=mssql_query("select convert(text,content) as content from article where articleid='$articleid' ");
´ËÓï¾ä¿ÉÒÔÕýÈ·Ö´ÐУ¬µ«ÎÊÌâÊÇÓеÄÎÄÕÂÄÚÈݺܶ࣬Óá®text¡¯Ö»ÄܶÁÈ¡´óÔ¼5000¸öºº×Ö£¬Ê£ÏµľÍÎÞ·¨ÏÔʾ£¬ÎÒ²»ÖªµÀÓÃʲô°ì·¨¿ÉÒÔ°ÑËùÓеÄÄÚÈݶ¼¶ÁÈ¡³öÀ´¡£Çë¸÷λ´ó¸ç°ï°ïæ¸øµãÒâ¼û»ò½¨Ò飬СµÜÎÒллÁË¡££¨Êý¾Ý¿âÊǹ̶¨²»ÄÜÐ޸ĵģ¬Ö»ÄÜÓÃPHP´úÂëÀ´½â¾ö¡££©
ÎÒÓÃÏÂÃæ´úÂë¶ÁÈ¡context×ֶΣº
PHP code:

while ( $row = mssql_fetch_row($result))
{
echo $row[0];
}


ÎÒ¾õµÃÊDZäÁ¿$row²»ÄÜ´æ´¢ÄÇô³¤µÄ×Ö·û£¬µ«ÎÒ²»¶®ÔõôÉ趨±äÁ¿´æ´¢×Ö·ûµÄ³¤¶È£¿

ÖÕÓÚÕÒµ½ÎÊÌâËùÔÚ£¬sql server 2000ÖÐ'text'ÀàÐÍÖ»ÄÜ´æ´¢4096¸ö×Ö·û£¬ËùÒÔ'ntext'×°»»³É¡®text¡¯ÀàÐͺ󣬳¬¹ý4096×Ö·ûºóÃæµÄ×Ö·ûÈ«²¿¶¼¶ªÊ§¡£´ó¼ÒÓÐʲô°ì·¨Äܹ»È«²¿¶ÁÈ¡Íê'ntext'ÀàÐÍ×ֶεÄËùÓÐÄÚÈÝ£¿

ÎÊÌâ½â¾ö£¬·½·¨ÈçÏ£º
PHPÔÚ²Ù×÷SQL ServerÊý¾Ý¿âʱ,Ö»ÄÜ·¢ËÍ4096BµÄ×Ö·û,Èç¹û°´ÕÕÕâ¸öÉèÖÃ,ÔÚ·¢²¼Ò»Ð©ÄÚÈݱȽϳ¤µÄÐÅϢʱ,»áµ¼ÖÂÐÅÏ¢²»È«,Òò´Ë,ÐèÒªÐÞ¸Äphp.iniÖÐÏà¹ØµÄÉèÖÃ:
ÓÃÈÎÒâÎı¾±à¼­Æ÷´ò¿ªphp.ini,
ÕÒµ½
;mssql.textlimit = 4096
¸ÄΪ
mssql.textlimit = 2147483647


Ïà¹ØÎÊ´ð£º

¸¶·ÑÇóÒ»¶Îphp´úÂ룬֧³ÖÌÔ±¦½»Ò× - PHP / »ù´¡±à³Ì

¸÷λ´óÏÀ 
ÇóÒ»¶Îphp´úÂë 
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ 
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ 
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½ 
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......

¿Õ¼äÉÏphpÎļþ²»ÄÜä¯ÀÀ£¬ä¯ÀÀ¾ÍÏÂÔØphpÎļþ

ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´Ô­Òò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......

ÐèÒªÊÓƵ½Ì³ÌµÄÐÂÊÖ½ø php + mysql + apache ÅäÖÃ

Õâ¸öÊÓƵ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔصØÖ·
ÏÂÔصØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´


......

Çë½ÌPHP¶àÑ¡±íµ¥µÄÎÊÌ⣡¼±ÓÃ

ÎÒ×÷Ò»Õâ¸ö¶àÑ¡±íµ¥£º

<input type="checkbox" name="services[]" value="½»Á÷ƽ̨" />
          ½»Á÷ƽ̨ &nbsp;
    ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ