Post Grid – which database table?

Support reply may delay for 3 weeks due to corona virus outbreak, please send us email to support@pickplugins.com
0
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
Submit Answer
Please login to submit answer.
1 Answers
Sort By:
Best Answer
0
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

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

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

Please use https://imgur.com/upload to upload your screenshot and share url here.
You can't upload any files or attachment to our server directly for security reason, you can use 3rd party website and share file url here. here is the top file sharing website you can use.

Please login to see your tickets