Ad:

PHP Discussion Thread
Marked Solved
Views: 1961

Jun 30th, 2008

using a variable to name the table in the CREATE TABLE function

Expand Post »

Hey,

Im just wondering how i can get something like this to work:

PHP Syntax (Toggle Plain Text)
$tablename = $_POST['tablename']; 
mysql_query(CREATE TABLE `databasename`.`$tablename` (`name` VARCHAR( 200 ) NOT NULL))
$tablename = $_POST['tablename']; 
mysql_query(CREATE TABLE `databasename`.`$tablename` (`name` VARCHAR( 200 ) NOT NULL))

At the moment its coming up with an error because I am using a variable for the table name instead of inputting it normally.

Thanks,

Max

Last edited by MaxMumford; Jun 30th, 2008 at 6:20 pm.

Similar Threads

Updated : Simple ASP.Net Login Page in ASP.NET
Table aready exists in MySQL
Can we call a User defined Function using Linked Servers ? in MS SQL
get html element value using php in PHP
Datagrid to draw a table in C#

MaxMumford

Reputation Points: 32

Solved Threads: 3

Posting Whiz in Training

Offline

228 posts
since Oct 2006

Permalink

Jun 30th, 2008

Re: using a variable to name the table in the CREATE TABLE function

you can do that.

try this:

PHP Syntax (Toggle Plain Text)
$tablename = $_POST['tablename'];
$sql = "CREATE TABLE `databasename`.`{$tablename}` (//table fields here)";
mysql_query($sql);
$tablename = $_POST['tablename'];
$sql = "CREATE TABLE `databasename`.`{$tablename}` (//table fields here)";
mysql_query($sql);

kkeith29

Reputation Points: 235

Solved Threads: 193

Nearly a Posting Virtuoso

Offline

1,315 posts
since Jun 2007

Permalink

Jun 30th, 2008

Re: using a variable to name the table in the CREATE TABLE function

php Syntax (Toggle Plain Text)
$tablename = "test";
$query = "create table ".$tablename." (name varchar(200) not null )";
mysql_query($query);
$tablename = "test";
$query = "create table ".$tablename." (name varchar(200) not null )";
mysql_query($query);

Like this.

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Jul 1st, 2008

Re: using a variable to name the table in the CREATE TABLE function

Thanks for the help

however I don't see how this is not working :s

PHP Syntax (Toggle Plain Text)
$sql = 'CREATE TABLE `web163-gallery-7`.`{$picurl}` (`name` VARCHAR( 200 ) NOT NULL ,`picurl` VARCHAR( 200 ) NOT NULL ,`group` VARCHAR( 200 ) NOT NULL ,`dateadded` TIMESTAMP( 200 ) NOT NULL DEFAULT CURRENT_TIMESTAMP ,`id` INT( 200 ) NOT NULL ,PRIMARY KEY ( `id` ) ,UNIQUE (`name` ,`picurl`)';
 
mysql_query($sql)
$sql = 'CREATE TABLE `web163-gallery-7`.`{$picurl}` (`name` VARCHAR( 200 ) NOT NULL ,`picurl` VARCHAR( 200 ) NOT NULL ,`group` VARCHAR( 200 ) NOT NULL ,`dateadded` TIMESTAMP( 200 ) NOT NULL DEFAULT CURRENT_TIMESTAMP ,`id` INT( 200 ) NOT NULL ,PRIMARY KEY ( `id` ) ,UNIQUE (`name` ,`picurl`)';

mysql_query($sql)

MaxMumford

Reputation Points: 32

Solved Threads: 3

Posting Whiz in Training

Offline

228 posts
since Oct 2006

Permalink

Jul 1st, 2008

Re: using a variable to name the table in the CREATE TABLE function

Missing ending )
P.S. group is a keyword. Its not advisable to use keywords as column names.
This works fine for me.

php Syntax (Toggle Plain Text)
$sql = "CREATE TABLE test.".$picurl ."
(name VARCHAR(200) NOT NULL ,
picurl VARCHAR( 200 ) NOT NULL ,
group1 VARCHAR( 200 ) NOT NULL ,
dateadded TIMESTAMP( 200 ) NOT NULL DEFAULT CURRENT_TIMESTAMP ,
id INT( 200 ) NOT NULL ,
PRIMARY KEY ( id ) ,UNIQUE (name ,picurl))";
$sql = "CREATE TABLE test.".$picurl ."
(name VARCHAR(200) NOT NULL ,
picurl VARCHAR( 200 ) NOT NULL ,
group1 VARCHAR( 200 ) NOT NULL ,
dateadded TIMESTAMP( 200 ) NOT NULL DEFAULT CURRENT_TIMESTAMP ,
id INT( 200 ) NOT NULL ,
PRIMARY KEY ( id ) ,UNIQUE (name ,picurl))";

nav33n

Moderator

Featured Poster

Reputation Points: 524

Solved Threads: 356

Purple hazed!

Offline

3,878 posts
since Nov 2007

Permalink

Jul 1st, 2008

Re: using a variable to name the table in the CREATE TABLE function

PHP Syntax (Toggle Plain Text)
# Drop any existing table `posts`
# --------------------------------------------------------
DROP TABLE IF EXISTS `posts`;
 
# --------------------------------------------------------
# Table structure for table `posts`
# --------------------------------------------------------
CREATE TABLE posts (
                    post_id int(11) NOT NULL auto_increment,
					category_id int(11) NOT NULL,
					user_id int(11) NOT NULL,
					title varchar(150) NOT NULL,
					body text NOT NULL,
					posted timestamp,
					PRIMARY KEY (post_id)
					);
# Drop any existing table `posts`
# --------------------------------------------------------
DROP TABLE IF EXISTS `posts`;

# --------------------------------------------------------
# Table structure for table `posts`
# --------------------------------------------------------
CREATE TABLE posts (
                    post_id int(11) NOT NULL auto_increment,
					category_id int(11) NOT NULL,
					user_id int(11) NOT NULL,
					title varchar(150) NOT NULL,
					body text NOT NULL,
					posted timestamp,
					PRIMARY KEY (post_id)
					);

Click to Expand / Collapse Quote originally posted by MaxMumford ...

Hey,

Im just wondering how i can get something like this to work:
PHP Syntax (Toggle Plain Text)
$tablename = $_POST['tablename']; 
mysql_query(CREATE TABLE `databasename`.`$tablename` (`name` VARCHAR( 200 ) NOT NULL))
$tablename = $_POST['tablename']; mysql_query(CREATE TABLE `databasename`.`$tablename` (`name` VARCHAR( 200 ) NOT NULL))
At the moment its coming up with an error because I am using a variable for the table name instead of inputting it normally.

Thanks,

Max

mexabet

Reputation Points: 16

Solved Threads: 9

Junior Poster

Offline

148 posts
since Mar 2008

Permalink

Jul 1st, 2008

Re: using a variable to name the table in the CREATE TABLE function

Thanks

I thought it wasnt working but that was because i needed to call the table something with .jpg at the end and iv realised i cant do that. No worries iv found a work around.

Max

MaxMumford

Reputation Points: 32

Solved Threads: 3

Posting Whiz in Training

Offline

228 posts
since Oct 2006

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: include function in php

Next Thread in PHP Forum Timeline: get sets of info from db depending on hidden field's value

DaniWeb Message

Cancel Changes

User Name
Password