How can PHP developers efficiently check for the existence of a specific word in a user input text before storing it in a MySQL database?

To efficiently check for the existence of a specific word in a user input text before storing it in a MySQL database, PHP developers can use the strpos function to search for the word within the input text. If the word is found, the input can be stored in the database; otherwise, an error message can be displayed to the user. 

$user_input = $_POST['user_input'];
$specific_word = 'example';

if (strpos($user_input, $specific_word) !== false) {
    // Word found in user input, proceed to store in database
    // Add your database insertion code here
} else {
    echo 'Error: Specific word not found in user input';
}

Keywords

PHP string manipulation strpos MySQL data validation

Related Questions