php Mysql 20221208授業 db_sample01.phpとinput.phpのソース
fittingmindコピーした後に[UTF-8]のLFに文字コード変換してください。
またphpはパーミッションの変更はしません。
db_sample01.php
<?php
function db_connect(){
//データベース接続
$server = “localhost”;
$server = “mysql1.php.xdomain.ne.jp”;
$userName = “ibarakiclass_uwa”;
$password = “Te9236St”;
$dbName = “ibarakiclass_wata “;
$mysqli = new mysqli($server, $userName, $password,$dbName);
if ($mysqli->connect_error){
echo $mysqli->connect_error;
exit();
}else{
$mysqli->set_charset(“utf-8”);
}
return $mysqli;
}
?>
—————————————————————–
input.php
<!DOCTYPE_html>
<html_lang=”ja”>
<head>
<meta_charset=”UTF-8″>
<title>データベース初歩</title>
</head>
<body>
<center>
<!—メニュー——>
<table>
<tr>
<td><a href=”index.php”>HOME</a></td>
<td><a href=”view.php”>view</a></td>
<td><a href=”search.php”>search</a></td>
<td><a href=”edit.php”>edit</a></td>
<td><a href=”delete.php”>delete</a></td>
</tr>
</table>
<!—メニュー——>
<!——php———————————————>
<?php
$name = $_POST[‘name’];
$address = $_POST[‘address’];
$tel = $_POST[‘tel’];
$mail = $_POST[‘mail’];
//echo “name = “.$name.” address = “.$address.” tel = “.$tel.” mail = “.$mail;
//データベースの接続と選択
//$host=”ibarakiclass_uwa:3306″;
$host=”mysql1.php.xdomain.ne.jp”;
$username=”ibarakiclass_uwa”;
$password=”Te9236St”;
$dbname=”ibarakiclass_wata”;
$mysqli = new mysqli($host, $username, $password, $dbname);
if ($mysqli->connect_error) {
printf($mysqli->connect_error);
exit;
}
//SQLを実行
$sql=”INSERT INTO ibarakiclass_wata (name,address,tel,mail) VALUES (‘”.$name.”‘,'”.$address.”‘,'”.$tel.”‘,'”.$mail.”‘)”;
//echo ” sql = “.$sql;
$res = $mysqli->query($sql);
if (!$res) {
printf($mysqli->error);
exit;
}
//結果の出力
$HTLM=””;
$query = “SELECT * FROM ibarakiclass_wata ORDER by id ASC LIMIT 0,50”;
if ($result = $mysqli->query($query)) {
while ($row = $result->fetch_assoc()) {
// printf(“%s (%s)\n”, $row[“name”], $row[“address”]);
$HTLM = $HTLM.”
<tr>
<td>
“.$row[“id”].”
</td>
<td>
“.$row[“name”].”
</td>
<td>
“.$row[“address”].”
</td>
<td>
“.$row[“tel”].”
</td>
<td>
“.$row[“mail”].”
</td>
</tr>
“;
}
$result->close();
}
//接続のクローズ
$mysqli->close();
?>
<div>
<table border=”1″>
<?=$HTLM?>
</table>
</div>
<p>登録が完了しました。<br /><a href=”index.php”>戻る</a></p>
<!——php———————————————>
</body>
</html>
