How can I make a DB managing page?

zoobooboozoo

Hi there I would like to create a PHP page,
that I can insert info into my DB with it...

like when you doing when signin-up to a board or smthng 🙂

anyone has any guide or tut?

thx in advance

Houdini

Make a form with html then in the action send the $POST info to another php script that takes the $POST values and puts them into the database. Means you need at least two pages to do that.

zoobooboozoo

I made an HTML form which will get inputted with all the required info,
and I know how to apply such thing with a PHP page to a SQL-DB...

but I don't know how to make the .php file to understand/transform into variables...

maybe a guide to how to do this?
or an example script that does it?

thx in advance

zoobooboozoo

Have anyone done auch a thing and would like to give me some instructions>?

please 🙂

rincewind456

Google for PHP/MySQL tutorials there are 100's out there that describe what you want.

Houdini

The name of fields of your HTML form will take on a value (if entered) of $POST['thatfieldname'] So on your second page you would either create short variables like below or use the $POST variables.

$name = $_POST['name'];
$address = $_POST['address'];
$phone = $_POST['phone'];
//and so on then you would just put the values into the db
include("db.php");//whatever you use to connect to the databse
$connect = ($host,$user,$password)
  or die("Could not connect to server".mysql_error());
$select = ($db,$connect)
  or die("Could not select database".mysql_error());
$sql ="INSERT INTO members (name,address,phone) VALUES ('$name','$address','$phone')";
$result = mysql_query($sql)
  or die("Could not execute query".mysql_error());
//do something else