Post Grid – which database table?

0
Post Grid - which database table? 1
hatton
Aug 11, 2017 06:26 PM 1 Answers General
Member Since Aug 2017
Subscribed Subscribe Not subscribe
Flag(0)

Hello,

where is the data stored (in which database table)? I created hundreds of grids and I need to update all of them with a sql query.

2 Subscribers
Post Grid - which database table? 1
Post Grid - which database table? 3
Submit Answer
Please login to submit answer.
1 Answers
Sort By:
Best Answer
0
Post Grid - which database table? 4
PickPlugins
Aug 11, 2017
Flag(0)

Welcome to our forum

Post grid data saved under post meta of post_grid post  type.

 

Can you please explain your issue?

Regards

Post Grid - which database table? 5
PickPlugins
- Aug 13, 2017 10:38 PM
Flag (0)
0

Thanks for your reply with details, all option under post grid post meta box saved under meta field "post_grid_meta_options" as an array, if you can var_dump($post_grid_meta_options) you will see option details data.

$post_grid_meta_options = get_post_meta( $post->ID, 'post_grid_meta_options', true );

you can run a loop for query post for post grid post type and merge/replace with your new values and update.

Let me know if you can do it.

Regards

Post Grid - which database table? 6
hatton
- Aug 13, 2017 01:34 PM
Flag (0)
0

Hello Nur,

thank you for your response. My problem is very simple. I used Post Grid to create a large quantity of grids, and now I need to update them all at once. In this case, I need to change the Mobile width and the Grid Item Margin for all the grids. Instead of going into each grid and updating the value, it would have been a lot easier to use a SQL Query.

In fact, I also noticed that certain data was being "saved under post meta of post_grid post type", however, the values saved in there doesn't contain the values I need to update.

So, is there a way where I can update the "Mobile width" and the "Grid Item Margin" with a SQL Query? Where are these values stored?

Thank you for your time and very best regards.

Sign in to Reply
Replying as Submit