Tutlist.com - Browse by Tag: mysql

In an effort to tie the website and blog together, developers commonly throw together some quick PHP/MySQL programming to pull in recent blog post titles and links to the individual posts. Here’s the PHP and MySQL that accomplishes that task.

Submitted by: TJHooker
Submitted on: Apr 27, 2010

While developing web application , in many many places we face the problem where we can use only MYSQL and get the number of number of days between two given dates using MySQL.

Submitted by: JohnGalt
Submitted on: Dec 21, 2009

Pagination is a way of splitting up data into manageable chunks to display to a user, if you’ve spent more than two minutes on the internet chances are you’ve come into contact with some form of pagination.

Submitted by: JohnGalt
Submitted on: Dec 20, 2009

Most modern web applications today interact with databases, usually with a language called SQL. Lucky for us, this language is quite easy to learn. In this article, we are going to start with some basic SQL queries and use them to interact with a MySQL database.

Submitted by: JDStraughan
Submitted on: Dec 17, 2009

This tutorial will teach you how to install and configure Apache 2.2.11 + PHP 5.3 + MySQL 5.1.36 and PHPMyAdmin 3.2.0.1 for Windows Vista & Windows 7.

Submitted by: JohnGalt
Submitted on: Jul 11, 2009

Making a custom login system is a common task for beginning PHP developers. Jumping right into it, however, may not be the best approach. There are several important aspects do building a login system that not only makes it work, but makes it safe.

Submitted by: JDStraughan
Submitted on: Jun 30, 2009

A short while ago I wrote an article about using stored procedures in MySQL and extending MySQLi in PHP to execute them. I'm now going quickly cover some more advanced techniques you can use to reduce the amount of data transferred between database and application.

Submitted by: JDStraughan
Submitted on: Jun 25, 2009

The days are gone when the timestamps were displayed like “12 Jan 2003 10:50 pm”!!! A paradigm shift have changed the world to more “Live” stream based systems. Now the Web pages are not just data wrapped in HTML, but they have became more real with realtime interaction between people. And thus the timestamps also got changed to “2 mins ago”, “5 hours ago” like formats. This identify more lively the streams and you can visualize them as events happened just minutes ago.

Submitted by: JDStraughan
Submitted on: Jun 4, 2009

Web services are taking over the world. I credit Twitter’s epic rise to the availability of a simple but rich API. Why not use the same model for your own sites? Here’s how to create a basic web service that provides an XML or JSON response using some PHP and MySQL.

Submitted by: JDStraughan
Submitted on: May 7, 2009

If you are a regular at Reddit, you must have noticed the way people vote there. You can either vote up or vote down. Pretty interesting, huh? This tutorial will show you how to create such a voting system with jQuery, PHP and MySQL.

Submitted by: JohnGalt
Submitted on: May 5, 2009