Example #1
0
<?php

require_once "dbfunc.php";
$dbc = new DBConet();
$threads = $dbc->get_data();
?>
<!DOCTYPE html>
<html lang="ja">
  <head>
    <meta charset="utf-8">
    <title>掲示板</title>
    <link rel="stylesheet" href="css/base.css">
  </head>
  <body>
    <div id="container">
      <header>
        <h1>掲示板</h1>
      </header>
      <main role="main">
        <div id="thread-container">
          <dl>
            <?php 
foreach ($threads as $thread) {
    extract($thread);
    $message = nl2br($message);
    ?>
              <dt><?php 
    echo $id . ':' . $user_name . ':' . $timestamp;
    ?>
</dt>
Example #2
0
<?php

require_once 'dbfunc.php';
// index.phpから送られたデータをサニタイジングしてデータベースに挿入
$inputed_data = $_POST;
foreach ($inputed_data as $key => $val) {
    $inputed_data[$key] = htmlspecialchars($val);
}
$dbc = new DBConet();
$is_set = $dbc->set_data($inputed_data);
if ($is_set) {
    $success = $dbc->insert_data();
    if (!$success) {
        echo "データベース接続失敗<br>";
    }
}
$title = $dbc->get_title();
?>
<!DOCTYPE html>
<html lang="ja">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="refresh" content="3; ./index.php"> 
    <title>掲示板</title>
    <link rel="stylesheet" href="css/base.css">
  </head>
  <body>
    <div id="container">
      <header>
        <h1><?php 
echo $title;