How can delete a user without deleting the post and comments in wordpress?

In this blog, I will expalin how to delete a user/Editor/Subscriber/Author/Administor without deleting the post and comments. When you start deleting the post application will be prompt that you want to assign the post to another user. To keep the user's post, this you have to assign the deleteing user post to another user.

Follow the following simple steps.
1. Login as Administrator (must be not login to whom you are going to delete).
2. Go to User Listing.
3. Click on check box in front of user to whom you want to delete. See below screenshot.

4. Click on delete icon. It will bring to you new page.
5. Now assign all post to another user/administrator. See below Screenshot.

6. Click on "Confirm Deletion". User deleted successfully.

Now deleting the user, same user wouldn't be able to login to system. If he is currently login will logout automatically.

Best Related Posts are Following:

1. How to create wordpress Shortcode?.
2. XMLRPC Wordpress Attack.
3. Wordpress insert record into table and get last insert Id.
4. Wordpress Interview Questions and Answers for experienced.
5. How do I get wordpress global variable and functions in custom file [SOLVED].
6. How to send Email in wordpress.
7. How to change the author of a post in Wordpress.
8. How can delete a user without deleting the post and comments in wordpress?.
9. Wordpress redirect https to http with htaccess [SOLVED].
10. Wordpress Website title repeated two times in browser header [SOLVED].
11. Wordpress Interview Questions and Answers.

How to use MySQLi parameterized statements?

Here I will provide code snippet for the followings

• How to make Database Connection with PHP-MysQLI.
• How to fetch the records from database using MysQLI parameterized/prepared statements.
• How to insert the record in database using MysQLI parameterized/prepared statements.

Create New Table

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(50) NOT NULL,
  `last_name` varchar(50) NOT NULL,
  `email` varchar(255) NOT NULL,
  `type` char(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 
INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`, `type`) VALUES
(1, 'Micheal', 'Steve', 'micheal@georama.com', 'Guide'),
(2, 'Vt', 'B2B', 'vt@georama.com', 'Guide'),
(5, 'Jana', 'Peter', 'jana@gmail.com', 'Guide'),
(6, 'Ram', 'kumar', 'ramkumar@no-spam.ws', 'Guide');

How to make Database Connection with PHP-MysQLI.

$host = 'localhost';
$user = 'root';
$password = '';
$dbName = 'arun';
$mysqliObj = new mysqli($host, $user, $password, $dbName);
if ($mysqliObj->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqliObj->connect_errno . ") " . $mysqliObj->connect_error;
}

How to fetch the records from database using MysQLI parameterized/prepared statements.

$userType = "Guide";
$stmt = $mysqliObj->prepare("SELECT * FROM users WHERE type = ?");
$stmt->bind_param("i", $userType);
$stmt->execute();
$resObj = $stmt->get_result();
while ($row = $resObj->fetch_assoc()) {
    print_r($row['id']);echo "\n";
}

How to insert the record in database using MysQLI parameterized/prepared statements.

/** Insert into database with mysql * */
//the data
$id = null;
$firstname = "Web";
$lastname = "Technoogy";
$email = "arun.c@no-spam.ws ";
$type = "Guide";

$stmt = $mysqliObj->stmt_init();
if (!($stmt->prepare("INSERT INTO users(first_name, last_name, email,type) VALUES (?,?,?,?)"))) {
    echo "Prepare failed: (" . $mysqliObj->errno . ") " . $mysqliObj->error;
}
$stmt->bind_param("ssss", $firstname, $lastname, $email, $type);
$stmt->execute();
$stmt->close();

Best Related Posts are Following:

1. What is MySQLI technology in php.
2. Using mysqli and parameterized statements in PHP with Example.