how to pass form imput as variable to mysql?

[matumba]

hi!

I have simple form like

<form method="POST" action="create_db.php"> 
 db name: <input type="text" name="db" size="20">  

<br>
table name: <input type="text" name="table" size="20">
<br>
field name: <input type="text" name="name" size="20">  

<input type="submit" value="Submit"><input type="reset">

I want to pass thouse variable to create_db.php but having problems.. how to do it? /whats wrong with my code?

 
<?
//create_db.php
$create ="CREATE DATABASE " + $db;

$link = mysql_connect(localhost,root);

if (! $link)
die("Couldn't connect to MySQL");
mysql_query( $create );
if ( $link ){ //om länk finns skapa tabel
mysql_select_db( $db, $link)
or die("Select DB Error: ".mysql_error());
mysql_query("CREATE TABLE $table( id INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY(id), namn VARCHAR(30) )")
or die("Create table Error: ".mysql_error());
//sätter in värden från formen in i tabelen
mysql_query ("INSERT INTO personer ( name ) VALUES ('$name')");
}
else {
echo "succes";
mysql_close($link);
}
?>
 

--

Thanx in advance

[leatherback]

ehm

It helps if you tell us what is not working, whether you get error messages or..

J.

[matumba]

I figured that out.. well there was no errors... I was asking how to pass form variables.. nothing more or less.. it was some year or so since I wrote php.. hehe so I am just rosti..

[leatherback]

Ok,

Say you have a form field called 'myvar'

and you post this form to a page, you can get the variable like this:

$myvar = $_POST[myvar];

J.