I have following query:
CREATE TABLE `test` ( `col1` INT( 10 ) NOT NULL , `col2` VARCHAR( 50 ) NOT NULL , `col3` DATE NOT NULL ) ENGINE = MYISAM ; I want to write a general php script that get table name(test) from above query.
- you can use regular expressions. are all input queries of type CREATE TABLE?ahmet alp balkan– ahmet alp balkan2011-06-12 17:17:30 +00:00Commented Jun 12, 2011 at 17:17
- what will be regular expression. I am not good in regular expressions..Student– Student2011-06-12 17:18:24 +00:00Commented Jun 12, 2011 at 17:18
- if all your queries are CREATE TABLE, you can split it and just get the 3rd word, right?ahmet alp balkan– ahmet alp balkan2011-06-12 17:18:58 +00:00Commented Jun 12, 2011 at 17:18
- Yes. It is always create query in this case.Student– Student2011-06-12 17:23:19 +00:00Commented Jun 12, 2011 at 17:23
- pear.php.net/package/SQL_Parser might solve this task in a more generic way.mario– mario2011-06-12 17:32:15 +00:00Commented Jun 12, 2011 at 17:32
Add a comment |
1 Answer
If you can access the string which gets queried before you run the query, you can do this:
preg_match("/^create table `(?P<tablename>)`/i", $query, $matches); print_r($matches); /* Output: Array ( [0] => CREATE TABLE `test` (`col1` INT( 10 ) NOT NULL ,`col2` VARCHAR( 50 ) NOT NULL , `col3` DATE NOT NULL ) ENGINE = MYISAM ; [tablename] => test [1] => test ) */ If you can't access the string for some reason, but you know that nothing is created in the database between the query and your code then you can use this query to retrieve the last created table:
SELECT * FROM information_schema.TABLES ORDER BY CREATE_TIME DESC LIMIT 1; 