Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ■test29.php
- <?php
- var_dump($result);
- var_dump($pdo);
- ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xm1ns="http://www.w3.org/1999/xhtml">
- <html lang="ja">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
- <meta http-equiv="Content-Script-Type" content="text/javascript">
- <title>単語集</title>
- </head>
- <body>
- <style type="text/css">
- <!--
- BODY {
- background-image: url(chocolate3-2.jpg);
- background-repeat: no-repeat;
- background-attachment: fixed;
- background-position: right top;
- }
- -->
- .font1 {
- font-family: "あずきフォント";
- }
- .font2 {
- font-family: "あずきフォント";
- font-size: 160%;
- color: "#e4b9f9";
- }
- .font3 {
- /* padding: 4px; */
- /* font-family: "あずきフォント"; */
- }
- .font4 {
- position:relative;left:15px;
- }
- .font5 {
- border-collapse: collapse; /* 枠線の表示方法 */
- border: 1px #1C79C6 solid; /* テーブル全体の枠線(太さ・色・スタイル) */
- }
- .font {
- font-family: "あずきフォント";
- font-size: 160%;
- color: "white";
- }
- .body {
- cursor: url(hosi5.ani);
- }
- @font-face {
- font-family: 'あずきフォント'; /* お好きな名前に */
- src: url('azuki.eot'); /* IE9以上用 */
- src: url('azuki.eot?#iefix') format('embedded-opentype'), /* IE8以前用 */
- url('azuki.woff') format('woff'), /* モダンブラウザ用 */
- url('azuki.ttf') format('truetype'); /* iOS, Android用 */
- }
- html,body {
- scrollbar-base-color: #c3d7e0;
- scrollbar-track-color: #c3d7e0;
- scrollbar-face-color: #c3d7e0;
- scrollbar-shadow-color: #c3d7e0;
- scrollbar-darkshadow-color: #c3d7e0;
- scrollbar-highlight-color: #c3d7e0;
- scrollbar-3dlight-color: #c3d7e0;
- scrollbar-arrow-color: #ffffff;
- filter: chroma(color = #c3d7e0);
- }
- </style>
- <table bgcolor="#882200" cellpadding="2" cellspacing="0">
- <tr><td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border:hotpink 1px solid;" rowspan="3" bgcolor="lightpink">
- <p>
- <p class="font1" ><font color="white">検索したい文字を入力して下さい</font></p>
- <form action="" method="post">
- <input type="hidden" name="command" value="search">
- <input type="text" name="keyword">
- <input type="submit" value="検索"style="border: 1px solid #ff44ff; color: #ee00ff; background-color: #eeccff;position:relative;left:20px;">
- </form>
- </p>
- <P align="right"><font size="2" color="hotpink">■■■</font></td>
- </tr>
- <tr><td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td></tr>
- <tr><td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td></tr>
- </table>
- <!-- ノートに書く -->
- <table bgcolor="#882200" cellpadding="2" cellspacing="0">
- <tr><td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border:hotpink 1px solid;" rowspan="3" bgcolor="lightpink">
- <p>
- <img src="res-19.gif"><font color="white" class="font1">ノートに書く</font>
- </p>
- <p>
- <form action="" method="post">
- <font color="white" class="font1">ことば<input type="text" size="10" name="word">
- 意味<input type="text" size="30" name="sense"></br>
- メモ<input type="text" class="font4" size="20" name="memo">
- <input type="hidden" name="command" value="insert">
- <input type="submit" value="書く" style="border: 1px solid #ff44ff; color: #ee00ff; background-color: #eeccff;position:relative;left:20px;">
- </form>
- </p>
- <P align="right"><font size="2" color="hotpink">■■■</font></td>
- </tr>
- <tr><td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td></tr>
- <tr><td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td>
- <td style="border-top:chocolate 1px solid;border-left:chocolate 1px solid;border-bottom:black 1px solid;border-right:black 1px solid;" width="20" height="25" valign="bottom" align="right"><font color="peru" size="1"><b>」</b></font></td></tr>
- </table>
- <form action="" method="post">
- <button type="submit" name='button4' value='button4' style="border: 1px solid #ff44ff; color: #ee00ff; background-color: #eeccff;">修正</button>
- </form>
- <form action="" method="post">
- <input type="hidden" name="command" value="listDisplay">
- <input type="submit" value="一覧表示" style="border: 1px solid #ff44ff; color: #ee00ff; background-color: #eeccff;">
- </form>
- <!-- <table border="1" style="border-color:#6c2735; border-style:solid; border-width: 2px;" cellpading="0" border="1" width="80%"> -->
- <!-- <table class="font5" cellpading="0" border="1" width="80%"> -->
- <table width="80%" rules="all" cellpading="0" border="1" style="border-color:brown;border-width:1px; border-style:solid;">
- <caption class="font2">単語集</caption>
- <tr style="background: #882200">
- <!-- <th width="30" height="35" class="font1"><font color="white">番号</font></th> -->
- <th width="30" height="35" class="font1"><font color="white">ことば</font></th>
- <th width="30" height="35" class="font1"><font color="white">意味</font></th>
- <th width="30" height="35" class="font1"><font color="white">メモ</font></th>
- <?php
- if(isset($_POST['button4'])){
- echo '<th width="30" height="35" class="font1"><font color="white">更新</font></th>
- <th width="30" height="35" class="font1"><font color="white">削除</font></th>';
- }
- ?>
- </tr>
- <?php
- function h($str) {
- return htmlspecialchars($str);
- }
- //PDO()コンストラクタ インスタンス初期化
- $pdo = new PDO('mysql:host=localhost;dbname=takahashi1;charset=utf8', 'takahashi', 'takahashi' );
- // もし修正ボタンが押されたら
- if ($_POST ['button4']) {
- foreach ( $pdo->query ('select * from words order by id desc') as $row ) {
- echo '<tr>';
- echo '<form action="" method = "post">';
- echo '<input type="hidden" name="command" value="update">';
- echo '<input type="hidden" name="id" value="', $row ['id'], '">';
- // echo '<td>', $row ['id'], '</td>';
- echo '<td>';
- echo '<input type="text" name="word" size="10" value="', $row ['word'], '">';
- echo '</td>';
- echo '<td>';
- echo '<input type="text" name="sense" size="40" value="', $row ['sense'], '">';
- echo '</td>';
- echo '<td>';
- echo '<input type="text" name="memo" size="20" value="', $row ['memo'], '">';
- echo '</td>';
- echo '<td><button type="submit" style="border: 1px solid #ff44ff; color: #ee00ff; background-color: #eeccff;">更新</button></td>';
- echo '</form>';
- echo '<form action="" method="post">';
- echo '<input type="hidden" name="command" value="delete">';
- echo '<input type="hidden" name="id" value="', $row ['id'], '">';
- echo '<td><button type="submit" style="border: 1px solid #ff44ff; color: #ee00ff; background-color: #eeccff;">削除</button></td>';
- echo '</form>';
- echo '</tr>';
- echo "\n";
- }
- }
- if(isset($_POST['command']) || !$_POST){
- switch($_POST['command']){
- case 'update':
- //PDOのインスタンスを代入した変数$pdoを指定することでPDOクラスに用意された機能が利用可能になる
- $result = $pdo->prepare('update words set word=?, sense=?, memo=? where id=?');
- $result -> execute(array(h($_POST['word']),h($_POST['sense']),h($_POST['memo']),$_POST['id']));
- break;
- case 'delete':
- $result = $pdo->prepare('delete from words where id=?');
- $result->execute(array($_POST['id']));
- break;
- case 'insert':
- //prepareメソッドはSQL文がセットされたPDOStatementインスタンスを返す
- //このインスタンスはSQL文を実行するのに必要なので変数に代入
- //prepareメソッドにSQL文を引数として渡す
- //SQL文がセットされたPDOStatementインスタンスを変数$resultに代入する
- $result = $pdo->prepare('insert into words values(null,?,?,?)');
- $result->execute(array(h($_POST['word']),h($_POST['sense']),h($_POST['memo'])));
- break;
- case 'listDisplay':
- break;
- case 'search':
- $vKeyword = isset($_POST['keyword'])?$_POST['keyword'] : '';
- $result = $pdo->prepare('select * from words where word like ? or sense like ? or memo like ?');
- $result->execute(array(
- '%' . $vKeyword . '%',
- '%' . $vKeyword . '%',
- '%' . $vKeyword . '%'
- ) );
- break;
- }
- if(!$_POST['command'] == 'search'){
- $result = $pdo->query('select * from words order by id desc');
- }
- foreach ($result->fetchAll() as $row){
- echo '<tr>';
- // echo '<td width="30" height="35" align="center" width="110" height="35">', h($row['id']), '</td>';
- echo '<td width="30" class="font3"><b>', h($row['word']), '</b></td>';
- echo '<td width="150" class="font3">', h($row['sense']), '</td>';
- echo '<td width="150" class="font3">', h($row['memo']), '</td>';
- echo '</tr>';
- echo "\n";
- }
- }
- ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement