Is it normal to have multiple postmeta tables in a WordPress database? No, each site has a single post/user/term and comment meta table. A multisite will have a set of those tables for each site in the multisite, plus network/site meta tables. What could be the reason behind this duplication? WP wouldn’t duplicate the tables … Read more
It appears, at least in cPanel, the lines in question were not required in the export, with the unsurprising consequence of the other encapsulated sql statements defaulting to reference the current database only. Turns out to be convenient when more than one database is configured, so long as there are no statements that select objects … Read more
Using the FPDF library (found at http://www.fpdf.org) you generate PDFs on the fly using any data from your WP site. function wpse60844_generate_pdf( $post ) { /* Define paths for where the PDF will be permanently or temporarily saved */ define( ‘FPDF_PATH’, plugin_dir_path( __DIR__ ) . ‘/fpdf/’ ); define( ‘SAVE_PATH’, plugin_dir_path( __DIR__ ) . ‘fpdf/pdfs/’ ); … Read more
Looking at the source of class-wp-query.php (ie, the WP_Query code), I find this: /* * Ensure the ID database query is able to be cached. * * Random queries are expected to have unpredictable results and * cannot be cached. Note the space before `RAND` in the string * search, that to ensure against a … Read more
Can’t insert into a database wordpress
there is no simple general answer for this, as it depends on what is causing the issue. Best way is to check your page using some Insights tool: https://pagespeed.web.dev/ https://gtmetrix.com/ They will tell you where the issue is. Big images are commonly a big issue – there are many converters to WebP format, that will … Read more
I’ve been handrolling, but XAMPP is pretty common. And yes, if you’re going to edit the site, you’ll want the vs code php extension. The wordpress install should probably come in with the site, but if not, it’s very simple. I’m assuming you have the database, because if you don’t, you don’t really have the … Read more
you can read your file using standard PHP: $value = json_decode( file_get_contents( ‘path/to/your/file.json’ ) ); Then you can use WordPress function to update post meta: update_post_meta( $post_id, $meta_name, $value, $prev_value ); $post_id = ID of the post you want to update $meta_name = name of the meta field you want to update $value = new … Read more
How to use Ajax with WordPress
Putting form result in my database