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·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ
¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃfile_get_contents($url)
²»¹ý·µ»ØµÄ½á¹ûÓÐʱºò»á²»È«
Èç¹ûÔÚhtmlÖÐʹÓà document.ready,ÔÚÒ³Ãæ×¼±¸ºÃºó£¬Ê¹ÓÃajax¶ÁÈ¡±ðÒ»²¿·ÖµÄÊý¾Ý
ÔÙͨ¹ýÐÞ¸Ähtml±êÇ©µÄÄÚÈÝ£¬¾Í²¿·ÖµÄÊý¾Ý¾ ......
ÏÈÉÏ´íÎó
ÎÞ·¨Áª½ÓÊý¾Ý¿â
java.sql.SQLException: Before start of result set
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......