<?php include 'tiosafe_config.php'; if (postNotEmpty('address_id')) { $address_id = $_POST['address_id']; $post_update_list = array('street', 'zip', 'city'); $db_update_list = array('entry_street_address', 'entry_postcode', 'entry_city'); $set_update = create_update_list($post_update_list, $db_update_list); //If the country is posted, get the id if (postNotEmpty('country')) { $countries_id = getCountryId($_POST['country'], $db); if (empty($set_update)) { $set_update = 'entry_country_id = ' . $countries_id; } else { $set_update .= ', entry_country_id = ' . $countries_id; } } if (!empty($set_update) && !empty($address_id)) { $query = "UPDATE " . TABLE_ADDRESS_BOOK . " SET {$set_update} WHERE address_book_id = " . $address_id; echo executeSQL($query, $db); } } else { echo '\\nInvalid query: the parameter address_id is required!'; } $db->close();
</wp:postmeta> <wp:postmeta> <wp:meta_key>_book_colours</wp:meta_key> <wp:meta_value><![CDATA[field_569398cc9b989]]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>categories</wp:meta_key> <wp:meta_value><![CDATA[CAT' . $row["cat_id"] . ']]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>_categories</wp:meta_key> <wp:meta_value><![CDATA[field_56939e989a86b]]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>countries_published_in</wp:meta_key> <wp:meta_value><![CDATA[' . getCountryId($row["country_id"]) . ']]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>_countries_published_in</wp:meta_key> <wp:meta_value><![CDATA[field_5693a32a65711]]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>series</wp:meta_key> <wp:meta_value><![CDATA[SR' . $row["series_id"] . ']]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>_series</wp:meta_key> <wp:meta_value><![CDATA[field_5693a44e799e5]]></wp:meta_value> </wp:postmeta> <wp:postmeta> <wp:meta_key>publication_year</wp:meta_key>