mysql:2517
From: finx <finx <finx@xxxxxxxxxx>>
Date: Fri, 29 Sep 2000 15:52:08 +0900
Subject: [mysql 02517] MySQL
¤Ï¤¸¤á¤Þ¤·¤Æ¡£¤«¤Ê¤¯¤é¤È¿½¤·¤Þ¤¹¡£ TurboLinux Server 6.1¤ËMySQL+PHP3.0.15-i18n-ja+Apache1.3.12¤ò¥¤¥ó¥¹¥È¡¼¥ë ¤·¤ÆPHP+MySQL¤Î´Ä¶¤òºî¤í¤¦¤È¤·¤Æ¤¤¤Þ¤¹¡£ MySQL¤ÈPHP¤ÎϢư¤ò³Îǧ¤·¤¿¤¤¤¿¤á¡¢²¼µ¤Î¤è¤¦¤Ê¥¹¥¯¥ê¥×¥È¤ò http://www.softagency.co.jp/mysql/TIPS/php3/connect.html ¤ò¤â¤é¤Ã¤Æ¤¤Æ¡¢test_mysql_php.php3¤È¤·¡¢¥Ö¥é¥¦¥¶¤«¤éɽ¼¨¤ò»î¤½¤¦¤È¤·¤¿¤È ¤³¤í¡¢ Fatal error: Call to unsupported or undefined function mysql_connect() in /home/httpd/html/test_mysql_php.php3 on line 2 ¤È¤¤¤¦¤è¤¦¤Ê¥¨¥é¡¼¤¬½Ð¤Æ¤¤Æ¤·¤Þ¤¤¤Þ¤¹¡£ php3.ini¤¬´Ø·¸¤¹¤ë¤Î¤«¤È»×¤¤¡¢´Ø·¸¤·¤½¤¦¤Ê¤È¤³¤í¤Ï > mysql.default_host =127.0.0.1 ; > default host for mysql_connect() (doesn't apply in safe mode) > mysql.default_user = root ; default user for mysql_connect() (doesn't apply in safe mode) > mysql.default_password = ¤È¤¤¤¦¤è¤¦¤ËÀßÄê¤òÊѤ¨¤Æ¤ß¤¿¤Î¤Ç¤¹¤¬¤³¤ì¤Ç¤âÊѲ½¤¬Ìµ¤¤¤è¤¦¤Ê¤Î¤Ç¤¹¡£ 2½µ´Ö¤°¤é¤¤Çº¤ß³¤±¤Æ¤¤¤ë¤Î¤Ç¤¹¤¬¡¢¤â¤·²ò·è¤Î¥Ý¥¤¥ó¥È¤ä»å¸ý¤¬¤ï¤«¤ì¤Ð¤ª¶µ ¤¨Äº¤±¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£ o ÃÖ¤¤¤¿php¥Õ¥¡¥¤¥ë > <?php > $conn = mysql_connect("localhost"); // server ̾¡¢¥æ¡¼¥¶¡¼Ì¾¡¢¥Ñ¥¹¥ï¡¼¥É¤òÍ¿¤¨¤ÆÀܳ > > mysql_select_db("test", $conn); // $conn ¤Ï¾Êά¤Ç¤¤ë > $result = mysql_query("select * from a", $conn); // query > > // mysql_select_db ¤È mysql_query ¤ò»ÈÍѤ¹¤ë¤«¤ï¤ê¤Ë mysql_db_query ¤¬»ÈÍѤǤ¤ë > //$result = mysql_db_query("test", "select * from a", $conn); > > $num = mysql_num_rows($result); > > echo $num . ": " . mysql_result($result, 0, "a"); echo "<BR>\n"; // query ·ë²Ìɽ¼¨ > > > > // test ¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Æ¡¼¥Ö¥ë̾¤òÁ´¤Æɽ¼¨ > $result = mysql_list_tables("test"); > > $i=0; $loop=mysql_num_rows($result); > while($i < $loop) { > $tb_names[$i]=mysql_tablename($result, $i); > echo $tb_names[$i] . "<BR>"; > $i++; > } > > ?> --- finx@clara finx@xxxxxxxxxx
-> 2517 2000-09-29 15:52 [finx <finx@xxxxxxxxx] MySQL 2518 2000-09-29 16:17 ¨²[Yasuhide OMORI / Âç¿] 2536 2000-09-29 16:44 ¨²[ISHIDA Akio <iakio@x] 2673 2000-11-03 15:46 ¨±[tateyan <tateyan@xxx] 2688 2000-11-09 09:33 ¡¡¨±["s a s a n o" <zaza@] MySQL ¤Î¥Á¥å¡¼¥È¥ê¥¢¥ë 2689 2000-11-09 10:24 ¡¡¡¡¨±[Yukihiro KAWADA <kaw] 2690 2000-11-09 20:20 ¡¡¡¡¡¡¨±["s a s a n o" <zaza@]