The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

> no luck inserting data into database
MindyT
post Nov 9 2015, 10:44 AM
Post #1


Advanced Member
****

Group: Members
Posts: 165
Joined: 12-November 13
Member No.: 19,963
Hi, it has been a while since I have worked with PHP & MYSQL. Can someone help me understand why information from a form isn't being inserted in the database. The connection is fine.

CODE

<?php
require_once('functions.php');
databaseConnection();
error_reporting(-1);
ini_set('display_errors', 1);

if ($_POST)
    {
    $error = array();

    if (empty($_POST['fname']))
        {
        $error['fname'] = "<span class='error'>Please enter your first name.</span>";
        }
    if (empty($_POST['lname']))
        {
        $error['lname'] = "<span class='error'>Please enter your last name.</span>";
        }

    if (!count($error))

        {        //Do something
        die("Do Something here");
        }
    
    if(isset($_POST['submit'])) {
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$orgName = $_POST['orgName'];
$address = $_POST['address'];
$city = $_POST['city'];
$state = $_POST['state'];
$zipcode = $_POST['zipcode'];
$phone = $_POST['phone'];
$fax = $_POST['fax'];
$email = $_POST['email'];
$confirmEmail = $_POST['confirmEmail'];
$projectOptions = $_POST['projectOptions'];
$projectOverview = $_POST['projectOverview'];
$year = $_POST['year'];
$services=array('social media', 'web content management', 'marketing material creation', 'SEO', 'video editing' , 'web design');
    }
mysql_select_db("www_mediaservicesunlimited_com");
$sql="INSERT INTO clients & #40;fname,lname,orgName,address,city,state,zipcode,phone,fax,email,confirmEmail,
projectOptions,projectOverview,year)
        VALUES  ('$_POST[fname]','$_POST[lname]','$_POST[orgName]','$_POST[address]','$_POST[city]','$_POST[state]','$_POST[zipcode]','$_POST[phone]','$_POST[fax]','$_POST[email]','$_POST[confirmEmail]','$_POST[projectOptions]','$_POST[projectOverview]','$_POST[year]' )";
}
///mysql_query($sql,$databaseConnection);
///mysql_close($databaseConnection);
?>
<!doctype html>
<html>
<head>
      <meta charset="utf-8">
      <style type="text/css">
        #contactForm label, #contactForm input {
            margin-bottom:20px;
          }
      </style>
      <title>Untitled Document</title>
   </head>
   <body>
       
        <div id="contactForm">  
         <form action ="contactUs.php" method="post">
         <label>  
           <label for "fname"> First Name:</label>
                  <input id = "fname" type="text" name="fname" size="15" value ="<?php echo !empty($_POST['fname']) ? $_POST['fname'] : '';?>" >    <?php echo !empty($error['fname']) ? $error['fname'] : '';?>
            <label for "lname">Last Name:</label>
                   <input type="text" name="lname" size="20"><?php echo !empty($error['lname']) ? $error['lname'] : '';?>
            <label for="orgName">Organization's Name:</label>
            <input type="text" name="orgName" maxlength="50">
            </label><br />
            <label> <!--new row -->  
                <label for "address">Street Address: </label>
                  <input id = "address" type="text" name="address" size="15" maxlength="50">
                <label id="city">City: </label>
                  <input id = "city" type="text" name="city" size="10" maxlength="25">
                <label  for "state"> State:    </label>
                  <select id  = "state" name = "state"  value="">
                     <option value ="Please choose a state">
                        Please choose a state
                     </option>
                     <?php states($state); ?>
                  </select>
                 <label for "zipcode">Zipcode:</label>
                  <input id = "zipcode" type="number" name="zipcode" size="5" maxlength="5">
             </label><br />
             <label> <!--new row -->
              <label for "phone">  Phone Number:(including area code)  <br /> </label>
                  <input type="text" name="phone" size="10" maxlength="10">  
            <label for="fax">Fax Number: (including area code)
</label>        
                  <input type="text" name="fax" size="10" maxlength="10">
            </label><br />
            <label> <!--new row-->
                <label for="email">Email: </label>
                  <input type="text" id = "email" name="email" />
                <label for="confirmEmail"> Confirm Email:</label>
                  <input type="text" id = "confirmEmail" name="ConfirmEmail" />
</label><br />
            <label> <!--new row -->
            <label for "projectChoices"> What would you like help with?  <br /></label>
             <table id="projectOptions">
                     <tr span=2>
                        <td><input type="checkbox" name="SocialMedia">Social Media </td>
                        <td><input type="checkbox" name="WebContentManagement">Web Content Management     </td>
                     </tr>
                     <tr>
                        <td><input type="checkbox" name="MarketingMaterials">Marketing Material Creation  </td>
                        <td><input type="checkbox" name="SEO">SEO (Search Engine Optimization)     </td>
                     </tr>
                     <tr>
                        <td><input type="checkbox" name="VideoEditing"> Video Editing  </td>
                        <td><input type="checkbox" name="WebDesign">Web Design      </td>
                     </tr>
                  </table>
            <label for="projectOverview"> Overview about the project:</label><textarea rows="5" cols="10"></textarea>  <br />
If you are not a robot, what year is it? <input type="text" name="year" size="4" maxlength="4"><br />
<input type="submit" name="submit" value="Contact Me!">
<input type="reset">
         </form>
        </div>
   </body>
</html>
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
 
 Reply to this topicStart new topic
Replies
CharlesEF
post Nov 11 2015, 07:07 PM
Post #2


Programming Fanatic
********

Group: Members
Posts: 1,981
Joined: 27-April 13
From: Edinburg, Texas
Member No.: 19,088
Well, are you saying the forum added it? If so then I have no control over that. We will have to see if someone else jumps in.

Anyway, based on your new code you still have a closing ) where it is not needed. And this test is wrong 'if ($_POST)', it should be 'if(isset($_POST['submit']))'.

You should start a new file, copy and pasted small sections of code at a time. First, read and sanitize the $_POST values then assign them to variables. Next copy and paste the database connection code and test it. Work your way down from there, small steps
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Posts in this topic
MindyT   no luck inserting data into database   Nov 9 2015, 10:44 AM
CharlesEF   I see a few possible problems: 1. You are open to...   Nov 9 2015, 12:58 PM
MindyT   I don't have a lot of time to answer all your ...   Nov 9 2015, 03:56 PM
masonh928   http://www.phpro.org/tutorials/Introduction-to-PHP...   Nov 9 2015, 10:43 PM
masonh928   I personally recommend PDO, but mysqli is better t...   Nov 9 2015, 10:43 PM
MindyT   I'm trying to use PDO to connect to the databa...   Nov 11 2015, 12:32 PM
CharlesEF   I think your problem is with this line of code: ...   Nov 11 2015, 02:44 PM
MindyT   that's weird. I dont have that #40; in the co...   Nov 11 2015, 03:43 PM
MindyT   this is weird. It did it again but it 's not ...   Nov 11 2015, 03:49 PM
CharlesEF   Well, are you saying the forum added it? If so th...   Nov 11 2015, 07:07 PM
CharlesEF   A thought about your copy and paste problem. Dele...   Nov 12 2015, 08:34 AM
Frederiek   Just my 2 cents. The "& #40;" should...   Nov 12 2015, 12:00 PM
CharlesEF   Just my 2 cents. The "& #40;" shoul...   Nov 12 2015, 01:07 PM
CharlesEF   If you still need help with this problem then inst...   Nov 12 2015, 11:02 PM
Frederiek   True, w/o the space, it's Unicode for (. (Tho...   Nov 13 2015, 04:22 AM

« Next Oldest · Databases · Next Newest »
 

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

- Lo-Fi Version Time is now: 12th May 2024 - 11:23 PM
Invision Power Board © 2024  IPS, Inc.
Licensed to: HTMLHelp.com, LLC