Free eBook - Interview Questions: Get over 1,000 Interview Questions in an eBook for free when you join JobsAssist. Just click on the button below to join JobsAssist and you will immediately receive the Free eBook with thousands of Interview Questions in an ebook when you join.

• Free Tutorials - HTML, Java, SQL, PHP, ASP, Perl, SQL Tutorials
• Discuss Programming Problems and Freshers Jobs related issues here.
• Discuss Final Year Project Ideas here.

Script Name PHP Excel Parser This script reads MS Excel file and transports its data into Database, or HTML-page, etc. It does this using PHP under Unix and Linux without Windows tools like COM. The parser imports data from Excel files (versions 5.0/97/2000/XP). Imported Excel data type: string, integer, float, date. String can be in compressed unicode (8-bits per character) or uncompressed unicode (16-bits per character) formats. To install and use this script you need installed and properly configured PHP only. Added MS Excel->MySQL builder. This is plugin (PHP program) - output in MySQL database. This program imports data extracted by ABC Excel Parser Pro from an Excel file into a MySQL database table. There are no PHP programming skills required to create MySQL database from your Excel file. The Demo and trial versions are available at www.zakkis.ca MySQL Dialog MySQL Dialog is a simple MySQL database access wrapper class to execute SQL queries and display the results in HTML tables. The class connects to a MySQL server, sends SQL statements, and gets the results as an array. A table with the data from the result sets can also be displayed. The class may optionally return error messages on failure based on the mysql_error() and user defined error messages. ezSqliteAdmin ezSqliteAdmin is a tool written in PHP & XUL intended to handle the administration of SQLite over the Web. It requires PHP >= PHP5.0.0 & Mozilla platform to run. MySQL-Dumper MySQL-Dumper is a script for automatically backuping your tables in a MySQL-database. The two basic pages are a page for frequently use and an administrator-page. The page for frequently use checks if there are tables in the database that have been changed after the last back-up. If they are, there will be made a back-up of these tables, which saves time and space. Convert Character set (convert charset) This is a PHP class that you can use to convert between utf-8, windows, iso, dos, ibm, mac charsets. It's very useful with databases, text procesing, especially when you have many people on different computers and different operating systems working on the same web site. Zip Code Database Project These archives include all files necessary to calculate the distance between two U.S. Zip Codes using PHP4+ and MySQL. php_db2util At the moment, the php_db2util extension supports: *) connecting to DB2 *) load data from client or server with replace option or insert option *) export data from table to client ( also not possible with ODBC ) *) run the runstats utility to recreate indexes ( also not possible with ODBC ) *) disconnect from DB2 Loads 2.000.000 rows in 10 minutes into a DB2 table! All this functions returns the count of the written/exported/readed lines to the calling function. This extension will not replace the ODBC support to IBM DB2, it will extend it. Requirements: You must have installed the runtime client from IBM for accessing the API libs. You can get the runtime client free as fixpack from the IBM website. There is also a free developer version of DB2 8.2. FX.php FX.php is a PHP class which combines the ease-of-use of FileMaker with the power of PHP. In the latest release, FX.php allows access to every version of FileMaker since version 5, and preliminary support has been added for MySQL. FX.php is designed to give FileMaker users the advantages and flexibility of using PHP. In addition, the new MySQL support adds the option of using data from multiple data sources, without knowledge of SQL. doSQL() doSQL() is a PHP4 script that can dump data back from a SQL text file (generated by backupDB() (also available on this site), phpMyAdmin, or similar) to a new database, or run any number of SQL commands in batch mode. Detailed progress reporting, including time remaing, processing rate (text and graph available). Simple SQL DESCRIPTION: Simple SQL provides functions to retrieve single fields or rows of a table, insert rows given arrays of column names and values, update single fields of a given table row, delete given table rows and many other common needs. ADVANTAGES: - This PHP class file will eliminate nearly all code from the built in std mysql PHP functions. - Speed, it will dramatically decrease development and execution time. - Extremely easy to use; one hardly has to understand the MySQL syntax. - It automatically determines whether or not there is an open connection to the MySQL server. It will connect and reconnect automatically. - The built in debugging functions make it easy to solve syntax error and logic error. - Supports arrays for arguments and returns ASSOC arrays from the DB with indexes. - Stores resource links and common variables such as the last table used.

Google Search