Adding to a database

briintex1 · 06-01-2004, 07:16 PM

I was wondering where I might have gone wrong on adding information to a database, the country_id is an autonumber, so I don't have to add it. But when a user puts in a name of the country, it adds it to the database, once they click the submit button, and it returns them back to this page. It passes the variable through the url I think but I am not for sure about that one either? But any suggestions are helpful...

PHP Code:


			
<?php

$db = mysql_connect("localhost", "tableName", "PW")or die(mysql_error());



mysql_select_db("database")or die(mysql_error());



$obj = mysql_query("SELECT * FROM country");

$obj=mysql_fetch_array($obj);



INSERT INTO COUNTRY (country_id, country_name) VALUES($country) ?>



}



echo '</select>';

}

?>  

 <html>

<head

</head>

<title><? echo $obj[1] ?></title>



<FORM ACTION="index.php" METHOD=POST>

Please enter the name of the country to put into the database.

<p>TITLE:<INPUT TYPE="text" NAME="country" SIZE=25 MAXLENGTH=25>

<p><INPUT TYPE="submit">

</FORM>



<?php echo $country ?>

<body>

</body>

</html>

MrShed · 06-02-2004, 09:55 PM

Quote:

Originally Posted by briintex1

INSERT INTO COUNTRY (country_id, country_name) VALUES($country) ?>

}

I might just be being dumb here, but any particular reason why this line isn't in a mysql_query() function?

boeing747fp · 06-03-2004, 12:13 AM

Quote:

$db = mysql_connect("localhost", "tableName", "PW")or die(mysql_error());

try this......

PHP Code:


			


<?php

$db = mysql_connect("localhost", "ServerUserName", "ServerPassWord");

mysql_select_db("DatabaseName",$db);



$select = mysql_query("SELECT * FROM `country`");

$obj=mysql_fetch_array($select);



mysql_query("INSERT INTO `country` (`country_id`, `country_name`) VALUES ('','$country')") or die(mysql_error()); 



}



echo '</select>';

}

?> 

<html>

<head>

</head>

<title><? echo $obj[1]; ?></title>



<FORM ACTION="index.php" METHOD=POST>

Please enter the name of the country to put into the database.

<p>TITLE:<INPUT TYPE="text" NAME="country" SIZE=25 MAXLENGTH=25>

<p><INPUT TYPE="submit">

</FORM>



<?php echo $country; ?>

<body>

</body>

</html>

One question, tho..... where did u set $country ? you should have somewhere above the INSERT thing a line like $country = $_POST['country'];