AHMAD ASJAD – احمد اسجد

Developer

  • HOME
  • Question & Answer
  • CONTACT

Tag Archives: enum

January 10, 2016

Find all enum values in MySql using php

 

Code Block   
  1. function get_enum_values($table, $field)
  2. {
  3. $sql = "SHOW COLUMNS FROM $table WHERE Field = '$field'";
  4. $row = mysql_fetch_array(mysql_query($sql));
  5. $type = $row['Type'];
  6. preg_match("/^enum\(\'(.*)\'\)$/", $type, $matches);
  7. $enum = explode("','", $matches[1]);
  8. return $enum;
  9. }
Posted in Database, Function, MySQL, PHP, Programming by ahmadasjad Leave a comment

Categories

  • Algorithm (10)
  • Array (2)
  • Database (5)
    • MySQL (5)
    • SQL (1)
  • Design Pattern (1)
  • e-Commerce (1)
    • Magento (1)
  • Framework (3)
    • Yii Framework (3)
  • Function (14)
  • HTML (1)
  • JavaScript (4)
  • JQuery (5)
  • Method (6)
  • OS (2)
    • Ubuntu (1)
    • Windows (1)
  • PHP (25)
  • Programming (30)
    • Python (1)
  • Server (1)
  • Sorting (1)
  • Uncategorized (1)
  • XAMPP (1)

Old Post

  • October 2018 (2)
  • February 2018 (2)
  • November 2017 (1)
  • February 2017 (1)
  • December 2016 (2)
  • November 2016 (1)
  • August 2016 (3)
  • July 2016 (1)
  • June 2016 (1)
  • May 2016 (1)
  • April 2016 (2)
  • January 2016 (3)
  • December 2015 (5)
  • November 2015 (7)
  • May 2015 (1)
  • March 2015 (2)
  • January 2015 (2)
  • December 2014 (1)
  • February 2014 (1)
This Site is owned by Ahmad Asjad & All © Reserved to him
ahmadasjad.in
 

Loading Comments...