Php Mysql and Dbconvert For Access & Mysql Software for Windows

MyDbDump pro
$39 - softgalaxy

MyDbDump is a Powerful database utility that can easily perform the following tasks : 1.Import your Access database to MySql, Even if a direct access to your MySQL database is denied . If you need to import your Access database to a Mysql database to use it in your web site you may find a big problem if your hosting provider doesn't allow Remote connection to his MySQL servers (which is common), but you can always use MyDbDump to overcome such restrictions . MyDbDump allows you to store your Access database in a PHP script, by Running this PHP script once in your website, you will be able to Import your Access database to MySQL much faster than if MS Access databases were copied to MySQL database directly because the copying to MySQL database is executed with utilization of the server where the particular script is launched . Using MyDbDump you can make the conversion manually or schedule your conversion tasks to be performed automatically. 2. Backup your MySql database: MyDbDump stores your MySQL database structure and / or records in a single PHP file or SQL script , by running the PHP file once in your Web site, you can restore your Mysql database. Easily whenever you need. The program supports scheduling of the storing process to be performed automatically. so using MyDbDump you can automatically carry out the backup of the specified database daily, weekly, monthly or once on the established time. 3. Dump your Access database Mydbdump creates a text file from your Access db containing the SQL script necessary to recreate your Access database whenever you need 4.Converting Access to SQL Mydbdump creates a SQL file from your Access db containing the SQL script necessary to create a MySQL database with the same structure and data of your Access database

---

---

myphpbooks
$24.95 - ICT eBooks by Yeoh HS

This script is a real world application that shows how to use MySQL with PHP. You can learn from the step by step commented php source code how to build a php program that uses MySQL to keep a database of your books. Program functions implemented include, saving a new record, listing of records for user selection, selection of a record and displaying its details, updating a record, deleting a record and searching for records. Once you have learned the techniques used in this program, you can build any php-mysql based programs.

If you are looking for a full example source codes for a complete PHP program that shows how to use PHP with MySQL, then this package is for you.

Here's what you'll learn from this package.
1. How to create and use functions in PHP
2. How to use html forms to send data to a PHP script
3. In a php script, how to properly retrieve data sent from a html form
4. How to separate php code from html and css files
5. How to display php generated data in html forms
6. How to use php include files to avoid unnecessary code duplication
7. In php functions, how to use variables defined outside the function
8. In php functions, how to pass variables into the function so that they can be used in the function
9. In php functions, how to return values of variables to the calling program.
10. In a php script, how to connect to a MySQL database, execute a query, get the query results and the number of rows returned in the query result.
11. How to dynamically fill a html form selection list with data returned from a mysql query.
12. How to use regular expressions to validate certain data inputs
13. In php script, how to redirect to another php script
14. How to avoid problems in query strings by using str_replace and addslashes
15. How to construct SQL queries that contain php variables.
16. How to use php to handle html form input errors and report them to the user.

---

---

DBConvert for Access & MySQL
$69 - DMSoft Technologies

DBConvert for Access & MySQL is a database migration tool for data conversion from MS Access database (MDB file) to MySQL server and MySQL db to Microsoft Access.

You can convert Access to MySQL or MySQL to Access simply by configuring several options through Wizard interface or in command line mode. Ability to organize application work using command line parameters is supplemented with a scheduler so you can run the program without user input after scheduling.

If a direct access to your MySQL base is denied (insufficient privileges) you can save your data into a dump file to overcome such restrictions. The primary function of the MySQL privilege system is to authenticate a user connecting from a given host, and to associate that user with privileges to select, insert, update, and delete a database. The SELECT, INSERT, UPDATE, and DELETE privileges allow you to perform operations on rows in existing tables in a database. The privilege system ensures that all users may perform only the operations allowed to them. Thus in case you have any privileges to create or modify a database on the target MySQL server there is an opportunity to save your data into a dump file. DBConvert for Access & MySQL fixes the contents of the source database into a local dump file the MySQL server directly. The destination file will consist of MySQL statements to create all the tables and to fill them with the data. Using this dump file MySQL server administrator will add data to your MySQL database.

One of the key things of database managing is the ability to filter data during conversion. Integrated data filters allow users to retrieve only specific data for converted tables according to defined filtering criterias (conditions). Filters give you more control on data migration process.

---

MySQL Excel
$38 - softgalaxy

Excel-MySQL converter is a powerful tool to convert any Excel file to a MySQL database or convert any MySQL database to an Excel file utilizing a very easy to use wizard style interface that support so many advanced options like (scheduling,command line support , table selection , field selection,..). The wizard can also store any Excel file into a php script to import it to MySQL even if remote connection to the MySQL server is not allowed . Main features: 1)All versions of MS Excel are supported 2)Works with all versions of Unix and Windows MySQL servers 3)Supports both local and remote connections to MySQL server. 4)Ability to convert the Excel file into MySQL indirectly if you are not allowed to connect your Mysql server remotely 5)Support for scheduling conversion tasks to be performed automatically. · 6)The ability to select only the tables you want convert. 7)The ability to select only the columns you want to convert from each selected table . 8)You can choose either to convert to a new database, overwrite an existing one or append your tables to an existing database. 9)Splitting Mysql tables which is containing more than 65535 records into Multiple Excel spreadsheets 10) Command line support.

---

Excel MySQL converter
$38 - softgalaxy

Excel-MySQL converter is a powerful tool to convert any Excel file to a MySQL database or convert any MySQL database to an Excel file utilizing a very easy to use wizard style interface that support so many advanced options like (scheduling,command line support , table selection , field selection,..). The wizard can also store any Excel file into a php script to import it to MySQL even if remote connection to the MySQL server is not allowed . Main features: 1)All versions of MS Excel are supported 2)Works with all versions of Unix and Windows MySQL servers 3)Supports both local and remote connections to MySQL server. 4)Ability to convert the Excel file into MySQL indirectly if you are not allowed to connect your Mysql server remotely 5)Support for scheduling conversion tasks to be performed automatically. · 6)The ability to select only the tables you want convert. 7)The ability to select only the columns you want to convert from each selected table . 8)You can choose either to convert to a new database, overwrite an existing one or append your tables to an existing database. 9)Splitting Mysql tables which is containing more than 65535 records into Multiple Excel spreadsheets 10) Command line support.

---

DBConvert for FoxPro & MySQL
$69 - DMSoft Technologies

DBConvert for FoxPro & MySQL is a database migration tool for data conversion from MS FoxPro database to MySQL server and MySQL db to Microsoft FoxPro.

One of the key things of database managing is the ability to filter data during conversion. Integrated data filters allow users to retrieve only specific data for converted tables according to defined filtering criterias (conditions). Filters give you more control on data migration process.

You can convert FoxPro to MySQL or MySQL to FoxPro simply by configuring several options through a Wizard interface or in command line mode. The ability to organize application work using command line parameters is supplemented with a scheduler so you can run the program without user input after scheduling.

If a direct access to your MySQL base is denied (insufficient privileges), you can save your data into a dump file to overcome such restrictions. The primary function of the MySQL privilege system is to authenticate a user connecting from a given host, and to associate that user with privileges to select, insert, update, and delete a database. The SELECT, INSERT, UPDATE, and DELETE privileges allow you to perform operations on rows in existing tables in a database. The privilege system ensures that all users may perform only the operations allowed to them. You can save data to a PHP script or to a dump file that allows you to get over any restrictions on access to a MySQL database.

The converter fixes the contents of the source database using a local dump file. The destination file will consist of MySQL statements to create all the tables and to fill them with the data. Using this dump file, the MySQL server administrator will add data to your MySQL database.

---