I'm building a database where students can enter their prefered profiles and when they want to view each data, they enter thier userids and password and it shows them their profiles on a page that belongs to them drawing their tables and fetching thier other informations.
this will guide you through:
/*
mysql > create table users (
>id int not null auto_increment primary key,
>userid varchar(255) not null,
>password varchar(255) not null,
>firstname varchar(255),
>dateofbirth DATE,
>info TEXT);
in the html form, it will look like this:
<html>
<body>
<form action="<?$_SERVER['PHP_SELF']?> " method="post">
<input type="text" name="userid" maxlength="20"><br />
<input type="password" name="pass" maxlength="20"><br />
<input type="text" name="fullname" maxlength="20"><br />
<input type="text" name="dateofbirth" maxlength="20"><br />enter as in yyyy-mm-dd.
<input type="submit" name="submit" value="submission"><br />
<input tyoe="reset" value="Clear"><br />
</form>
php page will look something like this:
<?php
$dbcnx = @mysql_connect("localhost", "user", "password");
if(!$dbcnx) {
die("<p>Can't connect to the database server now</p>");
}
$entry=@mysql_query('INSERT INTO users SET
etc....
and the calling of the user's table will....
When user enter his/her uerid and password, it get his/her information from the database and feel pleased.
*/
please help.
Haryoh