connect_error) { die("Connection failed: " . $conn->connect_error); } function onlyAlphanumeric($text) { return preg_replace("[^A-Za-z]", "", $text); } if($_POST['table']) { $table = $_REQUEST['table']; $fields = $_REQUEST['fields']; if(!isset($table)) { die('Error: required field.'); } if($_FILES['file_upload']['error'] > 0){ die('An error ocurred when uploading.'); } $field_list = explode(',',$fields); // build our table dynamically. $createtable = "CREATE TABLE IF NOT EXISTS `".$table."` ("; for($j=0;$j<=count($field_list);$j++) { if($field_list[$j] != '') { $createtable .= "`".$field_list[$j]."` varchar(255) "; if($j != count($field_list)-1) { $createtable .= ","; } } } $createtable .= "\n"; $createtable .= ") "; $createtable .= " ENGINE=MyISAM DEFAULT CHARSET=utf8;"; $conn->query($createtable) or die(mysqli_error($conn)); $file_url = str_replace("\\", "/", $_FILES['file_upload']['tmp_name']); if($file_url) { $querys = <<query($alttable) or die(mysqli_error($conn)); } ?>
File:
Table Name: Fields: (apple,pears,lemons)