No title
PHP
<?php
$pdo = new PDO('mysql:host=localhost;dbname=co_19_271_99sv_coco_com', 'co-19-271.99sv-c', 'Xc5tnWDA');
$pdo->query('CREATE TABLE IF NOT EXISTS kadai3_1_users (
id INT(5) AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(20),
password VARCHAR(20)
)');
if(isset($_POST['name']) && isset($_POST['password'])){
if(strlen($_POST['name']) && strlen($_POST['password'])){
$name = $_POST['name'];
$password = $_POST['password'];
$stmt = $pdo->prepare('INSERT INTO kadai3_1_users (name, password) VALUES (:name, :password)');
$flag = $stmt->execute(array(':name' => $name, ':password' => $password));
$user_id = $pdo->lastinsertid();
if ($flag){
print('ユーザー登録が完了しました<br>');
echo 'あなたのユーザー情報<br/>';
echo "ID: ".$user_id;
echo "<br/>";
echo "名前: ".$name;
echo "<br/>";
echo "パスワード: ".$password;
echo "<br/>";
echo "<br/>";
}else{
print('ユーザー登録に失敗しました<br>');
}
}else{
echo '未入力の項目があります<br/>';
}
}
echo "ユーザー一覧<br/>";
$result_rows = $pdo->query('SELECT * FROM kadai3_1_users');
foreach ( $result_rows as $row ) {
echo "{$row['id']}";
echo " {$row['name']}";
echo "<br/>";
}
echo "<br/>";
?>
<!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
</head>
<body>
<h1>新規登録フォーム</h1>
<form action="kadai3_1_signup.php" method="post">
<p>名前</p>
<input type = "text" name ="name"><br/>
<p>パスワード</p>
<input type = "text" name ="password"><br/>
<input type = "submit" value ="送信"><br/>
</form>
<a href="http://co-19-271.99sv-coco.com/kadai3_1_top.php">投稿ページ</a>
</body>
</html>