Database

Database size for news publishers?

Your problem is most likely not the size itself but how queries are being done. This could be a result of non optimal code or bad DB structure. As with all optimization you first need to find the actual bottle necks and than to decide if you fix the code, or maybe just scrap the … Read more

Is it possible to utilize custom SQL for a single-post.php?

If you just want the ID of the requested post within the template, get_queried_object_id() will give you that. If you want to modify the main query SQL before it’s executed, there are a number of filters that let you directly modify the SQL.

query sql-table and change entities

You should gotten return from SQL first. And then print results. Use $wpdb class for SQL queries. If you wanna use native SQL queries something like this might helps you $result = mysql_query(“SELECT * FROM table”); $result_array = mysql_fetch_array($result, MYSQL_ASSOC); But it`s very bad idea. Use $wpdb with preparing.

Want to update value in database. But it says update() on null

Your verify.php files lives outside WordPress framework, so $wpdb and everything else is not available. Correct way is to use admin_post_ hook. You can read about it here. This goes in functions.php add_action( ‘admin_post_add_foobar’, ‘prefix_admin_add_foobar’ ); function prefix_admin_add_foobar() { //$wpdb->update() } And the form: <form action=”<?php echo esc_url(admin_url(‘admin-post.php’)); ?>” method=”post”> <input type=”hidden” name=”action” value=”add_foobar”> <input … Read more

+ More