phpmyadmin

How to use phpspreadsheet reader with $wpdb

I’m assuming you mean this PhpSpreadsheet; if not, please edit your question to clarify. To incorporate any third-party PHP library into your WordPress site, you’ll either need to write a plugin or find one that already does what you need. The PhpSpreadsheet docs explain how you’d incorporate their library into any PHP application, which includes … Read more

Cannot login to WordPress admin after update

Upgrade your PHP version to 7.2. If that gives you access, update all themees/plugins and WP to latest versions. (PHP version updates done through your hosting Control Panel. Your hosting place should have help docs on how to set your PHP version.) Test those upgrades, then upgrade PHP to version 8.x. There are major security … Read more

How to change wordpress adminstrator user ‘s ID from 1 to 0?

The MySQL table that stores the user data wp_users have an autoincrement on the primary key ID. The database will handle it automatically to avoid duplicated values and the minimal value is 1. There is nothing you can do about it. Here is the WP tables shema if you want to have a look https://codex.wordpress.org/Database_Description#Table:_wp_users … Read more

Need SQL query to find&replace image URL

If you don’t have WPCLI installed, but still have commandline access or access via PHPMyAdmin, run: UPDATE wp_posts SET post_content = REPLACE(post_content,'<old URL>’,'<new URL>’); UPDATE wp_postmeta SET meta_value = REPLACE(meta_value,'<old URL>’,'<new URL>’);

SQL command to export post_content from wp_posts using phpMyAdmin

Use This Script <?php $servername = “localhost”; $username = YOUR_USER; $password = YOUR_PASSWORD; $dbname = YOUR_DB_NAME; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die(“Connection failed: ” . $conn->connect_error); } $a1 = ($_GET[‘id’]); $sql = “SELECT post_content FROM `wp_posts` where ID=’$a1′”; $result = $conn->query($sql); if ($result->num_rows > … Read more

+ More