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();
}
?>
Ïà¹ØÎÊ´ð£º
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ĿǰÔÚÎ人ÕÒ¹¤×÷
·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ
Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü
»¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³
Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......