http://www.advancescripts.com/rss/543.htmlDatabase Management RSS feedsen-usCopyright (c) AdvanceScripts All rights reserved. http://www.advancescripts.com/detailed/16337.html This class can be used to create a backup of a MySQL database using the mysqldump command. It invokes the mysqldump command to generate a backup file of a given database on behalf of a given authenticated MySQL database user. The generated backup file is copied to another file with the name based on the current date. http://www.advancescripts.com/detailed/16140.html 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 for pulling in the csv file. A CREATE button will create a simple database using VARCHAR() with all the fields length set to the longest length of any field. The INSERT button will insert the data. http://www.advancescripts.com/detailed/16034.html Gregwiz Backup is backup tool for Mysql database. Split backup file to multiple file, compresses it into gzip format. Easy to import. Multiple languages support. Create, Drop database function. http://www.advancescripts.com/detailed/15967.html Mimesis is a php4 flat file database class library. Mimesis mimics the behavior of a standard SQL database but without using SQL. Instead, using php's object oriented programming features Mimesis functions as a distinct class with various database manipulation methods. http://www.advancescripts.com/detailed/15656.html This db_class will talk with your mysql database and authenticate users as they login. You may insert, update, delete and select with this db_class. You can also validate email addresses passwords and more. Check it out download it and start using it now! http://www.advancescripts.com/detailed/15370.html This database management script is a great basis for writing code for using a database. It includes error catching and sanitation http://www.advancescripts.com/detailed/15334.html A Tool to write Databasedatas into a file. With the following Feutures: * The CSV-File can be expand by Text input. * Any number of the tablefieldelements in the file. * Any arrangement of the table fields. * Article maximum adjustable. * CSV-profiles can be created. * Application of PHP-functions to any fieldelements. http://www.advancescripts.com/detailed/15313.html mySQLdump Database Backup is a PHP script that: is executed either on a scheduled basis via cron or your manually via your browser; will backup any number of databases (data and structure); gzips the output files; allows you to download individual backup files or all backups bundled in a zip archive; optionally optimize tables in the databases; deletes old backup files from the server when new backups are created; eliminates transfering the backups to your PC using an FTP client or worse, excruciatingly slow transfer via email attachments; has HTMl user guide with complete instructions for installing and using (visit the site to read it). And it is free http://www.advancescripts.com/detailed/15141.html This script allows you to create a table with an image, a link and up to 20 fields and fill it with data. This is done via the admin.php, the data is stored in a Mysql-Database (database parameters in dbconnect.php). The output.php script returns a table with sorting function (click on the header so sort by columns) and a customizable layout. http://www.advancescripts.com/detailed/14857.html Having written a ga-zillian scripts, to query dbs, decided it would be much simpler to call just one function multiple times, duh! :) Then fulfilling business request after request - with web pages (PHP) calling the function - decided to progressing this further!! ;) By removing the script - hitting the function directly. Let it handle the query, via variable parameters passed in on the HTTP GET. This posed a bit of problem, pushing complexity on the inquirer. So then decided to write a web (interface) form to drive the function - which subsequently made the query. :) See the site for more details and a download. http://www.advancescripts.com/detailed/14698.html This is a function to convert a user's query in boolean syntax ("hotels AND mexico NOT cockroaches) into a SQL query over the appropriate database fields http://www.advancescripts.com/detailed/14541.html DbCon is a free php based MYSQL API class that provides functions to fetch data from the database, query the database with sql statements from file, it also has performance tracking and several other features. http://www.advancescripts.com/detailed/14513.html EasySQL is a PHP application to easily connect to your MySQL database with just 1 php file and 3 easy steps. Useful for beginners, it lets you easily interact with a mysql database using only your web browser. Features: Automatic table formatting, reusable query, javascript assisted features, syntax help file and full versioning control for easy updates. Username and password security can be added with an optional, [free] addon sister product - Admin-Login-Only. http://www.advancescripts.com/detailed/14466.html Flat File Database Manager will allow you to manage (update/delete/add) records in your flatfile database. Features include user defined delimiter (usually pipe, colon, or comma), customizable presentation of different data types. Following data types supported: (List) - Rendered as list box or combo box; (String) - Rendered as regular input field; (Logical) - Rendered as check box; (Text) - Rendered as text area. http://www.advancescripts.com/detailed/14454.html This class can be used to build MySQL SQL query conditions to search for Arabic text considering Arabic lexical rules. It uses the MySQL REGEXP and LIKE functions to retrieve better results from queries for Arabic text http://www.advancescripts.com/detailed/14264.html This comes handy because you can simple edit the appropriate fields, upload it along with the csv file and call it from the web and it will do the rest. It allows you to specify the delimiter in this csv file, whether it is a coma, a tab etc. It also allows you to chose the line separator, allows you to save the output to a file (known as a data sql dump). It also permits you to include an empty field at the beginning of each row, which is usually an auto increment integer primary key. This script is useful mainly if you don't have phpmyadmin, or you don't want the hassle of logging in and prefer a few clicks solution, or you simply are a command prompt guy. Just make sure the table is already created before trying to dump the data. Kindly post your comments if you got any bug report. http://www.advancescripts.com/detailed/14176.html JR-Backup is a php script written to automatically backup your database for you It will backup all the tables for you and send it to you via email daily , weekly or monthly as desired Easy to setup yet powerful Free Installation http://www.advancescripts.com/detailed/14175.html PHP CODE BUILDER is a open source web based software which can be used to generate PHP codes for creating database driven websites. Since the usage of PHP and MySQL websites have grown tremendously, this tool would act as an easy interface for the programmers to create website in a short time span. Many programmers have found this software useful inorder to create websites with PHP and MySQL. You can take a Demo or you can Download a copy for free http://www.advancescripts.com/detailed/13998.html This handy little script allows you to fully back up a given MySQL database utilizing the command line scripts. This script will automatically email you your database contents on the schedule you set. The instructions included will walk you right through the process! It's that easy to keep your database backed-up in case disaster stikes http://www.advancescripts.com/detailed/13964.html MySQLHandler is a complete wrapper for MySQL. It implements all functions available and can be easily customized for your preference. MySQLHandler is designed to aid you when writing queries in your code and you don't need to write those connection statements. When using a SELECT query, the rows can be returned in 3 different formats 1. Standard ResultSet 2. 2-dimensional array 3. XML Using the XML return method is very usable if you wish to export the results from a query to another application. Using XSLT and CSS you can also present it as a pretty HTML page. http://www.advancescripts.com/detailed/13811.html IAM Backup is package made of two classes. One performs the backup of the selected MySQL database, and the second restores the database. Both classes support gzip-compressed files for improved performance. http://www.advancescripts.com/detailed/13807.html 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 the results of the query. The first row has the query result column names. The class stores the whole spreadsheet definition in XLS format in a class variable. The generated spreadsheet data can be served for download. The class detects the browser type and issues the specific headers to make the browser handle the spreadsheet data file properly. http://www.advancescripts.com/detailed/13806.html This class takes the results of a SQL query and outputs in the CSV (comma separated values) format in only 2 lines of code. This comes very handy when exporting data since CSV is a format that can be readily read by Excel and many other applications. You can even use it for Word’s Mail Merge! The class offers the choice of sending the output to the browser or downloading it as a file. The name and extension of the dump file are defined by the developer. http://www.advancescripts.com/detailed/13761.html Micro DB Manager is a database abstraction class written in PHP using object oriented technologies. The class realize the following functionalities: * Connectiong to the databse * Executing queries * Converting results to associative array * Get selected rows * Get affected rows * Get last insert id * Get the number of executed queries * Get the execution time of the queries * Get error messages and codes http://www.advancescripts.com/detailed/13754.html This small tool helps you to convert your MySQL database layout into XML. Just specify connection informations and you can display or save the generated XML output. http://www.advancescripts.com/detailed/13685.html As the title says. It mimicks the PEAR::DB API, with a few (~3) very useful added functions: reset() for reseting a result set back to the first row, seek() for moving to a specific point in the result set and an SQL debugger which makes it much easier to see what queries are being performed. http://www.advancescripts.com/detailed/13632.html T3 DB Tools is a seditio database management plugin. Features: -- Backup all or selected tables of your seditio DB. -- Table information and schema. -- Browse tables (experimental) -- Drop, truncate tables. -- Option to export data, structure or both. -- Support for gzip, bzip2 compression of the backups. -- Restore database backup. -- Run custom sed queries. -- Extra security rights. -- Check, analyze, repair and optimize tables. -- Auto create the backup folder and the directory blocker protection. -- 100% ability to translate. -- Easy navigation and event reports. http://www.advancescripts.com/detailed/13204.html This class is a MySQL database access wrapper. It can: - Connect to a MySQL server - Execute SQL queries and retrieve single value results or return result rows into arrays - Return the last inserted table row identifier, the number of result rows and the number of affected rows - Count the number of executed queries - Lock and unlock tables - Escape text literal values or like patterns - Retrieve database access errors http://www.advancescripts.com/detailed/13202.html After fulfilling business request after request - with many short php web pages calling the function. Decided to progressing this further - by removing the web page altogether (hitting the function via a wrapper). Let it handle the query, via variable parameters passed in on the HTTP GET. This posed a bit of problem, pushing complexity on the enquirer. So then decided to write a web (interface) form to drive the function (wrapper) - which subsequently made the query. :) http://www.advancescripts.com/detailed/12965.html This class owns one method for all query commands whose return is the number of affected or selected rows. This allows to have a quick response on the query success or failure and to use a single method for running queries. $nrecords = $dbLite->queryLite("SELEC T * FROM sometable","some error message"); $nrecords = $dbLite->queryLite("UPDAT E sometable SET field1='$val1' WHERE field2='$val2'"); This class is also very easy to manipulate if you need to add some feature. http://www.advancescripts.com/detailed/12739.html MySQL Easy Editor is a php powered, mysql administration web handler. With this tool, you may view, create or drop databases, view, create, drop, empty, optimize or repair tables, view, create fields in tables, view, insert, modify, remove records in tables. As the name says, it is simple. A complex editor would do a lot more, but this is what you need if you want to maintain a database for a dynamic website for example. http://www.advancescripts.com/detailed/12681.html This class works under PHP4/PHP5 and all MySQL Versions from V3.x and newer. It features an easy-to-learn API and an error-management which includes auto-sending of EMails in case an DB error occured. The archive comes with complete documentation and some examples to show basic usage of this class. http://www.advancescripts.com/detailed/12680.html This class allows to develop applications using Oracle 8i or higher. It supports bind variables, IN/OUT variables for PL/SQL procedures and BLOB support. Additionally it features an easy-to-learn API and an error-management which includes auto-sending of EMails in case an DB error occured. The class works with PHP4 or PHP5 and requires the OCI8 extension to be enabled in your PHP. A complete documentation and some examples are included, too. http://www.advancescripts.com/detailed/12679.html Oracle Information Site allows DBAs to view the most important informations about all configured Oracle databases. Support for Oracle 8i, 9i and 10g (untested) is integrated. OIS gives the DBA many informations like - Instance Configuration parameter - Running processes with detail view - Redo Log and Rollback segment usage - Tablespaces - Overview of all defined DBMS_JOBs - Memory Usage - Basic tuning views - General instance statistics - Very basic schema browser In addition OIS has a small integrated management interface which allows DBAs to have an overview of all DB machines with saveable comments. Finally a basic table exporter is also integrated. To use OIS you'll need PHP4 or newer with OCI8 extension build in, and of course at least one Oracle instance. As OIS reads Oracle's internal tables it require DBA rights to access them, else OIS won't work. http://www.advancescripts.com/detailed/12422.html IP2Location™ IP-COUNTRY-REGION-CITY-LATITUDE-LONGITUDE-ZIPCODE-TIMEZONE database enables solution to determine country, region or state, city, latitude, longitude, US zip code and time zone of any IP address in a few simple steps. First, retrieve IP address from networking protocol or server-side variable of Web server. Next, translate IP address to IP number in decimal format to speed up database query. http://www.advancescripts.com/detailed/12386.html Script will output the connection code for sqlite_open, sqlite_popen and in the PDO format. Both SQLite version 2 and 3 are covered. http://www.advancescripts.com/detailed/12324.html The sql2rss.php script allows you to easily create rss feeds from SQL databases. The script currently supports the conversion of MySQL databases to RSS feeds. http://www.advancescripts.com/detailed/12235.html Powerful Data Management Tool, PHPEasyData is a PHP application which allow you to manage and display on the web your dynamics data and directories . PHPEasydata will largely facilitate all steps of a classical development to put data on your website (fields definition,database creation, forms to add/update records , php process to display records, members area, comments etc.) and more classical functions ... http://www.advancescripts.com/detailed/12129.html cPanel does not allow you to create databases directly from MySQL/PhpMyAdmin. You would have to login to cPanel and use its interface to create database each time you need a new one. cPanel Database Creator will make this process much easier. http://www.advancescripts.com/detailed/12126.html pjjTextBase is a powerful yet easy to use set of Unicode compatible PHP4+ functions, that provides a simple relational database when you don't need SQL. With pjjTextBase you can quickly develop a robust database-driven web application: anything from a guest­book, forum, poll etc. to fully-fledged CMS or e-commerce project. pjjTextBase requires no other software than PHP on your server. http://www.advancescripts.com/detailed/7742.html ClanManager is Clan Script for Clans who want to enter all their Informations in a Database. It is in English and German. You need PHP >4.2, MySQL and http://www.advancescripts.com/detailed/4785.html If you want to generate Previous and Next links like the ones scene on Google.com; PREVIOUS 1 2 3 NEXT ; Then this script can be manipulated to your advantage. Included, are the image files required to make your 'nav-bar' look like the Google one. New with 2.10 is the scrolling feature. This limits the amount of records shown in the nav-bar. For example, if you have scroll set at 10 and you are on the 2nd record out of 12 you will see: Previous 2 3 4 5 6 7 8 9 10 11 NEXT A text version is also included if you prefer a concise approach to displaying your records. http://www.advancescripts.com/detailed/4413.html Managing your online MySQL database was never so easy! r-Access for MySQL is a revolutionary tool allowing you to visually design your remote (web hosted) databases, modify tables structure, execute batch SQL queries, view/edit data - all in quick and effective manner. Software has client/server architecture. Server part is written on pure PHP therefore r-Access for MySQL can run on almost 100% of web servers that host MySQL databases. Client part is a powerful Windows application providing great capabilities of working with every aspect of MySQL database development and administration. http://www.advancescripts.com/detailed/4412.html Download Manager is a popular download management PHP script for websites. Most commonly used accross anime websites, the script protects there 'valuable' download URLs from vicious leechers(people who link others files on there own websites is the most common definition), while at the same time, tracking the ammount of times the file has been downloaded.Some of those features are Categories, Template Management, Database Backup, and more. http://www.advancescripts.com/detailed/4411.html If you have ever wasted your time re-writing code for database administration, this tool may be for you. The Add, Edit, Delete Admin Tool allows you to quickly and easily create administration tools for any mySQL database table. A.E.D. gives you all the options you would have if you were hand-coding each tool. Simply put, you supply the options and information, and A.E.D. will generate the PHP code for you. Automatically generate add, edit and delete admin tools for any table in your mySQL database. http://www.advancescripts.com/detailed/4410.html PHP Text DB is a flat file database manager which will allow you to provide dynamic content without the need of MySQL or ODBC. It allows: Adding new records, Editing current records, Deleting records, Displaying all records, Displaying todays records, Searching the records, and Allow / disable HTML. It is easy to install, and you can control the appearance and field names of the database through one simple text file. PHP Text DB consists of several small php pages which can easily be modified to suit your needs. http://www.advancescripts.com/detailed/4409.html Datalib provides a simplified and straight-forward abstraction layer for PHP. It currently provides drivers for Interbase, Microsoft SQL Server, MySQL, ODBC, Oracle 8+, PostgreSQL and Sybase. The connection and result classes are seperate to allow for multiple queries on the same connection. Two methods of recordset navigation are included (ADO-style and PHP-style). New updated documentation and examples are included! http://www.advancescripts.com/detailed/4408.html This function returns an array of 3 values that makes browsing through your SQL results, or any other list of results, very easy. The navigation bar looks very similar to ones used in most sites [ ]. You can limit the amount of rows displayed, the amount of page numbers to display, the previous and next buttons/text. etc. http://www.advancescripts.com/detailed/4407.html mySQL/HTML-Client is a Web interface to a mySQL database written in PHP. It allows you to display and query database. http://www.advancescripts.com/detailed/4406.html Enter your db information into the provided boxes, press a button, click the link and download your csv file. Very easy and you don't need to install anything. Script is available to download to run locally and securely on your own machine however. http://www.advancescripts.com/detailed/4405.html This small script looks for the databasesize of a given database on your server. Best for ISPs, which would like to offer such a service, but don't want to give away this Know-How. Multilanguage with german, english and italien translation. http://www.advancescripts.com/detailed/4404.html This small script looks for the databasesize of a given database on your server. Best for ISPs, which would like to offer such a service, but don't want to give away this Know-How. Multilanguage with german, english and italien translation. http://www.advancescripts.com/detailed/4403.html MJdbEdit is a tool for editing MySQL databases directly in your browser, using php. Currently you can: Create / Drop databases; Create / Rename / Drop tables; Create / Alter / Drop columns; Create / Save / Alter / Delete SQL-queries; View table stats; View records; Use the SQL Query Wizard to create complecated, multi-table, queries (No SQL knowledge needed); Create / Edit records; Run custom SQL queries; Show table creation SQL-query. It has a nice interface, and is easy to install. Do everything you need to do with your database in your browser. http://www.advancescripts.com/detailed/4402.html Paginator is a php class that will help you to split your record sets into pages. I wrote this class to save myself some time and then thought others might find it helpful. Paginator will return a number that you can use to set your base record and a number to use as an offset. For now I know it works in mySQL queries and with arrays. It also has methods to make it easy to make your page links. There also is an extension with some pre-made link sets to make things even easier. http://www.advancescripts.com/detailed/4401.html Update: Major BUG was fixed please upgrade. DBMS_JOB was filling shared pool with UNIQUE SQL and it is NOT GOOD (BAD). That is very easy upgrade. Read instraction inside of the file. This addition will allow enterprises to use Oracle DB to handle sessions in PHP. And cookies can be replaced with sessions in many cases. Will work with load balancing well. http://www.advancescripts.com/detailed/4400.html Ditto Download Manager is a popular download management free PHP script for websites. Most commonly used accross anime websites, the script protects there 'valuable' download URLs from vicious leechers(people who link others files on there own websites is the most common definition), while at the same time, tracking the ammount of times the file has been downloaded.Some of those features are Categories, Template Management, Database Backup, and more. http://www.advancescripts.com/detailed/4399.html The WSI_FTM program is a lightweight database to be used in applications where a fullblown database is not needed. The WSI_FTM database is managed by pure SQL-code and fully compatible with the famous ADODb library by using all the same functions etc, making the WSI_FTM upgradeble to a full database very easy. The WSI_FTM is built for optimal speed with its own cache system. http://www.advancescripts.com/detailed/4398.html The PHP MySQL Table Manager is designed to simplify administration of a MySql web database. It allows you to easily create, drop or rename tables. Alter tables structures by adding or dropping keys and indexes. Adding, removing or changing the properties of columns. Edit, add, search or delete table records. http://www.advancescripts.com/detailed/4397.html A litte tool to create an alter-script for the differences between two databases. Since 1.4.0 InnoDB FOREIGN KEYS are supported. http://www.advancescripts.com/detailed/4396.html Fusion Download Manager is a popular download management free PHP script for websites. Most commonly used accross anime websites, the script protects there 'valuable' download URLs from vicious leechers(people who link others files on there own websites is the most common definition), while at the same time, tracking the ammount of times the file has been downloaded.Some of those features are Categories, Template Management, Database Backup, and more. http://www.advancescripts.com/detailed/4395.html phpFriendlyAdmin is a remote database administration tool made specifically for non-technical people. After your database is set up, phpFriendlyAdmin is then configured to abstract database structure, making it easier for users to focus on manipulating content. Every field and table is given an alias and a description so as to bypass the complexity of interacting with database variables and offer a simplified form-driven approach to data entry. http://www.advancescripts.com/detailed/4394.html DbApp is for editing single or bulk database records without doing them one by one or using dump files. It is included in our adminApp. Easy set-up. Powerfull editing. DbApp is not yet made for creating databases. http://www.advancescripts.com/detailed/4393.html This php excel script will dump your data from SQL table (MySQL, supply your own SQL query) to a microsoft excel (.xls) file. The Excel file is specified as such by a set of headers, defining content. using php's header() function, also the rows and columns of the excel file are defined by tab and new line chars. http://www.advancescripts.com/detailed/4392.html Accession is powerful development tool aimed at providing developers an intuitive framework through which they can develop complex, web-based database administration applications in a minimal amount of time. Accession promotes the use of 'List'-based, and 'Detail'-based views of your record sets. All a developer needs to do to build rich feature-filled database application is to define to Accession what view type it is to present along with the fields it is to manage, and how these fields are to be presented. Accession supports a plethora of data types and database back-ends, in addition to all the features you'd expect from a database application toolkit. Come see our demos , and we're sure you'll be sold on our solution in no time! http://www.advancescripts.com/detailed/4391.html 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. http://www.advancescripts.com/detailed/4390.html noSQL is a small set (7kb) of SQL-like PHP functions to manage a database in an SQL-like way without a SQL-server. Everything is stored in flat .csv-formatted files, so putting data into noSQL or getting data from noSQL inside a spreadsheet program works immediately. If you are too lazy to setup an SQL-server, or you simply don't have one right now but perhaps later in the future, use noSQL. http://www.advancescripts.com/detailed/4389.html EasySQL is a PHP application to easily connect to your MySQL database with just 1 php file and 3 easy steps. Useful for beginners, it lets you easily interact with a mysql database using only your web browser. Features: Automatic table formatting, reusable query, javascript assisted features, syntax help file and full versioning control for easy updates. Username and password security can be added with an optional, [free] addon sister product - Admin-Login-Only. http://www.advancescripts.com/detailed/4388.html With this tool you can easily create a web forms to insert/update/delete function. You can view the data in a short list view and in a detail view, can set up various form check functions such as super real time check. You can easily change the look and feel with using css files. http://www.advancescripts.com/detailed/4387.html phpMyForms is a php script which allows the user to create simple database listings (done in 3 lines of configuration), or simple dataset manipulation formulars (~10 lines) by adjusting small php config files. automatic browsing controls and optional validation scripts are included in version 0.3 http://www.advancescripts.com/detailed/4386.html QuickDB is a database abstraction class that helps PHP developers to move from database engine to another with no more need to rewrite their codes. QuickDB will sits between a PHP scripts and PHP Database API. Until now there are 3 drivers for QuickDB, these driver support MySQL, MsSQL and ODBC. http://www.advancescripts.com/detailed/4385.html 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). http://www.advancescripts.com/detailed/4384.html ADODB_SQL allows you migrate your code using DB_Sql format (PHPLIB) to an another DB engine like ADODB. http://www.advancescripts.com/detailed/4383.html This script is oriented to chilean citizen. phpUF grab UF Value from Banco Central de Chile (UF is a chilean index money). Este script esta orientado a ciudadanos chilenos. phpUF captura el valor de la UF desde el Banco Central de Chile. http://www.advancescripts.com/detailed/4382.html Easily access your MySQL databases with this set of PHP classes. If you program using the ADO object model, you will find these methods and properties familiar. http://www.advancescripts.com/detailed/4381.html 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. http://www.advancescripts.com/detailed/4380.html OracleEditor.php is a standalone PHP script which allows you to browse your Oracle database tables/views and insert, update and delete rows in any table. It has two modes for SQL entry - one is wizard-like, the other one allows executing arbitrary SQL statements. It requires no installation and no configuration. It is written for situations where you quickly need to do some small data manipulation and don't have a better tool available. OracleEditor.php is free and Open Source. http://www.advancescripts.com/detailed/4379.html A small tool to backup and restore MySQL Tables. Features: backup/restore of binaries; multiserver; Gzipping; killing of backup files; german/english; Online help in popup. http://www.advancescripts.com/detailed/4378.html phptools4u.com http://www.advancescripts.com/detailed/4377.html These archives include all files necessary to calculate the distance between two U.S. Zip Codes using PHP4+ and MySQL. http://www.advancescripts.com/detailed/4376.html backupDB() is a PHP script that backs up MySQL tables and databases to a gzip'd file for easy daily backup. Can back up a single database and/or table, or all tables. Structure-only, complete-inserts optional. Can be called interactively or run as a cron job. Works well with doSQL() (also available on this site). Faster and more robust than phpMyAdmin's backup function. http://www.advancescripts.com/detailed/4375.html Need a script that reads Excel file and transports the information into Database or creates an HTML file? PHP Excel Parser Pro is the answer! Works under Unix, Linux, SunOS, Windows using PHP without any additional modules. The parser imports data from Excel files (versions 5.0/97/2000/XP). Imported Excel data types are: integer, float, string (compressed Unicode,8-bits per character, or uncompressed Unicode, 16-bits per character, formats), date, time, percent, formula (returns digits only). Parser Pro supports multiple Excel fonts and MAC files. The Demo & Trial versions are available at : http//www.zakkis.ca http://www.advancescripts.com/detailed/4374.html 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 http://www.advancescripts.com/detailed/4373.html 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 http://www.advancescripts.com/detailed/4372.html Using a unique database design I have developed a php class to have a completly text file database system. Just some of the functions included in the class are for: add/edit/delete records, add/edit/delete tables, sorting a database using a given field, and many more usful functions. This class is very usful for developers wanted to make applications for servers that do not support mySQL or something similar. Tutorials are available from our site.Update: version 4.3.3 includes limiting the query() results, editfield() and removefield() were also added. http://www.advancescripts.com/detailed/4371.html A PHP class script that demonstrates how to build the Next/Prev buttons for given MySQL query results. Easily create a paging navigation bar like Google. http://www.advancescripts.com/detailed/4370.html Staggered import of large and huge MySQL Dumps (like phpMyAdmin 2.x dumps and even GZip compressed dumps). Do you want to restore the huge backup of your mySQL database (or a part of it) into the new or the same mySQL database? You can't access the server shell and you can't import the dump using phpMyAdmin due to hard memory/runtime limit of the web-server. BigDump will do it even through the webservers with hard runtime limit and those in safe mode in a couple of short sessions. http://www.advancescripts.com/detailed/4369.html hkvstore.com http://www.advancescripts.com/detailed/4368.html This PHP class can read data from binary (XLS) Excel file without using COM, ODBC, etc. ExcelExplorer will work on any OS that supports PHP. Windows and Mac Excel files are supported. No additional classes, modules or configurations needed. Using ExcelExplorer you can read info about worksheets, columns, rows, cells. You can even read style info such as colors, alignment, fonts, borders and more. Have build-in caching, memory-safe mode. Demo version available on-line and for download. http://www.advancescripts.com/detailed/4367.html 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. http://www.advancescripts.com/detailed/4366.html Builds on PEAR DB to abstract datatypes and automate table creation, data validation, insert, update, delete, and select; combines these with PEAR HTML_QuickForm to automatically generate input forms that match the table column definitions. http://www.advancescripts.com/detailed/4365.html db_upload_file() stores a file in a database table. Make sure that the column data type is big enough for the files you will be storing. db_download_file() retrieves a file from the database and places it in the same path as the script calling it, and returns the relative URL. If the file does not exist in the database, it returns an empty string. http://www.advancescripts.com/detailed/4364.html A great WebBased DBQuery Tool. Very simple and very easy customization. Just run your queries , execute them and see the results. A great utility for webmasters. http://www.advancescripts.com/detailed/4363.html WizMySQLAdmin is a PHP script to manage MySQL databases. If your web site uses a MySQL database you can manage its contents with WizMySQLAdmin, as you can do with the most known phpMyAdmin: but my script is very simple to configure and use, because it's composed by only one file. So you can install it on your web site very easily. http://www.advancescripts.com/detailed/4362.html Designed to create a daily snapshot of the dynamic data on your website. (e.g. content management systems, forums, guestbooks etc.) Some of the features include: - Backup multiple databases and servers with different users and passwords. - Backups can be scheduled using cron (on UNIX systems) or AT (on Windows systems). - Create daily, weekly and monthly snpashots of your database. - Keep the daily, weekly and monthly backups for a user-specified time. - Archive and compress the SQL files (*.tar.gz). - Creates a detailed report of everything that has been done. - Reports can be mailed to you or any other user-specified email-address, saved to disk or displayed in browser. - Generated SQL files can be mailed to you or any other user-specified email-address. - Generated SQL files can be uploaded by FTP to any user-specified FTP server. - Choose to create SQL files for each table or one for each database - No system calls, everything in 100% pure PHP. http://www.advancescripts.com/detailed/4361.html Rather than to type commands SQL with the hand (in a window terminal), PHP makes it possible to interact with a database via functions. This is a set of PHP scripts that provides a Web interface to MySQL. It features: Display the entire records or only one record, Add a record, Update a record, Delete a record, SQL query, and more. http://www.advancescripts.com/detailed/4360.html AccessDBM is a simple wrapper for the PHP3 dbm file functions. It's primarily used for quick-and-dirty single-method'' programs. Supported DBM functions include initializing, adding and removing entries, getting values, openning and closing DBM, searching for keys and values, and more. http://www.advancescripts.com/detailed/4359.html Metabase is a set of PHP classes that provides DBMS independent access and management of databases. Currently it features: Set of functions that call the selected DBMS driver objects functions; DBMS Drivers classes; A parser class for interpreting DBMS independent database schemas file defined in a custom XML format; and A manager class for installing a new database, comparing a previously installed schema with a new schema and only installing the changes, and for dumping database structure and contents in the same XML format. http://www.advancescripts.com/detailed/4358.html WebSQL is a simple script written in PHP3 that provides a simple SQL Web interface for Sybase ASE. Please note that for certain MSIE browsers, you need to view the page source for script code. http://www.advancescripts.com/detailed/4357.html SQLAdmin is an SQL administration user interface for the Web. Its goal is to enable remote editing of tables stored in a SQL database. SQLAdmin is written in PHP and currently supports only mSQL (more databases support is planed).