How to check and get json object in WP database?

To check if a string from database is like a:2:{i:3;a:4:{s:5:”title”;s:0:””;s:4:”text”;s:503:”…}}, you can use the function is_serialized() To get the data as php array : if(is_serialized($data_as_string)){ $data_as_array = unserialize( $data_as_string); }

Restore of database doesn’t show content

Check that you are actually using the database by doing the following: 1 – go to cpanel, file manager, public_html, open the wp_config.php file 2 – check db creds and make sure it is actually the correct db. Everything must be exact. (IP/localhost, dbname, user, etc.) 3 – check the $table_prefix – make sure the … Read more

Custom post type and custom taxonomy key lenght & query performance

I’m not sure about the sort of precise figures a performance/algorithm researcher would be looking for. However, in terms of actual performance there is no difference. The WP database can take a beating and I’ve done plugins with dozens and dozens of filters and hooks and queries and they still run very very fast. Furthermore, … Read more

Can we store password in without being hashing?

Can’t comment yet so I’ll comment here: You’re not going to be able to decrypt wp passwords easily. They’re salted and even if you keep entering the same password, the hashed password in the database is going to be different every time. Your best bet is to do something like this on the site where … Read more