Maybe asking if it is possible first would be a good idea...but maybe just feasible... Okay here's how I am gonna phrase this.
I am brandnew to php, never seen more than a few lines of code. I need to have a method of dealing with forms and databases.(the server will change numerous times: oracle, microsoft, apache...) It must be cross-platform unlinke ASP, and Java doesn't seem to have the database power I need. So can the following be done at all using php, or even just parts, and if so, any help on how to go about it and places to get templates, examples, etc would be greatly appreciated.:
Page one: need to open a DB connection and place all the fields from an Access database into a table...
simple right?
Page two: Have a form right now. On submission I need the following things done, in order or at the same time, either way.
1)Check to see the form is complete, and place a little red astrix next to blank fields without submitting until the check is passed.(this is possible in java I know, but not a general check all forms, only a code for each indivdual one repeated and re-deisgned each time.)
2)Submit the results into an ms access database
3)Send a mail(pre-made) to me letting me know something was submitted.
4)Send a confirmation mail to the submitter letting them know it was prperly submitted(one of the form fields contains the name)
5)Send the user to a confirmation page.
The one on the second page is probably a real bitch, I know. And believe me, my boss isn't making this one easy with needing multi-platform and Ms Access database, but I have to work with the specs given to me. The sad part is I am merely a web-designer and intern designing and intranet site, not a php, asp, or java scripter(though down the line I do plan to learn php and java). But my boss fails to realize this. I do all the HTML hard coding and CSS myself, I am working on WIndows 2000 professional using frontpage as my editor. I also have Ultradev 3 if using that would be better, but I have not figured out its interface yet.(I just downloaded the trial version yesterday)
Now, I would prefer not to have to fully learn php in order to do this, but at the same time I would not feel right having someone do all the coding for me. Now I know this is a huge thing to drop like this, but as I said I first need to know what is and is not possible with the php, and if I will have to mix it with java or something else. But I also need to know how to go about what is possible. Any help is GREATLY appreciated.
THANK YOU, THANK YOU, THANK YOU in advance to anyone who can help me in any way with this massive chunk of code.