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µÄÁ÷ÐУ¬¾ø²»ÊÇżȻµÄ£¬¸÷ÖÖ¿ªÔ´¸¨ÖúÏîÄ¿Æðµ½Á˲»Ð¡µÄ×÷Óá£
1. ·¢ËÍÓʼþ phpmailer
2. ¹ÜÀíÓû§ Php user class
3. ץȡRSSժҪ Magpie RSS
4. »ñÈ¡·ÃÎÊÕߵĵØÀíÐÅÏ¢ Maxmind
5. »ñȡԶ³ÌÄÚÈÝ htmlSQL class
6. Trackback php trackback
7. Ä£°åϵͳ£¬µ±È»¾ÍÊÇSmarty ÁË
8. BBcode StringParser_B ......
Óà PHP ¶ÁÈ¡ºÍ±àд XML DOM
ʹÓà DOM ¿â¡¢SAX ½âÎöÆ÷ºÍÕýÔò±í´ïʽ
ÓÐÐí¶à¼¼Êõ¿ÉÓÃÓÚÓà PHP ¶ÁÈ¡ºÍ±àд XML¡£±¾ÎÄÌṩÁËÈýÖÖ·½·¨¶ÁÈ¡ XML£ºÊ¹Óà DOM ¿â¡¢Ê¹Óà SAX ½âÎöÆ÷ºÍʹÓÃÕýÔò±í´ïʽ¡£»¹½éÉÜÁËʹÓà DOM ºÍ PHP Îı¾Ä£°å±àд XML¡£
Óà PHP ¶ÁÈ¡ºÍ±àд¿ÉÀ©Õ¹±ê¼ÇÓïÑÔ£¨XML£©¿´ÆðÀ´¿ÉÄÜÓеã¿Ö²À¡£Êµ¼ÊÉÏ£¬XML ºÍËüµÄË ......
php ͨÓõĵ÷Óà soµÄ·½·¨ÊÇʹÓÃdl()º¯Êý£¬µ«ÊÇÔÚphp5.3Ö®ºó²»ÔÙÖ§³ÖÕâÖÖ·½·¨£¬½öÖ§³Ö¾²Ì¬µ÷Óã¬Ê¹ÓÃdl() ¶¯Ì¬µ÷Óõķ½·¨¼û£º
ÒýÓÃÒ³1: http://tech.idv2.com/2007/07/06/use-local-so-in-php/
¸ÐлÔ×÷ÕßÌṩµÄÇåÎúÃ÷Á˵ķ½·¨£¬µ«ÊÇÎÒÔÚ5.3.1°æ±¾iÖÐûÓÐͨ¹ý£¬ÓÚÊÇÎÒÕÒµ½ÁËÒ³Ãæ£º
  ......
1 MYSQLÖеÄ×Ö·û¼¯¸ÅÄî
MysqlµÄ×Ö·û¼¯ÀïÓÐÁ½¸ö¸ÅÄһ¸öÊÇ"Character set£¨×Ö·û¼¯£©"£¬ÁíÒ»¸öÊÇ"Collations"¡£
1.1 Collations
Collations·³ÉÖÐÎÄÊÇ"УÑé"£¬ÔÚÍøÒ³¿ª·¢µÄ¹ý³ÌÖУ¬Õâ¸ö´Ê»ã£¬Ö»ÔÚMysqlÀïʹÓã¬Ö÷Òª×÷ÓÃÊÇÖ¸µ¼Mysql¶Ô×Ö·ûµÄ±È½Ï£¬±ÈÈ磬 ASCII×Ö·û¼¯ÀCol ......
Á¬½Óµ½Êý¾Ý¿âÖ®ºó£¬¼´¿ÉÔÚÊý¾Ý¿âÖд´½¨ËùÐèÒªµÄ±í¡£ÔÚÊý¾Ý¿âÖд´½¨±í£¬¿ÉÒÔͨ¹ýÊÇÓÃPHPµÄMSSQL¿âº¯ÊýÖеÄmssql_query()º¯ÊýÖ´ÐÐÏàÓ¦µÄ½¨±íSQLÓï¾äÀ´ÊµÏÖ¡£º¯Êýmssql_query()ÊÇרÃÅÓÃÓÚÖ´ÐÐSQLÓï¾äµÄº¯Êý£¬¸Ãº¯Êý´úÂë¸ñʽ£º
mixed mssql_query(string query[,resource link_identifier[,int batch_size]])
¸Ãº¯Êý²ÎÊ ......