Set up Last Minute scrape/php web pages
- Update screen-scraper:
- Save the attached "RCI (Scraping Session).sss" file to the screen-scrape 'import' directory
- Launch screen-scraper workbench once more to ensure update occured, and automatically imported the scrape. (If you're prompted to update to the latest version when you launch screen-scraper, do it.
- With the workbench open click on the wrench icon in the menu bar. This should bring up the settings window.
- Change the 'Connection timeout' value to 180
- Change the 'Data extractor timeout' to 20
- Make sure that the 'Default Character set' is set to 'ISO-8859-1'
- Update the database with the provided new database:
- The sql database file is "lastMinuteDatabase.sql". Import the .sql file into the MySql database named 'last_minute'
- Update the php scripts
- Copy the contents of the 'php' folder to the appropriate web server folder. (If you keep your old '/inc/dbconnect.php' file you won't have to follow the next step)
- Edit the 'inc/dbconnect.php' script to connect to the local MySQL database.
- Set the '$server', '$user', and '$password' variables at the top of the script
- Make sure the user has read/write permissions to the 'last_minute' database.
- The scraping sessions should now be ready to run.
- The page to edit the resort information for you should be at: 'http://localhost/lastminuteusvacations/php/admin/listresortstoedit.php'
- When the page loads there should be a list of all the resorts that don't have a value in the 'state' field. (You can also see all the resorts if you click the 'Show all resorts' link at the top of the page.)
- Click on a resort's name to go to the edit page.
- All the fields from the database are listed here and you can edit them. Be aware however, if you change the resort name the next time you run the scrape the scrape will think the resort doesn't exist and add another one.
- Click the 'change' button at the bottom of the page when you are done editing. You will be taken back to the list of resorts.