if you want to keep the row with the lowest id value: DELETE n1 FROM table n1, table n2 WHERE n1.id > n2.id AND n1.meta_key = n2.meta_key OR if you want to keep the row with the highest id value: DELETE n1 FROM table n1, table n2 WHERE n1.id < n2.id AND n1.meta_key= n2.meta_key
Firstly I would try to avoid the use of a custom table using custom post types, custom taxonomies and post/user/term meta. This will greatly increase compatibility and give you a large chunk of free functionality, such as UIs, import/export support, archives, REST APIs, etc But assuming you cannot use that, for whatever reason, you should: … Read more
I notice that to link to each post, I am calling get_permalink() and this is creating an extra DB query for each post. Not true. If you check the link to the very old trac ticket #18822 in the post that you have linked to, this issue was raised by @kaiser in 2011. The question … Read more
I had the same problem. I did not have pre-existing menus, but newly created ones had the same symptoms as you described. In my case, the problem was a ill-defined table wp_terms. It was missing the AUTO_INCREMENT flag on the column term_id as well as all indexes and the primary key. I can only assume … Read more
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.
I believe a multisite solution + WooCommerce plugin (which is multisite compatible) would answer to the specifications you have listed. About the multisite installation I strongly recommend you to read: https://codex.wordpress.org/Before_You_Create_A_Network https://premium.wpmudev.org/blog/how-to-build-a-wordpress-multisite-network-with-multiple-domains/ As explained in the tutorial above, you can set different domain names for each of your sites, it just requires an additionnal plugin … Read more
Based on your code, you don’t have a column called ‘name’. Method column_name will display column content for the column ‘name’. So, for instance, you have the column called ‘madonhang’. Method for that column will be called ‘column_madonhang’. Each column has own method with the similar name.
wp_kses to the rescue! My Editor Contains everything a Post Might Pass the result through wp_kses_post on the way in and out, and all should be good. Remember, this will strip out anything added by the_content filter, so to preserve oembeds and shortcodes, use this: echo apply_filters( ‘the_content’, wp_kses_post( $content ) ); You might also … Read more