Board index   FAQ   Search  
Register  Login
Board index php forum :: Database mySQL & php coding

php error message when submitting new record to mysql db

Codes here !

Moderators: macek, egami, gesf

php error message when submitting new record to mysql db

Postby leefrand377 » Sun Aug 05, 2012 10:38 am

When I enter input to every text box and try to submit, I get my php error
Please fill in the Text Fields.
I cannot find the php programming error that makes it think that I have a blank field. The db fields match the php. I would appreciate help in determining why it thinks I have a blank field. Here's the php code.
Code: Select all
<?php // vols_add.php
/* This script adds a new record. */

// Define a page title and include the header:
define('TITLE', 'Add a Record');
include('vols_templates/vols_header.html');

print '<h2>Add a Record into the Database</h2>';
//print "<font color='red'>All Text Fields must be filled in.</font>";
// Restrict access to administrators only:
if (!is_administrator())
{
   print '<h2>Access Denied!</h2><p class="error">You do not have permission to access this page.</p>';
   
   exit();
}

// Check for a form submission:
if ($_SERVER['REQUEST_METHOD'] == 'POST')

{ // Handle the form.

   if ( !empty($_POST['Name']) && !empty($_POST['Email']) )
   {
      // Need the database connection:
      include('vols_includes/vols_connect.php');

      // Prepare the values for storing:
      $id= mysql_real_escape_string(trim(strip_tags($_POST['id'])), $link);
      $FullName = mysql_real_escape_string(trim(strip_tags($_POST['FullName'])), $link);
      $Email = mysql_real_escape_string(trim(strip_tags($_POST['Email'])), $link);
      $phone = mysql_real_escape_string(trim(strip_tags($_POST['phone'])), $link);
      $address = mysql_real_escape_string(trim(strip_tags($_POST['address'])), $link);
      $cell = mysql_real_escape_string(trim(strip_tags($_POST['cell'])), $link);
      $Fax = mysql_real_escape_string(trim(strip_tags($_POST['Fax'])), $link);
      $cityandzip = mysql_real_escape_string(trim(strip_tags($_POST['cityandzip'])), $link);
      $available = mysql_real_escape_string(trim(strip_tags($_POST['available'])), $link);
      $rel_experience = mysql_real_escape_string(trim(strip_tags($_POST['rel_experience'])), $link);
      $why_volunteer = mysql_real_escape_string(trim(strip_tags($_POST['why_volunteer'])), $link);
      $vol_before = mysql_real_escape_string(trim(strip_tags($_POST['vol_before'])), $link);
      $query = "INSERT INTO vols (FullName, Email, phone, address, cell, Fax, cityandzip, available, rel_experience, why_volunteer, vol_before)
VALUES('$FullName', '$Email', '$phone', '$address', '$cell', '$Fax','$cityandzip', '$available', '$rel_experience', '$why_volunteer', '$vol_before')";
      
      $r = mysql_query($query, $link);
      
      if (mysql_affected_rows($link) == 1)
      {
         // Print a message:
         print "\r\n<font color='blue'> Your Record has been added!</font>";
       }else
      {
         print '<p class="error">Could not store the Record because:<br />' . mysql_error($link) . '.</p><p>The query being run was: ' . $query . '</p>';
      }
      
      // Close the connection:
      mysql_close($link);
      
   } else
   {    // Failed to enter a Record.
      print '<p class="error"> Please fill in the Text Fields.</p>';
   }
   
} // End of submitted IF.

   // Leave PHP and display the form:
?>
<form action="vols_add.php" method="post">
      <table align="center">
        <tr><td><font color='red'>&nbsp;&nbsp;All Text Fields must be filled in.</font></td>
 <td>&nbsp;</td>
</tr>
        <tr>
          <td width="50%">Full Name:
                  <input type="text" name="FullName" id="FullName"></td>
          <td>Email:
                  <input type="text" name="Email" id="Email"></td>
         </tr>
        <tr>
          <td width="50%">Phone:
                    <input type="text" name="phone" id="phone"></td>
          <td>Address:
                    <input name="address" type="text" id="address" size="30"></td>
         </tr>
        <tr>
          <td width="50%">Cell Phone:
                 <input name="cell" type="text" id="cell" size="25"></td>
          <td>Fax No.:
                  <input type="text" name="Fax" id="Fax"></td>
         </tr>
        <tr>
          <td width="50%">City, State, Zip:           
                  <input name="cityandzip" type="text" id="cityandzip" size="20"></td>
          <td>Available; D/Hrs:
                  <input type="text" name="available" id="available"></td>
         </tr>
          </table>
          <br>
          <table align="center">
        <tr>
          <td align="center"><p>Related Experience                                    <p>
             <textarea name="rel_experience" id="textarea" cols="45" rows="5"></textarea>
           </td>
        </tr>
        <tr>
          <td align="center"><p>Why Do You Want to Volunteer? </p>
            <textarea name="why_volunteer" id="textarea2" cols="45" rows="5"></textarea>
       </tr>
       <tr>
          <td align="center"> <p>Have You Been a BCLA Volunteer Before? When? Please explain.</p>
           <textarea name="vol_before" id="textarea3" cols="45" rows="5"></textarea>
           </td>
         </tr>
   </table>
                   <input type="submit" name="submit" value="Submit New Record" />
</form>
leefrand377
New php-forum User
New php-forum User
 
Posts: 2
Joined: Sun Aug 05, 2012 9:00 am

Re: php error message when submitting new record to mysql db

Postby NigelRen » Sun Aug 05, 2012 10:48 am

If your not sure which fields are getting through - once you know it's using POST - use
print_r( $_POST );

to help.
But I think it may be that you've used FullName in the form and testing for a field called Name in the form handling part.
NigelRen
php-forum Active User
php-forum Active User
 
Posts: 450
Joined: Fri Aug 05, 2011 9:53 am

Re: php error message when submitting new record to mysql db

Postby leefrand377 » Sun Aug 05, 2012 11:10 am

You are sooooo right. I must have looked at that mistake 1000 times and missed it. Changing the test to "FullName" did it. I thank you so much!
Lee
leefrand377
New php-forum User
New php-forum User
 
Posts: 2
Joined: Sun Aug 05, 2012 9:00 am


Return to mySQL & php coding

Who is online

Users browsing this forum: Bing [Bot] and 5 guests

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.