Dynamic Add and/or Edit of MySQL Fields

wilhud

Hi all,

I'm still fairly new to PHP and mySQL, so I may be in way over my head here. But I was wondering if it's possible to UPDATE, as well as INSERT totally dynamic data into a table. Basically what I've done is made a page that displays all the tables from a db. Then if you choose a record to edit, it displays the data in a dynamic form where you can then change it. Now I want to take those fields and update the database with the info the user has submitted.

Unfortunately, I can't figure out a way to tell the MySQL statement what those dynamic form fields are. That's where I'm stuck. Is there maybe a way to tell it to update all, sorta like you can SELECT * ? That would be the easiest thing to do I guess, although it doesn't seem like a great solution. I was amazed I got this far and it's almost done, but I'm stuck now. I also want to do the same thing with adding data, but I'm sure I can figure one out if I can just get the other working. I've searched and checked the manual but there's a lot of space to cover, so I might've missed it somewhere. If this is even possible, that is.

Basically what I'm trying to do is create a simple way of updating a db, without getting too technical for the user. The database will already be setup, I just want them to be able to add or edit content, nothing else really. Well, delete but I've already figured that one out. I'm trying to make it so I don't have to keep setting this up for every db that is used. That's why I'm trying to make it totally dynamic. Any help or advice would be greatly appreciated. I hope this makes sense to somebody, lol.

Thanks!
Wil

wilhud

Okay, i think I'm one step away from getting this...here's what I did:

<?php $result = mysql_query("SELECT * FROM $Table",$db);
for ($i = 0; $i < mysql_num_fields($result); $i++) {
if ($DataArray == "") {
$DataArray = "'$" . mysql_field_name($result, $i) . "'";
} else {
$DataArray = $DataArray . ",'$" . mysql_field_name($result, $i) . "'";
}
} echo $DataArray; ?>">

That prints out the string of variables for my sql statement. It works, but when the form submits to itself, it prints the variable name with the $ in front of it, rather than the actual value that was submitted through the form. I'm almost there, I know it...any feedback would be great!!!

Thanks!!
Wil

wilhud

Okay, sorry for wasting space. I figured it out. I guess I just like talking to myself, lol.

If anyone is interested, here's what I did:

<?php $result = mysql_query("SELECT * FROM $Table",$db);
for ($i = 0; $i < mysql_num_fields($result); $i++) {
if ($DataArray == "") {
$DataArray = "'" . ${mysql_field_name($result, $i)} . "'";
} else {
$DataArray = $DataArray . ",'" . ${mysql_field_name($result, $i)} . "'";
}
} echo $DataArray; ?>">

I had been printing the $ as text, which was screwing things up. This code works, processes it as a variable so I can then use it in my sql statement. Okay, I'll stop talking to myself now. 😉

Bye!
Wil