select(dropdown)

[kriek]

Attempting to insert data from select field(s) into MySQL. All database connections are correct as it does submit normal form field data and the only two fields that do not pass data are hostplan and billplan which are dropdown.

<?php
    if ($_POST['kriekhost']) {
        $db = mysql_connect($db_host, $db_user, $db_pass);
        mysql_select_db ($db_name) or die ("Cannot connect to database");
        $query = "INSERT INTO host(fullname, username, email, userhost, userip, hostplan, billplan, registration)
            VALUES('".$_POST['fullname']."','".$_POST['username']."','".$_POST['email']."','".$userhost."','".$userip."','".$_POST['hostplan']."','".$_POST['billplan']."', now())";
        mysql_query($query);
        mysql_close($db);
        {
?>

-- HTML -- 

<?php
        }
    } else {
?>
<FORM class="forms" name="form" method="post" action="<?=$PHP_SELF?>">
  <p>Full Name<br>
    <input class="forms" type="text" name="fullname">
  </p>
  <p>User Name<br>
    <input class="forms" type="text" name="username">
  </p>
  <p> 
    <SELECT class="forms" name="hostplan">
      <OPTION selected>Select Hosting Plan</OPTION>
      <OPTION>--------------------</OPTION>
      <OPTION value="Advanced">Advanced</OPTION>
      <OPTION value="Basic">Basic</OPTION>
    </SELECT>
  </p>
  <p>Email Address<br>
    <input class="forms" type="text" name="email">
  </p>
  <p> 
    <SELECT class="forms" name="billplan">
      <OPTION selected>Select Billing Plan</OPTION>
      <OPTION>--------------------</OPTION>
      <OPTION value="Monthly">Monthly</OPTION>
      <OPTION value="Annually">Annually</OPTION>
    </SELECT>
  </p>
  <p> 
    <input class="submit" type="submit" name="kriekhost" value="Submit">
    <input class="submit" type="reset" name="Reset" value="Clear Form">
  </p>
</FORM>
<?php
    }
?>

[nnichols]

The code looks fine. The only suggestion I can make is that the data held in those two variables might not be compatible with the datatype in your mysql table.

If you try to insert a text-string into an int or other numeric field it will be left blank but mysql will not return an error.

Also if you try to insert an unlisted value into an ENUM or SET you will get an empty string, or the default value if one is set.

[kriek]

Both fields hostplan and billplan are the following:

Type: TEXT
Null: YES
Default: NULL

[nnichols]

I have tested your code on my local server and it builds the query correctly.

What happens? Does it insert all the fields except the hostplan and billplan fields?

You shouldn't be using TEXT fields for such small strings. You should be using ENUM or SET for these fields as they have set values. If you change these options regularly then it might be easier to use CHAR or VARCHAR. They should be set to NOT NULL probably, though I don't know the overall architecture of your app.

[kriek]

Right now nothing is passed to the database, if I remove hostplan and billplan from $query and VALUES the rest works fine and their information is inserted into the database. I actually changed both fields from VARCHAR to TEXT although it doesn't seem to make much difference at the moment. I’ll try playing with the NULL properties.

CREATE TABLE host (
  userid int(11) NOT NULL auto_increment,
  registration date default NULL,
  username text,
  fullname text,
  hostplan text,
  billplan  text,
  email text,
  userip varchar(20) NOT NULL default '',
  userhost text NOT NULL,
  PRIMARY KEY  (userid)
) TYPE=MyISAM;

[nnichols]

I created the db table that you posted and ran it with the code and it working fine. One
thing you should definitely be doing is addslashes() to each of the fields as you cannot rely
on users not to type in data that is 'safe'.

Maybe one of your variables that you are testing it with contains a single or double quote.

Try echoing your query to make sure it is formed correctly and run your query like this -

@mysql_query($query)
	or die('MySQL error: '.mysql_error().'<br>Query: '.$query);

to see if it generates any errors.

[kriek]

MySQL error: Query was empty

It also returned empty when I echo $query

But when I remove hostplan and billplan it works fine and the $query returns this when I echo it back. So it has to be something involving hostplan and/or billplan

Query: INSERT INTO host(fullname, username, email, userhost, userip, registration)

VALUES('jon kriek','kriek','[e-mail]','*.tampabay.rr.com','24.26.88.144', now())

[nnichols]

Please post the code for the entire page including any code from included files.

[kriek]

Check your PM and email, thanks for your help =)