Help? with Coding database modification script using a webform & frames...
I will have an Amazon book database that is updated regularly, say weekly. I need a program/script that I can run in IExplorer (as a page, or on a page) that will allow me to review any records that the category "Include?" lists as "Undecided" ; assign the record a "Yes" or "No" in place of the "Undecided" and then update the database. I only want to review undecided records. Another script will update the database with new records and another to mark records "to remove" when the link returns a 404 error.
I would like the display for this program/script to be in frames. Top frame needs to be only large enough for the "Yes" or "No" form buttons. Bottom frame would show the page listed in the "Amazon Detail Page URL". If this is not possible, then a form that lists a clickable link to the "Amazon Detail Page URL" would work.
When I click on "yes" or "no" I want it to record that information in the database and pull up the next undecided record for my review.
The Primary Key for this database will be: (int)
ASIN #
Other Data categories in this database: (all text)
Amazon Detail Page URL
Title
Author
Language
Format
Include? (Include this record on website? Yes/No/Undecided)
Remove? (NULL/to remove)
I am still a newbie with PHP. I am not even sure where to start with this script!
Any (advice / script code / or URLs for me to review) is Greatly Appreciated!
Thanks!
SR
I will have an Amazon book database that is updated regularly, say weekly. I need a program/script that I can run in IExplorer (as a page, or on a page) that will allow me to review any records that the category "Include?" lists as "Undecided" ; assign the record a "Yes" or "No" in place of the "Undecided" and then update the database. I only want to review undecided records. Another script will update the database with new records and another to mark records "to remove" when the link returns a 404 error.
I would like the display for this program/script to be in frames. Top frame needs to be only large enough for the "Yes" or "No" form buttons. Bottom frame would show the page listed in the "Amazon Detail Page URL". If this is not possible, then a form that lists a clickable link to the "Amazon Detail Page URL" would work.
When I click on "yes" or "no" I want it to record that information in the database and pull up the next undecided record for my review.
The Primary Key for this database will be: (int)
ASIN #
Other Data categories in this database: (all text)
Amazon Detail Page URL
Title
Author
Language
Format
Include? (Include this record on website? Yes/No/Undecided)
Remove? (NULL/to remove)
I am still a newbie with PHP. I am not even sure where to start with this script!
Any (advice / script code / or URLs for me to review) is Greatly Appreciated!
Thanks!
SR