Group items tagged

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.

My comments form for challenge 4-F. Took a long time, but I finally got it.

This is my 3 page, well 4 page website for module 2. They are all linked to the same CSS sheet. It's about great rivalries in Boston Sports and has a lot of other fun links too. Enjoy!

This is my rendering of the fibonacci sequence. I must admit that i had done this previously using javascript (when I was an undergrad, 4+yrs ago) and I would not let myself 'cheat' by researching other web sites. After sketching out the functionality and few tries I was able to get it, but I did have some difficulty with the formatting, for whatever reason, I could not get the '\n' to work, instead, i decided to echo a
tag.

Hmmm... close enough. 0 1 1 2 3 5 etc.

I added a comment to the viddler timeline. This comment is useful in terms of validation. When you go to validate your pages and you have included "POST" the page does not validate. For validation purposes you must enter it as "post".

Here is my comment on the last video about forms in PHP. I found it very helpful.

Here's a video comment on this "most important segmet so far" - in which "pitch" and "catch" sail over my head. Guess that makes me the monkey in the middle.

Anyone with insight into Tiny WIki out there?

This is my rendition of the ESP cards with random card generation. This one had taken me a while because I wasn't quite getting the concept of how the url were being passed. After re-watching the videos, I was able to grasp the concept better. I had originally thought that i could have the php function on a switch and then have a hidden input variable passed to the url...turn out i was over-thinking it....rather than give away the answer, just see for yourself!

Nice!

This is a Guestbook for my photo site that I made back for module 2. i wanted to have the entries be displayed like a blog, with the most recent posts displaying on top of the older ones so in the SELECT.... i used the ORDER BY feature to do this. i also noticed that everytime i loaded the page, an empty posting would show up on the guestbook, so in the SELECT i had to specific WHEN something specific was happening... aka.... when the name field was filled out. that is why there is a *required next to the name input

this is my version of the card game page, but where the card facing down is a random card, not the established heart card. i spent a few min. hitting the same card to see if they would eventually match, but then i got bored. I think this code should work, should is key. Prof, i will email it to you as per the webprog instructions to see if theoretically it would work.

Deja vu. Thought I commented on this, but maybe not. It sends the following as the realcard: cards[0]. Hard to match that with a 1 through 5.

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.

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

About.com is always a good place to start because it provides a general overview with links to other resources. The MySQL article on About.com explains the basics you need to learn SQL code to use with your MySQL database.

This site presents a nice overview of what PHP can do, why you would want to use it. It starts you off with a very simple explanation and examples. I know there are alot of different introductions out there, but this is just another example. We all have to find things that we personally find easy to use.

Just a quick bookmark. I used this site to help me create a couple small forms to add to my recipe page. Very helpful.

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.

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

This page lets you submit a comment, and then displays it on a new page.

OK, I finally got this working correctly! Take a look and leave a comment.

This is a new and improved recipe page that allows you to leave a comment at the bottom.

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