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();
}
?>
Ïà¹ØÎÊ´ð£º
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ
¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......
ÎÒÔÚÍøÕ¾µÄÒýµ¼Ò³ÖÐÌí¼ÓÁË<embed src="ÒôÀÖµØÖ·" autostart="true" loop="true" hidden="true"></embed>
Õâ¾ä»°£¬È»ºóÌø×ªÒ³Ãæºó£¬±³¾°ÒôÀÖ¾ÍûÓÐÁË£¬ÔõôÈÃÕ ......
¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿
MySQL 5.1²Î¿¼ÊÖ²á
ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á
baidu
MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......
index.phpÄÚÈÝ£º
$smarty->assign('name',strtotime('-0'));
$smarty->display("index.html");
index.htmlÄÚÈÝ£º
{$name|date_format:'%Y-%m-%d'}<hr>
{$ ......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......