Form data is submitting, but isn't going into mySQL

Question

My db connection is correct, I am able to select and echo out rows of my table. However, my form data isn't updating my database. I'm trying to submit the form on the same page, so I left the action blank. Here is my php:

<?php
if (isset($_POST['submit'])) {

    $con=mysqli_connect("localhost","hey","password!","dbname");
    $sql="INSERT INTO StudentList (StudentNum, LastName, FirstName, Address, City, State, Zip, Balance, FirstTermAttended)
    VALUES('$_POST[inputID]','$_POST[inputLast]','$_POST[inputFirst]','$_POST[inputAddress]','$_POST[inputCity]','$_POST[inputState]','$_POST[inputZip]','$_POST[inputBalance]','$_POST[inputTerm]')";
    echo "It worked";
}
?>

and here my form:

   <form class="form-horizontal" role="form" method="post" action="">
                <div class="form-group">

                    <div class="col-sm-offset-1 col-sm-10">
                        <input type="text" class="form-control" id="inputID" placeholder="Student ID Number">
                    </div>
                 </div>


                <div class="form-group">
                     <div class="col-sm-offset-1 col-sm-10">
                        <input type="text" class="form-control" id="inputLast" placeholder="Last Name">
                    </div>
                 </div>

                <div class="form-group">
                     <div class="col-sm-offset-1 col-sm-10">
                        <input type="text" class="form-control" id="inputFirst" placeholder="First Name">
                    </div>
                </div>

                 <div class="form-group">
                     <div class="col-sm-offset-1 col-sm-10">
                        <input type="text" class="form-control" id="inputAddress" placeholder="Street Address">
                    </div>
                </div>

                 <div class="form-group">
                     <div class="col-sm-offset-1 col-sm-10">
                        <input type="text" class="form-control" id="inputCity" placeholder="City">
                    </div>
                </div>

                 <div class="form-group">
                     <div class="col-sm-offset-1 col-sm-10">
                        <input type="text" class="form-control" id="inputState" placeholder="State">
                    </div>
                </div>

                  <div class="form-group">
                     <div class="col-sm-offset-1 col-sm-10">
                        <input type="text" class="form-control" id="inputZip" placeholder="Zip">
                    </div>
                </div>

                <div class="form-group">
                     <div class="col-sm-offset-1 col-sm-10">
                        <input type="text" class="form-control" id="inputBalance" placeholder="Current Balance">
                    </div>
                </div>

                 <div class="form-group">
                     <div class="col-sm-offset-1 col-sm-10">
                        <input type="text" class="form-control" id="inputTerm" placeholder="First Term Attended">
                    </div>
                </div>

                  <div class="modal-footer">
          <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
          <input type="submit" value="Save Student Information" id="submit" name="submit" class="btn btn-primary">
        </div>


            </form>

I also have this in my header, could it be screwing things up?

<?php
// Create connection
$con=mysqli_connect("localhost","hey","password!","dbname");

// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
?>

Aren't you missing a `mysqli_query()`? Also please sanitize the values you receive from `$_POST` — AyB, Feb 06 '14 at 04:44
[**How can I prevent SQL injection in PHP?**](http://stackoverflow.com/q/60174/1415724) < It's a message/clue. ;-) — Funk Forty Niner, Feb 06 '14 at 04:55

Monirul Islam · Accepted Answer · 2014-02-09T10:31:36.510

3

Your code is missing mysqli_query and also you need to assign name attribute to your input field. See Sample Example from here http://www.w3schools.com/php/php_mysql_insert.asp

edited Feb 09 '14 at 10:31

answered Feb 06 '14 at 04:49

Monirul Islam

985
1
8
23

score 0 · Answer 2 · answered Feb 06 '14 at 04:45

Your <input> fields require "name" attributes. It's the names that are used in the POST body - not the IDs! You should also look at prepared statements - you're open to injection at the moment. Also, it doesn't appear that you're actually executing the queries. Read what I link - it shows execution, too!

score 0 · Answer 3 · answered Feb 06 '14 at 04:47

0

change id="name" into name="name" in <input id="">

answered Feb 06 '14 at 04:47

user3106988

101
1
8

score 0 · Answer 4 · answered Feb 06 '14 at 04:47

0

You have only written the query. You have to execute the query with "mysqli_query".

Also specify "name" attribute to input elements. so that you can assess them in $_POST.

answered Feb 06 '14 at 04:47

Snehal S

865
4
13

score 0 · Answer 5 · answered Feb 06 '14 at 04:58

0

Assign id or class in your form instead of using div in your form. For further follow this example http://people.cis.ksu.edu/~hankley/d764/tut06/GopisettyPHP.html

answered Feb 06 '14 at 04:58

Owais

21
3

Form data is submitting, but isn't going into mySQL

5 Answers5