SIC PHP
apt-get install php odbc-mdbtools php-odbc php-mbstring
Play
Install mdbtools on local machine
sudo apt-get install mdbtools
Start mdb-sql:
mdb-sql SicDB.mdb
List tables
list tables go
Describe tables
describe table SIC0001F go
SIC Tables
+------------------------------+ |Tables | +------------------------------+ |SIC0001F | Personas físicas |SIC0001J | Personas jurídicas |SIC0001A | Last modification +------------------------------+
Query an ID (cédula)
select CEDULA,NOMBRE,APELLIDOS from SIC0001F where CEDULA like '%112540139%' go
Query example with PHP
On server:
<?php $query = 'select CEDULA,NOMBRE,APELLIDOS from SIC0001F where CEDULA like \'%112540139%\''; $mdb_file = 'SicDB.mdb'; $driver = 'MDBTools'; $dataSourceName = "odbc:Driver=$driver;DBQ=$mdb_file"; $connection = new \PDO($dataSourceName); $result = $connection->query($query)->fetchAll(\PDO::FETCH_ASSOC); print_r($result); ?>
Export to MariaDB
Tables
mdb-export SicDB.mdb SIC0001F > SIC0001F.csv mdb-export SicDB.mdb SIC0001J > SIC0001J.csv mdb-export SicDB.mdb SIC0001A > SIC0001A.csv
Schema
mdb-schema SicDB.mdb | sed "s/^-/#/;s/\[//g;s/\]//g" > sicdb.sql
Install MariaDB
sudo apt-get install mariadb-server mariadb-client php-mysql
Import to MariaDB
MariaDB [(none)]> create database sicdb;
cat sicdb.sql | mysql -u root sicdb
mysqlimport --ignore-lines=1 --fields-terminated-by=, --fields-enclosed-by=\" -u root --local -p sicdb SIC0001J.csv mysqlimport --ignore-lines=1 --fields-terminated-by=, --fields-enclosed-by=\" -u root --local -p sicdb SIC0001F.csv
PHP
<?php
$query = 'select CEDULA,NOMBRE,APELLIDOS from SIC0001F where CEDULA like \'%112540139%\'';
$connection = new PDO('mysql:host=localhost;dbname=sicdb', 'sicdb', 'sicdb');
$result = $connection->query($query)->fetchAll(\PDO::FETCH_ASSOC);
print_r($result);
?>
Troubleshooting
To fix this error:
Can't open cursor lib '/etc/libodbccr.so' : file not found
cd /usr/lib/x86_64-linux-gnu ln -s libodbccr.so.2 libodbccr.so </code>