Categories
PHPTips and Tutorials → Database-Related

Export Database Schema as 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.
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

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!
  • Platforms
    • Linux
  • Licenses
    • Freeware
DETAILS

Select random records from a MySQL database

Sometimes it could be very helpful to select a record from a table randomly. You can find such solution when you see random partners or randomly selected tutorials. This tutorial shows you how to select records randomly from a MySQL database.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

Importing csv data into MySQL with php script

This tutorial will show you how to import csv data into MYSQL with a simple PHP script. Many times you have to write a script because the import function in phpMyAdmin will not import the way you want.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Sun Solaris
  • Licenses
    • GPL
DETAILS

Optimize All Tables In A MySQL Database

If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

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...
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

Caching your pages with php

Php caching techniques to increase database overhead. Those caching techniques are very useful for high traffic web sites.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

A class to connect mysql servers using text files

If you''re using different databases and remote sites to test and/or install scripts. Here is a little class which can prevent some troubles. When connecting a remote mysql_server, it reads a file where all connection items such as host, user.. ...
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

A script to generate a report from a valid mysql connection

A script to generate a report from a valid mysql connection. The user has to supply which fields he wants to display in table. All properties are changable.
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD,
    • Mac OSX,
    • Sun Solaris
  • Licenses
    • Freeware
DETAILS

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 abstracti...
  • Platforms
    • Linux,
    • Windows,
    • FreeBSD
  • Licenses
    • Freeware
DETAILS

Page:
©2003-2019 jCay.com