The ability to store abstract key-value pairs without modifying the database structure is the reason. Without that, WordPress loses much of its flexibility. I can’t speak for others, but the single largest reason why I develop atop WordPress is its flexible nature. To quote one of your links above, Usually the reasoning behind doing what … Read more
The posts are related to taxonomies (taxonomy/tag) in the wp_3_term_relationships table, where the object_id column is the post’s id, and the term_taxonomy_id is the taxonomy/tag id. Depending on what you want to accomplish, the solution might be to create the same taxonomies at each blog. This way the tax_query should work as normal.
I would suggest manually creating your first page (a custom post type might make more sense here?) in WordPress and then use the fantastic WP CSV plugin to export the page. Using the first page fields as a guide, simply copy your car data into the appropriate cell in a chart and import the completed … Read more
@IlmarsL: thanks! I really did not think of that. I had the plugin Query Monitor enabled and this was the problem… Turning Query Monitor off solved the problem and memory did no more longer increase.
THE SHORT Export sudo mysqldump -u root -pPASSWORD DBNAME > filename.sql Import wp db import filename.sql THE LONG So this turns out to be very painless. The server dump is exactly what WP-CLI needs to import. REMOTE sudo mkdir backup Make a directory for the file. sudo chown -f -R ec2-user:group backup Set permissions to … Read more
You could encode them as JSON, or as serialized strings (the latter of which you can do using functions already baked in to WordPress). Both of these options will let you keep the number of database rows down. However, both of these options will also significantly hamper your ability to search the data, or deal … Read more
Before getting into Importing, I would familiarize yourself with both the standard post type and post_meta as well as custom post types and taxonomies. If your end goal would benefit from the latter, you will save yourself quite a bit of headache utilizing them during the import preparation. If you prefer working with the database … Read more
Overview That’s the one main caveat of WordPress development, that even a seasoned WordPress developer still wonders what’s the perfect automation for syncing database content from local environment to live server. You can’t just upload your database dump from your local development environment to the server and be happy with the results. WordPress actually stores … Read more
The main issue with your code is that the form submission will always have the same value. This could be seen by debugging $_POST where you check if $_POST[‘submit’] was set. I set up a custom database table and added some dummy data. I think this more or less mirrors your setup. Here is the … Read more
Not that there is specialized API for something exactly like that. Create your table, see Creating Tables with Plugins in Codex. Process submitted form (since you are not using higher APIs, don’t forget to check for capabilities, use nonces and such). Write data to your custom table, using $wpdb.