編集履歴

質問編集履歴

from action 追記

2021/06/04 08:00

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -112,7 +112,7 @@
-<form action="" accept-charset="utf-8" method="post">
+<form action="post" accept-charset="utf-8" method="post">
 <div>

トランザクションの追加

2021/06/04 08:00

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -204,45 +204,65 @@
-class Tcomment extends \Model
+class Tcomment extends \Model
 {
-　　　public static function insert_datas($onamae,$comment)
+   public static function insert_datas($onamae,$comment)
-    　{
+    {
+      try{
+        DB::start_transaction();
-　　　　$query = DB::insert('t_comment')->set(array(
+         $query = DB::insert('t_comment')->set(array(
-   　　　'name'=>$onamae,
+            'name'=>$onamae,
-   　　　'comment'=>$comment,
+            'comment'=>$comment,
-    　　　))->execute();
+         ))->execute();
+         DB::commit_transaction();
+       }catch(Exception $e){
+         DB::rollback_transaction();
+        }
-   　　$query = DB::query('SELECT * FROM t_comment');
+        $query = DB::query('SELECT * FROM t_comment');
-   　 　return $query->execute();
+        return $query->execute();
-　　　}
+    }
-　　　public static function get_datas()
+   public static function get_datas()
-    　{
+    {
-　　　　$query = DB::query('SELECT * FROM t_comment');
+        $query = DB::query('SELECT * FROM t_comment');
-　　　　return $query->execute();
+         return $query->execute();
-　　　}
+    }

文法の修正

2021/06/04 06:36

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -28,7 +28,9 @@
-           if (Input::method() == 'POST') {
+          if (Input::method() == 'POST')
+　　　　　　{
@@ -48,7 +50,7 @@
-     }
+     　　　}
     }
@@ -204,40 +206,48 @@
 class Tcomment extends \Model
-    {
+{
-   public static function insert_datas($onamae,$comment)
+　　　public static function insert_datas($onamae,$comment)
+    　{
-    {        $query = DB::insert('t_comment')->set(array(
+　　　　$query = DB::insert('t_comment')->set(array(
-   'name'=>$onamae,
+   　　　'name'=>$onamae,
-   'comment'=>$comment,
+   　　　'comment'=>$comment,
-    ))->execute();
+    　　　))->execute();
-   $query = DB::query('SELECT * FROM t_comment');
+   　　$query = DB::query('SELECT * FROM t_comment');
-    return $query->execute();
+   　 　return $query->execute();
-}
+　　　}
-public static function get_datas()
+　　　public static function get_datas()
-    {
+    　{
-$query = DB::query('SELECT * FROM t_comment');
+　　　　$query = DB::query('SELECT * FROM t_comment');
-return $query->execute();
+　　　　return $query->execute();
+　　　}
 }
-}
 ?>
 ```

文法の修正

2021/06/04 06:03

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -184,7 +184,7 @@
-```PHP
+```php
 //Model
@@ -202,128 +202,42 @@
-class Tcomment extends \Model {
+class Tcomment extends \Model
+    {
    public static function insert_datas($onamae,$comment)
+    {        $query = DB::insert('t_comment')->set(array(
+   'name'=>$onamae,
+   'comment'=>$comment,
+    ))->execute();
+   $query = DB::query('SELECT * FROM t_comment');
+    return $query->execute();
+}
+public static function get_datas()
-    {
+    {
-        $query = DB::insert('t_comment');
-        $query->columns(array(
-            'name',
-            'comment',
-        ));
-        $query->values(array(
-            '$onamae',
-            '$comment',
-        ));
-    $query = DB::query('SELECT * FROM t_comment');
+$query = DB::query('SELECT * FROM t_comment');
-    return $query->execute();
+return $query->execute();
-    }
-    public static function get_datas()
-    {
-        $query = DB::query('SELECT * FROM t_comment');
-        return $query->execute();
-    }
 }
-?
+}
+?>
 ```
-```php
-//Model
-<?php
-/**
- * コメントテーブル（t_comment）
- */
-namespace Model;
-use DB;
-class Tcomment extends \Model
-    {
-   public static function insert_datas($onamae,$comment)
-    {        $query = DB::insert('t_comment')->set(array(
-   'name'=>$onamae,
-   'comment'=>$comment,
-    ))->execute();
-   $query = DB::query('SELECT * FROM t_comment');
-    return $query->execute();
-}
-public static function get_datas()
-    {
-$query = DB::query('SELECT * FROM t_comment');
-return $query->execute();
-}
-}
-?>
-```

文法の修正

2021/06/04 05:53

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -228,7 +228,7 @@
         $query->values(array(
-            $onamae,
+            '$onamae',
             '$comment',

文法の修正

2021/06/04 05:52

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -288,60 +288,42 @@
-class Tcomment extends \Model {
+class Tcomment extends \Model
+    {
    public static function insert_datas($onamae,$comment)
+    {        $query = DB::insert('t_comment')->set(array(
+   'name'=>$onamae,
+   'comment'=>$comment,
+    ))->execute();
+   $query = DB::query('SELECT * FROM t_comment');
+    return $query->execute();
+}
+public static function get_datas()
-    {
+    {
-        $query = DB::insert('t_comment')->set(array(
-            'name'=>$onamae,
-            'comment'=>$comment,
-                ))->execute();
-    $query = DB::query('SELECT * FROM t_comment');
+$query = DB::query('SELECT * FROM t_comment');
-    return $query->execute();
+return $query->execute();
-    }
-    public static function get_datas()
-    {
-        $query = DB::query('SELECT * FROM t_comment');
-        return $query->execute();
-    }
 }
+}
 ?>
 ```

文法の修正

2021/06/04 05:49

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -228,7 +228,7 @@
         $query->values(array(
-            '$onamae',
+            $onamae,
             '$comment',
@@ -264,8 +264,84 @@
 }
+?
+```
+```php
+//Model
+<?php
+/**
+ * コメントテーブル（t_comment）
+ */
+namespace Model;
+use DB;
+class Tcomment extends \Model {
+   public static function insert_datas($onamae,$comment)
+    {
+        $query = DB::insert('t_comment')->set(array(
+            'name'=>$onamae,
+            'comment'=>$comment,
+                ))->execute();
+    $query = DB::query('SELECT * FROM t_comment');
+    return $query->execute();
+    }
+    public static function get_datas()
+    {
+        $query = DB::query('SELECT * FROM t_comment');
+        return $query->execute();
+    }
+}
 ?>
 ```

定義の変更をしました。エラーは出ないのですが、テーブルへの新規登録もなく前と何も変わりません。

2021/06/04 05:44

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -42,6 +42,8 @@
             $comment_data = Tcomment::insert_datas($onamae, $comment);
             $this->load->model('tcomment');
@@ -110,8 +112,6 @@
 <form action="" accept-charset="utf-8" method="post">
 <div>
 <label for="form_onamae">お名前</label>
@@ -140,6 +140,8 @@
 </form>
 <div>
   <table>
@@ -178,8 +180,6 @@
 </body>
 ```
@@ -206,7 +206,7 @@
-   public static function insert_datas()
+   public static function insert_datas($onamae,$comment)
     {
@@ -228,29 +228,21 @@
         $query->values(array(
+            '$onamae',
-            '$onamae',            '$comment',
+            '$comment',
         ));
-        $data = array(
-        'title' => '$onamae',
-        'name' => '$comment',
-);
-$this->db->insert('t_comment', $data);
-          $query = DB::query('SELECT * FROM t_comment');
+    $query = DB::query('SELECT * FROM t_comment');
-          return $query->execute();
+    return $query->execute();

コントロールからモデルへのデータの受け渡し文

2021/06/04 02:47

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -26,7 +26,9 @@
     {
-         if (Input::method() == 'POST') {
+           if (Input::method() == 'POST') {
@@ -38,7 +40,11 @@
-            $comment_data = Tcomment::insert_datas();
+            $comment_data = Tcomment::insert_datas($onamae, $comment);
+            $this->load->model('tcomment');
      }
@@ -86,8 +92,6 @@
 //Views
 <!DOCTYPE html>
 <html lang="ja">
@@ -104,7 +108,7 @@
-<form action="/post/save" accept-charset="utf-8" method="post">
+<form action="" accept-charset="utf-8" method="post">
@@ -112,7 +116,7 @@
 <label for="form_onamae">お名前</label>
-<input name="onamae" value="" type="text" id="form_onamae">
+<input name="onamae" value="" type="text" id="onamae">
 </div>
@@ -122,13 +126,13 @@
 <label for="form_comment">コメント</label>
-<input name="comment" value="" type="text" id="form_comment">
+<input name="comment" value="" type="text" id="comment">
 </div>
-<div class="actions">
+<div>
 <input name="submit" value="登録" type="submit" id="form_submit">
@@ -174,6 +178,8 @@
 </body>
 ```
@@ -210,7 +216,7 @@
         $query->columns(array(
-            'oname',
+            'name',
             'comment',
@@ -226,6 +232,28 @@
         ));
+        $data = array(
+        'title' => '$onamae',
+        'name' => '$comment',
+);
+$this->db->insert('t_comment', $data);
+          $query = DB::query('SELECT * FROM t_comment');
+          return $query->execute();
     }

insert文　受け渡し文の追加

2021/06/04 02:14

投稿

退会済みユーザー

スコア0

test CHANGED Viewed

File without changes

test CHANGED Viewed

@@ -6,220 +6,246 @@
 <?php
+/**
+ * Board Controller.
+ */
 use \Model\Tcomment;
 class Controller_Board extends Controller
 {
-    public function action_form()
+    public function action_post()
-{
+    {
+         if (Input::method() == 'POST') {
+            $onamae = Input::post('onamae');
+            $comment = Input::post('comment');
+            $comment_data = Tcomment::insert_datas();
+     }
+    }
+    public function action_index()
+    {
-        return View::forge('post/form');
+        $view = View::forge('board/index');
+        $comment_data = Tcomment::get_datas();
+        $view->comment_data = $comment_data;
+        return $view;
+    }
 }
+?>
+```
+```PHP
+//Views
+<!DOCTYPE html>
+<html lang="ja">
+<head>
+<meta charset="UTF-8">
+<title>入力フォーム表示画面</title>
+</head>
+<body>
+<form action="/post/save" accept-charset="utf-8" method="post">
+<div>
+<label for="form_onamae">お名前</label>
+<input name="onamae" value="" type="text" id="form_onamae">
+</div>
+<div>
+<label for="form_comment">コメント</label>
+<input name="comment" value="" type="text" id="form_comment">
+</div>
+<div class="actions">
+<input name="submit" value="登録" type="submit" id="form_submit">
+<div>
+</form>
+<div>
+  <table>
+  <tr>
+    <th>ID</th>
+    <th>名前</th>
+    <th>コメント</th>
+    <th>登録日</th>
+  </tr>
+  <?php foreach($comment_data as $data):?>
+  <tr>
+    <td><?php echo $data['id'];?></td>
+    <td><?php echo $data['name'];?></td>
+    <td><?php echo $data['comment'];?></td>
+    <td><?php echo $data['registed'];?></td>
+  </tr>
+  <?php endforeach;?>
+  </table>
+  </div>
+</body>
+```
+```PHP
+//Model
+<?php
+/**
+ * コメントテーブル（t_comment）
+ */
+namespace Model;
+use DB;
+class Tcomment extends \Model {
-    public function action_save()
+   public static function insert_datas()
-{        $form = array();
+    {
-        $form['onamae'] = Input::post('onamae');
+        $query = DB::insert('t_comment');
+        $query->columns(array(
+            'oname',
+            'comment',
+        ));
+        $query->values(array(
-        $form['comment'] = Input::post('comment');
+            '$onamae',            '$comment',
+        ));
+    }
+    public static function get_datas()
+    {
+        $query = DB::query('SELECT * FROM t_comment');
-        $post = Model_post::forge();
+        return $query->execute();
-        $post->set($form);
-        $post->save();
+    }
 }
-    public function action_index()
-{         $view = View::forge('Board');
-        $form = Fieldset::forge();        $form->add('oname','お名前',array('maxlength'=>8));        $form->add('comment',)
-        $view = View::forge('board/index');
-        $comment_data = Tcomment::get_datas();
-        $view->comment_data = $comment_data;
-        return $view;
-}
-}
 ?>
 ```
-```PHP
-//Views
-<!DOCTYPE html>
-<html lang="ja">
-<head>
-<meta charset="UTF-8">
-<title>入力フォーム表示画面</title>
-</head>
-<body>
-<form action="/post/save" accept-charset="utf-8" method="post">
-<div>
-<label for="form_onamae">お名前</label>
-<input name="onamae" value="" type="text" id="form_onamae">
-</div>
-<div>
-<label for="form_comment">コメント</label>
-<input name="comment" value="" type="text" id="form_comment">
-</div>
-<div class="actions">
-<input name="submit" value="登録" type="submit" id="form_submit">
-<div>
-</form>
-<div>
-  <table>
-  <tr>
-    <th>ID</th>
-    <th>名前</th>
-    <th>コメント</th>
-    <th>登録日</th>
-  </tr>
-  <?php foreach($comment_data as $data):?>
-  <tr>
-    <td><?php echo $data['id'];?></td>
-    <td><?php echo $data['name'];?></td>
-    <td><?php echo $data['comment'];?></td>
-    <td><?php echo $data['registed'];?></td>
-  </tr>
-  <?php endforeach;?>
-  </table>
-  </div>
-</body>
-```
-```PHP
-//Model
-<?php
-namespace Model;
-use DB;
-class Model_Tcomment extends \Model_Crud
-{
-        protected static $_table_name = 't_comment';
-        protected static $_primary_key = 'id';
-}
-class Tcomment extends \Model {
-    public static function get_datas()
-    {
-        $query = DB::query('SELECT * FROM t_comment');
-        return $query->execute();
-    }
-}
-```