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
Ïà¹ØÎĵµ£º
ÈýÄêǰתÓïÑÔ×öÁËJ2ee£¬½ñÌìÎÒÓֻص½µÄԵ㡣ÈýÄêǰÎÒÓÃPHPµÄ¿ª·¢ÍøÕ¾µÄ·½Ê½½øÈëÁËÈí¼þÕâ¸öÐÐÒµ£¬Ã»Ïëµ½ÏÖÔÚÎÒÓÖ»ØÀ´ÁË£¬ÕõÔú×ÅÍ´¿àµÄ»ØÀ´ÁË¡£
½«À´µÄÈí¼þ¿ª·¢ºÍ¹ÜÀíÎÒ½«×¨×¢ÓÚ»¥ÁªÍø¼¼ÊõµÄ·¢Õ¹¡£
ÀÎɧ·¢ÍêÁË¡£ÏÖÔÚÈÃÎÒÀ´¼Ç¼һÏÂÎÒ¶ÔSESSIONµÄdz¼û°É¡£
ͨ¹ýini_set('session.use_trans_sid', 0);ÉèÖÃÔËÐл·¾³ÖйØÓÚSESS ......
°²×°»·¾³£ºVMware Workstation 5.5.0 build-18463
Linux°æ±¾£ºRed Hat Enterprise Linux AS (2.6.9-42.EL)
Èí¼þ°æ±¾£ºMySQL5 - mysql-5.0.37.tar.gz
¡¡¡¡¡¡¡¡¡¡Apache2 - httpd-2.2.4.tar.gz
¡¡¡¡¡¡¡¡¡¡PHP5 - php-5.2.1.tar.gz
¡¡¡¡¡¡¡¡¡¡(½«ÒÔÉÏÎļþ±£´æÖÁ/home/tmpĿ¼)
[MySQL]
# cd /home/tmp (½øÈëѹËõ°ü ......
1. ÓÃPHP´òÓ¡³öǰһÌìµÄʱ¼ä£¬´òÓ¡¸ñʽÊÇ2007Äê5ÔÂ10ÈÕ 22:21:21
2. PHP´úÂëÈçÏ£º
$a="hello";
$b=&$a;
unset($b);
$b="world";
echo $a;
Æä½á¹ûÊÇ£¿
3. PHP´úÂëÈçÏ£º
$str="cd";
$$str="landog";
$$str.="ok";
echo $cd;
Æ ......
fedora8 ÓÃyumÀ´¹ÜÀí°²×°Apache+PHP+MysqlµÄ»ù±¾°²×°¡£
1. °²×°Apahce, PHP, Mysql, ÒÔ¼°phpÁ¬½Ómysql¿â×é¼þ¡£
yum -y install httpd php mysql mysql-server php-mysql
2. ÅäÖÿª»úÆô¶¯·þÎñ
/sbin/chkconfig httpd on [ÉèÖÃapache·þÎñÆ÷httpd·þÎñ¿ª»úÆô¶¯]
......