Categories
Tags → Mysql Update Select

Simple csv to MySQL tool

This code will take a csv file and create or, insert or update, the data into a MySQL database. It assumes the first line contains the field names and uses that to build the SQL query for the following data lines. There''s a download button fo...
DETAILS

mySQL database class compatible with PDO for PHP 4+

This is a mySQL database class, that allows you to run queries faster and supports prepared statements, just like PHP 5''s PDO, but working for PHP 4. It supports: - persistent connections; - raw query, just like mysql_query; - select func...
DETAILS

Database Functions

This class can be used to build and execute MySQL database queries. It can build SELECT, INSERT, UPDATE and DELETE queries from lists of parameters and values. The class can also execute the generated queries and retrieve the SELECT query...
DETAILS

SamMySql Database Class

This class wraps common MySQL database table SQL queries. It can: - Perform SELECT queries and retrieve a single value, a single row into an array and all rows into a multidimensional array. - Insert or update rows from a list of fields and v...
DETAILS

vpSQL

vpSQL is a small set of functions (under 13k) that interacts with a flat file database through a subset of sql instructions. vpSQL accepts the the following sql statements: SELECT fields FROM table[WHERE][ORDER BY][lLIMIT] INSERT fields,dat...
DETAILS

PHP MySQL Database Class

A class for very basic MySQL database connectivity. Written to reduce redundant code in my own projects aswell as aid in debugging and error reporting during the developement phase. Currently connects to a database, execute external files containing ...
DETAILS

Cascade Select

This class is meant to generate two HTML form select type inputs making the currently selected value on the first input determine the option values that are made available on the second. It uses JavaScript to update the second input options when...
DETAILS

Comdev CSV Importer

The CSV Importer component is the only tool that offers you the shortcut to maintain your MySQL database. Using CSV format file, everything is easy to work around with data that you have updated using spreadsheet software like Microsoft Excel. Key fe...
DETAILS

DaDaBIK for PHP-Nuke Vers. 7.1

DaDaBIK Database Interface Module for PHP-Nuke (from version 6.5 onwards, tested on PHP-Nuke 6.x - 7.3) with additional functions such as user authentication and e-mail notification. DaDaBIK is a free PHP application that allows you to easily c...
DETAILS

PHP CSV Importer

A script to import data to a MySQL database from CSV files. Open a CSV file and preview it. Then, connect to your MySQL database, select which fields should receive which column (or set value) and then import. You can add, update or even add and upd...
DETAILS
©2003-2008 jCay.com