Group items tagged

Here is PHP and MySQL manual that Professor Halavais directed me to when I was having (and still having) trouble with Module 4's challenges.

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.

I know I am jumping ahead a little bit here, but I saw this and decided to start tagiing some stuff down the road a little. This might help with some stuff in the futureI know I am jumping ahead a little bit here, but I saw this and decided to start tagiing some stuff down the road a little. This might help with some stuff in the future.

I know I am jumping ahead a little bit here, but I saw this and decided to start tagiing some stuff down the road a little. This might help with some stuff in the future.

Here is a 4 page site I made for upcoming Connecticut concerts for the month of February. I included a splash page that includes links to Toad's Place, Mohegan Sun, and The Webster. On each of the 3 venue pages, I included links to the venues' official website as well. Then, I included text about upcoming concerts. I purposely didn't link back to the splash page, thinking that once the user is into the venue sites, it wasn't necessary to return there.

This site seems to have some basic (read: semi-easy to understand) information written in non-geek speak. Just the basic opening paragraph explained it to me better than reading a bunch of other pages I found

While by no means a complete reference, this page gives a much more thorough overview on MySQL that a lot of the other sites out there. I especially like the 'tips and functions' section.

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?

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

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