Today I am going to show you how to build small RSS reader application using jQuery Mobile. This tutorial will show you advanced use of jQuery Mobile to make a real life application with database backend using PHP, MySQL and jQuery.
Archive for mysql
Many developers often forget to optimize mySQL so I bring you some good tips on what to do to help your database work.
Many of us write SQL queries. I am giving six example of some advanced but very useful ones that will make your life easier.
I had quite a few requests to rewrite the tutorial for making a shoutbox using mysql functions because some shared hostings do not have PDO extension allowed. So, here it is.
I was looking at Google Instant Search the other day, and asked myself : What if I do the similar thing to login functionality. I had to try it, so here it is, a jQuery Instant Login and how to do it.
Today, I am going to make a simple shoutbox using PHP, MySQL and jQuery. I am going to use the PDO for database access and try to explain why is it better that old mysql or mysqli functions.
Today I am going to explain usage of key/value tables in database design. This has nothing to do with NoSQL initiative or databases. Just an interesting approach to database design with its pros and cons which I will explain through nice example.
You built your site and everything is working fine, but when there is a lot of users on the site, your database becomes a bottleneck. I will show you how to deal with it using simple file cache system for your database results.