<?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";
}
?>