Controling Access Using PHP & MySQL

[JustForWebmasters]

Hi all,

I used Kevin Yank's article, Managing Users with PHP Sessions and MySQL to make a script that controls access to a certain area of my site.

However, I always get the following error message:

Parse error: parse error in /home/corby/justforwebmasters-www/authors/new.php on line 142

I have posted the code for the different scripts at: http://www.justforwebmasters.com/script.html . I have a feeling that I'm missing a closing parenthesis mark, but I don't know where to put it.

Any ideas?

Thanks,
Corbb

[freddydoesphp]

Could you post all that code into a .phps file, just copy the code into that file and name it wit ha .phps extension, that way we can see your color-highlighted code. Its sort of hard to read in the textareas, also you may want to convert your scripts to a {} structure instead of using colons for your if clauses. It will be easier to debug that way.

[JustForWebmasters]

Freddy,

That won't work because my server parses all files for PHP.

It's in a .zip file now. http://www.justforwebmasters.com/authorscripts.zip

-Corbb

[freddydoesphp]

Did you convert the if else clauses to brackets style instead of colon style?

[JustForWebmasters]

freddy,

I used most of the code Kev used in his article.

What do you mean by, "convert the if else clauses to brackets style instead of colon style"?

I'm not too advanced at PHP.

Thanks for your help,
Corbb

[freddydoesphp]

What I mean is you have thing like

if():
else(): 

That is only going to make you more confused, the reason you have a parse error on line 142 of new.php is because you are missing the

endif;

From the bottom of the file to close the else: clause, this is why Isaid to change it to a style like

if {

}
else {

} 

as I think it will help you miss those missing endif; that you are gonna need usinga colon style.

[JustForWebmasters]

Freddy,

Thanks for your help.

The script displays now, except it just reloads the form and doesn't add the entries to the database.

The .zip file has been updated.

[freddydoesphp]

I guess you aren't gonna change those control structures . The first reason its not working is you are checking for the existence of $submitok on line 6, $submitok never exists even when the form is submitted since your submit button has no name

<input type="submit" value="Add"> 

needs to have a name

<input type="submit" name="submitok" value="Add"> 

[JustForWebmasters]

Freddy,

Thank your help. It works now!

-A very happy Corbb

[freddydoesphp]

Would you at least humor me and promise me that you are gonna change those colons to brackets?

[JustForWebmasters]

If I come accross another script, I'll change 'em before coming to you

Thanks again for your help,
Corbb