Automated Forms Class

ShawnK

I need to be able to have some kind of query that will look at the names of all of the columns in a table and then make an array of those names. Then take those names and create form fields for every column name.

I need this because on the site I'm working on I am making the script but in the admin control panel I wrote it so it allows you to add columns to the users table. This means if he wants to add a spot in the user profile for phone number then he can do it in the admin panel. But the problem comes when I need to have users register.

How can I dynamiclly create these form fields from my mysql table? Does anyone know of a class or something I could use?

planetsim

Hmm It wouldnt be an easy task, since you will probably be needing to get the fields type so you can which input field to give it.

If that is what your going to do just get the Field List with Types send the Array to a Class which than just goes through them.

ShawnK

That would work good, and it will be my backup if I cannot manage this. What I really want to do is get the column names from a mysql table. So that I could get an array from some kind of query.

planetsim

SHOW FIELDS FROM mytablename

bunner_bob

$query = "SELECT * FROM tablename WHERE something='something'";
$result = mysql_query($query);
foreach ($result[0] as $fieldname => $fieldvalue)
{
    $fieldname_array[] = $fieldname;
}

is probably a simplistic way of doing it but it gets you there I think. One advantage though is you've already got your result array to pass to the form, with just one query.