Advertisement
Squito

SQL enum values list

Mar 6th, 2018
262
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.31 KB | None | 0 0
  1. <?php
  2. $query=mysqli_query($conn, "SHOW COLUMNS FROM tabla WHERE Field = 'mezo'");
  3. $row=mysqli_fetch_assoc($query);
  4. $x=array("enum('", "')");
  5. $y=array('', '');
  6. $enum=str_replace($x, $y, $row['Type']);
  7. $values=explode("', '", $enum);
  8. for($i=0;isset($values[$i]);$i++)
  9. {
  10.     echo "<OPTION>".$values[$i]."</OPTION>";
  11. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement