<?php
$dbhost = 'localhost';
$dbuser = 'citysynth';
$dbpass = 'pHAf5EKA3-un';
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
  die('Could not connect: ' . mysql_error());
}

	$db_select = mysqli_select_db($conn,"citysynth");
	if(!$db_select)
		die("DATABASE SELECT FAILURE" . mysql_error());
		
// Create table
$sql="CREATE TABLE IF NOT EXISTS `user1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first` text NOT NULL,
  `last` text NOT NULL,
  `email` text NOT NULL,
  `phone` text NOT NULL,
  `address` text NOT NULL,
  `city` text NOT NULL,
  `state` text NOT NULL,
  `zip` int(11) NOT NULL,
  `password` text NOT NULL,
  `path` text NOT NULL,
  `site` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;";

// Execute query
if (mysqli_query($conn,$sql)) {
  echo "Table users created successfully";
} else {
  echo "Error creating table: " . mysqli_error($conn);
}

?>