0 value when inserting data into mysql table using php

Question

I am new to php and mysql and seem to be running into an issue while trying to insert data into a mysql table.

I have a insert.php page with the following below

<?php
$db_host = 'hostname';
$db_user = 'username';
$db_pass = 'password';
$db_name = 'databasename';

 if (!empty($_POST))
{   
    $con = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
    if ($con->connect_error)
        die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());

    $sql = "INSERT INTO train2015 (emp_num, name, supervisor) VALUES (?,?,?)";
    if (!$stmt = $con->prepare($sql))
        die('Query failed: (' . $con->errno . ') ' . $con->error);

    if (!$stmt->bind_param('ssi',$_POST['emp_num'],$_POST['name'],$_POST['supervisor']))
        die('Bind Param failed: (' . $con->errno . ') ' . $con->error);

    if (!$stmt->execute())
            die('Insert Error ' . $con->error);

    echo "Record added";
    $stmt->close();
    $con->close();
}
?>

I then have add.php page

<?php
include('includes/insert.php');

?>

<html>
<body>
<form action="includes/insert.php" method="post">

Employee Number : <input type="text", name="emp_num"> </br>
Full Name : <input type="test" name="name"> </br>
Supervisor Name : <input type="text" name="supervisor"></br>

<input type="submit">

</form>
</body>
</html>

Everything seems to work fine, I hit the submit button, I see the Record added, go and check the table and I see the emp_num is fine, the name field is fine, but the supervisor always has a 0 in it. I seem to be missing something.

Thanks in advance for your help.

supervisor's most likely a string, so do sss - plus that comma in type="text", get rid of that. Plus, check the column's type if it's an int or varchar. Strings are varchar. Check the length also. — Funk Forty Niner
– Funk Forty Niner, Commented Feb 12, 2015 at 16:28
@Fred-ii- or you can make it an answer so we can properly upvote you. :) — John Conde
– John Conde, Commented Feb 12, 2015 at 16:32

Funk Forty Niner · Accepted Answer · 2015-02-12 16:32:42Z

4

As requested:

supervisor's most likely a string, so do sss - plus that comma in type="text", get rid of that.

You also need to check the column's type if it's an int or varchar.

Strings are varchar. Check the length also.

answered Feb 12, 2015 at 16:32

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

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

3 Comments

John Conde Over a year ago

Another happy customer :)

Funk Forty Niner Over a year ago

@JohnConde Indeed John. I'm in this to put a smile on a person's face ;-) if some of my jokes don't, some of my answers hopefully will. lol

Blaise M. Over a year ago

Sorry, how should we do this? You mean that the price should have integer data type? and also what about sss? Thank you.

Collectives™ on Stack Overflow

0 value when inserting data into mysql table using php

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related