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 nstrees - nested set tree library This library consisting of a single php file implements hierarchical datastructures (trees) using the mysql database. Nested set trees are flexible, they can have an arbitrary number of nodes and their data/structure can be read efficiently. The library implements all important functions: Tree creation, queries, reorganization, walks (traversal) and tree printing. table exists I find this little script very useful for web applications that need to automatically generate tables. I wrote it because I felt it was wrong to have a script execute create table SQL statements for tables that already existed. SQLiteManager SQLiteManager is a multilingual web based tool to manage SQLite database. The programming language used is: PHP4 and work fine with PHP5. Work just as well on a platform Linux as on Windows or Mac OsX. This project is in course of developpement, but it is alway very functional. The various functionality are: - Management of several database - Creation 'Connection' to several database - Property of the database. - Management of the options of the database. - Creation / update / delete tables - Management of the indices - Showing / Insert / ALter / Suppression of data in the tables - Imports data from a file - execution of manual query from 'SQLite' format or from 'MySQL' format (conversion) - Create / Update / Delete of View - create / Update / Delete of Trigger - Management of the user defined function. (usable in SQLiteManager query) - exports structure and data to the SQL format 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. Comdev CSV Data Tool v2.0 The CSV Data Tool 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 features: import csv file wizard, specify separator, onscreen columns & data viewing, select database to import and column matching, append / replace existing records / update using primary key. To backup your valuable data, you have the options to export only fields that you need from the selected table or simply export all of them to your local computer. Best of all, Comdev CSV Data Tool comes with Undo Import functionality that lets you preview lastest imported data, last backup data and undo import to restore all data. Packed with web based installation wizard that eases your pain from complicated configuration. Take advantage of our FREE Installation Support, get your copy today! dbUtils dbUtils is a simple, pure-PHP solution which allows anyone to manage multiple mySQL databases and tables. dbUtils currently consists of 5 functions to allow you to accomplish a number of copying, moving, renaming, and general management tasks. Designed originally for database backup without the need for command-line access or telnet access, but expanded to provide functions normally not available in most database management front-ends like phpMyAdmin. GrantMySql GrantMySql script allows user to manage users and rights of MySql database from Web browser in easy and simple manner. It is useful for novices as well as for advanced users. If you do not know line syntax of MySql or need often to change or give rights for MySql database, this script is ideal for you. Database Manager (mySQL) This script allows an object orientated interface to be created around a mySQL connection. It provides numerous functions to speed up the use of a mySQL database, especially useful is the dumpResultSet() function which prints out the results of the previous query. GreenLight SQLTool This tool consists of two files, one to execute queries submitted by form or uploaded as a file and display the results, and another to dump the database in MySQL or MSSQL format. The scripts can be used with either MySQL or MSSQL databases. Together they can be used to migrate a database (or at least the table structures and contents) from MySQL to MSSQL or vice versa. 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

Google Search