If you want sequential numbers for your posts, then don’t use the post ID column. AUTO_INCREMENT is meant to provide unique numbers (and split-brains in multi-master replication), it is never going to be without gaps, especially not in WordPress (revisions, autosaves, pages, contact forms, galleries and a bunch of other plugins) and especially not with … Read more
This is technically challenging. WordPress must have access to your DB password in plain text. Having access to the wp-config.php contents is already a breach of security in progress. There are alternate approaches to configuration, such as loading credentials via environment variables, but in practice they are used exceedingly rarely because PHP’s configuration file is … Read more
Just set a random user in your wp-config.php for each request: $db_users = array( ‘user_1’, ‘user_2’, ‘user_3’, ); define( ‘DB_USER’, $db_users[ array_rand( $db_users ) ] );
You’ve got a few things wrong. The first is that you are clearly in WordPress context. You should be using the AJAX API for this rather than including wp-load.php. That is virtually never the right way to do it. get_results() defaults to an object, so you are going to get errors when you try to … Read more
You need to give it a name as well. UNIQUE KEY rowid (rowid)
Yes, WordPress will sanitise data on its way to the database, so long as you use the APIs. If you’re using the wpdb object however you’ll need to use the prepare method to sanitise. I recommend against writing SQL queries as it bypasses object caches etc, but if you must write your own SQL, use … Read more
It would be safer to use [wp_insert_comment()][1] rather than manually through MySQL. WP often inserts data in multiple tables – using its core functions helps ensure that all of the data gets added in all of the right tables. I’d suggest creating a query to pull all published posts. Then, set up a foreach loop … Read more
You’re going to definitely want to do this with a plugin. Modifying WordPress Core files is an extremely bad idea as others have pointed out because every update will wipe them out and future versions may change the location/function of what you’re editing. You can get away by adding it to the theme’s functions.php file … Read more
Normalizing data is more efficient, and storing serialized data in a table field that you want to search / work with on DB level isn’t something for Non-Nosql RDBMS like MySQL/MariaDB. Searching those fields is inefficient, you can’t use indexes on it, can’t join on it, and it’s generally painful to develop imho. If you’ve … Read more
WordPress is fetching current post for you, you have to only type to the right url. When you get e.g. to example.com/lorem-ipsum/ WordPress will load automatically post with title Lorem ipsum and display it using page.php template. Your page.php template should be looking something like that. <?php get_header(); ?> <div id=”content”> <?php while ( have_posts() … Read more