Adding to database...

[Boxerman]

Hi guys,

 

i use a program called FSACARS and i have to go into the phpmyadmin to add people on the database...

 

i was wondering if anyone knows how i can get a php form to do this, so they fill stuff out and it adds them to the database automatically!

 

thanks!

 

James

[peranha]

Search google for a php register system.  That will get you started.

[aschk]

Create you html page with the form details in it. Post it to the process.php page, which takes the form variables.

With the form variables create an SQL statement which INSERT's the information into the database.

 

Easy peasy...

 

If you post some sample/dev code we'll help you along.

[Boxerman]

Thanks!

 

where do i start, ive got the form made up, how do i link it with the database?

[peranha]

<?php
//Server to connect to
$server = "server";

//Database to connect to
$db = "database";

//User Name to connect
$user = "user";

//Password to connect
$pass = "password";

// open connection
$connection = mysql_connect($server, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

?>

[Boxerman]

ahh i understand a little now... the form must be the same as this...

 

http://www.vipersim.com/jamesm/pilot_roster.php

 

it must have all the same fields... like rank, remarks etc...