Categories
Tags → In Mysql Query

florDBProcess: The easy way to do MySQL database scripting with PHP

Coding data access methods in PHP for the MySQL we very often come across the same connect, fetch, query and other methods. Here is a php script which creates a class for DB access, called DBprocess, and in a way makes inserts, updates, selects...
DETAILS

Zipcode Proximity script

Find all the zip codes within a radius of x miles from another zip code OR find the distance between 2 zip codes. This program was written with simplicity in mind. It is VERY easy to use and install. I even included a working example. This script c...
DETAILS

IAM-XLS

This class can be used to generate Excel spreadsheets in XLS format. It can add text or numeric values to given rows and columns of a spreadsheet. The class may also execute a MySQL database query and generate a single spreadsheet with th...
DETAILS

Counting records in PHP/mySQL

Following code samples, demonstrates how to count records in a MySQL database table. You may send parameters to query to display only selected range of rows.
DETAILS

IdealMySQL Database Class for MySQL

This is a MySQL class I wrote to use in my programs. It will allow you to do the following: - Connect to a mysql database - Query a mysql database to include * INSERT|DELETE|UPDATE|REPL ACE|DROP * SELECT|SHOW|DESCRIBE|EXPL AIN - Cat...
DETAILS

Creating an object oriented MySQL abstraction class

In this tutorial I will show you how you can create an object oriented database abstraction class for MySQL database. Besides the basic functions this manager class can summarize total time spent with db connection and query execution and counts how ...
DETAILS

Dynamic (2 level) navigation list

The creation of a dynamic nested unordered list without using any JavaScript code is sometimes a problem because the script needs to &"remember&" the values, sub values and also the query string from previous clicked links. In this ...
DETAILS

Mysql Select Query

This simple script uses the DBI module in order to connect to a Mysql database, retrieves the results from a select query and display the results inside a while statement. There is a live example as a demo.
DETAILS

DB Driver

This is a Database Abstraction Layer written in PHP and it currently supports both MySQL and MSSQL. Support for other database systems can easily be added. The Driver also contains a few functions that might be useful for debugging: query count...
DETAILS

myPageDisplay class

This class can perform several tasks and you decide how much you want from it. In its complete form it can generate an interactable paginated columnar listing from a MySQL database. If you want to use it in parts you can generate XHTML tables ...
DETAILS

Page:
©2003-2019 jCay.com