You unserialize() it. Be aware that most WordPress functions will automatically unserialize() database content before using it. See, for example, the Used By list for maybe_unserialize(). This is by no mean an exhaustive list, I’m sure. But if you’re retrieving data directly from the database — because there’s not a WordPress function to achieve what … Read more
As @kero said, use a CF7 hook. I’d use the wpcf7_before_send_mail hook. Grab data from the CF7 form object’s fields, and use those values to store data. I wrote a post to myself on how to get data from the CF7 form object here: http://securitydawg.com/changing-contact-form-7-with-the-wpcf7_before_send_mail-hook/ . You could use that to get started, just insert … Read more
schema.php file holds create the database table on installation You will get that file in wp-admin/includes/schema.php Hope you have get your answer.
The WordPress current_time() returns the current time in the format specified in the first parameter. In your example code, this is the mysql value. The second parameter represents a timezone option. The default returns the local time for the timezone specified on the site’s Settings > General page, or GMT depending on the value supplied … Read more
TL;DR This is not possible with wpdb. Use dbDelta(). Even better, use something else to run raw queries. Explanation wpdb->query() uses the mysql_query() function. From PHP manual: mysql_query() sends a unique query (multiple queries are not supported) to the currently active database on the server that’s associated with the specified link_identifier. In order for that … Read more
I solved my issue by passing the page variable as a hidden field: <form method=”get”> <input type=”hidden” name=”page” value=”<?php echo $_REQUEST[‘page’] ?>” /> <?php $this->customers_obj->prepare_items(); $this->customers_obj->search_box(‘Search’, ‘search’); $this->customers_obj->display(); ?> </form>
At a higher level, there truly isn’t any means to know if the php/db connector will return the correct id by relying on $wpdb->insert_id. The only way to be 100% sure is to have add a key you know will be unique (and indexed as such); you can then retrieve the id by querying the … Read more
You should create a ssh tunnel between the 2 serves. Then you can connect from the WP with only the mysql server ip. ssh -f [email protected] -L 2000:personal-server.com:25 -N The -f tells ssh to go into the background just before it executes the command. This is followed by the username and server you are logging … Read more
So after about a year (on and off!) I had managed to hopefully get a fix on encoding issue. Why it breaks What my experience boiled down to, is that encoding issue like this are mostly caused by miscommunication when moving data around. in best case this is read mismatch, when correct data is wrongly … Read more
There’s quite a lot of information on here about switching to InnoDB https://wordpress.stackexchange.com/search?q=innodb There are a number of things to think about: InnoDB is helpful with you’re faced with contention – ie when you have tables that are being written to as well as being read InnoDB does not support FULLTEXT indexes so plugins that … Read more