PHP Ïò±íÖÐÌí¼Ó¼Ç¼
Ïò±íÖÐÌí¼Ó¼Ç¼£¬Í¨³£ÒªÊ¹ÓÃÈçϵÄSQLÓï¾ä¡£
INSERT INTO $table_name(field1,field2,field3,......)values('value1','value2','value3'......)
ÆäÖÐ$table_name Ϊָ¶¨µÄ±íÃû£»field1¡¢field2¡¢field3·Ö±ðΪ±íÖÐ×Ö¶ÎÃû£»value1¡¢value2¡¢value3Ôò·Ö±ðΪ×Ö¶Îfield1¡¢field2¡¢field3Ëù¶ÔÓ¦µÄÖµ¡£
ʵÀýÈçºÎÌí¼Óмͼ£º
<?php
$hostname="datahost";
$dbuser="sa";
$dbpasswd="123";
$dbname="tempdb";
$conn=mssql_connect($hostname,$dbuser,$dbpasswd);
mssql_select_db($dbname);
$t_name="my_table";
$insert_t="insert into $t_name(id,name)values('1','ÕÅÈý')";
$result=mssql_query($insert_t,$conn);
if ($result)
{
echo"<font color=#666666>Òѳɹ¦Ïò±í</font><strong><font color=green>".$t_name."</font></strong><font color=#666666>ÖÐÌí¼Ó¼Ç¼£¡</font>";
}
else
{
echo"Ìí¼Óʧ°ÜÁË£¡";
}
mssql_close($conn);
?>
½á¹ûÑÝʾ£ºhttp://mingking.limewebs.com/db/insert_fields.php
Ïà¹ØÎĵµ£º
ÏÐÀ´Óпգ¬Ñ§Ï°Ò»ÏÂPHPµÄMVCģʽ£¬³äʵһÏÂ×ÔÎÒ£¬²»ÖÁÓÚÂäºó¡£¿´Á˸ö¼òµ¥µÄʾÀý
£¬×öµã¼Ç¼¡£
µ¥µãÈë¿Ú£º
1. ËùÓгÌÐò¶¼ÊÇͨ¹ýindex.phpÀ´½øÐе÷Óõģ¬ÕâÒª¿¿.htaccessÎļþÀ´½øÐпØÖÆ¡£
2. URL router¿ÉÒÔÓɵ¥¶ÀµÄRouterÀàÀ´½øÐÐControllerµÄÑ¡Ôñ£¬Ò²¿ÉÒÔ·ÅÔÚindex.phpÖнøÐÐÑ¡Ôñ¡£
3. Config×îºÃ·Åµ½µ¥¶ÀµÄÎļþÖУ¬½á ......
php ͨÓõĵ÷Óà soµÄ·½·¨ÊÇʹÓÃdl()º¯Êý£¬µ«ÊÇÔÚphp5.3Ö®ºó²»ÔÙÖ§³ÖÕâÖÖ·½·¨£¬½öÖ§³Ö¾²Ì¬µ÷Óã¬Ê¹ÓÃdl() ¶¯Ì¬µ÷Óõķ½·¨¼û£º
ÒýÓÃÒ³1: http://tech.idv2.com/2007/07/06/use-local-so-in-php/
¸ÐлÔ×÷ÕßÌṩµÄÇåÎúÃ÷Á˵ķ½·¨£¬µ«ÊÇÎÒÔÚ5.3.1°æ±¾iÖÐûÓÐͨ¹ý£¬ÓÚÊÇÎÒÕÒµ½ÁËÒ³Ãæ£º
  ......
PHPÖвå¼þ»úÖÆµÄÒ»ÖÖʵÏÖ·½°¸
ÕâÆªÎÄÕµijö·¢µãÊÇÓÉÓÚÒ»ÅóÓÑÎÊÎÒÊÇ·ñ»á²å¼þ£¬ÒÔ¼°¶Ô²å¼þ»úÖÆÊÇ·ñÀí½â£¬¼°ÆäÔÚPHPÖеÄʵÏÖ¡£ÎÒµ±Ê±ÈÏΪ²»¾ÍÊÇÒ»¸ö¹¦ÄܵÄʵÏÖô£¬ºÇºÇ¡£Ïë·¨ºÜ¼òµ¥£¬ÔÚÍøÉϲéÁËһϣ¬²ÅÖªµÀÔÀ´²»ÊÇÄÇô¼òµ¥µÄÒ»»ØÊ£¬ÔÚÍøÉÏժ¼ÁËÒ»¸ö·½·¨£¬´Ë·½°¸½öÊDzå¼þ»úÖÆÔÚPHPÖеÄʵÏÖ·½°¸Ö®Ò»£¬ÕªÂ¼ÏÂÀ´ºÍ´ó¼Ò·Ö ......
Linux°æ±¾£º Red Hat Enterprise Linux 5
Nginx°æ±¾£º nginx 0.8.34
PHP°æ±¾£º php 5.2.13
MySQL°æ±¾£º5.0.22
phpËùÐèÖ§³Ö¿â£ºlibiconv¡¢libmcrypt¡¢mhash¡¢mcrypt
1¡¢±àÒë°²×°phpËùÐèÖ§³Ö¿â
# tar zxvf libiconv-1.13.tar.gz
# cd libiconv-1.13/
# ./configure --prefix=/usr/local
# make &a ......
Á¬½Óµ½Êý¾Ý¿âÖ®ºó£¬¼´¿ÉÔÚÊý¾Ý¿âÖд´½¨ËùÐèÒªµÄ±í¡£ÔÚÊý¾Ý¿âÖд´½¨±í£¬¿ÉÒÔͨ¹ýÊÇÓÃPHPµÄMSSQL¿âº¯ÊýÖеÄmssql_query()º¯ÊýÖ´ÐÐÏàÓ¦µÄ½¨±íSQLÓï¾äÀ´ÊµÏÖ¡£º¯Êýmssql_query()ÊÇרÃÅÓÃÓÚÖ´ÐÐSQLÓï¾äµÄº¯Êý£¬¸Ãº¯Êý´úÂë¸ñʽ£º
mixed mssql_query(string query[,resource link_identifier[,int batch_size]])
¸Ãº¯Êý²ÎÊ ......