RPeraltaJr
4/11/2018 - 6:11 PM

Create new table

<?php 

$database_address 	= "localhost";
$database_user 		= "root";
$database_pass 		= "root";
$database_name 		= "wordpress";

$conn = mysqli_connect($database_address,$database_user,$database_pass,$database_name);
if (!$conn) {
	echo "Error: Unable to connect" . PHP_EOL;
}

echo "connected";

$table_name = "wp_submissions";
$table_columns = "";

$table_column_array = array(
	"firstName"		=> "VARCHAR(60)",
	"lastName"		=> "VARCHAR(60)",
	"email"			=> "VARCHAR(60)",
	"address"		=> "VARCHAR(80)",
	"zipcode"		=> "VARCHAR(5)",
	"experience"	=> "VARCHAR(3)",
	"interestedIn"	=> "VARCHAR(80)",
	"comments"		=> "VARCHAR(160)"
);

foreach ( $table_column_array as $column_name => $column_desc ) {
	$table_columns .= "$column_name $column_desc, ";
}

$sql = "CREATE TABLE $table_name (
	id INT AUTO_INCREMENT PRIMARY KEY,
	timestamp TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	$table_columns
	form_url VARCHAR(80)
)";

$success = $conn->query($sql);

if ($success) {
	echo "success";
} else {
	echo "fail";
}

?>