Submit an HTML select/dropdown form to MySQL database

Question

I am trying to submit an HTML <form> and have the input and select information entered into a MySQL database table. My code is entering the <input type="text"> data into the table, but it is not entering the data in the <select>.

This is the <form> I have been using:

<form enctype="multipart/form-data" action="send.php" method="post">
    <select name="gender">
        <option value="Male"> Male</option>
        <option value="Female">Female</option>
    </select>
    <input type="text" name="name">
    <input type="submit" value="Add">
</form>

And this is the PHP I've been using to enter the form into the table:

<?php
$gender=$_POST['gender']; // This is the select/dropdown
$name=$_POST['name'];  // This is the text input

mysql_connect("", "", "") or die(mysql_error()) ; 
mysql_select_db("") or die(mysql_error()) ; 

mysql_query("INSERT INTO `table1` VALUES ('$gender', '$name')") ; 
?>

Haha, the cartoon Joe linked to is great. Anywho, do not insert $_POST (or any user-entered data) directly into a mysql statement. That opens some big security holes. Look into the method mysql_real_escape_string. It's not perfect, but is a start. That aside, more information is needed to understand why your data isn't getting into the table. Is mysql throwing any errors? Use print_r to make sure you are capturing data from the form correctly. — jbarreiros
– jbarreiros, Commented Jul 15, 2011 at 19:17

spacediver · Accepted Answer · 2011-07-15 19:58:03Z

2

try to print your form results
try to print your SQL statement instead of executing
check the statement by eye
copy the statement and try to execute in at the server manually.
add the log=query.log option in the [mysqld] section of MySQL server configuration file (probably my.cnf), restart the server and look into query.log for recent queries -- do they reach the server?

answered Jul 15, 2011 at 19:58

spacediver

1,4931 gold badge11 silver badges18 bronze badges

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

Comments

Ram · Accepted Answer · 2011-07-15 19:16:13Z

1

Hmmm...If that doesn't work try:

mysql_query("INSERT INTO table1 VALUES ('".$gender."','".$name."');");

answered Jul 15, 2011 at 19:16

Ram

1,1511 gold badge11 silver badges35 bronze badges

1 Comment

llazzaro Over a year ago

you should avoid using concatenation in queries

wanovak · Accepted Answer · 2011-07-15 19:12:27Z

0

Try:

mysql_query("INSERT INTO `table1` (genderCol,nameCol) VALUES ('{$gender}','{$name}')");

Though, as @Joe Stefanelli stated, you should really be sanitizing input -- never trust the user. Take a look at using prepared statements

answered Jul 15, 2011 at 19:12

wanovak

6,12727 silver badges32 bronze badges

Comments

khoa vo · Accepted Answer · 2013-04-02 10:52:07Z

0

Your can try

<?php
$gender=$_POST['gender']; 
$name=$_POST['name']; 

mysql_connect("", "", "") or die(mysql_error()) ; 
mysql_select_db("") or die(mysql_error()) ; 

mysql_query("INSERT INTO `table1` SET `fieldgender`='{$gender}', `fieldname`='{$name}'") ; 
?>

With fieldgender And fieldname is colums in your mysql table1

answered Apr 2, 2013 at 10:52

khoa vo

12 bronze badges

Collectives™ on Stack Overflow

Submit an HTML select/dropdown form to MySQL database

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related