SubFreeze
12-07-2003, 12:16 AM
Why Hello everyone. As you can notice by my comfortably laid out information on the left -- I'm new to your forums. I have a problem most of you can hopefully help me with.. or one, I just need one. ;-)
I'm creating an Ad Proofing System for an Advertising Company. This is how it is laid out.
A client logs into the MySQL database (AdProof). Depending on the login and password, the PHP will print a list of image documents contained in the table under "proofs". The table will consist of; ID, Date, Proofs, Confirmed, Comments. All of the information is linked by the ID column -- which under Table "Authenticate" with "ID, Username, Password" will decide what is and is not printed.
(You might see issues with how I have things designed -- I'll bring that up in a few.).
I need, depending on Username and Password, a list of links to appear with the Image, Date, Confirmed, and Comment. When the user clicks on the link, a new page is loaded, where that image is viewable as a 700xXXX image, with a form below it. The form is "Name, Ad Proof # (from top left corner of ad", a checkbox "OK AS IS" or "CHANGES NEEDED", another text box for a Phone Number, and than a text box titled "Changes - Be Descriptive as possible" where someone can input what changes they want to their advertisement. Than a Submit button that will send an e-mail to Blah@Blah.com with the required changes. Once this happens, the page loads a Thank You document, telling them they will expect a phone call confirming changes in the next 2 business days. Once this happens, the Confirmed Box will be "No" in the table -- however, if they like the ad, and don't need changes, they can confirm the ad is fine and than the Confirmed cell is input as "Yes". Than they can't request changes.
That's the user side of the program. I need an administrative side that allows the company representative to log in with a set username and password, and than upload ad copies to the server using the script.
Here is my problem....
I'm an HTML guy. I am just learning PHP and MySQL. I can create the database, add, modify, and print tables. I do not know how to print links, show images, etc. Or to do an authentication system -- I'm a "Monkey-See-Monkey-Do" type guy. If I can visualize a database in my head, than the functions and code needed to print that information -- I'd be great, but I do not even know how a database links ID #'s and prints that information out in an organized manner. My structure for the database is incomplete, since I do not know how to do multiple Ad Proof images. I'm assuming I keep the ID# the same for each row and just change the other fields depending on the image.
Can someone give me a push in the right direction? I have 1 month to complete this program before I ship to Basic Tranining -- This is what is getting me the money to fly 2700 miles so I can see my family before I go into service for 5 years -- if I can't do this, I do not get to see my family. And I will see my family. :)
Any help is GREATLY appreciated. Such as tutorials on how to print specific database information, or the creation and usage of an authentication system, or how to upload an image, etc.
Thank you!
I'm creating an Ad Proofing System for an Advertising Company. This is how it is laid out.
A client logs into the MySQL database (AdProof). Depending on the login and password, the PHP will print a list of image documents contained in the table under "proofs". The table will consist of; ID, Date, Proofs, Confirmed, Comments. All of the information is linked by the ID column -- which under Table "Authenticate" with "ID, Username, Password" will decide what is and is not printed.
(You might see issues with how I have things designed -- I'll bring that up in a few.).
I need, depending on Username and Password, a list of links to appear with the Image, Date, Confirmed, and Comment. When the user clicks on the link, a new page is loaded, where that image is viewable as a 700xXXX image, with a form below it. The form is "Name, Ad Proof # (from top left corner of ad", a checkbox "OK AS IS" or "CHANGES NEEDED", another text box for a Phone Number, and than a text box titled "Changes - Be Descriptive as possible" where someone can input what changes they want to their advertisement. Than a Submit button that will send an e-mail to Blah@Blah.com with the required changes. Once this happens, the page loads a Thank You document, telling them they will expect a phone call confirming changes in the next 2 business days. Once this happens, the Confirmed Box will be "No" in the table -- however, if they like the ad, and don't need changes, they can confirm the ad is fine and than the Confirmed cell is input as "Yes". Than they can't request changes.
That's the user side of the program. I need an administrative side that allows the company representative to log in with a set username and password, and than upload ad copies to the server using the script.
Here is my problem....
I'm an HTML guy. I am just learning PHP and MySQL. I can create the database, add, modify, and print tables. I do not know how to print links, show images, etc. Or to do an authentication system -- I'm a "Monkey-See-Monkey-Do" type guy. If I can visualize a database in my head, than the functions and code needed to print that information -- I'd be great, but I do not even know how a database links ID #'s and prints that information out in an organized manner. My structure for the database is incomplete, since I do not know how to do multiple Ad Proof images. I'm assuming I keep the ID# the same for each row and just change the other fields depending on the image.
Can someone give me a push in the right direction? I have 1 month to complete this program before I ship to Basic Tranining -- This is what is getting me the money to fly 2700 miles so I can see my family before I go into service for 5 years -- if I can't do this, I do not get to see my family. And I will see my family. :)
Any help is GREATLY appreciated. Such as tutorials on how to print specific database information, or the creation and usage of an authentication system, or how to upload an image, etc.
Thank you!