Created
February 8, 2019 07:41
-
-
Save deshabhishek007/71857959e5a066365f9bbe64300f8743 to your computer and use it in GitHub Desktop.
Remove Orphan values from post-meta Table in WordPress
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<ol><?php | |
$link = mysqli_connect("localhost","Username","Password","DBNameHere"); | |
$sql = "SELECT `meta_id`,`post_id`,`meta_key`,Length(`meta_value`) as meta_data, `post_title`, `post_type` FROM `wp_postmeta` LEFT JOIN `wp_posts` on `wp_postmeta`.`post_id` = `wp_posts`.`ID` ORDER BY `wp_posts`.`post_title` ASC "; | |
$result = mysqli_query($link, $sql); | |
while($data = mysqli_fetch_assoc($result)){ | |
if($data['post_title'] == NULL && $data['post_type'] == NULL){ | |
$meta_id = $data['meta_id']; | |
$sql = "DELETE FROM `wp_postmeta` WHERE `meta_id` = ".$meta_id; | |
$res2 = mysqli_query($link, $sql); | |
echo "<li>".$data['post_id']."- Type: ".$data['post_type']."</li>"; | |
} | |
} | |
?> | |
</ol> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment