Check if column exist in MySQL table via PHP

Question

I created mysql tables and there I have put some columns.

Now I want to check that a certain column exists in the database via php.

Like this:

if (column exist){
echo "Column in table is available."
}
else{
echo "Column doesnt exist.";
}

Is it possible to do this?

A lot of thanks for your time :)

Answer 1

try

$result = mysql_query("SHOW COLUMNS FROM `table` LIKE 'fieldname'");
$exists = (mysql_num_rows($result))?TRUE:FALSE;
if($exists) {
   // do your stuff
}

For more :- MySQL, Check if a column exists in a table with SQL

Note:- mysql_* is deprecated use mysqli or PDO