There are probably a few ways to do this. The easiest way I can think of is to install Pods Framework. You can install it through the WordPress repository like you’d normally install a plugin, or through GitHub. Using Pods, you can extend the WordPress user database to add a birthday field. You can also … Read more
You’re inserting raw POST data straight into an SQL query – sanitize, sanitize, sanitize! The code below should get you started, but I would advise you add some additional checks (is the email valid? are the strings too long? etc.): <?php $errors = $values = array(); if ( isset( $_POST[‘Submit’] ) ) { $fields = … Read more
Pure SQL questions are off-topic but beyond that, pure SQL is dangerous because it may break if the WordPress Core changes the database structure. You are better off using Core tools where possible. In this case, WP_Query can do what you need. $args = array( ‘post_type’ => ‘post’, ‘meta_query’ => array( array( ‘key’ => ‘status’, … Read more
To upload a local WP installation to a server: Step 1 If you are on a host where you can expand an archived file (ie. Cpanel / File Manager) then easiest way is to ZIP or GZIP your entire WP install and upload it to the server, and use File Manager to expand the files … Read more
You don’t need PDO to write safe DB queries. PHP developers were able to do so before PDO was created 😉 There is nothing unsafe in using WPDB class, as long as you do it correctly (just use prepare and correct ways of escaping). There is one major flaw in your question: using PDO, of … Read more
Multiple things could be going wrong here,if you give some more infomation I can give you better answers here are some things to try. Check the wp-config.php to make sure the correct database settings are being used If you had permalinks you may want to check for or recheck the .htaccess file can you login … Read more
Had to update info in the wp-config.php file to match the new DB_NAME, DB_USER, DB_PASSWORD, DB_HOST
Here you go Javier, this should work. I included comments within the code to try and show you where things needed to change and added a few things you were missing. I’ll explain more below. <?php /* Should really come up with something more unique and related to your plugin */ function yourplugin_dbcreation() { global … Read more
You can’t use LIKE to compare arrays. LIKE is used to check if a string matches, or partially matches, a value in the database. IN is used to check if a value in the database is in a given set of values. They are not interchangeable. The correct comparison to use in your case depends … Read more
But surprisingly, not many threads show where these files exactly are in the server. WordPress doesn’t have files it manages, it instead relies on MySQL/MariaDB for database storage and execution. So you will not find the database stored as a file within a WordPress installation. If you need to handle database data in a file … Read more