Group items tagged

This is my rendering of the comment submit section. Everything seems to be submitting correctly, however, i just can't seem to get the database to populate. I reviewed the videos mutiple times with no answer. I thought it may be the 'localhost' issue, but bluehost.com does not give any of the options that we saw on 'nfs'...after about 7 hours of troubleshooting and every possible configuration... if anyone has ideas i would love to hear them....other than that, the site works flawlessly. Hope you enjoy.

Well, "other than that" is pretty much at the core. I wouldn't have known it was a problem if you hadn't mentioned it (will have to change the assignment). But this is a really core thing to figure out. If you can't actually store the material, then you won't be able to do this sort of exchange when you want to make your own stuff. There's nothing obviously wrong with your code. My guess is that there is something up with your username/pass or table names, but without an "or die" statement, we'll never know...

I got my blueberry muffin recipe page to add some reader comments that had been collected on the database from my previous coding that populated the database.

Here is a page about MySQL. It explains why MySQL is the world's largest open source database and why it is usually the top choice when selecting database technology.

An online training course from Web Developers Notes that explains the MySQL commands to create database tables: rows, columns, records, assigning unique id numbers to individuals records. At the news organization where I work, developers have used MySQL to create databases for Connecticut high school football and basketball statistics. The stats are all displayed in tables - check it out at http://data.courant.com/highschoolsports/basketball/home.aspx

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.

Here is my sugar cookie recipe, updated to include a "See Comments" button to show users' the comment information from my database table. I tried to utilize CSS to style the table to match the html page.

Here is my revised cookie recipe which now include a comment box with sends users' comments to a database using PHP.

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.

This site is very helpful for review. While I was able to complete the PHP assignments some of the concepts were a little hazy. This site is helpful if you would like further explanation. The author provides example code and breaks down each step in a way that is easy to understand. For instance. Here was one of the basic examples:\n\nLoops like these come in handy whenever you're working with long lists of things (such as jokes stored in a database... hint-hint!), but for now we'll illustrate with a trivial example: counting to ten.\n\n$count = 1;\nwhile ($count );\n $count++;\n}\n\nKind of scary-looking, I know, but let me talk you through it line by line.

This is a MySQL tutorial that you can download to help you understand MySQL databases and php.

The following is a site complete with all sorts of tutorials for PHP and MySQL. It is separated by topics such as Setup, Admin, Syntax, Database, Connect, etc, and allows you to jump in where ever you feel the need to. I'm a newbie, so this site has been great to read through.

All I did here was add a couple small forms at the bottom for the user to leave their name and a comment and I also connected it to a database to catch record the information. Took me a while...

Matt: Is this working? Have you checked the database to make sure content is being saved? Why am I seeing code on the form page?

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

This is my recipe with a submit button that stores the information given into my database.

This site offers mySQL tutorials and even shows how to create a database by making a blog.

A MySQL cheat sheet from the folks at Added Bytes. It isn't much for specific syntax, but it gives a broad overview. Explains different types of data used in setting up your database table. Also much date and time info, functions, and some sample select queries. Gives a feel for what's involved with the PHP/MySQL combination.

How to debug your PHP program in case your server, database or table malfunctions. This is real important and could save you valuable time ... days, perhaps!!

this page submits info into my database where i can read it, and then choose to respond. i added the javascript to this pages that requires an entry in the name, email and comment fields as well as a valid email address... comments in the .js file show where i got my code and help from. it validates

A tutorial on how to create forms and make them interact with php. Here, I take you step by step through nearly everything you need to know to get those databases primed and ready to go.

This is a link to a helpful tutorial page that defines some of the types in database. none of the examples in the lecture are text, but in the challenge the data is primarily text which lead me to believe that the type should be text. I received an error message when doing this. As I searched to find troubleshooting help I found that the varchar type also includes text.