Create New Table

**onestopplay** · 07-01-2009, 11:00 AM

So I have a Form:

HTML Code:

<form action="createtable.php" method="post"
Table Name: <input type="text" name="table"><br>
<input type="submit" name="submit" value="submit">
</form>

I want this to create a table in my MySQL database. Possible?
I have googled and come up with nothing.

**heavensgate15** · 07-01-2009, 12:47 PM

Yup, it's possible to create a table through php script... try this:

Code:

<html>
<head>
   <title></title>
</head>

<body>

  <form action="" method="post">
        Table Name: <input type="text" name="table"><br>
        <input type="submit" name="submit" value="submit">
  </form>
</body>
</html>

<?php

  $con = mysql_connect("localhost","root","") or die(mysql_error());
  mysql_select_db("db",$con) or die(mysql_error());

  $tname = $_POST[table];


  // Creating a table with an attributes: ID and name
  $data = "Create table ". $tname . "(ID int, name varchar(30))";
  $query = mysql_query($data);
 
  if($query)
    echo "New table is created";
  mysql_close($con);
 
?>

**heavensgate15** · 07-01-2009, 12:51 PM

you can try this website: www.w3schools.com

Thread: Create New Table

Thread Tools

Search Thread

Create New Table

Bookmarks

Bookmarks

Posting Permissions