PHP Light DbaseToSql: Import Dbase files and generate MySQL dump files

Recommend this page to a friend!

Download

Info

Example

Files

Install with Composer

Download

Reputation

Support forum

Blog

Links

Ratings				Unique User Downloads		Download Rankings
Not enough user ratings				Total: 155		All time: 9,028 This week: 51

Version		License		PHP version		Categories
`pldts` 1.0.1		Custom (specified...		5		PHP 5, Databases, Files and Folders

Description

Author

zinsou A.A.E.Mo�se

This package can import Dbase files and generate MySQL dump files.

It can take a given database file in XBase format and reads its records.

The package can generate text with SQL statements into a file that can be imported by MySQL to regenerate the same database in MySQL tables.

zinsou A.A.E.Mo�se

Performance

Level

Name:	zinsou A.A.E.Mo�se `<contact>`
Classes:	50 packages by zinsou A.A.E.Mo�se
Country:	Benin

Level 5

Innovation award

Nominee: 23x

Winner: 2x

Recommendations

Recommendation for a PHP class to convert dbf to mysql
Access old DBF dBase III files data to convert in mySql

Upload code source as zip file
I can't figure out how to upload a zip file.

Example


<?php


$dbf='83750a1c0300000081001f0000000000000000000000000000000000000000004e414d450000000000000043000000000a00000000000000000000000000000046495253544e414d45000043000000000a000000000000000000000000000000434f4d4d454e54000000004d000000000a0000000000000000000000000000000d207a696e736f75202020206973616163202020202030303030303030310020207a696e736f75202020204d6f69736520202020203030303030303032002020676e696d61766f202020636f726e656c6965202030303030303030330020';


$dbt='0400000000000000000000000000000003000000000200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ffff08000400000066696c730000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000025010024c27f0700c4004c0100bf5201000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ffff080004000000706572650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000025010024c27f0700c4004c0100bf5201000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000ffff0800040000006d6572650000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000025010024c27f0700c4004c0100bf5201000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000';





$x=hex2bin($dbf);// $x=pack('H*',$dbf);


$y=hex2bin($dbt);// $y=pack('H*',$dbt);


// var_dump($x,$y);





file_put_contents('fortrue.dbf',$x);


file_put_contents('fortrue.dbt',$y);


require('dbasetosql.class.php');


echo'<pre>';


$x=new dbasetosql('fortrue.dbf');//create from fortrue.dbf to fortrue.sql 


// $x=new dbasetosql('fortrue.dbf','newfortrue');//create from fortrue.dbf to the database newfortrue.sql 





echo '<div style="background-color:green">'.$x->ToSQL().'</div>';//generate sql code


$x->save_tofile();//save it to fortrue.sql  in your directory but you can call directly method::save without method::toSQL with the same parameter as toSQL


echo'<hr/>';





echo '<div style="background-color:#00bcd4">'.$x->ToSQL(true,'newtable').'</div>';;//generate sql code with a database name specified in the constructor and the table name newtable


echo'<hr>';


echo '<div style="background-color:gray">'. $x->ToSQL(false,'mytable').'</div>';;//generate sql code without creating a database but only  the table with the name mytable


echo'<hr/>';


echo'</pre>';

Details

PHP Light DbaseToSql is a tiny package to import Xbase with/without memo files to basic SQL syntax...
for a how to use example run the file BuildDbaseAndTest.php in your browser no need of DBF 
file to test it for the first time...Then you can look into the package folder.You must see
three files: one .dbf ,one .dbt and one another with the .sql extension...
It is a very light package ,so Feel to make feedback for improvement at 
leizmo@gmail.com or use the forum to do it....
ps: the PECL dbase extension is not required...

Files (5)

File	Role	Description
`BuildDbaseAndTest.php`	Example	example script
`dbasetosql.class.php`	Class	class source
`license.txt`	Lic.	license file
`ReadDbase.classes.php`	Class	class source
`readme.txt`	Doc.	readme

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.

Install with Composer

	pldts-2018-01-28.zip 10KB
	pldts-2018-01-28.tar.gz 8KB
	Install with Composer

Version Control

Unique User Downloads

Download Rankings

Total:	155
This week:	0

All time:	9,028
This week:	51

Applications that use this package

No pages of applications that use this class were specified.

If you know an application of this package, send a message to the author to add a link here.

About us

Advertise on this site

For more information send a message to info at phpclasses dot org.