Tutlist.com - Browse by Tag: sql

Learn HTML, JavaScript, PHP, SQL, MySQL. Practice HTML, JavaScript, PHP with online practice editor. Hundreds of examples. Pictorial presentation of topics. PHP code for MySQL statements. For each of the topics, versions and standards are mentioned and followed. Easy to follow. Regular updates.

Submitted by: subhbwn
Submitted on: Mar 1, 2011

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

String functions are mainly used to change the case of strings,concatenate strings,reverse strings,extract various part of strings and perform many other types of string manipulation. In SQL Server there is a Several built-in string functions to perform string manipulations.All below functions takes string input value and return a string or numeric value.

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