CIS 627 (Web Database Services Development) Week 10

Odds and ends

1. MYSQLDUMP
   
   

   Some resources

   • DatbaseToSQLScript.ppt: presentation on using mysqldump to create a SQL script for a database. You will submit a script for your project database.
   • mysqldump using xampp server shell in localhost
2. Best practices
   
   

   Resource

   • Pick four of the "best practices" from the youtube playlist PHP Best Practices and write two or three sentences of summary and/or reaction to each tutorial
3. User IP, CURL, and User Location
   
   

   Some resources

   • Uses CURL and SimpleXMLElement to read and parse a remote xml file XML_Reader_CURL.php XML_Reader_CURL.zip
   • PHP Tutorials: Show Recent Twitter Tweets using cURL
   • Beginner PHP Tutorial - 66 - Better Way to Get Visitors IP Address
   • Getting User Location Information with PHP
   • Write a page that grabs the user's IP address and accesses some of their geolocation information using an API. (You might need to test this one on the alpha.)
4. Autocomplete
   
   

   Some resources

   • jQuery Autocomplete Tutorial with PHP and MySQL
   • jQuery Autocomplete Tutorial with PHP and MySQL
   • Write a page that uses a table from NorthWind (e.g. Products, Customers, etc) to make an example of the autocomplete functionality where the choices come from a database.