PHP Classes

File: example.php

Recommend this page to a friend!
  Classes of Greg Neyman   SAS to MySQL   example.php   Download  
File: example.php
Role: Example script
Content type: text/plain
Description: Example Script
Class: SAS to MySQL
Extract data dictionaries from SAS file into MySQL
Author: By
Last change: to conform to base class changes
Date: 6 years ago
Size: 1,522 bytes
 

Contents

Class file image Download
<?php
/*
The definition files I've built this off of are ftp://ftp.cdc.gov/pub/Health_Statistics/NCHS/Dataset_Documentation/NHAMCS/sas
The data files are ftp://ftp.cdc.gov/pub/Health_Statistics/NCHS/Datasets/NHAMCS

Hilariously the public version of ed13for.txt has an error in it. This is good, it prompted me to write in error checking into the class.
*/
$link=mysqli_connect("localhost","root","","nhamcs") or die($link->error);
include(
"sas2sql.php");
$thingy= new sas2sql();
foreach(array(
"format"=>"ed14"."for.txt","input"=>"ed14"."inp.txt","label"=>"ed14"."lab.txt","data"=>"ED2014") as $k=>$v){
 
$fh=fopen($v,"r");
 
$thingy->$k=fread($fh,filesize($v));
 
fclose($fh);
}
$thingy->data=trim($thingy->data);
$thingy->name="ed2014";
$thingy->comm=true;
$thingy->save="ed2014.sql";
$thingy->convert();
foreach(
explode(";",$thingy->query) as $query) {
    if(!empty(
trim($query))) $link->query($query) or die($link->error);
}
$result=$link->query($thingy->split_query());
foreach(
explode(";",$thingy->split_results($result->fetch_all(),12)) as $query) {
    if(!empty(
trim($query))) $link->query($query) or die($link->error);
}
$result=$link->query("SHOW TABLES WHERE `Tables_in_nhamcs` LIKE 'ed2014%'") or die($link->error);
$tables=$result->fetch_all();
foreach(
$tables as $table) {
   
$result=$link->query($thingy->optimise_query($table[0]));
    foreach(
explode(";",$thingy->optimise_results($result->fetch_all(),$table[0])) as $query) {
        if(!empty(
trim($query))) $link->query($query) or die($link->error.$table[0]);
    }
}
?>