HTML Form to Database issue

[derekbelcher]

Hello.  I am building a tool for users to enter their roster of members and submit that to the members database.

 

I can do it for one entry at a time, but I want to be able to allow the user to enter all the members on one form and submit them all at one time.

 

Here is my code so far...

 

<?php

  if ($HTTP_POST_VARS['submit']) {

    mysql_connect("Localhost","p2r71184","692134a");

    mysql_select_db("p2r71184_regMembers");

$unit=$HTTP_POST_VARS['unit'];

    $firstname=$HTTP_POST_VARS['firstname'];

$lastname=$HTTP_POST_VARS['lastname'];

$rank=$HTTP_POST_VARS['rank'];

$email=$HTTP_POST_VARS['email'];

$query ="INSERT INTO yourmembers (unit,firstname,lastname,rank,email)";

    $query.=" VALUES ('$unit','$firstname','$lastname','$rank','email')";

    $result=mysql_query($query);

    if ($result) echo "<b>Your members have been uploaded successfully!</b>";

    else echo "<b>ERROR: There was a problem uploading, please try again!</b>";

  }

?>

  <H1>Member Roster</H1>

  <form method="post" action="addMember.php">

    <table width="600" border="1" cellpadding="0" cellspacing="0" bordercolor="#000000">

      <tr>

        <td bgcolor="#FFFF00"><div align="center">Unit </div></td>

        <td bgcolor="#FFFF00"><div align="center">First Name </div></td>

        <td bgcolor="#FFFF00"><div align="center">Last Name </div></td>

        <td bgcolor="#FFFF00"><div align="center">Rank</div></td>

        <td bgcolor="#FFFF00"><div align="center">Email Address </div></td>

      </tr>

      <tr>

        <td>

          <div align="center">

            <input name="unit" type="text" size="4">

          </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit2" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname2" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname2" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank2" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email2" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit3" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname3" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname3" type="text"  size="30">

        </div></td>

        <td><div align="center">

          <input name="rank3" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email3" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

      </tr>

      <tr>

        <td><div align="center">

          <input name="unit" type="text" size="4">

        </div></td>

        <td><div align="center">

          <input name="firstname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="lastname" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="rank" type="text" size="30">

        </div></td>

        <td><div align="center">

          <input name="email" type="text" size="45">

        </div></td>

    </tr>

    </table>

    <p align="left">

<input type="submit" name="submit" value="Submit Roster">

[marklarah]

Okay, after looking at it briefly, it looks like the easiest option is to be able to dynamically add more fields (using javascript, client side), and then submitting it to your database with arrays. That is, rather than getting specific post variables, just get all the post variables sent.

 

Also, nothing important, but you should probably use 'localhost rather than 'Localhost'. I have no idea if it really matters though.

 

Give me a bit of time to rustle something up.