phpÏòSQL SERVER 2000Êý¾Ý¿âÖвåÈëÈÕÆÚʱ¼ä£¿
´óÏÀÃÇ£ºÏÂÃæµÄ³ÌÐòÔËÐÐʱ×ÜÌáʾÕâÑùµÄ´íÎó£º
Warning: mssql_query() [function.mssql-query]: message: 'date' ²»ÊÇ¿ÉÒÔʶ±ðµÄ º¯ÊýÃû¡£ (severity 15) in F:\guest\sub_guest.php on line 20
Warning: mssql_query() [function.mssql-query]: Query failed in F:\guest\sub_guest.php on line 20
°ï濴һϣ¬Ð»Ð»
<?php session_start();?>
<?php
$conn=mssql_connect("WWW-LIUWEI","","") or die("Êý¾Ý¿âÁ¬½Ó´íÎó£¡");
mssql_select_db("guest",$conn);
function unhtml($content)
{
$content=htmlspecialchars($content);
$content=str_replace(chr(13)," <br>",$content);
$content=str_replace(chr(13)," ",$content);
$content=str_replace(chr(13)," ",$content);
return trim($content);
}
$title=$_POST[title];
$content=$_POST[content];
$username=$_POST[username];
$sql="insert into guest(guest_title,guest_content,guest_username,submit_date)values('$title','$content','$username',date('Y-m-d'))";
$query=mssql_query($sql,$conn);?>
<script language="javascript">
window.alert(" <?php echo "ÁôÑԳɹ¦£¡"?>");
window.opener.parent.location="index.php";
window.close();
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
1.¾«Í¨ÃæÏò¶ÔÏóµÄÉè¼ÆºÍ¿ª·¢£»
2.ÊìÁ·Ê¹ÓÃPHPÓïÑÔ(5.0+)½øÐÐÊý¾Ý¿â£¬ÍøÂçͨÐÅ£¬Îļþ¶Áд£¬°²È«»úÖÆµÈ¿ª·¢£»
3.ÊìÁ·Ê¹ÓÃMYSQL(5.0+)Êý¾Ý¿â¿ª·¢£¬°üÀ¨»ù±¾µÄÊý¾Ý¿âÉè¼Æ/ÓÅ»¯/°²È«£¬¸´ÔÓµÄT-SQLÓï¾ä±àд£¬ÊìÁ·±àдMYS ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......