Database help

Sayjinn

ok i have my database up and have one table...the only problem is i have no clue on how to do anything else like have the user add them selves to the database and how to query that info to a table, with all that using php. If somebody can help me i would appreciate it alot.

my database name is ld
my table name is bards
connects to localhost

Im guessing i have to make a login, register, and members page?

heres my members page http://www.eqkac.com/legatumdraconis/members.htm

scoppc

Well, start creating a form that accepts user's input. Let say, you have fields such as name, age, dob, username, password, etc.
set the action attribute of the form to a PHP file that gets those input and save em to database.

You can use $POST,$GET variables to grab the input and do whatever process to get em ready to be stored in database.

Good Luck!

mo0ness

Yea, ur gona need a registration page and login page 😛. I recommend you take a look on this forum for past code people have included and read up on it. I STRONGLY recommend u go 2 a webpage that shows you step by step tutorials on how 2 do exactly what u want, try lookin in the tutorials on this site, and http://www.php-developer.com/zend/tut/.

What ur gona need 2 do, is make html forms that link to each php script. Like a registration page, say u have the fields: Username, Password, Email as ur field values, heres wot u wud do...


// Make sure all fields are filled

if ($Username && $Password && $Email)
{

// Select the database

mysql_select_db($databasename) or die ("Couldnt select database: ".mysql_error());

$query = "INSERT INTO $table (Username, Password, Email) values ('$Username', '$Password', '$Email');

// Do the query

mysql_db_query($databasename, $query) or die ("Query failed: ".mysql_error());

print "Membership added!";

}
else
{
print "Fill in all required fields";
}

Well..thats the "basic" registration kinda thing, just 2 give u the idea.