<?php
$con = mysql_connect('localhost','root','admin');
if(mysql_select_db('ktv',$con))
echo"³É¹¦";
else echo"Ñ¡Ôñʧ°Ü";
$query = "INSERT INTO `ktv`.`roomlist` (`ROOMNUM`, `STYLE`, `LOCATION`, `CONDITION`, `PRICE`, `CAPACITIES`) VALUES (\'217\', \'´ó°üÏá\', \'AÇø\', \'Âú\', \'80\', \'20\');";
if($query==true){
echo "sucess";
} else{
echo "Êý¾Ý²åÈë³ö´í";
}
mysql_close();
?>
Õâ¶ÎsqlÓï¾äÊÇÓÃphpmyadminÖ±½ÓÉú³ÉµÄ£¬ÎªÊ²Ã´ÓÐÓÒб¸ÜÄØ£¿
Õâ¶Î´úÂëÊä³ö:³É¹¦sucess£¬ µ«ÊÇÊý¾Ý¿âÖÐûÓÐÔö¼Ó¼Ç¼ ÊÇÎªÊ²Ã´ÄØ£¿
ÔÚÏßµÈ
ÓÒб¸ÜÊǵ¥ÒýºÅµÄתÒå
ÄÇΪʲôÏÔʾsucess£¬µ«ÊÇÊý¾Ý¿âÀïµÄ¼Ç¼ȴûÓÐÔö¼ÓÄØ
Õâ¸öÓ¦¸ÃÊÇÒ»¸öÌí¼ÓµÄ²Ù×÷£¬ÄãÌí¼ÓÖ®ºó£¬µÃÓÐÒ»¸öÅжϲÅÐУ¬¼ÙÈçÄãÄǸöÌí¼Ó°´Å¥µÄnameֵΪadd
PHP code:
<?php
if(isset($_POST['add'])){
$con = mysql_connect('localhost','root','admin');
if(mysql_select_db('ktv',$con))
echo"³É¹¦";
else echo"Ñ¡Ôñʧ°Ü";
$query = "INSERT INTO `ktv`.`roomlist` (`ROOMNUM`, `STYLE`, `LOCATION`, `CONDITION`, `PRICE`, `CAPACITIES`) VALUES (\'217\', \'´ó°üÏá\', \'AÇø\', \'Âú\', \'80\', \'20\');";
if($query==true){
echo "sucess";
} else{
echo "Êý¾Ý²åÈë³ö´í";
}
mysql_close();
}
?>
ÎÒÔÚÍøÕ¾µÄÒýµ¼Ò³ÖÐÌí¼ÓÁË<embed src="ÒôÀÖµØÖ·" autostart="true" loop="true" hidden="true"></embed>
Õâ¾ä»°£¬È»ºóÌø×ªÒ³Ãæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......