編集履歴

回答編集履歴

修正

2018/08/19 16:45

投稿

スコア0

test CHANGED Viewed

@@ -1,75 +1 @@
-```php
-<td><a href='2.php?name=$name'><?php print $name; ?></a></td>
-```
-↓
-```php
-<td><a href='2.php?name=<?php echo urlencode($name) ?>'><?php print $name; ?></a></td>
-```
-```php
-    $sql = "SELECT id,name,price from juices where name='$name'";
-    $statement = $database->query($sql);
-    $records = $statement->fetchAll();
-```
-↓
-```php
-    $sql = "SELECT id,name,price from juices where name=:name";
-    $database->prepare($sql);
+質問者が質問を消したようなので削除
-    $statement = $database->execute([':name' => $name]);
-    $records = $statement->fetchAll();
-```
-```php
-$id = $_GET["id"];
-$price = $_GET["price"];
-$title = $_GET["title"];
-```
-↓
-```php
-$id = $_GET["id"];
-$price = $_GET["price"];
-$title = $_GET["title"];
-$name = $_GET["name"];
-```

修正

2018/08/19 16:45

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

@@ -73,293 +73,3 @@
 $name = $_GET["name"];
 ```
----
-# Sample
-```sql
-CREATE TABLE `sample` (
-  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `name` varchar(64) NOT NULL DEFAULT '',
-  PRIMARY KEY (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-INSERT INTO `sample` (`id`, `name`)
-VALUES
-	(1,'Suzuki'),
-	(2,'Sato');
-```
-```php
-<?php
-/**
- * common.php
- * @since 2018/08/19
- */
-// 文法エラーを表示する
-ini_set('display_errors', true);
-error_reporting(E_ALL);
-/**
- * XSS対策
- * @param string $string
- * @return string
- */
-function h(string $string)
-{
-	return htmlspecialchars($string, ENT_QUOTES, 'utf-8');
-}
-/**
- * PDOオブジェクトを取得
- * @return \PDO
- */
-function getPdo()
-{
-	$dsn = 'mysql:host=localhost;dbname=sample;charset=utf8mb4';
-	$user = 'root';
-	$password = 'password';
-	$option = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION];
-	$pdo = new PDO($dsn, $user, $password, $option);
-	return $pdo;
-}
-/**
- * レコードセットを取得
- * @param string $sql
- * @param array $params
- * @return array
- */
-function select($sql, $params = [])
-{
-	$pdo = getPdo();
-	$stmt = $pdo->prepare($sql);
-	$stmt->execute($params);
-	return $stmt->fetchAll();
-}
-/**
- * レコードを取得
- * @param string $sql
- * @param array $params
- * @return array
- */
-function selectOne($sql, $params = [])
-{
-	$pdo = getPdo();
-	$stmt = $pdo->prepare($sql);
-	$stmt->execute($params);
-	return $stmt->fetch();
-}
-```
-```php
-<?php
-/**
- * index.php
- * @since 2018/08/19
- */
-// 共通関数を読み込む
-require 'common.php';
-$rows = select('SELECT id, name FROM `sample` WHERE 1');
-?>
-<!DOCTYPE HTML>
-<html lang="ja">
-	<head>
-		<meta charset="UTF-8">
-		<title>LIST</title>
-	</head>
-	<body>
-		<div>
-			<table>
-				<thead>
-					<tr>
-						<th>NAME</th>
-					</tr>
-				</thead>
-				<tbody>
-					<?php foreach ($rows as $row): ?>
-						<tr>
-							<td>
-								<a href="detail.php?id=<?php echo h($row['id']) ?>">
-									<?php echo h($row['name']) ?>
-								</a>
-							</td>
-						</tr>
-					<?php endforeach; ?>
-				</tbody>
-			</table>
-		</div>
-	</body>
-</html>
-```
-```php
-<?php
-/**
- * detail.php
- * @since 2018/08/19
- */
-require 'common.php';
-$id = filter_input(INPUT_GET, 'id');
-$row = selectOne('SELECT * FROM `sample` WHERE id = :id', [':id' => $id]);
-?>
-<!DOCTYPE HTML>
-<html lang="ja">
-	<head>
-		<meta charset="UTF-8">
-		<title></title>
-	</head>
-	<body>
-		<p><?php echo h($row['name']); ?></p>
-	</body>
-</html>
-```

追記

2018/08/19 15:31

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

@@ -73,3 +73,293 @@
 $name = $_GET["name"];
 ```
+---
+# Sample
+```sql
+CREATE TABLE `sample` (
+  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
+  `name` varchar(64) NOT NULL DEFAULT '',
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+INSERT INTO `sample` (`id`, `name`)
+VALUES
+	(1,'Suzuki'),
+	(2,'Sato');
+```
+```php
+<?php
+/**
+ * common.php
+ * @since 2018/08/19
+ */
+// 文法エラーを表示する
+ini_set('display_errors', true);
+error_reporting(E_ALL);
+/**
+ * XSS対策
+ * @param string $string
+ * @return string
+ */
+function h(string $string)
+{
+	return htmlspecialchars($string, ENT_QUOTES, 'utf-8');
+}
+/**
+ * PDOオブジェクトを取得
+ * @return \PDO
+ */
+function getPdo()
+{
+	$dsn = 'mysql:host=localhost;dbname=sample;charset=utf8mb4';
+	$user = 'root';
+	$password = 'password';
+	$option = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION];
+	$pdo = new PDO($dsn, $user, $password, $option);
+	return $pdo;
+}
+/**
+ * レコードセットを取得
+ * @param string $sql
+ * @param array $params
+ * @return array
+ */
+function select($sql, $params = [])
+{
+	$pdo = getPdo();
+	$stmt = $pdo->prepare($sql);
+	$stmt->execute($params);
+	return $stmt->fetchAll();
+}
+/**
+ * レコードを取得
+ * @param string $sql
+ * @param array $params
+ * @return array
+ */
+function selectOne($sql, $params = [])
+{
+	$pdo = getPdo();
+	$stmt = $pdo->prepare($sql);
+	$stmt->execute($params);
+	return $stmt->fetch();
+}
+```
+```php
+<?php
+/**
+ * index.php
+ * @since 2018/08/19
+ */
+// 共通関数を読み込む
+require 'common.php';
+$rows = select('SELECT id, name FROM `sample` WHERE 1');
+?>
+<!DOCTYPE HTML>
+<html lang="ja">
+	<head>
+		<meta charset="UTF-8">
+		<title>LIST</title>
+	</head>
+	<body>
+		<div>
+			<table>
+				<thead>
+					<tr>
+						<th>NAME</th>
+					</tr>
+				</thead>
+				<tbody>
+					<?php foreach ($rows as $row): ?>
+						<tr>
+							<td>
+								<a href="detail.php?id=<?php echo h($row['id']) ?>">
+									<?php echo h($row['name']) ?>
+								</a>
+							</td>
+						</tr>
+					<?php endforeach; ?>
+				</tbody>
+			</table>
+		</div>
+	</body>
+</html>
+```
+```php
+<?php
+/**
+ * detail.php
+ * @since 2018/08/19
+ */
+require 'common.php';
+$id = filter_input(INPUT_GET, 'id');
+$row = selectOne('SELECT * FROM `sample` WHERE id = :id', [':id' => $id]);
+?>
+<!DOCTYPE HTML>
+<html lang="ja">
+	<head>
+		<meta charset="UTF-8">
+		<title></title>
+	</head>
+	<body>
+		<p><?php echo h($row['name']); ?></p>
+	</body>
+</html>
+```

追記

2018/08/19 11:12

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

@@ -47,3 +47,29 @@
     $records = $statement->fetchAll();
 ```
+```php
+$id = $_GET["id"];
+$price = $_GET["price"];
+$title = $_GET["title"];
+```
+↓
+```php
+$id = $_GET["id"];
+$price = $_GET["price"];
+$title = $_GET["title"];
+$name = $_GET["name"];
+```