PHP Form data not sending

Question

I wanted to add an input field, where the user can input a name for example and it would be added to the relevant table in the database. However i want to create a new action for this, so far i have the basic input fields and submit button with the following code:

public function action_mynewaction() {
     $this->auto_render = false;
     if ($this->request->is_ajax()) 
     {
     $stmt = DB::query(Database::INSERT, 'INSERT INTO `mytable` (`name`) VALUES (:Name)');
     $view = View :: factory('my/form/file_path');
     echo $view->render();
     }
    }

This is my view file where the form is displayed

<table cellspacing="1" cellpadding="5" class="myclass noSort">
   <thead>
      <tr>
         <th>A</th>
         <th>B</th>
         <th>C</th>
      </tr>
    </thead>
        <tfoot>
            <tr>
              <td colspan="3">&nbsp;</td>
            </tr>
        </tfoot>
         <tbody>
            <tr>
                <form action="" method="post">
                 <td>Add Name</td>
                 <td><input type="text" name="Name"></td>
                 <td><input type="submit" value="Submit">
                </form>
             </tr>
          </tbody>
   </table>

But whenever i add in my

$stmt->param(':Name', $_POST['name']);

part it doen't show me the input/form field at all?

Doesn't display form/input field at all

       public function action_mynewaction() {
          $post = $this->request->post();

          $stmt = DB::query(Database::INSERT, 'INSERT INTO `mytable` (`name`) VALUES (:Name)');
          $stmt->param(':Name', $_POST['name']);
          $stmt->execute();

          $view = View :: factory('my/form/file_path');
          echo $view->render();
   }

For reference, you cannot put form elements directly inside tr elements. The only valid children are td and th. — BenM
– BenM, Commented Jan 10, 2014 at 16:25
@BenM That's good as html standard, but it allows you to put form isn't it? =/ — Goikiu
– Goikiu, Commented Jan 10, 2014 at 16:27
<td><input type="submit" value="Submit"> closing </td> missing — Daniel W.
– Daniel W., Commented Jan 10, 2014 at 16:32
@Goikiu well that depends on the browser. Some will outright remove the tag, others move it further up / down the DOM tree. It's unexpected behavior and you should not code around it. — erKURITA
– erKURITA, Commented Jan 10, 2014 at 17:09

Goikiu · Accepted Answer · 2014-01-10 16:23:58Z

2

forms data are case sensitive.

Into your html you have : name="Name" and you will retrieve data with $_POST['Name'] that said if the "receiver" php page isn't the same as the one is sending put an "action" to the form.

answered Jan 10, 2014 at 16:23

Goikiu

5603 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

gen_Eric Over a year ago

Without an action, the <form> will just submit to the same page.

Goikiu Over a year ago

@RocketHazmat I didn't ever used that. Thanks for the info. I'll edit my post.

Dinesh Saini · Accepted Answer · 2014-01-10 16:29:39Z

1

Please follow name convention so that it can bind corresponding element to browser get method.

    public function action_mynewaction() {
          $post = $this->request->post();

          $stmt = DB::query(Database::INSERT, 'INSERT INTO `mytable` (`name`) VALUES (:Name)');
          $stmt->param(':Name', $_POST['Name']); /* replace 'name' with 'Name' */
          $stmt->execute();

          $view = View :: factory('my/form/file_path');
          echo $view->render();
   }

answered Jan 10, 2014 at 16:29

Dinesh Saini

2,9162 gold badges36 silver badges51 bronze badges

Collectives™ on Stack Overflow

PHP Form data not sending

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related