Public feed #376693

Someone

public text v1 · immutable
Raw Edit
·published 2007-03-01 05:57 UTC
rendered paste body
<?php
if($_POST['Submit']) {
		if($_POST['create'] == 'projects') {
			$sql = 'CREATE TABLE `projects` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR( 50 ) NOT NULL , `body` TEXT NOT NULL , INDEX ( `id` ) ); ';
		} elseif ($_POST['create'] == 'scans') {
			$sql = 'CREATE TABLE `scans` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR( 50 ) NOT NULL , `body` TEXT NOT NULL , INDEX ( `id` ) ); ';
		} elseif ($_POST['create']=='textfiles') {
			$sql = 'CREATE TABLE `textfiles` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR( 50 ) NOT NULL , `body` TEXT NOT NULL , INDEX ( `id` ) ); ';
		} elseif ($_POST['create']=='twatech') {
			$sql = 'CREATE TABLE `twatech` ( `id` INT NOT NULL AUTO_INCREMENT, `title` VARCHAR( 50 ) NOT NULL , `body` TEXT NOT NULL , INDEX ( `id` ) ); ';
		}
} else {
	?>
		<form action="addtables.php" method="post">
		create the following tables in you db:<br>
		projects:
		<input type="checkbox" name="create" value="projects"/>
		<br>
		scans:
		<input type="checkbox" name="create" value="scans"/>
		<br>
		textfiles:
		<input type="checkbox" name="create" value="textfiles"/>
		<br>
		twatech:
		<input type="checkbox" name="create" value="twatech"/>
		<br>
		<input type="submit" value="Submit">
		</form>
	<?php
	}
?>