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×îºÃ·Åµ½µ¥¶ÀµÄÎļþÖУ¬½á ......
±¾ÎÄÈí¼þµÄÏÂÔصØÖ·¾Í²»Áгö£¬Ö÷ÒªÊǼǼ°²×°Ê±µÄ²½Öè¼°Ïà¹ØÎÊÌâµÄ´¦Àí·½·¨£»»ùÓÚ°²×°·½·¨Ä¿Ç°ÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÀûÓÃRPM°ü°²×°£¬Ò»ÖÖÔ´Âë±àÒë°²×°£»ÒÔÏÂÖ÷
ÒªÊÇÒÔÔ´Âë±àÒë°²×°£»ÒòΪԴÂë°²×°Èí¼þµÄÏ໥ÒÀÀµÐÔС£¬°²×°·½Ê½Óø÷ÖÖunix/linuxϵͳ£¬Î¬»¤·½±ã¡£Èç¹ûÏëÈ¥³ýÏà¹Ø·þÎñʱ£¬Ö±½Órm
–rfĿ¼ ¼´¿É£»½¨Òé²ÉÓÃÔ´Âë· ......
ºÜ¶àʱºòÎÒÃÇϲ»¶ÓÃjsÀ´»ñÈ¡ÈÕÆÚºÍʱ¼ä£¬µ«Õâ½ö½öÊÇ¿Í»§¶ËµÄ¡£
ÎÒÃÇ¿ÉÒÔÓÃphpµÄdateº¯Êý¼´¿ÉÀ´»ñÈ¡·þÎñÆ÷ÉϵÄʱ¼ä£º
<?php
//½«Ê±ÇøÉèÖÃΪÖйú
date_default_timezone_set("PRC");
echo date("Y-m-d l H:i:s A");
//ÀýÊä³ö£º2010-03-06 Saturday 11:51:29 AM
?> ......
1 <?php
2 $doc = new DOMDocument('1.0', 'utf-8');
3 $doc->load('./articles.xml');
4
5 $xpath = new DOMXPath($doc);
6 /*
7 * $xpath = domxml_open_file("articles.xml");
8 */
......
Á¬½Óµ½Êý¾Ý¿âÖ®ºó£¬²»µ«¿ÉÒÔÔÚÊý¾Ý¿âÖд´½¨±í£¬Ò²¿ÉÒÔɾ³ýÒѾ´æÔÚµÄ±í¡£É¾³ý±íÒ²ÊÇͨ¹ýmssql_query()º¯ÊýÖ´ÐÐÏàÓ¦µÄɾ³ý±íSQLÓï¾äÀ´ÊµÏÖ¡£
<?php
$hostname="datahost";
$dbuser="sa";
$dbpasswd="123";
$dbname="tempdb";
$conn=mssql_connect($hostname,$dbuser,$dbpasswd);
mssql_select_db($dbname);
$t_na ......