This is a more advanced tutorial on using Ajax and PHP to extract a list from a MySql database that can be done in a way that an ordered list can't provide. After you've created the database, you use PHP and Ajax to drag and drop data in the order you want it extracted, then you can save the data in this newly-defined order.
Just wanted to share this example of a database powered by MySQL. It includes thousands of records for restaurants health inspections in Connecticut. It's dynamic and updated regularly with new reports. I didn't build it, but I admire the developer who did. I only helped with the HTML/CSS display
When setting up my database, I have been banging my head against the wall trying to figure out which data types to use for each item. I began by checking the MySQL homepage, but in the end I found myself getting more and more confused - they seemed to get tooo wordy and involved in the definition of the data type. I found this site to be much more helpful in describing the different data types - it gets right to the point and clearly explains with examples, what each data type does.
Recipe with comment form - much love to the Head First PHP & MySQL book, whose fabulous chapters 2-4 were very helpful, and kept many tears away. And love to Erica, for letting me know that creating the additional user was a MANDATORY step. <3
Here is my first venture in MySQL. You can leave comments on the bottom of the slightly restyled recipe page. Can't view them yet (that's phase 2), but they insert into the database.
Web Hosting Suggestion -- For module 4, I've added a comment to video #3 (11:40). For anyone on a very tight budget, this web hosting site is similar to NearlyFreeSpeech (PHP, MySQL support), but it's 100% free. It's been working great so far.
This is a brief, six question quiz to see how much of a Harry Potter nerd you are. If you get the easy ones wrong, the response you receive on the answer page will insult you accordingly. Ch.14 in the HTML & CSS book was incredibly helpful, as was Ch.1 Head First PHP & MySQL. I love the Head First books. I found this challenge to be easier than the dice, believe it or not.
Great site for free downloadable cheat sheets for HTML, CSS, MySQL, and seemingly everything else pertaining to web programming. Formatted in pdf to fit on one page to print for easy reference.
here's the 'home' for my 'rate my class' project.
as of this posting, i've got the structure of the site all laid out, it just needs some cascadingly stylish touches. i didnt use any javascript on this yet either. i just wanted to get something posted in time for the class deadline.
each class has its own php page, which pitches and catches to itself, and its own mysql table. the nav drop down links directly to each course.
enjoy!
In my search for how to use jQuery and AJAX to build a select drop down menu, I found this four part demo - HTML, PHP, jQuery and JSON (JavaScript Object Notation). It also includes an example of how to create multiple select boxes with data populated from a MySQL database.
Seems to be eating the last part of my URL. Is the VARCHAR big enough to hold big urls? Or is it something else? Be nice if the URLs were links (e.g., for the name). Nice, but unnecessary :).
