Submission form issues

Ogden2k · 05-30-2005, 06:37 PM

I have created a MySQL DB, stuff, it contains two a table named xbox. There are multiple fields that contain Title, publisher, purchased, etc.

I can successfully insert the title into the DB, but when I try to submit multiple input fields (from the web form) it only adds the publisher, not the title.

Here's the code:

PHP Code:


			
// If info has been submitted add it to the DB.
if (isset($_POST['title'])) {
 $title = $_POST['title'];
 $sql = "INSERT INTO xbox SET
  title='$title'";
 }
 
if (isset($_POST['publisher'])) {
 $publisher = $_POST['publisher'];
 $sql = "INSERT INTO xbox SET
  publisher='$publisher'";
 if (@mysql_query($sql)) {
  echo '<p>Your info has been added.</p>';
 } else {
  echo '<p>Error adding submitted info: ' . mysql_error(). '</p>';
 }
}

CreativeLogic · 05-30-2005, 08:00 PM

The way you're doing it will actually create two new rows. What you need to do instead is make that into one query so that they are inserted on the same row. Let me know if you need a further explaination.

Ogden2k · 05-30-2005, 08:55 PM

Yes, please explain, I'm not sure of any other way on how to do htis.

Thanks,

CreativeLogic · 05-30-2005, 09:13 PM

This code is untested. If you don't understand what a part of it is doing just ask. It's fairly simple, but if you run into problems try looking up the php function first.

PHP Code:


			
// check for variables to contain data

if (!empty($_POST['title']))

{

    // add values to array for later use

    $row[] = 'title';

    $value[] = "'" . addslashes($_POST['title']) . "'";

}

if (!empty($_POST['publisher']))

{

    $row[] = 'publisher';

    $value[] = "'" . addslashes($_POST['publisher']) . "'";

}



// check to see if we need to insert data

if (count($row) > 0)

{

    // create query

    // the implode functions will create values in the query and if both

    // values are set will create a query looking like this:

    // INSERT INTO xbox (title, publisher) VALUES ('Title Posted Value', 'Publisher Posted Value')

    $sql = "INSERT INTO xbox (" . implode(',', $row) . ") VALUES (" . implode(',', $value) . ")";

    if (@mysql_query($sql))

    {

        echo '<p>Your info has been added.</p>';

    }

    else

    {

        echo '<p>Error adding submitted info: ' . mysql_error(). '</p>';

    }

}

else

{

    // no data inserted

}

jaswinder_rana · 06-01-2005, 07:33 PM

a few additions to Ryan's code
at the top do this
$row =$value = array();//initialize just to avoid some notices which might come up later on.

and then in insert statement
$sql = "INSERT INTO xbox (" . implode(',', $row) . ") VALUES ('" . implode('','', $value) . "')";

just updated to add '(single quotes) around the values

CreativeLogic · 06-01-2005, 11:55 PM

You're exactly correct with the query, and yes it is always better to initiate your variables but I have never got into this practice with PHP.