PHP Database-Related Tutorials and Tips

New Listings

Most Popular

Top Rated

Discussion

Link To Us

Search For:

Categories

Ajax

ASP

ASP.NET

C and C++

CFML

CGI and Perl

Flash

Java

JavaScript

PHP

Python

Remotely Hosted

Ruby on Rails

Tools and Utilities

Web Hosting

XML



	Sponsor Links

Home :: PHP :: Tips and Tutorials :: Database-Related

Sort Listings By:

Total: 152 Displaying: 21 - 40

Pages:

1 2 3 4 5 6 7 8

Migration of Access data to MySQL

	In this tutorial you will learn how to migrate "Access data to MySQL". It is very important for ASP TO PHP Comers. Enjoy It!
Free Version: 1.00 Platform(s): linux Updated: Mon Feb 12 2007

Member Reviews (0)

Visitor Ratings

Get metadata on MySQL databases

Getting information about databases if essential if you want to write generic and scalable applications. This code shows you how to get information such as all databases on the server, all tables in each database and all field and field info for each table. Even if you do not need to build on this code, you might want to copy the code which prints out all databases, tables and field information plus examples. Its a great way to get an overview of the tables you are working on for a project.

Free Version: n/a Platform(s): linux, windows, freebsd, osx, sun Updated: Thu Jan 25 2007

Member Reviews (0)

Visitor Ratings

Install ADOdb Database Abstraction Layer

	Do you get stressed out by mysql or other database queries? Do you use multiple databases and wish there was just one way to handle all of your queries? ADOdb is a system that executes queries to any type of database the same way, so you only have to know how to do it their way. This tutorial walks you through installing ADOdb on your web server, and configuring it to work with a mysql server.
Free Version: n/a Platform(s): linux, windows, freebsd, osx, sun Updated: Wed Jan 17 2007

Member Reviews (0)

Visitor Ratings

Caching your pages with php

	Php caching techniques to increase database overhead. Those caching techniques are very useful for high traffic web sites.
Free Version: n/a Platform(s): linux, windows, freebsd, osx, sun Updated: Tue Jan 16 2007

Member Reviews (0)

Visitor Ratings

Database Abstraction with ADODB

	The use of abstraction layers is a controversial topic among PHP users. There are reasons why people use them, and likewise why they don’t. In this article I will be going through the advantages and disadvantages of using the ADODB database abstraction layer.
Free Version: n/a Platform(s): linux, windows, freebsd Updated: Tue Dec 19 2006

Member Reviews (0)

Visitor Ratings

MySQL Table Fields Data Typs

	Learn the three main basic data types used in MySQL and how to utilize them to build a more effective dynamic web site. Lots of web developers use MySQL but not all of them harness the power of these features.
Free Version: n/a Platform(s): linux, windows, osx, sun Updated: Sun Dec 3 2006

Member Reviews (0)

Visitor Ratings

Alternate row colours using MySQL

	This tutorial teaches you how to number rows and give them alternate colours!
Free Version: 1.00 Platform(s): linux, windows Updated: Sun Nov 5 2006

Member Reviews (0)

Visitor Ratings

Display MySQL table as HTML example

	This example use MySQL functions from PHP to display full MySQL table(every column and every row) as HTML.
Free Version: n/a Platform(s): linux, windows, sun Updated: Wed Oct 25 2006

Member Reviews (0)

Visitor Ratings

Rankin project : Table listing, insert, modify & delete

All scripts contained within the 'rankin' original project folder are intended to offer the PHP/MySQL 'novice' access to a series of scripts which can be used as an instructional aid and a set of templates in order to get a good head start on developing web applications that maintain database records (list, insert, modify & delete records). Developed with 'top-down' methodolgy (not object oriented) in order to keep the scripts as easy as possible to follow the logic. E-mail gleonard@ticino.com for a free zip file of the entire project and request the 'rankin project'. If you would like to see a demo goto http://www.gleonardonline .com/rankin .

Free Version: v 1.0 Platform(s): linux, windows Updated: Tue Oct 10 2006

Member Reviews (0)

Visitor Ratings

MySQL FAQs - Managing Tables and Running Queries with PHP Scripts

	A collection of 18 tips on managing tables and data rows with PHP scripts. Clear explanations and tutorial exercises are provided on creating and dropping tables; inserting, updating, and deleting rows, selecting and looping through data rows by pages; setting auto-increment IDs.
Free Version: n/a Platform(s): n/a Updated: Mon Sep 25 2006

Member Reviews (0)

Visitor Ratings

MySQL FAQs - PHP Connections and Query Execution

	A collection of 18 FAQs on connecting MySQL server with PHP scritps. Clear explanations and tutorial exercises are provided on MySQL server connection; providing port number, user account and password; selecting or creating database; running SQL statements; checking execution errors.
Free Version: n/a Platform(s): linux, windows, osx, sun Updated: Mon Sep 11 2006

Member Reviews (0)

Visitor Ratings

Paging Results in PHP

	Following examples teaches how to query a mySQL database and getting results in pages. Every page displays results maximum 10 results in a single page.
Free Version: n/a Platform(s): linux, windows, freebsd, osx, sun Updated: Wed Sep 6 2006

Member Reviews (0)

Visitor Ratings

How to create and populate a database in your PhpMyAdmin

	In some content management scripts case one needs to create a database and also populate it (insert the tables from the example .sql file). It's the case of PhpNuke for example. You will learn here to create a new database in phpmyadmin and also insert the needed information. There are some images too, to help you grasp the info easier.
Free Version: n/a Platform(s): n/a Updated: Tue Aug 22 2006

Member Reviews (0)

Visitor Ratings

How to install a local server. Tutorial for PHPDEV

For those working on php and mysql a server is mandatory. But what if you cannot have a place to upload and modify or maybe you just want to develop your project privately and then install online? This is the moment a local server is needed. Your computer can "act" like a normal server if you have some programs installed. PHPDEV is a free program that, once installed, can offer you the tools you needed to work offline on your projects and still be able to benefit from all the features a server has. This tutorial will guide you through all the steps needed till you have a working local server on your PC.

Free Version: n/a Platform(s): n/a Updated: Tue Aug 22 2006

Member Reviews (0)

Visitor Ratings

Connecting,Inserting Data & Showing data from Mysql Databse

	This is an Easy Tutorials for Beginners of PHP. With this tutorial you will learn how to Connect to Mysql Databse,Insert Data into Mysql Database and Show data from Mysql Databse.
Free Version: 0.5 Platform(s): windows Updated: Wed Aug 9 2006

Member Reviews (0)

Visitor Ratings

SQLite Introduction

	This article is intended for PHP programmers interested in learning about the SQLite extension. The article will introduce the reader to the functionality offered by the PHP SQLite extension,and overview the benefits of SQLite in relation to other database systems. A basic understanding of how PHP and SQL work is assumed.
Free Version: n/a Platform(s): n/a Updated: Mon Aug 7 2006

Member Reviews (0)

Visitor Ratings

PHP Script Tips - Working with MySQL Database

	A collection of 21 tips on working with MySQL database. Clear explanations and tutorial exercises are provided on connecting and selecting MySQL database, creating and dropping tables, inserting, updating, and deleting rows, selecting and looping through data rows, searching by key words, setting auto-increment IDs.
Free Version: n/a Platform(s): linux, windows, freebsd, osx, sun Updated: Mon Jun 12 2006

Member Reviews (0)

Visitor Ratings

Check Database Permissions

	If you are the root user then it will display all the databases on the server, but if your not the root user then it will show all the databases that your user has permissions for. It's a really fun to play around with and can be expanded in a variety of ways. It's explained in the comments.
Free Version: n/a Platform(s): n/a Updated: Sun Jun 11 2006

Member Reviews (0)

Visitor Ratings

Useful String Manipulation

	The correct usage of PHP strings is essential when dealing with database queries submitted from User Forms, such as User Registration. Find out how to format strings before saving them in a database in this helpful tutorial.
Free Version: 1.0 Platform(s): linux, windows, freebsd Updated: Sun Jun 11 2006

Member Reviews (0)

Visitor Ratings

Basic mySQL Queries And PHP

	Learn how to issue basic mySQL queries using PHP and how to properly validate SQL queries before issuing them to the database server to prevent possible attacks or unauthorized access
Free Version: 1.0 Platform(s): linux, windows, freebsd Updated: Mon May 22 2006

Member Reviews (0)

Visitor Ratings

Total: 152 Displaying: 21 - 40

Pages:

1 2 3 4 5 6 7 8

Other iNET Interactive Sites:
Web Hosting Talk | dBForums | Mac Forums | Hosting Catalog