Help with PHP

I´m developing a webpage to a teacher and the teacher want two authenticated area one for the students and other for the teachers.



My problem is :

I have my authentification script using cookies for USER and PASSWORD, but in the authenticated area I have some links to another page, and when I click it pass to the page without authenticate, ex. if I write the address of this page, it go to the page without the authentication. What I need to include to the page to be authenticate within the authenticated area. This are subLinks that only authenticated user can access.



Another problem is I have a form with mySql DB and I don´t want to use in the ACTION an external file. I want to include the php code in the same page.. I did it in the same page but the values in the INSERT code return and error, like THE VARIABLE ARE NOT DECLARE and present all the name of the variable (the fields) in the error. it is putting the same name of the page in the ACTION of the form but I if use and external file (php script in ACTION FORM) this is copying the PHP code to another file. it work perfecly, but I don´t want these in this way, because I´m showing the report in the same page, it means, that each time I submit and record it actualize the report in the right of the page.. How can I do this?.



Another think, I have a form to calculate the grades so, some fields are calculated from the information of others. Ex. I have to grades : 80 and 85 how can I show the average of this two number in another field (avg field). without write in avg. field, and put the avg field displayonly(not access to write), and how can I excute a script when I go out of the last grade field..



How can I show an information in a field without type it..



How can I use a list/menu reading from a database.



Sorry my english, I´m from Dominican Republic and my natural language is Spanish, please write me back...



Nestor Valdez

at the top of each page you want restricted you should place something like this at the top

if($_COOKIE['name'] == '')
header("Location: index.php");

I am also a teacher and would like to use the power of a database with php to automate many of the functions a teacher uses. ie. gradebook, report cards, newsletters, etc.

You may want to look for free packages out there that offer "PowerSchool" type environments for teachers and schools. First check devscripts, then search around for education + php or education + free + online schools or something like that.

You could then use the code to answer some of your questions if the package is not what your teacher friend wants.

See claroline.net for a free package for online classes.
See phpBB.com for a free forum.
Also see Easyphp.net for free server/php/mysql for the school server.

Good Luck.
Like to hear how it goes. - E-mail me if you want. I work at a Spanish / English Language school in Anchorage, AK.