Ò»¸öÁ¬½ÓmysqlºÍmssqlµÄ×¢²á¹¦ÄÜ£¡100·Ö
Ìṩһ¸öÍêÕûµÄ¼òµ¥Ê¾Àý
µã»÷×¢²áµÄʱºò£¬°ÑÐÅϢͬʱע²áµ½mysqlµÄA±íºÍmssqlµÄA±í лл
×¢²á¹¦ÄÜ?? ÊÇʲôÒâ˼
ÄãºÃ ÎÒÊǵÚÒ»´Î½Ó´¥PHP£¬¿ÉÒÔÏêϸµãÂð
ÆäʵÎÒÊÇÏëÔÚDiscuzÀïµÄ×¢²áÌí¼ÓÒ»¸öµ½MSSQLµÄ±í
$db->query("Insert Into ceshi(CeshiName)Values('AAAA')");
Õâ¸öÊÇÎÒ²âÊÔÁËÏÂÔÚMYSQLÀïOK
ÏÖÔÚÎÒÏëÔõôʵÏÖÔÚMSSQL£¬mysql_queryÕâ¸öÊÇʲô£¿ÎÒÐèÒªÁ¬½ÓÊý¾Ý¿âÊÇÔõôÑùµÄ ³õѧÕßÇë½ÌºÇºÇ
¼ÈÈ»ÊÇÐÂÊÖ£¬½¨ÒéÏÈ¿´¿´PHPÊÖ²áÔÙȥʵÏÖijЩ¹¦ÄÜ¡£
ллÄãµÄ½¨Ò飬ÓÉÓÚ¸Õ½Ó´¥PHP£¬Óï·¨²»ÊìϤ£¬²»¹ý×¢²áµÄ»°Ò²¾ÍÊÇÒ»ÌõSQL
ÎÒÏÖÔÚ¾ÍÊÇÏë×î¼òµ¥µÄ×¢²áµ½MSSQLÀïµÄÒ»¸öСʾÀý
PHP code:
<?php
$con=mssql_connect("localhost","sa","123","ceshi");
echo $con;
if($con)
echo "<br/>Á¬½Ó³É¹¦";
else
echo "Á¬½Óʧ°Ü";
?>
±ÈÈçÕâ¸öÊý¾Ý¿âÁ¬½ÓÉÏÁË ÎÒÔõôÌí¼ÓÒ»ÌõÊý¾Ý£¿
PHP code
Code highlig
Ïà¹ØÎÊ´ð£º
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
²»ÖªµÀÊDz»ÊÇÎÒµÄxamppÓÐÎÊÌ⣬mysqlÊÇͼÐλ¯µÄ£¡
Ò»¸öID×éÔÚÎÒµÄmysqlµÄ±íÀïÃæ 2£¬5£¬8£¬7
µãÁËÅÅÐò£¬È»ºóÓÃPHPÎļþÁ¬½ÓÕâ¸ö±íÏÔʾ±íµÄÐÅϢʱ£¬IDµÄ˳Ðò»¹ÊDz»±ä£¡Ó¦¸ÃÊÇ2£¬5£¬7£¬8µÄ°ÉÉýÐòÅÅÐòºó£¡
ÔÚPHPÎļþÀï ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
Ò»¸ö×ÜÕ¾.Èý¸ö×ÓÕ¾¹²ËĸöASP¿ª·¢µÄÕ¾µã;Êý¾Ý¿âÊÇMSSQL2000;ËĸöÕ¾¸÷ÓÐ×Ô¼ºµÄÊý¾Ý¿â(ËĸöÕ¾µãµÄ¿â½á¹¹¶¼ÊÇÒ»ÑùµÄ.),¸÷ÓÐ×Ô¼ºµÄÐÅÏ¢Ìí¼Óºǫ́,ËĸöÕ¾ÊǶÀÁ¢µÄ.ËĸöÕ¾¶¼ÔÚͬһ¸ö·þÎñÆ÷ÖÐ.
ÏÖÔÚÐèÒªÏÖʵ:
Ò».ÈçºÎÈÃ×ÜÕ¾ ......