A database is a fundamental component for most web applications. If you’re using PHP, you’re probably using MySQL–an integral part of the LAMP stack.

PHP is relatively easy and most new developers can write functional code within a few hours. However, building a solid, dependable database takes time and expertise. Here are ten of the worst MySQL mistakes I’ve made (some apply to any language/database)… Continue Reading…

In this tutorial I’m going to show you how you can use the php library called PHP Excel Reader to read excel files using php. Yes, things like excel readers for php has already been written by smart people in the past so I’m not going to show you how to build an excel reader from scratch. It’s not quite my level yet, I still consider myself a beginner. Anyway, let’s get to the main topic.

Requirements

Sample Spreadsheet

First you need to have a sample spreadsheet that you could  work on. Just make it simple, preferably a 2-column sheet with a  few data on it.

To Read More Click Here

Source: http://kyokasuigetsu25.wordpress.com

All Credits goes to respective author of the article.

With the help of some advanced selectors a dropdown menu can be easily created with CSS. Throw in some fancy CSS3 properties and you can create a design that was once only achievable with background images and Javascript. Follow this tutorial to see the step by step process of building your own pure CSS dropdown menu.

The menu we’ll be creating features two sub categories that appear once the parent link is activated by a hover. The first series of sub-links appear underneath main nav bar, then the second series of links fly out horizontally from the first dropdown. Take a look at the CSS dropdown menu demo to see it all in action.

Demo

To Read Full tutorial Click Here

Source: Line25.com. All Credits goes to respective author of the tutorial.

Hey guys. Today we’re going to take a look at how you can build a single-page application (SPA) supporting graceful degradation using some of jQuery’s Best friends; DocumentCloud’s Backbone.js, Underscore.js, LAB.js and jQuery templating to name but a few.

Alex Sexton has been giving a great presentation highlighting these tools in few recent conferences and I thought it would be useful to write up a tutorial to compliment their use.

 

The SPA application we’ll be building today is a three-level bookmarkable image gallery. Before we get started, please feel free to check out the demo below or download the sources for the tutorial.

To Read More  Click Here

Credits to : addyosmani.com

Today we will start learn on developing Windows 8 Apps and setting up an development environment.

Here is the following articles by Jennifer Marsman from MSDN Network:

Choose a development language

You have three choices of languages for development of Metro apps:

  • XAML and C#/VB.NET/C++
  • HTML5, CSS3, and JavaScript
  • DirectX

If you are porting an existing application or website, that may make the decision easy.  If I were porting a Windows Phone app that I had written in Silverlight, I would choose to port to XAML.  If I were porting an existing website to a Metro app, I would choose to port to HTML.  Both of these choices would require the least amount of work.  (For more information, see my post on porting apps to Metro.)

If you are starting an application from scratch, make a decision based on your background and experience.  For example, HTML is the best option if you come from a web development background and you’ve never used XAML or C#.

Finally, here are the tips that have helped me as a developer to create better design:

Use the resources at http://design.windows.com.  There is design guidance, case studies, and design assets (such as .psd files for Photoshop).  In particular, I like this food truck case study which walks through the process of converting a website to a Metro-style app, showing the before and the after.

I visit the UX guidelines regularly.  The other day I was trying to figure out the best way to input some text fields in a Metro app, and I found this guidance for text input which gave me checklists, guidance on which controls to use, and some common “do’s” and “don’ts”.

The Visual Studio templates will help you get there.  If you start from the Grid or Split template in Visual Studio Express 2012 for Windows 8, you will begin with good Metro design.  The templates have navigation, animations, and font hierarchies already in place.

Credits: Jeniffer Marsman