drop-down list

bn1995

hi all,

how can I insert selected value from drop-down list to mysql ?

suppose we have .htm form with drop-down list of three cities (tokyo,London,Paris)and submit button ...if we select London and press submit ==> london should insert to my SQL in users table , in city filed

can any one help .... tired to find solution.

thanks in advance

Sxooter

So, how far have you gotten? Can you submit a form and then echo the output to the screen? Can you connect to your db and issue queries? I'd suggest using an id to identify london, etc, so the db would look like this:

id | name
1 | London
2 | Paris
3 | Tokyo

then when you create the form, you create your select list so it looks like:

<select name="city">
<option value="1">London</option>
<option value="2">Paris</option>
<option value="3">Tokyo</option>
</select>

Then when you insert into the database just insert the number. Be sure to scrub your input.

Here's a short story. When I went to Spain for a year, my Spanish was pretty terrible. Instead of shouting at the Spaniards in English to please speak English, I tried my best in broken spanish to communicate and learn their language. Sure, I made a mess of their language, but since I was trying my best, they were warm and friendly and helped me learn Spanish.

This board is a lot like that. "Help, someone do everything for me!" is not gonna get a lot of helpful replies, because that's the same as going to Valencia on the coast of Spain and screaming in English that you can't speak Spanish. They speak enough english to know what you're saying there, and they ignore you. Try, even a little, and you'll get lots of help. Just bang out some godawful code that barely works and makes babies cry and folks will step right up and help.

Sxooter

Oh, and go to the top of phpbuilder and look through the code snippet library. Lots of examples there. I know, I wrote a few of them. LONG ago.

bn1995

thanks for the answer and for your story

the code will be like,

<html>

<body>

<select name="city">
<option value="1">London</option>
<option value="2">Paris</option>
<option value="3">Tokyo</option>
</select>

</body>

</html>

================

<?php

$mysqldb= "db";
$mysqlUser='user';
$mysqlPass='*******';
$ip='localhost';

$db = mysql_connect($ip, $mysqlUser, $mysqlPass)
or die('Could not connect: ' . mysql_error());

mysql_select_db($mysqldb) or die('Could not select database');

$res = mysql_query("insert into users (city) values('$_POST

[city]')");

echo "Successful";

====

the entries will be numbers instead of names ....but it can be managed ,

I need to find way to hide my connection data (password,username,database).

thank you for you help after 5 days of searching and trying

I screamed once in Italy ,dont want to talk about it 😃

Sxooter

OK, so, what you really wanna do is abstract this so that if you add a new category in the database, your form automatically uses it. That means NOT hard coding in the names / values in your form. Something like:

<form method='post'>
<select name="city">
<?php
$query = "select * from cities";
$res = pg_query($query);
while ($row = pg_fetch_assoc($res)){
    print "<option value=\"";
    print $row['id'];
    print "\">";
    print $row['cityname'];
    print "</option>\n";
}
?>
</select>

bn1995

thank you alot man

what can I do to return it back .

"am good in oracle " if you have any .

thanks man