PDA

View Full Version : PHP Script Question



fieldmedics
08-01-2008, 11:41 PM
I just paid someone to build a database script for me. I want to learn how to do it, however I guess I would need to know the correct name of the type of script first.

I operate a Job Posting site for EMT's and Paramedics. I had a HTML form I used that came to my email. I would then hand enter the data into a page on my site.

He made a new form (exactly like the one I had) that would post to the database. I would then log into a admin page and approve or disprove the posting.

When the person posted the job, each text box data would show on certain part pf the page where I used to hand enter them with html.

I.E...

posting - http://www.fieldmedics.com/jobs/forms/postjob.htm

the data entered show in two locations

List of postings in each state - http://www.fieldmedics.com/jobs/view_job_postings.php?state=Alabama

and the posting itself - http://www.fieldmedics.com/jobs/view_job_details.php?id=25

He also set up a cron job that I will tackle when I figure the script out.

If anyone can help, please do so..

thanks in advance,

Dave

fileserverdirect
08-02-2008, 12:02 AM
I just paid someone to build a database script for me. I want to learn how to do it, however I guess I would need to know the correct name of the type of script first.


I am not really sure we understand what you are asking. It seams like the script is working fine.

I would then log into a admin page and approve or disprove the posting.

Is this what you need to figure out?
--
Please be more specific...
-FSD

?foru
08-02-2008, 12:14 AM
Hi Dave,

If I understand correctly, you would like to learn how this was done. I took a quick look at your source code on the page that posts the job.

If you would like to see how it works, try to take a look at the "postjob_confirm.php" file. You should see an INSERT into statement with the individual names of your form fields. Your .php view page would use something like the mySQL SELECT statement which pulls the info from the database. Here is a quick link I found that may help you with various PHP MySQL statements.

http://www.comptechdoc.org/independent/web/php/intro/phpmysql.html (http://http://www.comptechdoc.org/independent/web/php/intro/phpmysql.html)

Post here for additional help.

Brad