[Resolved] Click Agree to continue

WetWired

Hey i looking for something that seems rather simple. Here it goes:

When the user logs into the clients area, he/she is taking to /clients.php. Where all there information is. But instead I would like the user to login, and be redirected to /useragree.php. Then the user will click I Agree. And be redirect to clients.php. But I would like to have it set so when the user logs back in 3 days later, not to see the agrement page since he/she has already agreed to the terms. Any ideas? I'm still new to php, but learn very quickly. Thanks

maybe start me up on some of the core code?

Someone told me this but i can't get it working, Just need a little push start.

Use a session php.net/session or a cookie php.net/setcookie.

Have a textarea in a form, and submit it to "useragree.php" for example, then on that page start the session, set $_SESSION['useragree'] = true. Then if you need to check it you can use that variable. If it is not set then you can redirect back to the page with the license agreement on.

lazzerous

add a field to the users table called 'tos' or 'agree' or something - enum ('n','y');

set all current and new users to 'n';

on the login page, once they successfully enter in a correct username/password combo, check this field - if it's set to 'n' then show the user agreement form - if it's set to 'y' then let them go where they need to go

make sense?

WetWired

Kool i think im getting it.

So i would make this sql call?

ALTER TABLE user ADD (
        tos enum ('n','y'); DEFAULT 'n'
)

And something like this?

        if (user='n')
        {
agrreement page
        }
        else
        {
clients page
        }

Thanks so far, i know exacly what your telling me to do, just trying to get it on code now lol.

lazzerous

sql query is close:
ALTER TABLE tablename ADD tos ENUM('n','y') DEFAULT 'n';

even in 'if' statements, one qual sign changes a value while two compare values:

if ($user=='n')
{
// agrreement page
}
else
{
// clients page
}

WetWired

dude you so rock! Thank you i will go check now. I've only been working with php for a couple of months, and styuding hard 😛

lazzerous

keep goin man - PHP is where it's at

plz don't forget to mark this thread resolved

WetWired

I'm trying a few things now bud, then i will come back and let you know if i got it or not. 🙂

WetWired

sorry to double post. Okay i ran the sql and it worked. But when i use the above 'if' statments, it does not show the agreement page. It acually just logs in normaly.

Heres my Database information:
The table is 'user'
The Feild is 'tos'

And this code didn't work.

if ($user=='n')
{
        // this will fetch the agreement template
        eval('print_output("' . fetch_template('clients_tos') . '");');
}
else
{
        // this will fetch the clients index page
        eval('print_output("' . fetch_template('clients_index') . '");');

}

I'm not sure that its checking the database the the felid tos is set to n.

lazzerous

well, there's a couple things here...

First, when you add a field to an existing table, eben though you set what the default setting should be, it does not set it for existing entries, so you will have to update them:

update user set tos='n';

this will update all records

second:
I don't see your connection info or select statement, so im gonna ask you to make sure you're assigning a value to $user before you reference to it:

// example
$query = mysql_query("select tos from user where id='0'");
$row=mysql_fetch_array($query);
$user = $row[tos];

WetWired

Great man, im getting close. But this is the error i get now.

Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\clients.php on line 74

Line 74 is the following

$row=mysql_fetch_array($query);

Any ideas? Thank you so much for how much you helped so far. This is a great site!

WetWired

got it to work 🙂

/me clicks mark this thread resolved!