MySQL�ｿｽ�ｿｽPHP�ｿｽﾌ連�ｿｽg
PHP�ｿｽ�ｿｽ�ｿｽ�ｿｽMySQL�ｿｽ作す�ｿｽ�ｿｽ�ｿｽ�ｿｽ@�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾐ介し�ｿｽﾜゑｿｽ�ｿｽB
PHP�ｿｽAMySQL�ｿｽP�ｿｽﾌでの難ｿｽ�ｿｽ�ｿｽﾍゑｿｽ�ｿｽﾅに奇ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽ驍ｱ�ｿｽﾆゑｿｽ�ｿｽO�ｿｽ�ｿｽﾆなゑｿｽﾜゑｿｽ�ｿｽB
PHP�ｿｽﾌ設抵ｿｽﾍ難ｿｽ�ｿｽT�ｿｽC�ｿｽg�ｿｽ�ｿｽ�ｿｽuPHP�ｿｽi RPM �ｿｽﾅ）�ｿｽﾌ難ｿｽ�ｿｽ�ｿｽ�ｿｽv�ｿｽﾅ会ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽﾜゑｿｽ�ｿｽB
�ｿｽo�ｿｽ[�ｿｽW�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾍゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾆ古ゑｿｽ�ｿｽﾅゑｿｽ�ｿｽ�ｿｽ�ｿｽA�ｿｽ�ｿｽ{�ｿｽI�ｿｽﾉは難ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾆ思�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽB�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾙなゑｿｽ謔､�ｿｽﾅゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽA�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽT�ｿｽC�ｿｽg�ｿｽ�ｿｽ�ｿｽﾅゑｿｽ�ｿｽ�ｿｽ�ｿｽﾗゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽB
MySQL�ｿｽﾌ設抵ｿｽ�ｿｽ�ｿｽ@�ｿｽﾍ難ｿｽ�ｿｽT�ｿｽC�ｿｽg�ｿｽ�ｿｽ�ｿｽuMySQL �ｿｽﾌ難ｿｽ�ｿｽ�ｿｽ�ｿｽv�ｿｽﾅ会ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽﾜゑｿｽ�ｿｽB�ｿｽ�ｿｽ�ｿｽe�ｿｽ�ｿｽ2008�ｿｽN4�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾝ、�ｿｽﾅ新�ｿｽﾌゑｿｽ�ｿｽﾌになゑｿｽ�ｿｽﾄゑｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽB
�ｿｽy�ｿｽ[�ｿｽW�ｿｽ�ｿｽ�ｿｽR�ｿｽ�ｿｽ�ｿｽe�ｿｽ�ｿｽ�ｿｽc�ｿｽ齬�
php-mysql�ｿｽ�ｿｽ�ｿｽW�ｿｽ�ｿｽ�ｿｽ[�ｿｽ�ｿｽ�ｿｽﾌイ�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ
MySQL�ｿｽ�ｿｽPHP�ｿｽﾌ接托ｿｽ�ｿｽ�ｿｽ�ｿｽW�ｿｽ�ｿｽ�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽB
�ｿｽﾅ近ゑｿｽOS�ｿｽﾅは鯉ｿｽ�ｿｽX�ｿｽC�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽ�ｿｽ�ｿｽA�ｿｽ�ｿｽ�ｿｽﾟてイ�ｿｽ�ｿｽ�ｿｽX�ｿｽg�ｿｽ[�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ驍ｱ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾟゑｿｽ�ｿｽﾜゑｿｽ�ｿｽB
�ｿｽ�ｿｽ�ｿｽﾍゑｿｽ�ｿｽ�ｿｽﾅハ�ｿｽ}�ｿｽ�ｿｽﾜゑｿｽ�ｿｽ�ｿｽ�ｿｽB�ｿｽB�ｿｽB
# yum install php-mysql
�ｿｽO�ｿｽﾌゑｿｽ�ｿｽ�ｿｽ Apache �ｿｽ�ｿｽ�ｿｽﾄ起�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽB
# /etc/rc.d/init.d/httpd restart
�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽ�ｿｽ�ｿｽ�ｿｽp�ｿｽﾌ��ｿｽ�ｿｽ[�ｿｽU�ｿｽﾌ作成
�ｿｽ�ｿｽ�ｿｽT�ｿｽC�ｿｽg�ｿｽ�ｿｽ�ｿｽuMySQL �ｿｽﾌ難ｿｽ�ｿｽ�ｿｽ�ｿｽv�ｿｽﾌ抵ｿｽ�ｿｽﾅ紹介し�ｿｽﾄゑｿｽ�ｿｽ�ｿｽu�ｿｽe�ｿｽX�ｿｽg�ｿｽf�ｿｽ[�ｿｽ^�ｿｽﾅ難ｿｽ�ｿｽ�ｿｽm�ｿｽF�ｿｽv�ｿｽﾅ作成�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽ�用�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾆ思�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽB
�ｿｽusample�ｿｽv�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽﾉ対ゑｿｽ�ｿｽﾄ全�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾂ��ｿｽ�ｿｽ[�ｿｽU�ｿｽ�ｿｽ�ｿｽ�成�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽB
# mysql -u root -p �ｿｽ�ｿｽ root�ｿｽﾅ��ｿｽ�ｿｽO�ｿｽC�ｿｽ�ｿｽ Enter password: �ｿｽ�ｿｽ �ｿｽp�ｿｽX�ｿｽ�ｿｽ�ｿｽ[�ｿｽh�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 4.1.20 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant all privileges on �ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽ�ｿｽ.* to �ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽ�ｿｽ@localhost identified by '�ｿｽp�ｿｽX�ｿｽ�ｿｽ�ｿｽ[�ｿｽh'; �ｿｽ�ｿｽ �ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽ�ｿｽ�ｿｽ�成 mysql> \q �ｿｽ�ｿｽ �ｿｽ�ｿｽ�ｿｽO�ｿｽA�ｿｽE�ｿｽg Bye
�ｿｽT�ｿｽ�ｿｽ�ｿｽv�ｿｽ�ｿｽ�ｿｽX�ｿｽN�ｿｽ�ｿｽ�ｿｽv�ｿｽg�ｿｽﾅ難ｿｽ�ｿｽ�ｿｽm�ｿｽF
�ｿｽﾈ会ｿｽ�ｿｽ�ｿｽ�ｿｽQ�ｿｽl�ｿｽﾉサ�ｿｽ�ｿｽ�ｿｽv�ｿｽ�ｿｽ�ｿｽX�ｿｽN�ｿｽ�ｿｽ�ｿｽv�ｿｽg�ｿｽ�ｿｽ�ｿｽ�成�ｿｽ�ｿｽ�ｿｽAPHP�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�す�ｿｽ�ｿｽf�ｿｽB�ｿｽ�ｿｽ�ｿｽN�ｿｽg�ｿｽ�ｿｽ�ｿｽﾉ格�ｿｽ[�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽB �ｿｽp�ｿｽ[�ｿｽ~�ｿｽb�ｿｽV�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾌ設抵ｿｽ�ｿｽ�ｿｽY�ｿｽ黷ｸ�ｿｽﾉ。
�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽR�ｿｽ[�ｿｽh�ｿｽﾍ必�ｿｽ�ｿｽUTF-8�ｿｽﾅ作成�ｿｽ�ｿｽ�ｿｽ�ｿｽ謔､�ｿｽﾉゑｿｽ�ｿｽﾄゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽI
�ｿｽ�ｿｽL�ｿｽX�ｿｽN�ｿｽ�ｿｽ�ｿｽv�ｿｽg�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽs�ｿｽ�ｿｽ�ｿｽA�ｿｽ�ｿｽq�ｿｽﾌ「�ｿｽe�ｿｽX�ｿｽg�ｿｽf�ｿｽ[�ｿｽ^�ｿｽﾅ難ｿｽ�ｿｽ�ｿｽm�ｿｽF�ｿｽv�ｿｽﾅ作成�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽﾈゑｿｽA�ｿｽﾈ会ｿｽ�ｿｽ�ｿｽ�ｿｽ\�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽB<html> <head> <meta http-equiv=content-type content="text/html; charset=UTF-8"> <title>PHP�ｿｽﾌテ�ｿｽX�ｿｽg</title> </head> <body> <?php // �ｿｽT�ｿｽ[�ｿｽo�ｿｽﾚ托ｿｽ $con = mysql_connect("localhost","�ｿｽ�ｿｽ�ｿｽ[�ｿｽU�ｿｽ�ｿｽ","�ｿｽp�ｿｽX�ｿｽ�ｿｽ�ｿｽ[�ｿｽh") or die("�ｿｽﾚ托ｿｽ�ｿｽ�ｿｽ�ｿｽs"); // �ｿｽf�ｿｽ[�ｿｽ^�ｿｽx�ｿｽ[�ｿｽX�ｿｽ�ｿｽI�ｿｽ�ｿｽ mysql_select_db('sample',$con) or die("DB�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾜゑｿｽ�ｿｽ�ｿｽ"); // �ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽh�ｿｽ~�ｿｽﾌゑｿｽ�ｿｽﾜゑｿｽ�ｿｽﾈゑｿｽ $strsql = "SET CHARACTER SET UTF8"; mysql_query($strsql,$con); $strsql = "select * from sample_tbl"; // SQL�ｿｽﾌ趣ｿｽ�ｿｽs $res = mysql_query($strsql,$con); print "�ｿｽﾆ会件�ｿｽ�ｿｽ= " . mysql_num_rows($res) . "<br>"; // �ｿｽW�ｿｽJ while ($item = mysql_fetch_array($res)) { print $item[0]." ".$item[1]."<br>"; } // �ｿｽﾚ托ｿｽ�ｿｽ�ｿｽ�ｿｽN�ｿｽ�ｿｽ�ｿｽ[�ｿｽY mysql_close($con); ?> </body> </html>
�ｿｽﾆ会件�ｿｽ�ｿｽ= 2
1 GODZILLA
2 �ｿｽS�ｿｽW�ｿｽ�ｿｽ
�ｿｽ�ｿｽ�ｿｽ{�ｿｽ黷ｪ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽﾈゑｿｽ�ｿｽ�ｿｽ�ｿｽﾆゑｿｽ�ｿｽm�ｿｽF�ｿｽ�ｿｽ�ｿｽﾄゑｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽ�ｿｽB
�ｿｽﾈ擾ｿｽﾅゑｿｽ�ｿｽB