No. | ¼ÁÌ䡦²óÅú | ¤ª¤ì¤¤ |
|
[72521] PHP½é¿´¼Ô¤Ç¤¹¡£php4¤Ç¡¢mysql¤Ø¼Â¹Ô¤·¤¿¥¯¥¨¥ê¤ÎSQLSTATE(5·å¡Ë¤ò¼èÆÀ¤·¤¿¤¤¤¬¡¢¤¦¤Þ¤¯¤¤¤«¤Ê¤¤¡£ |
|
|
OS: Windows XP pro
¥½¥Õ¥È¥¦¥§¥¢Ì¾/¥Ð¡¼¥¸¥ç¥ó:mysql4.0.20¡¢php 4.3.7.7
¥Ï¡¼¥Éµ¡¼ï̾/·¿ÈÖ:
¥¨¥é¡¼¥á¥Ã¥»¡¼¥¸¤Ê¤É:
¥¯¥¨¥ê¤Î¼Â¹Ô·ë²Ì¤Î¥³¡¼¥É(SQLSTATE)¤ò¼èÆÀ¤·¤è¤¦¤È»×¤¤¡¢Ä´¤Ù¤¿¤Î¤Ç¤¹¤¬¤è¤¯¤ï¤«¤ê¤Þ¤»¤ó¡£
SQLSTATE¤ò¼èÆÀ¤¹¤ë´Ø¿ô(mysqli_sqlstate)¤¬ÍÑ°Õ¤µ¤ì¤Æ¤¤¤ë¤è¤¦¤Ç¤¹¤¬¡¢¤½¤Î´Ø¿ô¤ò»ÈÍѤ¹¤ë¤È¡¢¡ØFatal error: Call to undefined function: mysqli_sqlstate() in ¡¦¡¦¡¦¡¦¡¦¡Ù¤È¤¤¤¦´Ø¿ô̤ÄêµÁ¤Î¥¨¥é¡¼¤È¤Ê¤ê¤Þ¤¹¡£
¥Í¥Ã¥È¤ÇÄ´¤Ù¤¿¤Î¤Ç¤¹¤¬¡¢¡Ø¤³¤ì¤é¤Î´Ø¿ô¤ò͸ú¤Ë¤¹¤ë¤Ë¤Ï¡¢mysqli³ÈÄ¥¥µ¥Ý¡¼¥È¤ò ͸ú¤Ë¤·¤ÆPHP¤ò¥³¥ó¥Ñ¥¤¥ë¤¹¤ëɬÍפ¬¤¢¤ê¤Þ¤¹¡£¡Ù ¤È¤¤¤¦¤³¤È¤Ç¤·¤¿¡£
¢¤½¤Î¾ðÊ󤬷Ǻܤµ¤ì¤Æ¤¤¤¿¥Ú¡¼¥¸
http://72.14.203.104/search ?q=cache:kznezJnFZB0J:php.new21.com/manual/ja/ref.mysqli.php +php4+sqlstate&hl=ja &lr=lang_ja
¾åµ¤Î¥Ú¡¼¥¸¤Î¥¤¥ó¥¹¥È¡¼¥ë¼ê½ç¤òÆɤߤޤ·¤¿¤¬¡¢¤¤¤Þ¤¤¤Á¥¤¥á¡¼¥¸¤¬¤Ä¤«¤á¤Þ¤»¤ó¡£
´õ˾¤È¤·¤Æ¤Ï¡¢¤³¤Î³ÈÄ¥µ¡Ç½¤ò»ÈÍѤ·¤Ê¤¯¤Æ¤â¡¢SQL¤Î¼Â¹Ô·ë²Ì¤ò¡¢¤Ê¤ó¤À¤«¤Î¥³¡¼¥É¤Ç¼èÆÀ¤Ç¤¤ì¤Ð¤è¤¤¤Î¤Ç¤¹¤¬¡¢¤³¤Îµ¡Ç½¤ò»ÈÍѤ·¤Ê¤¯¤Æ¤ÏÉÔ²Äǽ¤Ê¾ì¹ç¡¢¤³¤Î³ÈÄ¥µ¡Ç½¤Î¥¤¥ó¥¹¥È¡¼¥ë¤Î»ÅÊý¤ò¶µ¤¨¤Æ¤¤¤¿¤À¤±¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£
µ¹¤·¤¯¤ª´ê¤¤Ãפ·¤Þ¤¹¡£
¤½¤Î¾:
makotori 2005ǯ11·î12Æü12:33
|
|
|
|
[72524] |
>¾åµ¤Î¥Ú¡¼¥¸¤Î¥¤¥ó¥¹¥È¡¼¥ë¼ê½ç¤òÆɤߤޤ·¤¿¤¬¡¢¤¤¤Þ¤¤¤Á¥¤¥á¡¼¥¸¤¬¤Ä¤«¤á¤Þ¤»¤ó¡£
¾Ü¤·¤¯Ä´¤Ù¤¿¤ï¤±¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¤¬¡¢¤Á¤ç¤Ã¤È¸«¤¿¤È¤³¤í¡¢
¤³¤ì¤Ï¡¢UNIX¤Ê¤É¤Î¥ª¡¼¥×¥ó¥½¡¼¥¹¤Ç¤è¤¯¹Ô¤Ê¤ï¤ì¤Æ¤¤¤ë¡¢¥½¡¼¥¹¥³¡¼¥É¤«¤é¥³¥ó¥Ñ¥¤¥ë¤·¤Æ¥Ð¥¤¥Ê¥ê¤òºîÀ®¤¹¤ëÊýË¡¤Ë¤Ä¤¤¤Æ½ñ¤«¤ì¤Æ¤¤¤ë¤è¤¦¤Ç¤¹¡£
Windows´Ä¶¤Ç¤Ï¡¢C¥³¥ó¥Ñ¥¤¥é¤¬É¸½à¤Ç¤Ï¥¤¥ó¥¹¥È¡¼¥ë¤µ¤ì¤Æ¤¤¤Þ¤»¤ó¤Î¤Ç¡¢¼Â¹Ô¤¹¤ë¤Î¤ÏÆñ¤·¤¤¤«¤â¤·¤ì¤Þ¤»¤ó¤Í¡£
¡Ê¤Ò¤ç¤Ã¤È¤¹¤ë¤È¡¢¤³¤Î¥ª¥×¥·¥ç¥ó¤Ç¥³¥ó¥Ñ¥¤¥ë¤·¤¿¥Ð¥¤¥Ê¥ê¤¬¤É¤³¤«¤ÇÆþ¼ê¤Ç¤¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡Ë
>¥½¥Õ¥È¥¦¥§¥¢Ì¾/¥Ð¡¼¥¸¥ç¥ó:mysql4.0.20¡¢php 4.3.7.7
>´õ˾¤È¤·¤Æ¤Ï¡¢¤³¤Î³ÈÄ¥µ¡Ç½¤ò»ÈÍѤ·¤Ê¤¯¤Æ¤â¡¢SQL¤Î¼Â¹Ô·ë²Ì¤ò¡¢¤Ê¤ó¤À¤«¤Î¥³¡¼¥É¤Ç¼èÆÀ¤Ç¤¤ì¤Ð¤è¤¤¤Î¤Ç¤¹¤¬
¤³¤Á¤é¤Î¾ðÊó¤Ç¤Ï¡Ö¤³¤Î´Ø¿ô(mysql_sqlstate)¤Ï MySQL 4.1.1 ¤ÇÄɲ䵤ì¤Þ¤·¤¿¡×¤È¤Î¤³¤È¤Ê¤Î¤Ç¡¢MySQL 4.1.1¤ËÊѤ¨¤Æ¤ß¤Æ¤Ï¤É¤¦¤«¤È»×¤¤¤Þ¤¹¤¬¡¢¤¤¤«¤¬¤Ç¤·¤ç¤¦¤«¡©
MySQL 4.1 ¥ê¥Õ¥¡¥ì¥ó¥¹¥Þ¥Ë¥å¥¢¥ë -- 11.1.3.52 mysql_sqlstate()
http://dev.mysql.com/doc/refman/4.1/ja/mysql-sqlstate.html
MySQL 4.1 ¥ê¥Õ¥¡¥ì¥ó¥¹¥Þ¥Ë¥å¥¢¥ë -- 12.1 ÊÖ¤µ¤ì¤ë¥¨¥é¡¼
http://dev.mysql.com/doc/refman/4.1/ja/error-returns.html
maido (2696) 2005ǯ11·î12Æü13:30
|
+10 p
|
|
|
[72525] |
¼ºÎé¡£
MySql¤Î³ÈÄ¥µ¡Ç½¤ò¥µ¥Ý¡¼¥È¤Ç¤¤ëPHP¤¬É¬Íפʤó¤Ç¤¹¤è¤Í¡£
¤â¤¦¾¯¤·Ä´¤Ù¤Æ¤ß¤Þ¤¹¡£
¡Ê¤¿¤À¡¢MySql¤ÎÊý¤ÏMySQL 4.1.2°Ê¾å¤Ë¤¹¤ëɬÍפ¬¤¢¤ë¤È»×¤ï¤ì¤Þ¤¹¡Ë
maido (2696) 2005ǯ11·î12Æü13:50
|
|
|
|
[72530] |
¤³¤Á¤é¤ÎÀâÌÀ¤Ë¤è¤ë¤È¡ÖPHP5¤«¤é»È¤¨¤ë¤è¤¦¤Ë¤Ê¤Ã¤¿MySQL³ÈÄ¥¥µ¥Ý¡¼¥È¤ò»È¤¦¤È¡Á¡×¤È¤Ê¤Ã¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢PHP5¤Ë¤¹¤ëɬÍפ¬¤¢¤ë¤è¤¦¤Ç¤¹¡£
http://www.thinkit.co.jp/free/marugoto/1/3/1/1.html
¤Þ¤¿¡¢¤³¤Á¤é¤Ë¤ÏPHP5¤ÎWindowsÈǤΥ¤¥ó¥¹¥È¡¼¥ë¤Ë¤Ä¤¤¤Æ½ñ¤«¤ì¤Æ¤¤¤Þ¤¹¤Î¤Ç¡¢»²¹Í¤Ë¤·¤Æ¤ä¤Ã¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡£
http://livedocs.macromedia.com/dreamweaver/8_jp/using/wwhelp /wwhimpl/common/html/wwhelp.htm?context=LiveDocs_Parts &file=gs_18_q6.htm
¾åµ¤Î¥Ý¥¤¥ó¥È¤Ï¡¢
¡¡¡¦PHP¤Î¥À¥¦¥ó¥í¡¼¥ÉÀè¤Ï¤³¤Á¤é¤Ç¡¢
¡¡¡¡³Æ¥Õ¥¡¥¤¥ë¤Ï²¼µ¤Î¡Ê¡ËÆâ¤Î¤â¤Î¤È»×¤ï¤ì¤Þ¤¹
¡¡¡¡http://www.php.net/downloads.php
¡¡¡¦¡ÖWindows PHP 5.x ¥¤¥ó¥¹¥È¡¼¥é¡×¤ò¥À¥¦¥ó¥í¡¼¥É¤·¤Æ¥¤¥ó¥¹¥È¡¼¥ë¤¹¤ë
¡¡¡ÊPHP 5.0.5 installer [2,336Kb] - 9 Sep 2005¡Ë
¡¡¡¡
¡¡¡¦MySQL ¤òÁàºî¤¹¤ë¤¿¤á¤ËɬÍפʳÈÄ¥µ¡Ç½¤¬Æþ¤Ã¤¿¡ÖWindows PHP 5.x ¤Î
¡¡¡¡zip ¥Ñ¥Ã¥±¡¼¥¸¡×¤ò¥À¥¦¥ó¥í¡¼¥É¤·¤ÆÁȤ߹þ¤à
¡¡¡ÊPHP 5.0.5 zip package [7,825Kb] - 05 Sep 2005¡Ë
¾°¡¢MySQL¤ÎÊý¤Ï¡¢4.1.2°Ê¹ß¤¬É¬ÍפǤ¹¡£
maido (2696) 2005ǯ11·î12Æü16:28
|
|
|
|
[72532] |
¡ÖPHP 4¤«¤éPHP 5¤Ø¤Î°Ü¹Ô¡×¤Ë¤Ä¤¤¤Æ¤Ï¤³¤Á¤é¤â»²¹Í¤Ë¤·¤Æ¤¯¤À¤µ¤¤¡£
¡Ê⤷¡¢±Ñ¸ì¤Ç¤¹¡Ë
Âè 76¾ÏMigrating from PHP 4 to PHP 5
http://www.php.net/manual/ja/faq.migration5.php
±Ñ¸ì¤¬¶ì¼ê¤Ê¤é¡¢²¼µ¤Î¥µ¥¤¥È¤Î¡ÖURLÍó¡×¤Ë¾åµURL¤òÆþ¤ì¤ÆËÝÌõ¤¹¤ë¤È¡¢Â¿¾¯¤ÏÌò¤ËΩ¤Ä¤«¤â¤·¤ì¤Þ¤»¤ó¡Ê¤ï¤«¤ê¤ä¤¹¤¯Ìõ¤µ¤ì¤ë¤ï¤±¤Ç¤Ï¤¢¤ê¤Þ¤»¤ó¤¬¡Ë
http://www.excite.co.jp/world/english/web/
maido (2696) 2005ǯ11·î12Æü16:42
|
|
|
|
[72662] |
ËÜÅö¤Ë¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡ª¤È¤Æ¤âͱפʾðÊó¤Ë´¶¼ÕÃפ·¤Þ¤¹¡£
¿§¡¹¤Ê¤´Äó°Æ¤ò¤·¤Æĺ¤¤Þ¤·¤¿¤¬¡¢
>¤³¤Á¤é¤Î¾ðÊó¤Ç¤Ï¡Ö¤³¤Î´Ø¿ô(mysql_sqlstate)¤Ï MySQL 4.1.1 ¤ÇÄɲ䵤ì¤Þ¤·
>¤¿¡×¤È¤Î¤³¤È¤Ê¤Î¤Ç¡¢MySQL 4.1.1¤ËÊѤ¨¤Æ¤ß¤Æ¤Ï¤É¤¦¤«¤È»×¤¤¤Þ¤¹¤¬¡¢¤¤¤«¤¬
>¤Ç¤·¤ç¤¦¤«¡©
¤³¤ÎÊýË¡¤ò»î¤·¤¿¤¤¤È»×¤Ã¤Æ¤ª¤ê¤Þ¤¹¡£
¡mysql¤ò°ìÅÙ¡¢¥¢¥ó¥¤¥ó¥¹¥È¡¼¥ë¤·¤Æ¤«¤é¡¢ºÆ¥¤¥ó¥¹¥È¡¼¥ë¡£
¢¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×
¤Î2Ä̤꤬¤¢¤ë¤«¤È»×¤¤¤Þ¤¹¤¬¡¢¥¢¥ó¥¤¥ó¥¹¥È¡¼¥ëÊýË¡¤ÎÀâÌÀ¤ò¤·¤Æ¤¤¤ë¥µ¥¤¥È¤¬°Ê³°¤Ë¾¯¤Ê¤¯¡¢ÊýË¡¤¬¤ï¤«¤ê¤Þ¤»¤ó¡£
¤Þ¤¿¤Ï¡¢¥Ð¡¼¥¸¥ç¥ó¥¢¥Ã¥×¤ÎÊýË¡¤ò¤´»ØÆ¤¿¤À¤±¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡£
makotori 2005ǯ11·î14Æü23:27
|
|
|
|
[72666] |
>¥¢¥ó¥¤¥ó¥¹¥È¡¼¥ëÊýË¡¤ÎÀâÌÀ¤ò¤·¤Æ¤¤¤ë¥µ¥¤¥È¤¬°Ê³°¤Ë¾¯¤Ê¤¯¡¢ÊýË¡¤¬¤ï¤«¤ê¤Þ¤»¤ó¡£
»ä¤Î¥¤¥ó¥¹¥È¡¼¥ë¤·¤¿¡Ömysql-5.0.15-win32¡×¤Î¾ì¹ç¤Ï¡¢
¡¡¥³¥ó¥È¥í¡¼¥ë¥Ñ¥Í¥ë¢ª¥×¥í¥°¥é¥à¤ÎÄɲäȺï½ü¡¡¤Ë¡ÖMySQL Server 5.0¡×¤È¤¤¤¦¤Î¤¬¤¢¤ë¤Î¤Ç¡¢¤½¤³¤Ç¡Öºï½ü¡×¤È¤¹¤ì¤Ð¤¤¤¤¤è¤¦¤Ç¤¹¡£
¡Ê¡Ömysql4.0.20¡×¤ËƱÍͤʤâ¤Î¤¬¤¢¤ê¤Þ¤»¤ó¤«¡©¡Ë
¤Ç¤¤ë¤À¤±¡¢°ìö¥¢¥ó¥¤¥ó¥¹¥È¡¼¥ë¤·¤Æ¤«¤é¿·¤·¤¤¥Ð¡¼¥¸¥ç¥ó¤ò¥¤¥ó¥¹¥È¡¼¥ë¤·¤Æ¤¯¤À¤µ¤¤¡£
¾°¡¢¡Ömysql-5.0.15-win32¡×¤Ï¤³¤Á¤é¤Î¥Ú¡¼¥¸¤ÎÃæ¤Û¤É¤Î¥ê¥ó¥¯¤«¤é¥À¥¦¥ó¥í¡¼¥É¤·¤¿¤â¤Î¤Ç¤¹¡£
¡ÊWindows (x86) 5.0.15 33.7M ¡Ë
http://dev.mysql.com/downloads/mysql/5.0.html
maido (2696) 2005ǯ11·î14Æü23:50
|
|
|
|
( »²¾È¿ô:2022 ÆüÊ¿¶Ñ:0.3 ) |
|
¡Á¡¡²óÅú¤Î¼õÉÕ¤ò½ªÎ»¤·¤Þ¤·¤¿¡¡¡Á |