[RESOLVED] combining two loops

bastienvans

This has been driving me nuts for the past 2 days. Any help will be greatly appreciated.

here it is:

I would like to fetch the field names using mysql_fetch_field from my table, called 'listing', while looping every $_POST from my form, then insert it in my database.

e.g.

foreach($_POST as $fieldname => $values) {
echo $fieldname.'-'.$values.'<br />';
}

yields:

Title_Details - data from form
Location - data from form
Address - data from form
Property Type - data from form
...and so on

The problem is, the name of my fields in my table are different. For instance 'Title_Details' is 'titledetails'. Therefore I would like to fetch the field names from my table using mysql_fetch_field.

e.g.

while ($fields = mysql_fetch_field($query)){

echo $fields->name.'<br />';

}

yields:

titledetails
location
address
propertyType

Ultimately, I want to combine the two together and end up with:

titledetails - data from form
location - data from form
address - data from form
propertyType - data from form

Thanks for your help... Please let me know if I have to be more clear.

TheoGB

Can you not control, the form?

Basically it looks like in your form the input fields have name values that are:
Title_Details
Location
Address
Property Type

Just change the name="" tag on each to be the same as your database field names. I do this sort of thing in my code and it works fine.

bastienvans

I have so many fields that I'm getting them from my table using a mysql_fetch_field.

E.g.

SELECT titledetails AS "Title Details" from table

this way it is written out the way I want.

Thanks for your reply!

TheoGB

Any method you use to convert the names you're getting in from the form to the names your table uses will be complex and more than likely prone to errors.

I am still not 100% sure on what you're attempting but theoretically you only need to build ONE update for your database, certainly one per row.


$query_string = "UPDATE {table} SET titledetails='".mysql_real_escape_string($_POST['Title_Details'])."' WHERE {index value}=".$_POST['index value'];

Except you'd want to set all your variables in there in one update in the same way.

bastienvans

thanks again for your reply.

The reason why I am using all these loops is to be able to add a field later on to my table, or remove one, and everything will be dynamic and change. How would you go about getting the names from your table for your fields and formatting them the way you want, then plug them back in your database the way they are written in your table?

bastienvans

never mind. I am modifying the way I am getting my field names initially. Thanks for your help

TheoGB

Okay cool.

I don't know how you'd do what you're saying. There are a LOT of mysql and string functions in PHP.

I'd advise downloading the CHM help file version of the PHP documentation from http://php.net as I find it invaluable as a reference. 🙂