yandod/plain.php

## plain.php
<?php
$keyword = '';
if (isset($_POST['keyword'])) {
    $keyword = $_POST['keyword'];
}

mysql_connect('localhost','user','password');
mysql_select_db('cakephp_sample');
mysql_query('set names utf8');
$sql = sprintf(
  "SELECT id,name,description FROM friends WHERE name LIKE '%s'",
  mysql_real_escape_string('%'.$keyword.'%')
);
$result = mysql_query($sql);
$data = array();
while ($row = mysql_fetch_assoc($result)) {
  $data[] = $row;
}
?>
<html>
<head><title>テストページ</title></head>
<body>
<form action="list1.php" method="POST">
<input name="keyword"><input type="submit">
</form>
<ul>
<?php
foreach ($data as $row) {
    echo '<li>';
    echo $row['name'];
    echo $row['description'];
    echo '</li>';
}
?></ul>
</body></html>
	<?php
	$keyword = '';
	if (isset($_POST['keyword'])) {
	$keyword = $_POST['keyword'];
	}

	mysql_connect('localhost','user','password');
	mysql_select_db('cakephp_sample');
	mysql_query('set names utf8');
	$sql = sprintf(
	"SELECT id,name,description FROM friends WHERE name LIKE '%s'",
	mysql_real_escape_string('%'.$keyword.'%')
	);
	$result = mysql_query($sql);
	$data = array();
	while ($row = mysql_fetch_assoc($result)) {
	$data[] = $row;
	}
	?>
	<html>
	<head><title>テストページ</title></head>
	<body>
	<form action="list1.php" method="POST">
	<input name="keyword"><input type="submit">
	</form>
	<ul>
	<?php
	foreach ($data as $row) {
	echo '<li>';
	echo $row['name'];
	echo $row['description'];
	echo '</li>';
	}
	?></ul>
	</body></html>