Results 1 to 3 of 3

Thread: MySQL database and HTML?

  1. #1

    MySQL database and HTML?

    Hello!
    I have a problem with data adding form..
    Ok, so when I added fields into MySQL database through phpmyadmin, I made there many fields which are 'ENUM' or 'SET' and I wrote few options under those fields.
    Now when I have this Html form which can edit old items or add new items into database.
    I would like to get scrollbars for those 'ENUM' or 'SET' fields, but how?
    I have here a simple html code:

    <SELECT NAME="xxx">
    <OPTION> 1
    <OPTION> 2
    <OPTION> 3
    <OPTION> 4
    <OPTION> 5
    </SELECT>

    The problem is that I don't know how to get the options from database into <OPTION> 1, <OPTION> 2 and so on...

    I hope that somebody understood what I ment here...
    Thanks!

  2. #2

  3. #3
    PHP Code:

    function getOptions($field,$table) {
       
    $result=mysql_query("SHOW COLUMNS FROM `$table` LIKE '$field'");
       if(
    mysql_num_rows($result)>0){
           
    $row=mysql_fetch_row($result);
           
    $options=explode("','"preg_replace("/(enum|set)\('(.+?)'\)/","\\2"$row[1]));
       } else {
           
    $options=array();
       }
       
    $optionList='';
       foreach(
    $options as $val) {
          
    $optionList.="<option value='$val'>$val</option>";
       }   
       return 
    $optionList;
    }

    // example
    $options getOptions('fieldnamehere','tablenamehere');
    echo 
    "<select name='blah'>";
    echo    
    $options;
    echo 
    "</select>"

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012