#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2012
    Posts
    56
    Rep Power
    2

    HTML Select Option to add data


    Hi,

    I am developing an online gallery for one of our local museum. I am new to PHP scripting and so I have numerous challenges. At this point I would like to understand how I can add data from html select option values into a mysql field.

    Code:
    <select name="cobjecttype" id="cobjecttype" tabindex="" >
    			<option value="">---Select object type---</option>
    			<option value="cceramic">Ceramic</option>
    			<option value="cclock">Clock</option>
    			<option value="cgold">Gold and silverware</option>
    			<option value="cmask">Mask</option>
    			<option value="cpainting">Painting</option>
    			<option value="csculpture">Sculpture</option>
    			<option value="ctapestry">Tapestry</option>
    	  </select>
    I am not geting it to work as expected and no errors generated.

    I will appreciate.

    joseph
  2. #2
  3. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,317
    Rep Power
    7170
    There's no problem with your <select> element that I see. The value will be submitted to your PHP script in either $_POST['cobjecttype'] or $_GET['cobjecttype']. From there, you need to construct and run an appropriate insert or update query depending on what exactly you want to do with that piece of data.

    The issue you're running into is more likely with your PHP code than your HTML.
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around
  4. #3
  5. Did you steal it?
    Devshed Supreme Being (6500+ posts)

    Join Date
    Mar 2007
    Location
    Washington, USA
    Posts
    14,002
    Rep Power
    9398
    The name of the input is "cobjecttype" so the selected value will be either $_POST["cobjecttype"] (if your form is action=post) or $_GET["cobjecttype"] (otherwise).
    For the database follow a generic PHP+MySQL tutorial, but look for one using mysqli or PDO - not the regular mysql extension and its mysql_* functions.

    Sounds like you have more code than you've shown so far. What is it?

IMN logo majestic logo threadwatch logo seochat tools logo