mysql



Fix SQL INSERT problems with PHP addslashes function

If you’ve created you own custom content management system using PHP, you may have noticed problems inserting data. One of the problems could be that your data may have characters that prevent it from being inserted. Some of the character that would cause this type of problem are single or double quotes, backslash, and NUL [...]

(No Ratings Yet)
02.14.10


How to backup MySQL Database via SSH

First you log in using your terminal application by typing the flowing SSH command:
ssh yourusername@hostname-or-ipaddress
After that, you will be prompted to enter your password. As you enter your password, the text will be hidden. Next we should switch to the “root” user. You can do so by typing the following in your terminal window:
su – [...]

(1 votes, average: 1.00 out of 5)
11.27.09


Select UNIQUE or DISTINCT MySQL/PHP Queries

How to filter / remove duplicate items in your database query result using DISTINCT

(7 votes, average: 4.14 out of 5)
04.19.09


PHP MySQL Order by Two Columns

Here’s how to order your data by two or more columns using PHP and MySQL

(21 votes, average: 3.90 out of 5)
04.12.09


MySQL Table Fields Data Types

Learn MySQL data types like Numeric Types, Date and Time Types and String Types for building dynamic web sites.

(6 votes, average: 2.50 out of 5)
12.25.06


Create MySQL Database With PHP

Create a dynamic web site by using MySQL Database and PHP. It is easy and I provided the code to cut and paste.

(1 votes, average: 3.00 out of 5)
12.25.06


PHP Order By Multiple Fields in MySQL

Want to be able to order by two or more database fields / columns using the ASC and DESC order clause

(18 votes, average: 4.22 out of 5)
07.16.04


PHP Search using WHERE, AND, LIKE, OR Query Functions

How to search multiple fields in a database

(13 votes, average: 3.92 out of 5)
07.16.04


Polls and Comments with PHP and MySQL

Create a poll voting and comments system with the help of PHP and MySQL. Explains in details the script and database design.

(1 votes, average: 5.00 out of 5)
04.10.04


Installing PHP MySQL Apache on windows 98 in 5 min

This article on “Installing Apache-MySQL-PHP on Windows 98″ in just five min is a complete step by step tutorial to install this trio package. The article contains full graphics snapshots to help the new developers to install the trio package without any

(No Ratings Yet)
03.19.04