СµÜÎÒÔÚ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´úÂë
¿ÉÒÔʵÏÖÒÔϹ¦ÄÜ
Õë¶Ô²»Í¬µÄä¯ÀÀÆ÷ÏÔʾ²»Í¬µÄͼƬ
¾ÍÊÇÓÐÒ»ÕÅͼƬ£¬Ö»Ïë¸øie6Óû§¿´µ½
Èç¹ûie7¡¢chrome¡¢firefoxÓû§ä¯ÀÀÔòÏÔʾÁíÍâÒ»ÕÅͼƬ  ......
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿Õ¼ä²»Ö§³Ö¡£
»òÕßÄãµÄÕ˺ÅûÓп ......
Õâ¸öÊÓƵ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔصØÖ·
ÏÂÔصØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
ÎÒ×÷Ò»Õâ¸ö¶àÑ¡±íµ¥£º
<input type="checkbox" name="services[]" value="½»Á÷ƽ̨" />
½»Á÷ƽ̨
......
ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË
¼Æ»®ÈÎÎñ...php....sql...truncate....OK
Äã¾ÍÕâ½ÓÔÚҳà ......