Help on coding for inserting data into a table thru a popup

Matt_2K

I have some drop down menu buttons about 8 of them with names on. If one is called other. How do you know how I could have a box that popped up asking for them to type their name, then It gets put into my table in my database.

I can't put it together but I know some basic info.

if($fname == 'Other'){
// popup code
}elseif($lname == 'Other'){
//popup stuff
}else{
mysql_query("INSERT INTO name (fname, lname) VALUES ($value1, $value2)");
}

Thats the code saying that if other is used, then the pop-up code pops up asking for some data and it inserts it into my name table and my lname and fname coloums.

I have also got

mysql_connect($host,$username,$password);

mysql_select_db($database_name);

Can anybody put this into a .php file or improve on it ?

Thanks Matt_2K

Matt_2K

I've now given up on that one

I now just need a .php script with to boxes first name and last name where somebody fills in and it inserts it into my database

Thankyou

mahendrakalkura

here it comes

<?php

if(!isset($sumit)) {

?>

<form name='form' action='<?php print("$PHP_SELF"); ?>'>
First Name : <input type='text' name='first_name'><br>
Last Name : <input type='text' name='last_name'><br>
<input type='submit' name='submit' value='submit'><br>
</form>

<?php

} else {

$dbhost='localhost';

$dbusername='root';

$dbpassword='';

$dbname='quiz';

$connectparam = mysql_connect($dbhost,$dbusername,$dbpassword);
mysql_select_db($dbname);

my_query=mysql_query("insert into your_table_name values('$first_name','$last_name')",$connectparam);

print("Suitable Message");

}

?>

reply if you have any problem

mahendrakalkura

i am sorry for the mistake

<?php

if(!isset($sumit)) {

has to be

<?php

if(!isset($submit)) {

i ate out the letter "b"

lol

sorry