Skip to content

Instantly share code, notes, and snippets.

@arschmitz
Created November 16, 2010 17:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save arschmitz/702105 to your computer and use it in GitHub Desktop.
Save arschmitz/702105 to your computer and use it in GitHub Desktop.
<?php
session_start();
$db = mysql_connect("localhost", "bdag", "bdag") or die("Could not connect.");
if(!$db)
die("no db");
if(!mysql_select_db("bdaginventory",$db))
die("No database selected.");
$handle = fopen("vehicles.csv", "r");
// Read first (headers) record only)
$data = fgetcsv($handle, 1000, ",");
$sql= 'CREATE TABLE inventorytest (';
for($i=0;$i<count($data)-1; $i++) {
$sql .= $data[$i].' VARCHAR(0), ';
}
//The line below gets rid of the comma
$sql = substr($sql,0,strlen($sql)-2);
$sql .= ');';
mysql_query($sql);
echo $sql;
echo "done";
fclose($handle);
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment