MySQL
Super Ajax Polling/Voting System using JQuery, Ajax, PHP and MySQL
Polling system or Voting system is very common in web sites. Voting can be about your site or blog or some other thing just to get the user attention and get your idea about your product.
I always tries to provide the users of 99Points.info some common but useful scripts which makes their effort succeeded. So after some voting system tutorials like
Digg style Voting now I have come to simple ajax based polling system. This is another series of Jquery. Hope You like it and don’t forget to subscribe and give your feed back in comments. Thanks !
MySQL date_format: To get date in different styles.
My SQL has a special function that allows the developer to format the date in any way they wish by specifying a sequence of format strings. A string is composed of the percentage symbol ‘%‘ followed by a letter that signifies how you wish to display part of the date. These are some of the more common strings to use:
How To: Create database indexes in PHP/MySQL ?
Any RDBMS like MySql are geared to perform read operations better than write operations. The efficiency in read operations are achieved by database indexes.
Indexes are most important in optimizing databases. If an application has large database then it is always optimized and indexes are part of this section.
