Hi, i have successfully made my registration and login page.
Now i need help.
When i click on login by using specific username and password that i had created, i want my next page to show details about that person, this details are stored in Mysql when they register and enter their information like age, company, address etc. I want this information to display when the user signs in with his/her username and i want something like a welcome label with their name on my page e.g. rob welcome to your profile so how can i actually get that name rob on my page without doing it manually and hence picking it up from my sql database?
After this i want them to edit this data and save it.
I tried going through many things but i was unable to do that, can anyone help: (i am using dreamweaver and php)?
Sir, what part of the codes do i show ?...
Below are the codes for the login button which will prompt me to another page, hence not showing details of that user (which i want and i do not know how to do).
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="cascadeglobal"; // Database name
$tbl_name="registration"; // Table name
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);
$sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'";
echo "Wrong username and password";
Ok, i'll make it simple and clear hope its easy to understand.
I want a page on my dreamweaver that displays information that i had entered during the registration.
The data that should be displayed will depend on the username and password a person enters on his or her login page.
For example: i have a registration form which asks:
Enter First Name, Last Name, Age, Gender, Address, Email, User Name, Password and Confirm Password.
Once the user registers he or she is taken to the login page.
(I am using mysql to store all the information)
On the login page when they write their username and password on clicking signin i want another page that display:
This is your profile,
First Name: aaa
Last Name: bbb
User Name: ggg
Hope this is easy to understand.
I tried looking for tutorials and forums, but still couldn't find a solution to this.