[Alex M]

Hi Steven,

thanx again for your connections-plugin – it helps me a lot!
I know, my question is not really support-related. I still hope, the answer is just two lines of code for you and you find the time:

I need to update the “district”-data of the address of one entry via a cronjob. So the code is not in the plugin. At the moment I have this

// get the addresses-entry of one single entry
$result = $wpdb->query("SELECT addresses FROM wp_connections WHERE id=$temp_id");
$row = $result->fetch_assoc();
$string = $row['addresses'];
$addresses = unserialize($string);

// change the value of "district"
$new_district = $addresses[0]->district +1; 
... // Code to put $new_district back into the addresses-Array 

// Update addresses-array in DB
$sql_new = "UPDATE wp_connections SET addresses WHERE entry_id=$temp_id";
$prep_new = $wpdb->prepare($sql_new);
$prep_new->execute();

Unfortunately I am really not familiar with arrays or even arrays in databases.
Do you see, what I am trying to do and can you help?

Thank you,
Alex

[Steven Zahm]

@ Alex

Three things…

1. You need to update the district value within the addresses array. Your code example writes just the new district value to a new variable.
2. You need to serialize the array before saving it back to the database.
3. The example code is not actually writing any value back to the database. The example code I think will just empty the addresses value.

Hope this helps!

[Alex M]

Hi Stephen,
thank you for you reply.
Since I am not that familiar with arrays your answer does not help as I hoped it will.
I know my example code is not working. I just wanted to visualize what I would like to do.
I was hoping you could provide me the exact code line to
1. update the value of the “district” with a new value
2. the sql-term to update the addresses array in the database

Thank you,
Alex

[Steven Zahm]

@ Alex

re: Since I am not that familiar with arrays your answer does not help as I hoped it will.

Do this instead so you do not have to deal with arrays or manually accessing the database at all:

// Get the entry you wish to modify.
$data    = Connections_Directory()->retrieve->entry( 42409 );

// Setup the entry.
$entry   = new cnEntry( $data );

// Get the address, by id, that you wish to change the district field.
$address = $entry->addresses->get( 38437 );

// Set the new value for the district field.
$address->setDistrict( 'new' );

// Update the address in the entry with the modified address.
$entry->addresses->update( 38437, $address );

// Save the changes back to the database.
$entry->update();

• Change 42409 to the entry you wish to update.
• Change 38437 to the address id you wish to update the district.

Does that help?

[Alex M]

Hi Steven,

this actually helped a lot!!
I did not know I could use the connections-functions in a cronjob as well.

Sorry for the late response, but my computer broke down.

Thank you again for your help and great support!!

[Alex M]

Oops, I tested with fixed numbers instead dynamic IDs …

How do I get the address-id if I have the entry-id?
Is there a function too?

[Steven Zahm]

@ Alex

re: How do I get the address-id if I have the entry-id?

Look in the database. In the connections_addreses table, there is an entry_id column which will match the etrny_id you want to edit.

[Alex M]

Hi Steven,

thank you for your answer.
I already had the database-query and it did not work, so I thought of some different function. Did not work as well.
At the end of the day I had a wrong variable earlier … :o/

Now everything is fine. Thanx again for your time!

[Author]

Posts