jkuroiwa

<?php

function hobo_escape($val){
	// because there is no good way to escape a dynamic table/field name
	$ret = preg_replace('/[^a-zA-Z _]+/', '', $val);
	$ret = preg_replace('/\s+/', '_', $ret);
	return $ret;
}

// Credentialing for MySQL server if you want the code to create table and load data automatically

jkuroiwa

<?php
// Credentialing for MySQL server if you want the code to create table and load data automatically
$host = "localhost";
$user = "user";
$password = "password";
$base = "database";
$connection = mysql_connect($host,$user,$password) or die (mysql_error());
mysql_select_db($base,$connection);

// $id is the unique identifier for the Socrata data.