phpÓëmysqlÁ¬½ÓÎÊÌâ
<?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>
Õâ¾ä»°£¬È»ºóÌø×ªÒ³Ãæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
Çë¸ßÊÖÃǸø½éÉܼ¸±¾ºÃÊ飡
ÊÖ²áºÜÖØÒªµÄàÞ£¡~
ÎÒ¶¼ÊÇÐÂÊÖ Ò»Æë¼ÓÓÍ
Ò»°ã¶¼ÊÇÊÖ²áµÄÀ²£¬ÔÙ¼ÓÉÏÒ»±¾ÊµÀý½²½â
php´ÓÈëÃŵ½¾«Í¨ Õâ±¾ÊéÀïÓкöà´íµÄµØ·½¡£
È¥ÂòÊ¥¾°É£¬ÄDZ¾Ê黹²»´í£¬ÁíÍâÄǸö18.8MµÄÊÖ²áÒ ......
²ËÄñÇó¾È£¡£¡
ÏÖÔÚÎÒÊÖÍ·ÓÐÒ»¸öphp+oracleµÄÍøÕ¾¡£¡£·þÎñÆ÷ÊÇlinuxϵͳ
Çë¸÷λ¸æËßÎÒÈçºÎ·¢²¼¡£¡£¡£ÎÒÊÇÐÂÊÖ¡£Ð»Ð»ÁË£¡£¡
°²×°Ò»¸öapache£¬°ÑphpÎļþ·Åµ½apacheµÄ·¢²¼Ä¿Â¼Ï£¬ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......