All pastes #1041532 Raw Edit

Unnamed

public text v1 · immutable
#1041532 ·published 2008-06-07 21:05 UTC
rendered paste body
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Add a Record</title>
</head>

<body>

<form method="post" action="addrecord.php">

<table cellspacing=3 cellpadding=3>
<tr>
<td colspan="2" align="center">
	<h3>Add a Database Record</h3>
</td>
</tr>
<tr>
<td align=top>
<p><b>ID:</b><br />
<input type="text" name="id" size=11 maxlength=11></p>
<p><b>Title:</b><br />
<textarea name="title" cols=25 rows=3 wrap=virtual></textarea></p>
<p><b>Date:</b><br />
<input type="text" name="date" size=10 maxlength=10 /></p>
</td>
<td valign="middle" align="center">
<p><b>Author</b><br />
<input type="radio" name="author" value="Brittany" checked />Brittany
<input type="radio" name="author" value="Scott" /> Scott
<input type="radio" name="author" value="Zachary" />Zachary
</p>
</td>
</tr>
<tr>
<td valign=top>
<p><b>Subject 1</b><br />
<input type="text" name="tag1" size=25 maxlength=100 /></p>
<p><b>Subject 2</b><br />
<input type="text" name="tag2" size=25 maxlength=100 /></p>
<p><b>Subject 3</b><br />
<input type="text" name="tag2" size=25 maxlength=100 /></p>
</td>
<td>
<?
		$connection = mysql_connect("localhost","root","zsbn179012") or die(mysql_error());
		$tables = mysql_list_tables($_POST[$DatabaseName]) or die(mysql_error());
		
	
		$table_list = "<select name=\"TableName\">";
		
		
		$i = 0;
		while($i < mysql_num_rows($tables)){
		$table_names[$i] = mysql_tablename($tables, $i);
		$table_list .= "<option value=\"$table_Names\">$table_names[$i]</option>";		
		$i++;
		}
		
		$table_list .= "</select>";
?>
    
    <b>Choose your table</b>
    
    <? echo "$table_list"; ?>
</td>
</tr>
<tr>
<td valign=top colspan=2 align=center>
<p><b>Blog Text</b><br />
<textarea name="text" cols=50 rows=10 wrap=virtual></textarea></p>
<P><input type="submit" value="Add Record" /></P>
</td>
</tr>
</table>
</form>

</body>
</html>