PHPÓëMYSQLµÄÎÊÌâ
ÎÒÔÚas4Éϰ²×°ÁËmysqlºÍphp-mysql
rpm -qa | grep php-mysql
php-mysql-4.3.9-3.22.4
rpm -qa | grep MySQL
MySQL-shared-4.1.20-0
MySQL-devel-standard-4.1.20-0.rhel4
MySQL-client-4.1.20-0
MySQL-server-standard-4.1.20-0.rhel4
¿ÉÊÇÔÚä¯ÀÀÆ÷´ò¿ªweb²âÊÔÒ³ÃæÊ±¿Õ°×£¬¾ßÌå²âÊÔphpÎļþÈçÏ£º
more testconnectmysql.php
<?php
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "ʧ°Ü!";
else echo "³É¹¦!";
mysql_close();
?>
¶ø´ò¿ªÆäËûphpÎļþÕý³££¬Èç
more test.php
<?
phpinfo();
?>
ÇëÎʸÃÈçºÎ½â¾ö£¬Ð»Ð»¡£
ÊDz»ÊÇphp-mysql»¹ÒªÅäÖÃɶ¶«Î÷ÄØ£¿
²¹³äÒ»¾äphp-mysqlºÍmysql¶¼ÊÇrpm°²×°µÄ
./mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 4.1.20-standard
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
¿ÉÒÔ·ÃÎÊsqlµÄ¡£
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; Error handling and logging ;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; error_reporting is a bit-field. Or each number up to get desired error
; reporting level
; E_ALL  
Ïà¹ØÎÊ´ð£º
ÔÚ¹úÍâµÄ¿Õ¼ä£¬ÆäËüµÄphpÕ¾µã¶¼Õý³££¬¿ÉÖ»ÓÐ×î½ü½¨µÄÕâ¸öÕ¾µã£¬Ö»ÒªÒ»ä¯ÀÀphpÎļþ¾Í³öÏÖÏÂÔØÌáʾ£¬ÏÂÔØÏÂÀ´µÄÎļþ¶¼ÊÇ´øÓÐphpÔ´Â룬¸÷λ·¹ýµÄ£¬°ï°ïÎÒ£¬¿´¿´Ê²Ã´ÔÒò£¬ÏÈлÁË¡£
¿ÉÄÜÊÇÒòΪ¸ÃÕ¾µãûÓÐÄãÏëÒªµÄä¯ÀÀÆ ......
Ôڲɼ¯Ò»¸öÒ³ÃæµÄʱºòͨ³£¶¼ÊÇʹÓÃ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: ......
ÇëÎÊ£¬ÒÔÏ´úÂ룬Ϊʲô²»¹ÜÓ㿾Ístr_replaceÕâ¸öº¯Êý£¬Ì滻ôÓÐÆð×÷Óã¿
PHP code:
$gg='<script type=\"text/JavaScript\">
alimama_pid=\"mm_14281022_2030060_8250750\";
alima ......