Popular

Top Rated

Search :

Sponsors

Find Any Hosting

Offshore Software Development

Categories

Home » PHP » Tips and Tutorials » Database Management

RSS

Sponsors

Database Management

Display MySQL table as HTML example

Home | Rate It | Error

This example use MySQL functions from PHP to display full MySQL table(every column and every row) as HTML.

Price:Free Rate:

0.0(out of 5) Vote:0

Get metadata on MySQL databases

Home | Rate It | Error

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

Price:free Rate:

0.0(out of 5) Vote:0

Optimize All Tables In A MySQL Database

Home | Rate It | Error

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.

Price:free Rate:

0.0(out of 5) Vote:0

SImple PHP Database Abstraction Class

Home | Rate It | Error

This DB connectivity class makes it even easier to work with data from MySQL databases. It handles errors, features a better result object, and allows you to iterate through the rows returned by a SELECT query.

Price:free Rate:

0.0(out of 5) Vote:0

How to connect to MS SQL Server database

Home | Rate It | Error

Before you can get content out of your MS SQL database, you must know how to establish a connection to MS SQL Server from inside a PHP script. This tutorial describes how to connect to MS SQL database with a DSN and without a DSN.

Price:free Rate:

0.0(out of 5) Vote:0

A script to generate a report from a valid mysql connection

Home | Rate It | Error

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.

Price:free Rate:

0.0(out of 5) Vote:0

5 useful PHP functions for MySQL data fetching

Home | Rate It | Error

PHP usually comes with mysql extension mysql (mysql_... functions) which is rather low-level and requires writing too much code for a trivial tasks: error-checked execution of SQL queries, getting single row from SQL table, getting value from SQL table cell, etc. OOP mysqli extension isn't any better. In this article we present 5 useful functions which greatly simplify majority of real-life MySQL operations.

Price:free Rate:

0.0(out of 5) Vote:0

DSN and DSN-less connections

Home | Rate It | Error

DSN stands for 'Data Source Name'. It is an easy way to assign useful and easily rememberable names to data sources which may not be limited to databases alone. DSN-less connections don't require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. This tutorial will show you how to connect to an Access database with a DSN and without a DSN.

Price:free Rate:

0.0(out of 5) Vote:0

Select random records from a MySQL database

Home | Rate It | Error

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. a

Price:free Rate:

0.0(out of 5) Vote:0

Importing csv data into MySQL with php script

Home | Rate It | Error

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.

Price:free Rate:

0.0(out of 5) Vote:0

Pages : 1 2 3

Home | Feedback | Advertise with us
(c) Copyright 2006 AdvanceScripts™. All rights reserved.
No part of this website may be reproduced, copied and/or distributed in any medium without express written permission
Trademarks are property of their respective owners
Site Developed and Hosted by Ethic Solutions

Hosting Resources Free Tutorials Flash Tutorials Webmaster dicussion forum Web Directory phpLDHacks Bollywood Discussion