Getting data from select box to put in database

scavok

I thought this would be something I could easily look up, but I couldn't find anything useful on google or the search here.

I have a few select boxes, and a submit button. I have a query working for when the user hits the submit button and it sends a few variables, but I need it to also send what the user has selected in the boxes.

if  ($Sign_up) 
{

 	 $query = "INSERT INTO phpbb_operations_users (operation_id, user_id, username, user_role, user_weapon, user_squad, user_platoon, user_company) VALUES ('$op_id', '$user_id', '$username')"; //missing values for select boxes 
 	 $result = $db->sql_query($query) or die(print_r($db->sql_error(),true));
}

Here's one of the select boxes you can use to give me an example of how I can get the value of the select box into a variable:

<select name="Weapons">
					<option value="Rifleman"> Rifleman </option>
					<option value="SMG"> SMG </option>
					<option value="Sapper"> Sapper </option>
					<option value="Grenadier"> Grenadier </option>
					<option value="Pak36"> Pak36 </option>
					<option value="Flak36"> Flak36 </option>
					<option value="Opel"> Opel </option>
					<option value="Halftrack"> Halftrack </option>
</select>

Thanks

rachel2004

$_POST['Weapons']

or you could also do:

$weapons = $_POST['Weapons'];

scavok

Thanks, but I'm getting a parsing error:

Parse error: parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING' in /home/scavoke/public_html/forums/operations.php on line 279

This is line 279:

	 	 $query = "INSERT INTO phpbb_operations_users (operation_id, user_id, username, user_weapon) VALUES ('$op_id', '$user_id', '$username', '$_POST['Weapons']')";

The first 3 are variables, and they work just fine. But when I add one of the tables and values from the select boxes (in this case, weapons), I get that error. It's expecting a string, but I don't understand how it can be anything but a string. The values are all text, and I have the table in the database set to text.

rachel2004

Use the variable $weapons in that query statement you have.

Make sure the variable $weapons has been assigned as follows:

$weapons = $_POST['weapons'];

Post back you results.

rachel2004

Use the variable $weapons in that query statement you have.

Make sure the variable $weapons has been assigned as follows:

$weapons = $_POST['weapons'];

...earlier in your script.

Post back your results.

scavok

That worked. I really don't know why I didn't try that when I tried so many other things 😃

rachel2004

Be aware that you cannot nest single quotes inside of other single quotes unless you escape (using \ ) the inner quotes. This applies to using double quotes as well.

Look at your code with $_POST['weapons'] at the end of your query that didn't work. Do you see NOW why it wasn't working and why I told you to use $weapons just to simplify your life?

Take care. ;-)