want to join us? register, it's easy | help

browse by tag: mysql

sort by

newest, oldest, most popular


category icon

How to run a SQL query in phpMyAdmin

in PHP added by Brandon, on 15/4/2007 beginner tutorials mysql php phpmyadmin query

This will provide you basic information on how to use phpMyAdmin

comment save report
category icon

5 useful PHP functions for MySQL Data Fetching

in PHP added by AnyExample, on 5/4/2007 database databases fetching data mysql

In this article we present 5 useful functions which greatly simplify majority of real-life MySQL operations: error-checked execution of SQL queries, getting single row from SQL table, getting value from SQL table cell, etc.

comment save report
category icon

Export Database Schema as XML

in PHP added by Nolte, on 14/2/2007 databases mysql php schema xml

Sometimes it can be useful to have a dump of the current database schema. This script reads the schema from a MySQL database and outputs XML that describes the schema.

comment save report
category icon

Simple PHP/MySQL Pagination

in PHP added by goodphptutorials, on 3/2/2007 databases mysql pagination

Learn how to implement pagination for results from a MySQL database. Full code for a php pagination class is presented.

comment save report
category icon

AJAX Chat Tutorial Part 5: The Javascript, Sending Chat Messages, Screen Name Changes

in PHP added by CalEvans, on 14/1/2007 AJAX JavaScript mysql oo programming zend framework

Part 5 of our 7 part tutorial on creating an Ajax based Chat application.

comment save report
category icon

The 10 mistakes you should avoid with PHP

in PHP added by regindk, on 10/1/2007 advanced tutorials mysql php security

A list of the 10 most common mistakes done by PHP developers and how to avoid them.

comment save report
category icon

AJAX Chat Part Tutorial 6 : Updating the User List

in PHP added by CalEvans, on 8/1/2007 AJAX media mysql php zend framework

This is Part 6 of a 7 part tutorial on how to create an web based chat application using Ajax, MySQL and the Zend Framework.

comment save report
category icon

An Introduction to Database Normalization

in PHP added by goodphptutorials, on 3/12/2006 database databases mysql normalization

This article will take a practical look at database normalization, focusing on the first three of seven generally recognized normal forms. Additional resources that look at the theory of database normalization and the additional normal forms can be found in the Resources section at the end of this article.

comment save report
category icon

How to connect to MySQL database using PHP

in PHP added by goodphptutorials, on 29/11/2006 database databases mysql php

Before you can get content out of your MySQL database, you must know how to establish a connection to MySQL from inside a PHP script. To perform basic queries from within MySQL is very easy. This article will show you how to get up and running.

comment save report
category icon

PHP Login Script with Remember Me Feature

in PHP added by goodphptutorials, on 23/8/2006 account logon mysql signup user authentication

I just started programming with PHP and MySQL this week and the first script I wanted to write was a login script. I wanted to include the popular "Remember Me" feature seen on a lot of websites that basically keeps users logged into the website, even after they've closed the browser so that the next time they come, they won't have to login again manually.

comment save report
category icon

Five common PHP database problems

in PHP added by goodphptutorials, on 11/8/2006 database problems databases mysql troubleshooting

Discover five common database problems that occur in PHP applications -- including database schema design, database access, and the business logic code that uses the database -- as well as their solutions.

comment save report
category icon

Three-Tier Development with PHP 5

in PHP added by goodphptutorials, on 21/3/2006 advanced tutorials mysql php5 smarty tier

This article will demonstrate the power of three-tier development in PHP 5, using PEAR::DB_DataObject for the business logic and Smarty for display logic. I assume that you have some familiarity with HTML, Smarty, PEAR::DB_DataObject, MySQL, and PHP 5

comment save report
category icon

PHP/MySQL News with Comments

in PHP added by goodphptutorials, on 26/2/2006 comment content management mysql news

In this tutorial, you will learn the concepts behind building a news system with PHP and MySQL.

comment save report
category icon

Managing Users with PHP Sessions and MySQL

in PHP added by goodphptutorials, on 31/1/2006 cookies cookies and sessions database mysql sessions user

In this article, I shall provide an overview of the system I developed, beginning in the first half with the user signup process. In the second half, I'll focus on the site itself, how it requires users to log in and then maintains that logged-in status throughout their visit.

comment save report
category icon

Building Database Interfaces

in PHP added by goodphptutorials, on 12/1/2006 database databases dml interface mysql objects oop query

This article is about using and building Database Interfaces (DB interfaces). DB interfaces make application development faster and easier. This is accomplished by relocating scattered DML (Insert, Update, Delete) statements into a single shared tool, the Class. A Class encapsulates data post processing, integrity, and security into a single tool that can be accessed throughout the application.

comment save report
category icon

The PHP Anthology Volume 1, Chapter 2 - Object Oriented PHP

in PHP added by goodphptutorials, on 12/12/2005 beginner database mysql objects oo programming

The object oriented paradigm is an approach to programming that?s intended to encourage the development of maintainable and well structured applications

comment save report
category icon

Object Oriented PHP: Paging Result Sets

in PHP added by goodphptutorials, on 12/12/2005 beginner mysql oo programming paged resutls queries sitepoint

In this article, I'll teach you the basic principles and features of Object Oriented Programming that exist in the PHP language.

comment save report
category icon

MySQL Functions

in PHP added by goodphptutorials, on 8/12/2005 databases functions mysql reference

The defacto reference for php's mysql reference

comment save report
category icon

Incremental MySQL Backups

in PHP added by goodphptutorials, on 4/12/2005 backup databases mysql

Backing up a database is something that should be done regularly on a dynamic driven website

comment save report
category icon

Build a People Online Counter with PHP and MySQL

in PHP added by goodphptutorials, on 4/12/2005 counter databases mysql stats tracking visitors

Building a counter is easy. Building a counter that will tell you how many people have been on your website in the last five minutes takes a little more planning

comment save report