Group items tagged

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

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.

Convert spreadsheet cells to HTML tables by copy and paste. This site was created by a fellow online producer at the Orlando Sentinel. I've found it to be rather helpful for presentation of data.

A staple of the raw food diet. Looks green, tastes good!

So, great page. But :)... Tables for layout is bad news. There's no way to predict how it will be viewed on some devices, and it makes it harder (in some cases) to be spooned into a CMS. So, fine for now, but lose the <table> habit for anything other than tables as we move forward. (In this case, floating the image to the left would accomplish the same effect, but provide a liquid layout...)

Muy buen plugin de jquery para ordenar tablas

I couldn't bring myself to add these entries on the bottom of my existing module 2 website - instead I went back and added links to the existing pages to this 'new' page, which echoes entries from a data table created entirely in myphpAdmin. PS - my boyfriend actually hates The Land Before Time. I was just having a little fun.

This page has the php that shows the comments that are in the mySQL db table. They are displayed for all the world to see.

The form on the bottom takes a name and comment and then inserts it into a mysql db table.

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!!

cssbasics.com - Everything you ever wanted to know about the basics of CSS (Cascading Style Sheets) table of contents

CSS Table Styles are coming.

I took my recipe html file and tried cleaning it up. After numerous attempts to fix my code myself, I clicked the "Clean up Markup with HTML Tidy" button. HTML Tidy basically truncated my table-specific CSS and aggregated it at the top. I suppose I'll learn how to do this myself when I begin on Module 2. Instead of changing the original file, I saved a new one to show to the code difference at http://marie.nfshost.com/recipe2.html

HTML Tidy is a lifesaver--as long as you look at the changes and can figure out why they have happened. (It also makes it prettier, if you use the "indents" feature.)

Here is my variation on the Baseball Cards challenge. There are 3 different images to choose from, and the info displayed after submission (as well as the drop down itself) is generated from a database table. If you'd like to learn more about my friends & family, take a peek!

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!

This is a link to a working comments page (linked to a database table) which requires a valid name and email address before submission using Javascript. An error message appears & fades at the bottom of the form if something is omitted. I also made the same thing happen using PHP, so there are also messages at the top of the page from that code. I got the Javascript from http://www.leigeber.com/2008/04/dynamic-inline-javascript-form-validation/, and included this citation in my js page. Upon submission, a thank you message appears at the top of the form.

Nice!

how, with a little bit of help, i figured out how to get user inputted info into a MySql table.

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...

The blueberry muffin recipe now includes a way for people to send in their names, email addresses and comments about the recipe, and my database will keep track of all the information, ready to spit it out to me at a moment's notice!

A website whose purpose it is to be a one-stop shop for all your html coding needs.