How can you check if a variable fetched from a MySQL database is an integer in PHP?

To check if a variable fetched from a MySQL database is an integer in PHP, you can use the is_numeric() function. This function will return true if the variable is a number or a numeric string, including integers. You can use this function to validate the fetched variable before using it in any calculations or comparisons. 

// Assume $result is the variable fetched from the MySQL database
if (is_numeric($result) && floor($result) == $result) {
    echo "The variable is an integer.";
} else {
    echo "The variable is not an integer.";
}

Keywords

PHP MySQL variable integer validation

Related Questions