Converting mysql to $wpdb

Question

I'm trying to convert this to using a $wpdb class. It will return all the enums possible and i have to use this $wpdb due to mysql_query giving me weird error (no database selected) Code is following

function getEnumValues($table, $field)
  {
    $enum_array = array();
    $query = 'SHOW COLUMNS FROM `' . $table . '` LIKE "' . $field . '"';
    $result = mysql_query($query);

    if($result === FALSE) {
    die(mysql_error()); }

    $row = mysql_fetch_row($result);
    preg_match_all('/\'(.*?)\'/', $row[1], $enum_array);
    if(!empty($enum_array[1]))
    {
      //Shift array keys to match original enumerated index in MySQL (allows for use of index values instead of strings)
      foreach($enum_array[1] as $mkey => $mval) $enum_fields[$mkey+1] = $mval;
      return $enum_fields;
    }
    else
      return array(); // Return an empty array to avoid possible errors/warnings if array is passed to foreach() without first being checked with !empty().
}

Afterwards I have to use this code snippet to read them out

<?php
            $enums = getEnumValues("property", "form_field_type");
            foreach($enums as $enum){
                  echo '<input type = "radio" name = "form_field_type" value = "'.$enum.'">';
                  echo '<label for = "'.$enum.'"> '.$enum.'</label><br>';
            }
?>

of note, the mysql extension is deprecated, the mysql_query function and others will throw warnings in recent versions of PHP, and will fail completely in the newest versions ( the extension was removed in favour of mysqli and PDO ) — Tom J Nowell
– Tom J Nowell ♦, Commented Dec 9, 2015 at 3:13

Felix · Accepted Answer · 2015-12-10 21:16:05Z

0

You can query INFORMATION_SCHEMA and achieve the same:

function getEnumValues($table, $field)
  {

    global $wpdb;

    $result = $wpdb->get_row("SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '" . DB_NAME . "' AND TABLE_NAME = '" . $table . "' AND COLUMN_NAME LIKE '" . $field . "'");

    if($result === FALSE) {
      die($wpdb->last_error); 
    }

    // this is the column name
    $result->COLUMN_NAME;

}

edited Dec 10, 2015 at 21:16

answered Dec 10, 2015 at 20:42

Felix

114 bronze badges

Hey if you have a datbase set in config.php that you want to work with, is setting the database name still required?

JediTricks007
– JediTricks007

2015-12-10 20:46:38 +00:00
Commented Dec 10, 2015 at 20:46
Good point, the database name is in a global named DB_NAME

Felix
– Felix

2015-12-10 21:15:20 +00:00
Commented Dec 10, 2015 at 21:15

Add a comment |

AhmadKarim · Accepted Answer · 2020-10-02 22:35:43Z

0

Here is a solution for a WordPress table field. This will break if the ENUM values have comma in them

https://gist.github.com/ahmu83/358f8e41e6134013991d9e3cf5edaf8c

answered Oct 2, 2020 at 22:35

AhmadKarim

1012 bronze badges

Could you include the relevant parts of the code in the answer please, rather than just linking to it? Thanks!

Rup
– Rup

2020-10-02 23:05:20 +00:00
Commented Oct 2, 2020 at 23:05

Add a comment |

Stack Exchange Network

Converting mysql to $wpdb

2 Answers 2

Your Answer

Hot Network Questions

Converting mysql to $wpdb

2 Answers 2

Your Answer

Sign up or log in

Post as a guest

Related

Hot Network Questions