yandod · January 24, 2012 14:33 · yandod · Jan 24, 2012 · cognitom · Jan 24, 2012
diff --git a/sample.php b/sample.php
 <html>
 <head>
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
 </head>
 <body>
 <?php

 //DBの接続情報
 $user = 'root';
 $pass = 'pass';
 $name = 'yourdatabase';

 /**
 -- 下記のデータをmysqlの任意のデータベースに登録してください。
 CREATE TABLE IF NOT EXISTS `FOO` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `number` int(11) NOT NULL,
  PRIMARY KEY (`id`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;


 INSERT INTO `FOO` (`id`, `name`, `number`) VALUES
 (1, '下北沢', 10),
 (2, '渋谷', 20);

 **/
 $dbh = new PDO(
        'mysql:host=localhost;dbname='.$name.';charset=utf8',
        $user,
        $pass
 );

 echo '<pre>';
 foreach($dbh->query('SELECT * from FOO') as $row) {
        print_r($row);
 }

 if (function_exists('apache_get_modules')) {
        echo "apache modules\r\n";
        print_r(apache_get_modules());
 } else {
        echo 'not apache';
 }
 ?>
 </body>
 </html>
	<html>
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
	</head>
	<body>
	<?php

	//DBの接続情報
	$user = 'root';
	$pass = 'pass';
	$name = 'yourdatabase';

	/**
	-- 下記のデータをmysqlの任意のデータベースに登録してください。
	CREATE TABLE IF NOT EXISTS `FOO` (
	`id` int(11) NOT NULL AUTO_INCREMENT,
	`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
	`number` int(11) NOT NULL,
	PRIMARY KEY (`id`)
	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;


	INSERT INTO `FOO` (`id`, `name`, `number`) VALUES
	(1, '下北沢', 10),
	(2, '渋谷', 20);

	**/
	$dbh = new PDO(
	'mysql:host=localhost;dbname='.$name.';charset=utf8',
	$user,
	$pass
	);

	echo '<pre>';
	foreach($dbh->query('SELECT * from FOO') as $row) {
	print_r($row);
	}

	if (function_exists('apache_get_modules')) {
	echo "apache modules\r\n";
	print_r(apache_get_modules());
	} else {
	echo 'not apache';
	}
	?>
	</body>
	</html>