www.webdeveloper.com
Results 1 to 5 of 5

Thread: Simple Form Insert Problem

  1. #1
    Join Date
    Nov 2005
    Posts
    169

    Simple Form Insert Problem

    Hello everyone, I have a question about a very basic form I've set up. I'm trying to get the hang of SQL select, but I first need to put some content in my SQL tables! For now, here is the code I've used:

    The form on the page:
    HTML Code:
    <form action="testform.php" method="post">
    <input type="text" name="title" value="Game Title">
    <input type="text" name="esrb" value="ESRB Rating">
    <input type="Submit" value="Submit Title">
    </form>
    The testform.php file:
    PHP Code:
    <?
    $username
    ="edited";
    $password="edited";
    $database="edited";
    mysql_connect(localhost,$username,$password);
    @
    mysql_select_db($database) or die( "Unable to select database");
    $title=$_POST['title'];
    $esrb=$_POST['esrb'];
    $query="INSERT INTO game_titles (gameID,gametitle,esrbrating) VALUES(DEFAULT,$title,$esrb)";
    mysql_query($query);
    echo 
    "It worked."
    ?>
    For some reason, the output isn't written into the correct tables? What's wrong here? Thanks!

  2. #2
    Join Date
    Jul 2004
    Posts
    300
    try the following:

    $query="INSERT INTO game_titles (gameID,gametitle,esrbrating) VALUES(DEFAULT,'$title','$esrb')";

  3. #3
    Join Date
    Nov 2005
    Posts
    169
    Thanks a bunch! It fixed the problem! While I'm at it, may I ask how you get the form method to just include the PHP from my "testform.php" file instead of actually redirecting the browser to that file?
    Last edited by Tusserte; 09-21-2007 at 06:03 PM.

  4. #4
    Join Date
    Nov 2005
    Posts
    169
    UPDATE: The form worked, but only once. For some reason, only id=0 goes in, and the form ignores the rest of the things I try to input. By the way, gameID is the auto_increment PRIMARY KEY and is supposed to be the generic INT number assigned to tell each row apart. The other variables are actual inputs. What am I doing wrong?

  5. #5
    Join Date
    Nov 2005
    Posts
    169
    Another update: ignore the last update. I didn't see that there my phpmyadmin page scrolled, so I didn't see the extra: auto_increment and somehow thought I had set it before. Sorry! However, the question before still stands, I'm very curious . Thanks!

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
  •  
HTML5 Development Center



Recent Articles