Sponsors
Database Management
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.
Price: Free Rate:
0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 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
Price: free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 A script to generate a report from a valid mysql connection
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
0.0(out of 5) Vote:0 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.
Price: free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 SImple PHP Database Abstraction Class
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
0.0(out of 5) Vote:0 5 useful PHP functions for MySQL data fetching
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
0.0(out of 5) Vote:0 How to connect to MS SQL Server database
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
0.0(out of 5) Vote:0 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. a
Price: free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 PHP Database Integration With MySQL
One of the defining features of PHP is the versatility it offers for connection to, and manipulation with, databases. In this article, we look at some features of the PHP and MySQL combination. We shall go through the following steps:- Connect to MySQL Database Server Create new Database Select MySQL Database Add data to table Retrieve data Error Handling
Price: free Rate: 0.0(out of 5) Vote:0
0.0(out of 5) Vote:0 DSN and DSN-less connections
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
0.0(out of 5) Vote:0