Creating a MySQL table

[Priyav]

Hi
I am designing a website on Joomla. I have created a form, using Fabrik, that allows users to input the name of a project. I then want to use php coding to create a table with this name. My question is how to change the string into the format required for MySQL table names!
Thanks a lot, and hope someone can help!

 

[felixkat]

I don't think I fully understand the question.

Are you saying that you want the form to create a mysql table using the input data of a form? So if somebody enters the data as 'foo' it will create a mysql table called 'foo'?

 

[Priyav]

Yeah, exactly that! The thing is, someone might enter something like "This&That". I then need a line to change it to "this_that" so that it can be used as a table name!

 

[Priyav]

Thanks for your help Felix, but I have managed to do it now! Just to let others know, I used FabrikString::clean()