How can people Register on a site, and have it go to their profile? I need help...

[imagehorizons]

How would I do that?

[Aso]

Sorry imagehorizons, could you elaborate a bit more please?

Sounds like you're going to need a database and some server-side knowledge - for now I'll move this to the PHP Forum

[CloudedVision]

First off, please repeat the question thats stated in the title, don't just say "how do you do that?"

And to do that you'll have to learn PHP (or ASP or something) Here's a very nice list of resources to learn PHP.

[ccandeland]

I m working on a similar problem I have created a userform using PHP and Javascript for validation which writes to a MySQL database. Im going to use sessions to create a login area

[longstand]

To perform a user accounts page you need to create a login form that loads creates a session['ID'] variable once login validate is successfull!

Let me try to explain over a few steps:

First off login form:

i cannot be bothered typing the whole bunch of login code so u will have to set the connection variables & protect against mysql inject yourself:

The code below validates the user by this code:

PHP: Select all

$sql = "SELECT * FROM data WHERE Username = '$login_name' && Password = '$login_pass'";
   $result = mysql_query($sql);
   
// Fetch data!
   $row = mysql_fetch_array($result);
   $count = mysql_num_rows($result);
   
// Validate login!
   if ($count==1)
   {
       $_SESSION['ID'] = $row['dataID']; // Notice here a  session is set
       $_SESSION['Username'] = $row['Username'];
       $_SESSION['Password'] = $row['Password'];
       Header ('Location:' . $re_direct);
   }
   else
   {
       echo "Username or password are incorrect";
   }
   
   ob_end_flush(); 

Then from succesfull login you are directed to the accounts page & you will have to recall the session['ID'] like so:

make sure you use mysql_fetch_array to grab the data from rows after query, the all you have to do is echo the data from the datanase like this: <?php echo['Example coloumn']; ?>

PHP: Select all

<?php
    session_start();
    
    
    
    if (empty($_SESSION['ID'])) {
    exit ("You have to be logged in to view this page");  
    }
    
        include 'db_fns.php';
        $sql = "SELECT * FROM data WHERE dataID=".$_SESSION['ID'];
        $result = mysql_query($sql);
        $row = mysql_fetch_array($result);
    
         
?>

Here is a example of echo data to appear were you want it on your page relevant to the registered session['ID'] in use:

PHP: Select all

<table border="0" cellpadding="5" cespacing="4">
<tr>
<td><strong>Name:</strong></td>
<td><?php echo $row['Name']; ?></td>
</tr>

Step 1: login & create sessionID - redirect to accounts page!

Step 2: start session\connect to server & select database!

Step 3: run query & fetch array from the result resource!

Step 4: echo colomns to display logged in users data!


Hope this helps

[ccandeland]

Thats a great help thanks

[longstand]

No problem!! if you have any probelms creating the rest of the login form just egt in touch... Am a bit tipsy at the mo so excuse the poor spelling!!! Sessions are easy only when you have seen a example working infront of you!

Always start a session at the top of the page to be output first then simple run a query by the id, fetch array the result & echo out the data from the relevant rows 7 the session will do the rest even if it is a shopping cart or search engine.... easy peazy dude

[ccandeland]

thanks im gonna give that a go

[deanjg]

I had a similar requirement for a client, and I used this subscription service instead of PHP/MySQL:

www.HostedDatabase.com

Check out this page on their site which explains how to set it up without any server code:

http://www.hosteddatabase.com/how_to_security.asp

You set up a custom database with all the field you want in the profile, then you create (or the users create) Users that can login and access/edit the profile info. You can also protect portions of your site so that only authorized users can gain access. They offer a free 30-day trial so you can set it all up and give it a spin.

Good luck.