anargi Posted February 6, 2012 Share Posted February 6, 2012 Hi! I have a question about (dynamic)create table with php script.I don't know if (dynamic) is correct word. I want to create a mysql table but the name of table if it is possible the user to give via html form. my example: This is simple html form where the user he can to insert two fields(id,name) <html> <head> </head> <body> <meta http-equiv="Content-Language"content="en-us-gr"> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <form method="POST" action="categ.php"> <table border="1"> <tr><td> <div align="right"> ID: <input type="text" name="id" size="19"> </div> <div align="right"> Name: <input type="text" name="name" size="19"> </div> <div align="right"> <input type="Submit" name="Create" value="create"> </div> </tr></tr> </table> </body> </head> These data send in my database via below code: <?php mysql_connect("localhost","root","MYPASSWORD") or die(mysql_error()); if(mysql_select_db("blog")); { mysql_query("SET NAMES 'utf8'"); } $sql="INSERT INTO menu(id,name) VALUES ('$_POST[id]','$_POST[name]')"; mysql_query($sql); { echo "ok!"; } ///////////////////////////////////////////////////////////////////////////////////// //[b]And here i want to create a table but the name of table if it is possible to be the name where the user gave via above html form.[/b] $qry=mysql_query("CREATE TABLE /*The name of the table via above html form*/ (mycode...mpla...mpla)"); if(!$qry) { die("Table not created\n".mysql_error()); } else { echo "Table Created\n"; } ?> <meta http-equiv="refresh" content="3;url=admin_home.php"> Is there some way to success this result? Thanks! Link to comment https://forums.phpfreaks.com/topic/256564-question-about-create-dynamic-table-in-mysql/ Share on other sites More sharing options...
mikosiko Posted February 7, 2012 Share Posted February 7, 2012 I have a question about (dynamic)create table with php script why do you want to do that? Link to comment https://forums.phpfreaks.com/topic/256564-question-about-create-dynamic-table-in-mysql/#findComment-1315304 Share on other sites More sharing options...
kickstart Posted February 7, 2012 Share Posted February 7, 2012 Hi Creating / modifying tables in that way is fairly easy. Just use a create statement as you have suggested, but changing the table name. However from a design point of view it is a really bad idea and will result in a quite horrible database, making it very difficult to extract data from it. All the best Keith Link to comment https://forums.phpfreaks.com/topic/256564-question-about-create-dynamic-table-in-mysql/#findComment-1315408 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.