28 Beginner’s Tutorials for Learning about MySQL Databases

by Jake Rocheleau
on October 22, 2012

in Tutorials

Get the FlatPix UI Kit for only $7 - Learn More or Buy Now

Developing and programming with databases is a huge step onto a large plateau of information. Nobody starts out with MySQL and masters the software in a week. Not only do you need to learn setting up DBs and tables, but also the SQL language itself.

This rough road was very difficult to traverse maybe 5 or 10 years ago. But there is much more information online today which is generally very helpful. Thus I have scoured through Google and put together 28 of my personal favorite MySQL tutorials for newbies. You can learn all the basics of setting up a database and connecting into your own application. But additionally if you have any questions or comments on the gallery, feel free to share with us in the discussion below.

Pagination SQL Server vs MySQL

Read More

Code a Mobile-Friendly HTML5 Video Stream with Multiple Sources

by Jake Rocheleau
on September 27, 2012

in Tutorials

Get the FlatPix UI Kit for only $7 - Learn More or Buy Now

New media on the Internet has gone through a rigorous process of quality control and best practices for web developers. Back just a few years ago Flash video was the most prominent solution. But with HTML5 support in all modern browsers the solution to embedding audio/video media has become a lot less complicated.

In this tutorial I want to explore how we can build a very simple webpage for embedding mobile-responsive HTML5 video. I have included two versions of the page – one with standard HTML5 video and the other using Video.js. The HTML is almost identical which shows how much progress HTML video has made in a few short years. But you can check out a demo of both pages from the links I’ve included below.

Preview Screen HTML5 Video Stream MP4/WebM

Read More

Dynamic TinyURL Links Generator using jQuery

by Jake Rocheleau
on August 23, 2012

in Tutorials

Get the FlatPix UI Kit for only $7 - Learn More or Buy Now

There are so many web applications available for shortening URLs to share online. TinyURL is one of the originals and has been around longer than I can even remember. Their service is always online and it works perfectly for translating into tweets or posts on Facebook.

In this tutorial I want to build a mini-app which will generate tiny URLs right from your web browser. You could install this script on any domain and you’ll be able to generate dynamic links using Ajax without even refreshing the page! Their service doesn’t have a detailed API but it’s enough that we can pass a full URL and get the tiny version back as a result. And that’s just enough functionality for this app to hold some value when hosted on a 3rd party website.

TinyURL Links Generator with Ajax - preview

Read More
Page 6 of 25« First...45678...Last »