API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 26th, 2017
93
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 12.35 KB | None | 0 0
raw download clone embed print report
  1. ■test29.php
  2.  
  3. <?php
  4. var_dump($result);
  5. var_dump($pdo);
  6. ?>
  7. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  8. "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  9. <html xm1ns="http://www.w3.org/1999/xhtml">
  10. <html lang="ja">
  11. <head>
  12. <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
  13. <meta http-equiv="Content-Script-Type" content="text/javascript">
  14.  
  15.  
  16. <title>単語集</title>
  17. </head>
  18. <body>
  19.     <style type="text/css">
  20. <!--
  21. BODY {
  22.     background-image: url(chocolate3-2.jpg);
  23.     background-repeat: no-repeat;
  24.     background-attachment: fixed;
  25.     background-position: right top;
  26. }
  27.  
  28. -->
  29. .font1 {
  30.     font-family: "あずきフォント";
  31. }
  32.  
  33. .font2 {
  34.     font-family: "あずきフォント";
  35.     font-size: 160%;
  36.     color: "#e4b9f9";
  37. }
  38.  
  39. .font3 {
  40.     /*  padding: 4px; */
  41.     /*  font-family: "あずきフォント"; */
  42. }
  43. .font4 {
  44.     position:relative;left:15px;
  45. }
  46. .font5 {
  47.     border-collapse: collapse; /* 枠線の表示方法 */
  48.     border: 1px #1C79C6 solid; /* テーブル全体の枠線（太さ・色・スタイル） */
  49. }
  50.  
  51. .font {
  52.     font-family: "あずきフォント";
  53.     font-size: 160%;
  54.     color: "white";
  55. }
  56.  
  57. .body {
  58.     cursor: url(hosi5.ani);
  59. }
  60.  
  61. @font-face {
  62.     font-family: 'あずきフォント'; /* お好きな名前に */
  63.     src: url('azuki.eot'); /* IE9以上用 */
  64.     src: url('azuki.eot?#iefix') format('embedded-opentype'), /* IE8以前用 */
  65.         url('azuki.woff') format('woff'), /* モダンブラウザ用 */
  66.         url('azuki.ttf') format('truetype'); /* iOS, Android用 */
  67. }
  68.  
  69. html,body {
  70.     scrollbar-base-color: #c3d7e0;
  71.     scrollbar-track-color: #c3d7e0;
  72.     scrollbar-face-color: #c3d7e0;
  73.     scrollbar-shadow-color: #c3d7e0;
  74.     scrollbar-darkshadow-color: #c3d7e0;
  75.     scrollbar-highlight-color: #c3d7e0;
  76.     scrollbar-3dlight-color: #c3d7e0;
  77.     scrollbar-arrow-color: #ffffff;
  78.     filter: chroma(color = #c3d7e0);
  79. }
  80. </style>
  81.         <table bgcolor="#882200" cellpadding="2" cellspacing="0">
  82. <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>
  83. <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>
  84. <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>
  85. <td style="border:hotpink 1px solid;" rowspan="3" bgcolor="lightpink">
  86. <p>
  87. <p class="font1" ><font color="white">検索したい文字を入力して下さい</font></p>
  88. <form action="" method="post">
  89. <input type="hidden" name="command" value="search">
  90. <input type="text" name="keyword">
  91. <input type="submit" value="検索"style="border: 1px solid #6c2735; color: #6c2735; background-color: #f2dae8;position:relative;left:20px;">
  92. </form>
  93. </p>
  94. <P align="right"><font size="2" color="hotpink">■■■</font></td>
  95. </tr>
  96. <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>
  97. <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>
  98. <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>
  99. <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>
  100. <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>
  101. <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>
  102. </table>
  103. <!--    ノートに書く -->
  104.     <table bgcolor="#882200" cellpadding="2" cellspacing="0">
  105. <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>
  106. <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>
  107. <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>
  108. <td style="border:hotpink 1px solid;" rowspan="3" bgcolor="lightpink">
  109.         <p>
  110.         <img src="res-19.gif"><font color="white" class="font1">ノートに書く</font>
  111.         </p>
  112.         <p>
  113.         <form action="" method="post">
  114.         <font color="white" class="font1">ことば<input type="text" size="10" name="word">
  115.         意味<input type="text" size="30" name="sense"></br>
  116.         メモ<input type="text" class="font4" size="20" name="memo">
  117.         <input type="hidden" name="command" value="insert">
  118.         <input type="submit"  value="書く" style="border: 1px solid #902342; color: #902342; background-color: #f2dae8;position:relative;left:20px;">
  119.         </form>
  120.         </p>
  121.  
  122.  
  123.  
  124. <P align="right"><font size="2" color="hotpink">■■■</font></td>
  125. </tr>
  126. <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>
  127. <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>
  128. <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>
  129. <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>
  130. <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>
  131. <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>
  132. </table>
  133. <p>
  134.     <form action="" method="post">
  135.     <button type="submit" name='button4' value='button4' style="border: 1px solid #902342; color: #902342; background-color: #f2dae8;">修正</button>
  136.     </form>
  137.     <form action="" method="post">
  138.     <input type="hidden" name="command" value="listDisplay">
  139.     <input type="submit"  value="一覧表示" style="border: 1px solid #902342; color: #902342; background-color: #f2dae8;">
  140.     </form>
  141.     </p>
  142. <!-- <table border="1" style="border-color:#6c2735; border-style:solid; border-width: 2px;" cellpading="0" border="1" width="80%"> -->
  143. <!--    <table class="font5"  cellpading="0" border="1" width="80%"> -->
  144.     <table width="80%"  rules="all" cellpading="0" border="1" style="border-color:brown;border-width:1px; border-style:solid;">
  145.         <caption class="font2">単語集</caption>
  146.         <tr style="background: #882200">
  147. <!--            <th width="30" height="35" class="font1"><font color="white">番号</font></th> -->
  148.             <th width="30" height="35" class="font1"><font color="white">ことば</font></th>
  149.             <th width="30" height="35" class="font1"><font color="white">意味</font></th>
  150.             <th width="30" height="35" class="font1"><font color="white">メモ</font></th>
  151.             <?php
  152.             if(isset($_POST['button4'])){
  153.                 echo '<th width="30" height="35" class="font1"><font color="white">更新</font></th>
  154.                     <th width="30" height="35" class="font1"><font color="white">削除</font></th>';
  155.                 }
  156.             ?>
  157.         </tr>
  158. <?php
  159. function h($str) {
  160.     return htmlspecialchars($str);
  161. }
  162. //PDO()コンストラクタ　インスタンス初期化
  163. $pdo = new PDO('mysql:host=localhost;dbname=takahashi1;charset=utf8', 'takahashi', 'takahashi' );
  164. // もし修正ボタンが押されたら
  165. if ($_POST ['button4']) {
  166.     foreach ( $pdo->query ('select * from words order by id desc') as $row ) {
  167.         echo '<tr>';
  168.         echo '<form action="" method = "post">';
  169.         echo '<input type="hidden" name="command" value="update">';
  170.         echo '<input type="hidden" name="id" value="', $row ['id'], '">';
  171. //      echo '<td>', $row ['id'], '</td>';
  172.         echo '<td>';
  173.         echo '<input type="text" name="word" size="10" value="', $row ['word'], '">';
  174.         echo '</td>';
  175.         echo '<td>';
  176.         echo '<input type="text" name="sense" size="40" value="', $row ['sense'], '">';
  177.         echo '</td>';
  178.         echo '<td>';
  179.         echo '<input type="text" name="memo" size="20" value="', $row ['memo'], '">';
  180.         echo '</td>';
  181.         echo '<td><button type="submit" style="border: 1px solid #ff44ff; color: #ee00ff; background-color: #eeccff;">更新</button></td>';
  182.         echo '</form>';
  183.         echo '<form action="" method="post">';
  184.         echo '<input type="hidden" name="command" value="delete">';
  185.         echo '<input type="hidden" name="id" value="', $row ['id'], '">';
  186.         echo '<td><button type="submit" style="border: 1px solid #ff44ff; color: #ee00ff; background-color: #eeccff;">削除</button></td>';
  187.         echo '</form>';
  188.         echo '</tr>';
  189.         echo "\n";
  190.  
  191.     }
  192. }
  193. if(isset($_POST['command']) || !$_POST){
  194.     switch($_POST['command']){
  195.     case 'update':
  196.         //PDOのインスタンスを代入した変数$pdoを指定することでPDOクラスに用意された機能が利用可能になる
  197.         $result = $pdo->prepare('update words set word=?, sense=?, memo=? where id=?');
  198.         $result -> execute(array(h($_POST['word']),h($_POST['sense']),h($_POST['memo']),$_POST['id']));
  199.         break;
  200.     case 'delete':
  201.         $result = $pdo->prepare('delete from words where id=?');
  202.         $result->execute(array($_POST['id']));
  203.         break;
  204.     case 'insert':
  205.         //prepareメソッドはSQL文がセットされたPDOStatementインスタンスを返す
  206.         //このインスタンスはSQL文を実行するのに必要なので変数に代入
  207.         //prepareメソッドにSQL文を引数として渡す
  208.         //SQL文がセットされたPDOStatementインスタンスを変数$resultに代入する
  209.         $result = $pdo->prepare('insert into words values(null,?,?,?)');
  210.         $result->execute(array(h($_POST['word']),h($_POST['sense']),h($_POST['memo'])));
  211.         break;
  212.     case 'listDisplay':
  213.         $result = $pdo->query('select * from words order by id desc');
  214.         break;
  215.     case 'search':
  216.         $vKeyword = isset($_POST['keyword'])?$_POST['keyword'] : '';
  217.         $result = $pdo->prepare('select * from words where word like ? or sense like ? or memo like ?');
  218.         $result->execute(array(
  219.                 '%' . $vKeyword . '%',
  220.                 '%' . $vKeyword . '%',
  221.                 '%' . $vKeyword . '%'
  222.         ) );
  223.         break;
  224.     }
  225.     if(!$_POST['command'] == 'search'){
  226.         $result = $pdo->query('select * from words order by id desc');
  227.     }
  228.     foreach ($result->fetchAll() as $row){
  229.         echo '<tr>';
  230.         //      echo '<td width="30"  height="35" align="center" width="110" height="35">', h($row['id']), '</td>';
  231.         echo '<td width="30" class="font3"><b>', h($row['word']), '</b></td>';
  232.         echo '<td width="150" class="font3">', h($row['sense']), '</td>';
  233.         echo '<td width="150" class="font3">', h($row['memo']), '</td>';
  234.         echo '</tr>';
  235.         echo "\n";
  236.         }
  237. }
  238. ?>
  239.  
  240. </table>
  241. </body>
  242. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!