
ãPHPå ¥éç·šã#6 ãšã³ãžãã¢ãã¬ãŒãã³ã°ç ä¿®ïŒæ²ç€ºæ¿å¶äœäœéšïŒ
ååWeek5ããPHPå ¥éç·šã#5 ãšã³ãžãã¢ãã¬ãŒãã³ã°ç ä¿®ïŒå€æ¬¡å é åã颿°ãSQLãªã©ïŒããšé¡ããŠãäž»ã«ã颿°ãã®ããã°ã©ãã³ã°ã®åŠç¿å å®¹ãæŽçããŠã¢ãŠããããããŸããð»
ä»åWeek6ããPHPå
¥éç·šã#6 ãšã³ãžãã¢ãã¬ãŒãã³ã°ç ä¿®ïŒæ²ç€ºæ¿å¶äœäœéšïŒããšé¡ããŠãäž»ã«ãWebã¢ããªéçºå
¥é PHP+MySQLç·š1: æ²ç€ºæ¿ãäœãããã®ããã°ã©ãã³ã°ã®åŠç¿å
å®¹ãæŽçããŠã¢ãŠããããããŠãããŸãð»
ãã©ãŒã ã§ã¡ãã»ãŒãžãæçš¿
æ²ç€ºæ¿ã®æçš¿ãã©ãŒã ãäœãå 容ãåŠç¿ããŸããããã®ããã«ããã©ãŒã ã®ä»çµã¿ãšäœãæ¹ãåŠç¿ããã¡ãã»ãŒãžããµãŒããŒã§åä¿¡ãããšãããŸã§åãçµã¿ãŸããã
以äžð»ã®ããã«ã³ãŒããæã€ããšã§æçš¿ãã©ãŒã ãäœæããããšãã§ããŸãããinputã®textã®ãšãããradio buttonãªã©ã«å€æŽãå¯èœã§ãã
<h2>æçš¿ãã©ãŒã </h2>
  <form action="#" method="">
  <input type="text" name="content">
  <button type="submit">éä¿¡</button>
</form>ãããšç°¡åãªãã©ãŒã ã§ã¡ãã»ãŒãžãæçš¿ããããšãã§ããŸããð¡
éä¿¡ã®åã®ð²ãã¯ããå°ãæ ã倧ããã§ãð
paizaæ²ç€ºæ¿
æçš¿ãã©ãŒã
ð²ãéä¿¡
ç¶ããŠphpã§åŠç¿ããifæã®é£æ³é
åãçµã¿èŸŒã¿ãŸãð»
<?php
print_r($_post);
if(isset($_post["content"])){
  $content = $_post["content"];
} else {
  $content = "ãªã";
}
echo "æçš¿å
容ãåä¿¡ïŒ".$content;
?>print_r($_post); ã¯åãåã£ãããŒã¿ã衚瀺ãããæå³ã§æžããŠããŸãã
å ã¿ã«ãisset()ïŒã€ãºã»ããïŒãšã¯ãäžèšã§èšããšããã®å€æ°ãé
åã®äžã«ãã¡ãããšããŒã¿ãå
¥ã£ãŠãããã©ããã調ã¹ãããã®ç¢ºèªã¹ã¿ã³ããã®ãããªé¢æ°ã ããã§ãã
PHPã§ããŒã¿ããŒã¹ã«æžã蟌ãã
æçš¿ãã©ãŒã ããåä¿¡ããããŒã¿ãããŒã¿ããŒã¹ã«æžã蟌ãåŠç¿ãããŸããã以äžð»å°ãé·ãã®ã§ããã<body>ã®äžèº«ã®phpã®èšè¿°ã«çç®ããŠããã ããŠã
$pdo = new PDO("mysql:host=127.0.0.1;dbname=lesson;charset=utf8", "root", "");ãšæåã«æã¡ãŸããifæã®äžèº«ã以äžð»ã®ããã«èšè¿°ããŠã¿ãŸããã
if (isset($_POST["content"])) {
$content = $_POST["content"];
$sql = "INSERT INTO bbs(content, updated_at) VALUES(:content, NOW());";
$stmt = $pdo ->prepare($sql);
$stml = bindvalue(":content", $content, PDO::PARAM_STR);
$stmt -> execute();
}äœãé·æã§ããåãããªãã®ã§ããïŒè§£å床ãäžããã®ãå°é£ðŠïŒã
å
šäœåã¯ä»¥äžð»ã®éãã§ããããšã«ããæ¢ç¿äºé
ã§ããifæãçšããŠããŒã¿ããŒã¹ã«æžã蟌ããã®èšè¿°ã«ãªããŸãã
<!DOCTYPE html>
<html lang="ja">
<head>
ãã<meta charset="utf-8">
ãã<title>paizaæ²ç€ºæ¿</title>
</head>
<body>
ãã<?php
ãã$pdo = new PDO("mysql:host=127.0.0.1;dbname=lesson;charset=utf8", "root", "");
// åãåã£ãããŒã¿ã衚瀺
print_r($_POST);
if (isset($_POST["content"])) {
$content = $_POST["content"];
$sql = "INSERT INTO bbs(content, updated_at) VALUES(:content, NOW());";
$stmt = $pdo ->prepare($sql);
$stml = bindvalue(":content", $content, PDO::PARAM_STR);
$stmt -> execute();
}
else {
$content = "ãªã";
}
echo "æçš¿å
容ãåä¿¡:" . $content;
?>
<h1>paizaæ²ç€ºæ¿</h1>
<h2>æçš¿ãã©ãŒã </h2><form action="bbs.php" method="post">
ãã<label>æçš¿å
容</label>
ãã<input type="text" name="content">
ãã<button type="submit">éä¿¡</button>
</form>
<h2>çºèšãªã¹ã</h2>
<table>
<tr>
<th>id</th>
<th>æ¥æ</th>
<th>æçš¿å
容</th>
</tr>
<tr>
<td>1</td>
<td>2016-10-14</td>
<td>ããã«ã¡ã¯</td>
</tr>
</table>äœãšãªãä»ãŸã§ç¿ã£ãç¥èãç©ã¿éãªã£ãŠWebã¢ããªãªããããŒã ããŒãžãå¶äœãããŠããã®ãð¡ãšèããããããŸããã
ãã®æ¥ã¯ãããŸã§ã®åŠç¿ã§ããã
æ²ç€ºæ¿ã®æ©èœããŸãšããã
ãããŸã§äœã£ãŠããæ©èœãã²ãšã€ã«ãŸãšããŠããã£ããæ²ç€ºæ¿ã宿ãããŸãããWebã¢ããªã±ãŒã·ã§ã³ãšããŠåœ¢ã«ãªããšããããªãã®æããããããã§ãããïŒ
以äžð»ã®ããã«ãwhileæãã䜿çšããŠã³ãŒããæã€ããšã§æ²ç€ºæ¿ã®çºèšãªã¹ãã䞊ã¹ãããšãåºæ¥ãŸãã
<h2>çºèšãªã¹ã</h2>
<?php
// ããŒã¿ããŒã¹ããããŒã¿ãååŸãã
$sql = "SELECT * FROM bbs ORDER BY updated_at;";
$stmt = $pdo->prepare($sql);
$stmt -> execute();
?>
<table>
  <tr>
<th>id</th>
<th>æ¥æ</th>
<th>æçš¿å
容</th>
</tr>
ãã Â <?php
  ã  while ($row = $stmt -> fetch(PDO::FETCH_ASSOC)) { ?>
    <tr>
      <td><?= $row["id"] ?></td>
      <td><?= $row["updated_at"] ?></td>
      <td><?= $row["content"] ?></td>
  </tr>
 <?php } ?>
</table>çºèšãªã¹ã
ãidããããæ¥æããããæçš¿å
容
1ã2016-10-16 01:00:00ãããã«ã¡ã¯
2ã2016-10-16 02:00:00ãããããã
3ã2016-10-16 03:00:00ãããããªã
4ã2016-10-16 04:00:00ãhello paizaãŸãã以äžð»ã®ããã«ã³ãŒãã£ã³ã°ãè¡ããšç°¡åãªæçš¿ãç»é¢äžã«è¡šç€ºããããšãåºæ¥ãŸãã
<h2>æçš¿ãã©ãŒã </h2>
<form action="bbs.php" method="post">
  <label>æçš¿å
容</label>
  <input type="text" name="content">
  <button type="submit">éä¿¡</button>
</form>ããã¯äžèšããã©ãŒã ã§ã¡ãã»ãŒãžãæçš¿ãã«ãèŒããŠããŸã
éä¿¡ã®åã®ð²ãã¯ããå°ãæ ã倧ããã§ãð
æçš¿ãã©ãŒã
ð²ãéä¿¡æåŸã«ã³ãŒãå ã®bodyã®åé ã§ãifæããçšããŠæçš¿ãã©ãŒã ã«æžã蟌ã¿ãããŠããåºŠã«æŽæ°ããããèšå®ãè¡ããŸãð»ãã»ã»ã»ã»ãã¯çç¥ã§äžèšã®ãwhileæãã®ç®æã«ç¹ãã£ãŠããŸãã
<?php
$pdo = new PDO("mysql:host=127.0.0.1;dbname=lesson;charset=utf8", "root", "");
print_r($_POST);
  Â
if(isset($_POST["content"])) {
  $content = $_POST["content"];
  $sql = "INSERT INTO bbs (content, updated_at) VALUES (:content, NOW());";
  $stmt = $pdo -> prepare($sql);
  $stmt -> bindvalue("content",$content, PDO::PARAM_STR);
  $stmt -> excute();
}
?>
.
.
.
.
<?php } ?>ããæçš¿ãã©ãŒã ã«äœãã³ã¡ã³ããæžããŠéä¿¡ãã¿ã³ãæŒããšãïŒã®ã³ã¡ã³ããèªåçã«è¿œå ãããŸãããç§ã¯ã³ãŒããæžããŠtryããŸãããã³ã¡ã³ãã远å ãããã«åèŠå «èŠããŸããð äœããå šè§ã§ãã£ãããã¹ããŒã¹ãåè§ã§ãªãã£ãããããšãã°ãçããã®ã§èªå·±è§£æ±ºèœåãå¿ èŠã§ãð¡
paizaæ²ç€ºæ¿ã
æçš¿ãã©ãŒã
æçš¿ãã©ãŒã
ð²ãéä¿¡
ãidããããæ¥æããããæçš¿å
容
1ã2016-10-16 01:00:00ãããã«ã¡ã¯
2ã2016-10-16 02:00:00ãããããã
3ã2016-10-16 03:00:00ãããããªã
4ã2016-10-16 04:00:00ãhello paizaãã®æ¥ã®åŠç¿ã¯ãããŸã§ã§ããã
ãªããªãè€éã§ã¯ãããŸãããç°¡åãªæ²ç€ºæ¿å¶äœäœéšãéããŠä»ãŸã§ç¿ã£ãäºã®å¿çšã§ãµã€ãå¶äœãå¯èœã§ããããšãåãããŸããð¡
æ®ãã®æéã¯BootstrapãåŠãã ããVisual Studio Code (VSã³ãŒã) ã䜿ã£ãŠå®éã«HTML/CSSã«ã³ãŒããæžããŠå®è£ ããäœéšãªã©ãããŒã ããŒãžã®æ§é ã«ã€ããŠåŸ©ç¿ãšãããåŠç¿ãé²ããŠãããŸããã
Paizaã䜿çšããphpã®ãšã³ãžãã¢ãã¬ãŒãã³ã°ã¯ä»¥äžã«ãªããŸããä»ãŸã§ã®åºç€ã®æŠå¿µãã©ã掻ãããã¯èªå次第ãªã®ã§ããããããªã¹ããªã³ã°ã§åŠãã äºãä»åŸã®äººçã«æŽ»ãããŠãããã°ãšèããŠããŸãâºïž

ä»åãèªãã§ããã ããããããšãããããŸããðââïž
#php
#ãšã³ãžãã¢ãã¬ãŒãã³ã°
#ããã°ã©ãã³ã°
#ããŒã ããŒãžå¶äœäœéš