-
table creator
ok, hopefully you can see what this does... anyway, it doesnt work :( can you tell me why? i've checked and checked but cant see why:(
PHP Code:
<html><head><title>Creating a table</title></head>
<body>
<?php
if( !$_POST[fields] and !$_POST[db] )
{
$form ="<form action=\"create_table.php\" method=\"post\">";
$form.="How many fields are needed in the new table?";
$form.="<br><input type=\"text\" name=\"fields\">";
$form.="<input type=\"submit\" value=\"Submit\">";
echo($form);
}
else if( !_POST[db] )
{
$form ="<form action=\"create_table.php\" method=\"post\">";
$form.="Database: <input type=\"text\" name=\"db\"><br>";
$form.="Table Name: <input type\"text\" name=\"table\"><br>";
for ($i = 0 ; $i <$_POST[fields]; $i++) {$form.=
"Column Name: <input type=\"text\" name=\"name[$i]\">";
$form.="Type: <select name=\"type[$i]\">";
$form.="<option value=\"char\">char</option>";
$form.="<option value=\"int\">int</option>";
$form.=</select> ";
$form.="Size:<input type=\"text\" name=\"size[$i]\">"; }
$form.="<input type=\"submit\" value=\"Submit\">";
$form.="</form>"; echo($form);
}
else
{
$conn = @mysql_connect("localhost", "shaun", "password")
or die("Err:Conn");
$rs = @mysql_select_db($_POST[db], $conn) or die("Err:Db");
$sql = "create table $_POST[table] (";
for ($i = 0; $i < count($_POST[name]); $i++)
{
$sql .= "$name[$i] $type[$i]";
if(($_POST[type][$i] =="char") or ($_POST[type][$i] =="varchar"))
{
if($_POST[size][$i] != "") ){ $sql.="($_POST[size][$i])"; }
}
if(($i+1) != count($_POST[name]) ){ $sql.=","; }
} $sql .= ")";
echo("SQL COMMAND: $sql <hr>");
$result = mysql_query($sql,$conn) or die("Err:Query");
if ($result)
{ echo("RESULT: table \"$_POST[table]\" has been created"); }
}
?> </body> </html>
Please help, thanks.
-
this fixed your syntax:
PHP Code:
<html>
<head>
<title>Creating a table</title>
</head>
<body>
<?php
if( !$_POST['fields'] and !$_POST['db'] )
{
$form ="<form action=\"create_table.php\" method=\"post\">";
$form.="How many fields are needed in the new table?";
$form.="<br><input type=\"text\" name=\"fields\">";
$form.="<input type=\"submit\" value=\"Submit\">";
echo($form);
}
elseif( !$_POST['db'] )
{
$form ="<form action=\"create_table.php\" method=\"post\">";
$form.="Database: <input type=\"text\" name=\"db\"><br>";
$form.="Table Name: <input type\"text\" name=\"table\"><br>";
for ($i = 0 ; $i <$_POST['fields']; $i++)
{
$form.= "Column Name: <input type=\"text\" name=\"name[$i]\">";
$form.="Type: <select name=\"type[$i]\">";
$form.="<option value=\"char\">char</option>";
$form.="<option value=\"int\">int</option>";
$form.="</select> ";
$form.="Size:<input type=\"text\" name=\"size[$i]\">";
}
$form.="<input type=\"submit\" value=\"Submit\">";
$form.="</form>"; echo($form);
}
else
{
$conn = @mysql_connect("localhost", "shaun", "password")
or die("Err:Conn");
$rs = @mysql_select_db($_POST['db'], $conn) or die("Err<img src=\"images/smilies/biggrin.gif\" border=\"0\" alt=\"\">b");
$sql = "create table $_POST[table] (";
for ($i = 0; $i < count($_POST[name]); $i++)
{
$sql .= "$name[$i] $type[$i]";
if(($_POST['type'][$i] =="char") or ($_POST['type'][$i] =="varchar"))
{
if($_POST['size'][$i] != "")
{
$sql.="($_POST[size][$i])";
}
}
if(($i+1) != count($_POST['name']) )
{
$sql.=",";
}
}
$sql .= ")";
echo("SQL COMMAND: $sql <hr>");
$result = mysql_query($sql,$conn) or die("Err:Query");
if ($result)
{
echo("RESULT: table \"$_POST[table]\" has been created");
}
}
?>
</body>
</html>
Stephan
-
-
argh, it doesnt work right. the first 2 pages are fine, but on the 3rd page...
say i want an integer, and 2 character fields, i get this as the SQL query:
SQL COMMAND: create table test ( , (Array[1]), (Array[2]))
i guess i'm gonna have to tinker about with this code....
....can anyone see what's wrong?
-
Re: table creator
<html>
<head>
<title>Creating a table</title>
</head>
<body>
<?php
$fields=$_POST['fields'];
$db= $_POST['db'];
$table=$_POST['table'];
$name=$_POST['name'];
$type=$_POST['type'];
$size=$_POST['size'];
if( !$fields and !$db)
{
$form ="<form action=\"create_table.php\" method=\"post\">";
$form.="How many fields are needed in the new table?";
$form.="<br><input type=\"text\" name=\"fields\">";
$form.="<input type=\"submit\" value=\"Submit\">";
echo($form);
}
elseif( !$db )
{
$form ="<form action=\"create_table.php\" method=\"post\">";
$form.="Database: <input type=\"text\" name=\"db\"><br>";
$form.="Table Name: <input type\"text\" name=\"table\"><br>";
for ($i = 0 ; $i <$fields; $i++)
{
$form.= "Column Name: <input type=\"text\" name=\"name[$i]\">";
$form.="Type: <select name=\"type[$i]\">";
$form.="<option value=\"char\">char</option>";
$form.="<option value=\"int\">int</option>";
$form.="</select> ";
$form.="Size:<input type=\"text\" name=\"size[$i]\">";
}
$form.="<input type=\"submit\" value=\"Submit\">";
$form.="</form>"; echo($form);
}
else
{
$conn = @mysql_connect("localhost", "root", "")
or die("Err:Conn");
$rs = @mysql_select_db($db, $conn) or die("Err<img src=\"images/smilies/biggrin.gif\" border=\"0\" alt=\"\">b");
$sql = "create table $table (";
for ($i = 0; $i < count($name); $i++)
{
$sql .= "$name[$i] $type[$i]";
if(($type[$i] =="char") or ($type[$i] =="varchar"))
{
if($size[$i] != "")
{
$sql.="($size[$i])";
}
}
if(($i+1) != count($name) )
{
$sql.=",";
}
}
$sql .= ")";
echo("SQL COMMAND: $sql <hr>");
$result = mysql_query($sql,$conn) or die("Err:Query");
if ($result)
{
echo("RESULT: table \"$table\" has been created");
}
}
?>
</body>
</html>
It works fine with the above code.
