Using PHP and MYSQL to make logins and profiles for my site?

hey I'm new to php and MYSQL but read some tutorials because i wanted to let my website users log in and make their own profiles, but I'm completely lost. I don't know where to go from here; From what i read i don't see how it applies to what i need to use it for. Can someone point me in the right direction or explain to me the starting steps to put log ins and profiles on my site?

http://www.phpeasystep.com/workshopview.php?id=6
more help here

that's a good tutorial, but i have another question. Once my users go through the registration process how do i have the server create a page for them. For example, on myspace you register then you automatically have a page waiting for you to fill out and you also have the option of making a sub URL like myspace.com/whatever_you_choose

If you mean a profile, then think up a html template you want for them all to look like. Then fill in the user information with a mysql data array containing that persons specific data. Finally, write this template with all information specified.

for example a basic profile creation could be:

Code: Select all: <?php // mysql connection and session information goes here // be sure to sanitize all variables before hand $query = mysql_query("SQL GOES HERE"); $create = mysql_fetch_assoc($query); $file = fopen($create['username'].".php",w); // This is a heredoc of the template (very basic) $profile = <<< PROFILE <html> <head> <title>My profile</title> </head> <body> <div>Id: {$create['id']}</div> <div>Name: {$create['name']}</div> <div>Picture: <img src="{$create['picture_url']}"</div> </body> </html> PROFILE; // this writes the profile to the actual file if (!fwrite($file,$profile)) die ("Profile creation terminated"); fclose($file); ?>

You would want to use more than one file and include them whenever needed.
E.g, template.php can be included into create.php.

So if i understand kiyouras' code then all that code he wrote would be the actual profile of the person and the
"mysql_query("SQL GOES HERE")" would fetch the users info that i have already submitted to the database through a register page?

Yes. All the code inside $profile would be the actual profile. You could do this every time someone registers.

Using PHP and MYSQL to make logins and profiles for my site?

Using PHP and MYSQL to make logins and profiles for my site?

Re: Using PHP and MYSQL to make logins and profiles for my site?

Re: Using PHP and MYSQL to make logins and profiles for my site?

Re: Using PHP and MYSQL to make logins and profiles for my site?

Re: Using PHP and MYSQL to make logins and profiles for my site?

Re: Using PHP and MYSQL to make logins and profiles for my site?

Who is online