Learn VBA & Macros in 1 Week!

PHP - User Updating A Form With Drop Down Menus In It

Full Excel VBA Course - Beginner to Expert

User Updating A Form With Drop Down Menus In It	View Content

Hi I have a single page submission update page which incorporates 7 drop down menus and 2 text input fields, everything works fine with the data updating back to the database, the only thing is that when the page is updated all the drop down menus are updated which includes ones that I don't want updated?

I need to only update the drop down menus that have been selected? but am unsure how I do it?

This is the code from the page, sorry if its a mess but I am not that experienced at the moment.
This is a snippet of one of the drop down menus

Code: [Select]
<tr>
<td class="heading">Current Status</td>
<td><?php echo $statusdescrip ['status_description']; ?>
<select name="status_id" >
<?php
$status_set = findstatus();
$statuslist = mysql_fetch_assoc ($status_set);
?>
<?php
do {
?> <option value="<?php echo $statuslist ['status_id']; ?>" ><?php echo $statuslist ['status_description']; ?></option>
<?php
} while ($statuslist = mysql_fetch_assoc ($status_set));
?></select>
<span class="compuls">*</span></td>
</tr>

Full Excel VBA Course - Beginner to Expert

Drop-down Menus Not Posting Into Database, Yet Rest Of Form Is

Similar Tutorials

View Content

Ok, I have one database three tables.

Table 1 is ncmr the main table where everything is to be entered.

Table 2 is companies, where all the companies in pull down menu 1 is located.

Table 3 is fabricators, where all the people who have had hands on the product are residing.

I want the selected choices of table 2 and 3 to be inputed into table 1. I know this has to be possible, but I don't know how. I thought I wrote the code correctly, but it seems not.

Can someone review my code and show me where my mistake is?

Here is the page:

http://kaboomlabs.com/PDI/post2.php

Thanks.

Code: [Select]
<?php

    require_once('connectvars.php');
     $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
     or die('Error connecting to MySQL server.');
    ?>

<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>PDI Non-Conforming Materials Report</title>
<link rel="stylesheet" type="text/css" href="CSS/postie.css" />

</head>

<body>
<div id="logo">
<img src="images/PDI_Logo_2.1.gif" alt="PDI Logo" />
</div>

<div id="title">
<h3 id="NCMR2">Non-Conforming Materials Report (NCMR)</h3>
</div>
<?php
    //Post Data
     if (isset($_POST['submit'])) {
     $ab = mysqli_real_escape_string($dbc,$_POST['ab']);
     $date = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime ($_POST['date'])));
     $part = mysqli_real_escape_string($dbc,$_POST['part']);
     $rev = mysqli_real_escape_string($dbc,$_POST['rev']);
     $partdesc = mysqli_real_escape_string($dbc,$_POST['partdesc']);
     $ncmrqty = mysqli_real_escape_string($dbc,$_POST['ncmrqty']);
     $comp = mysqli_real_escape_string($dbc,$_POST['comp']);
     $ncmrid = mysqli_real_escape_string($dbc,$_POST['ncmrid']);
     $rma = mysqli_real_escape_string($dbc,$_POST['rma']);
     $jno = mysqli_real_escape_string($dbc,$_POST['jno']);
     $fdt = mysqli_real_escape_string($dbc,$_POST['fdt']);
     $cof = mysqli_real_escape_string($dbc,$_POST['cof']);
     $fab1= mysqli_real_escape_string($dbc,$_POST['fab1']);
     $fab2= mysqli_real_escape_string($dbc,$_POST['fab2']);
     $fab3= mysqli_real_escape_string($dbc,$_POST['fab3']);
     $non= mysqli_real_escape_string($dbc,$_POST['non']);
     $dis= mysqli_real_escape_string($dbc,$_POST['dis']);
     $comm= mysqli_real_escape_string($dbc,$_POST['comm']);
     $caad= mysqli_real_escape_string($dbc,$_POST['caad']);
     $po= mysqli_real_escape_string($dbc,$_POST['po']);
     $pod = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime($_POST['pod'])));
     $dri = mysqli_real_escape_string($dbc,date('Y-m-d',strtotime($_POST['dri'])));

     $output_form = 'no';
     if (empty($ab) || empty($date) || empty($part) || empty($partdesc)){

    // We know at least one of the input fields is blank
    echo '<div id="alert">';
    echo 'Please fill out all of the required NCMR information.<br />';
     echo '</div>';

    }
     $output_form = 'yes';

    }

    //Access the Database
     if (!empty($ab) && !empty($date) && !empty($pod)) {
     $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
     or die('Error connecting to MySQL server.');

     $query = "INSERT INTO ncmr (ab, date, part, rev, partdesc, ncmrqty, comp, ncmrid, rma, jno, fdt, cof, fab1, fab2, fab3, non, dis, comm, caad, po, pod, dri)

     VALUES ('$ab','$date','$part','$rev','$partdesc','$ncmrqty','$comp','$ncmrid','$rma','$jno','$fdt','$cof','$fab1','$fab2','$fab3','$non','$dis','$comm','$caad','$po','$pod','$dri')";

     $data = mysqli_query($dbc, $query) or die("MySQL error: " . mysqli_error($dbc) . "<hr>\nQuery: $query");


          // Confirm success with the user
     echo '<tr><td class="thank">';
     echo '<p>Thank you for adding the NCRM, the correct person will be informed.</p>';
     echo '<p><a href="post.php"><< Back to the form</a></p>';
     $output_form = 'no';
     echo '</td></tr>';

     mysqli_close($dbc);
    }
      if ($output_form == 'yes') {
    echo "<form action='".$_SERVER['PHP_SELF']."' method='post'>";
     echo '<fieldset>';
     //Part, Rev, Part Description, NCMR Qty
     echo '<div id="box1">';
     echo '<div id="ab"><span class="b">Added By:  </span><input type="text" name="ab" value="" /></div>';
     echo '<div id="date"><span class="b">Date Filed:  </span><input type="text" name="date" value="" /></div>';
     echo '<div id="part"><span class="b">Part Number:  </span><input type="text" name="part" value="" /></div>';
     echo '<div id="rev"><span class="b">Part Revision:  </span><input type="text" name="rev" value="" /></div>';
     echo '<div id="partdesc"><span class="b">Part Description:  </span><textarea name="partdesc" rows="3" cols="22" ></textarea></div>';
     echo '<div id="ncmrqty"><span class="b">NCMR Qty:  </span><input type="text" name="ncmrqty" value="" /></div>';
     echo '</div>';


    //Company, Customer NCMR, Internal RMA, and Job Number
     echo '<div id="box2">';
     echo'<div id="comp">';
     echo '<span class="b">Company:  </span>';
     $mysqli->select_db('comp');
     $result = $mysqli->query("SELECT * FROM comp");
     $i = 0;
     echo "<SELECT name='comp'>\n";
     while($row = $result->fetch_assoc()) {
     if ($i == 4) echo '<option value="lines">-----</option>';
     echo "<option value='{$row['user_id']}'>{$row['name']}</option>\n";
     $i++;
     }
     echo "</select>\n";
     echo '</div>';

     echo '<div id="ncmrid"><span class="b">Customer NCMR ID:  </span><input type="text" name="ncmrid" value="" /></div>';
     echo '<div id="rma"><span class="b">Internal RMA #:  </span><input type="text" name="rma" value="" /></div>';
     echo '<div id="jno"><span class="b">Job #:  </span><input type="text" name="jno" value="" /></div>';
     echo '</div>';


    //Type of Failure and Class of Failure
     echo '<div id="box3">';
     echo '<h2>Failure</h2>';
     echo '<div id="fdt">';
     echo '<span class="b">Failure Due To:  </span><br />';
     echo '<select name="fdt">';
     echo '<option value="none">----None----</option>';
     echo '<option value="In House">In House</option>';
     echo '<option value="Third Party">Third Party</option>';
     echo '</select>';
     echo '</div>';

     echo'<div id="cof">';
     echo '<span class="b">Class of Failu   </span><br />';
     echo '<select name="cof">';
     echo '<option value="none">----None----</option>';
     echo '<option value="Materials">Materials</option>';
     echo '<option value="Fabrication">Fabrication</option>';
     echo '<option value="Drawing">Drawing</option>';
     echo '<option value="Assembly">Assembly</option>';
     echo '<option value="Testing">Testing</option>';
     echo '<option value="Electrical">Electrical</option>';
     echo '<option value="Programming">Programming</option>';
     echo '<option value="Machining">Machining</option>';
     echo '<option value="Inspection">Inspection</option>';
     echo '<option value="Purchasing">Purchasing</option>';
     echo '<option value="Administrator">Administrator</option>';
     echo '</select>';
     echo '</div>';
     echo '</div>';

     //Fabricators
     echo '<div id="box4">';
     echo '<h2>Fabricators</h2>';
     echo'<div id="fab1">';
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user");
     echo "<SELECT name='fab1'>\n";
     while($row = $result->fetch_assoc()) {
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';

     echo'<div id="fab2">';
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user");
     echo "<SELECT name='fab2'>\n";
     while($row = $result->fetch_assoc()) {
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';

     echo'<div id="fab3">';
     $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);
     $mysqli->select_db('user');
     $result = $mysqli->query("SELECT * FROM user");
     echo "<SELECT name='fab3'>\n";
     while($row = $result->fetch_assoc()) {
     echo "<option value='{$row['user_id']}'>{$row['user']}</option>\n";}
     echo "</select>\n";
     echo '</div>';
     echo '</div>';

     //Nonconformity, Disposition, Comments and Comments & Additional Details
                echo '<div id="box5">';
     echo '<div id="non"><span class="b">Nonconformity:  </span><br /><textarea name="non" rows="3" cols="110" ></textarea><br /></div>';
     echo '<div id="dis"><span class="b">Disposition:  </span><br /><textarea name="dis" rows="3" cols="110" ></textarea></div>';
     echo '<div id="comm"><span class="b">Comments:  </span><br /><textarea name="comm" rows="3" cols="110" ></textarea></div>';
     echo '<div id="caad"><span class="b">Comments and/or Additional Details:  </span><br /><textarea name="caad" rows="3" cols="110" ></textarea></div>';
     //PO, PO Date, and Date Recieved
                echo '<div id="podr">';
     echo '<div id="po"><span class="b">PO:  </span><input type="text" name="po"  size="7" value="" /></div>';
     echo '<div id="pod"><span class="b">PO Date:  </span><input type="text" name="pod"  size="7" value="" /></div>';
     echo '<div id="dri"><span class="b">Date Received:  </span><input type="text" name="dri"  size="7" value=""';
     echo '</div>';
     echo '<div id="button"><input type="submit" value="Submit NCMR" name="submit" /></div>';
     echo '</div>';
     echo '</fieldset>';
    echo '</form>';
     }




    ?>
</body>
</html>

Php Pdf Form Showing "array" For Drop Down Menus

Similar Tutorials

View Content

Hello I have an issue with a form that has been built by someone else on Wordpress.

using contact form 7 plugin there's a for to fill out and it emails a PDF copy to the customer.

however on the pdf any information from dropdown selections shows "Array" instead of what was selected, everything looks fine to me (with my very minimal knowledge of PHP) the title & Preferred Payment Method: doesn't show on the pdf

here is the contact form 7 code.

<div class="steps">
    <div class="step gap-large step-1">
        <h2 class="step-title"><span class="gold">Step 1.</span> Calculate the value of your <span class="gold">gold</span></h2>
        [gold_calculator your-items]    
    </div>
    <div class="step gap-large step-2">
        <h2 class="step-title"><span class="gold">Step 2.</span> Submit your details</h2>
        <div class="row">
            <div class="column col-xs-12 col-sm-2 col-lg-4">
                <label class="required" for="sell-title">Title</label>
                [select* your-title id:sell-title class:form-control "Mr" "Mrs" "Miss" "Ms"]
            </div>
            <div class="column col-first-name col-xs-12 col-sm-5 col-lg-4">
                <label class="required" for="sell-first-name">First Name</label>
                [text* your-first-name id:sell-first-name class:form-control placeholder "Enter your first name"]
            </div>
            <div class="column col-last-name col-xs-12 col-sm-5 col-lg-4">
                <label class="required" for="sell-last-name">Last Name</label>
                [text* your-last-name id:sell-last-name class:form-control placeholder "Enter your last name"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-4">
                <label class="required" for="sell-email">Email Address</label>
                [email* your-email id:sell-email class:form-control placeholder "Enter your email address"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-daytime-phone">Daytime Telephone</label>
                [tel* your-daytime-phone id:sell-daytime-phone class:form-control placeholder "Enter your telephone number"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="" for="sell-mobile-phone">Mobile Telephone</label>
                [tel your-mobile-phone id:sell-mobile-phone class:form-control placeholder "Enter your mobile number"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-6">
                <label class="required" for="sell-address-1">Address Line 1</label>
                [text* your-address-1 id:sell-address-1 class:form-control placeholder "Enter your address"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-6">
                <label class="" for="sell-address-2">Address Line 2</label>
                [text your-address-2 id:sell-address-2 class:form-control placeholder "Enter your address"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-4">
                <label class="required" for="sell-city">Town/City</label>
                [text* your-city id:sell-city class:form-control placeholder "Enter your town/city"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-county">County</label>
                [text* your-county id:sell-county class:form-control placeholder "Enter your county"]
            </div>
            <div class="column col-xs-12 col-sm-6 col-lg-4">
                <label class="required" for="sell-postcode">Postcode</label>
                [text* your-postcode id:sell-postcode class:form-control placeholder "Enter your postcode"]
            </div>
            <div class="column col-xs-12 col-sm-12 col-lg-6">
                <label class="required" for="sell-method">Choose your method of payment</label>
                [select* your-method id:sell-method class:form-control "Instant Bank Transfer" "Cash" "Cheque"]
            </div>
            <div class="column col-xs-12 ccol-sm-12 col-lg-6">
                <div class="input-label required">Terms &amp; Conditions</div>
                [acceptance your-price-acceptance id:sell-price-acceptance]I accept the price offered above for my gold.[/acceptance]
                [acceptance your-terms-acceptance id:sell-terms-acceptance]I accept the <a href="/terms-conditions/" target="_blank">terms &amp; conditions</a>.[/acceptance]
                [acceptance your-acknowledgement id:sell-acknowledgement]I declare and acknowledge that: 1. I confirm the property enclosed is mine to sell, 2. I believe the items(s) to be genuine gold or platinum 3. You will contact me if the value calculated upon receipt differs in weight or carat 4. I accept payment will only be made to the person named on the submission form.[/acceptance]
            </div>
            <div class="column col-submit col-xs-12 col-sm-12">
                <div class="alert alert-info">After clicking the ‘Submit’ button below, we'll email you a form to print off and include with the package you send to us. If you wish to be paid by bank transfer, please write your bank details on the form once printed.</div>
                <div class="submit">[submit class:btn class:btn-gold "Submit"]</div>
            </div>
        </div>
    </div>
</div>

here is the pdf php form code.

<?php /** @var \Strive\Sections\Pdf_Form $this */ ?>
<head>
    <style>
        h1, h2 {
            margin-top: 0;
        }

        th, td {
            text-align: left;
            vertical-align: top;
        }

        .section {
            padding: 20px 0;
        }

        .border-top {
            border-top: solid 1px #E7E7E7;
        }

        .cut-top {
            border-top: dashed 1px #E7E7E7;
        }

        .text-placeholder {
            background-color: #F7F7F7;
        }

        .cut-note {
            text-align: center;
            font-size: 80%;
            margin-bottom: 5px;
        }
    </style>
</head>
<body>
<h1>Step 3. Print &amp; post this form with your gold</h1>
<div class="section quote border-top">
    <h2 class="section-title">Customer Quote:</h2>
    <div>
        <?php if ( $this->calculator['empty'] 😞 ?>
            <p>You didn't weigh your gold - don't worry, we'll do it for you and call you with an offer. </p>
        <?php else: ?>
            <ol>
                <?php foreach ( $this->calculator['items'] as $item 😞 ?>
                    <li><?php echo $item['weight']; ?>g of <?php echo $item['name']; ?> -
                        &pound;<?php echo $item['price']; ?></li>
                <?php endforeach; ?>
            </ol>
            <p>Total: &pound;<?php echo $this->calculator['total']; ?></p>
        <?php endif; ?>
    </div>
</div>
<div class="section details border-top">
    <h2 class="section-title">Customer Details:</h2>
    <table width="100%">
        <tr>
            <td width="50%">
                <table width="100%">
                    <tr>
                        <th>Reference:</th>
                        <td><?php echo $this->reference; ?></td>
                    </tr>
                    <tr>
                        <th>Name:</th>
                        <td></td><?php echo empty( $this->title ) ? '' : $this->title; ?>
                            <?php echo empty( $this->first_name ) ? '' : $this->first_name; ?>
                            <?php echo empty( $this->last_name ) ? '' : $this->last_name; ?></td>
                    </tr>
                    <tr>
                        <th>Email:</th>
                        <td><?php echo empty( $this->email ) ? '-' : $this->email; ?></td>
                    </tr>
                    <tr>
                        <th>Telephone:</th>
                        <td><?php echo empty( $this->daytime_phone ) ? '-' : $this->daytime_phone; ?></td>
                    </tr>
                    <tr>
                        <th>Mobile:</th>
                        <td><?php echo empty( $this->mobile_phone ) ? '-' : $this->mobile_phone; ?></td>
                    </tr>
                </table>
            </td>
            <td width="50%">
                <table width="100%">
                    <tr>
                        <th>Address 1:</th>
                        <td><?php echo empty( $this->address_1 ) ? '' : $this->address_1; ?></td>
                    </tr>
                    <tr>
                        <th>Address 2:</th>
                        <td><?php echo empty( $this->address_2 ) ? '' : $this->address_2; ?></td>
                    </tr>
                    <tr>
                        <th>Town/City:</th>
                        <td><?php echo empty( $this->city ) ? '' : $this->city; ?></td>
                    </tr>
                    <tr>
                        <th>County:</th>
                        <td><?php echo empty( $this->county ) ? '' : $this->county; ?></td>
                    </tr>
                    <tr>
                        <th>Postcode:</th>
                        <td><?php echo empty( $this->postcode ) ? '' : $this->postcode; ?></td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>
</div>
<div class="section payment border-top">
    <p>Preferred Payment Method: <?php echo empty( $this->method ) ? '' : $this->method; ?></p>
    <?php if ( $this->method === 'Instant Bank Transfer' 😞 ?>
        <p>Write down your bank details below for the account in which you wish funds to be deposited.</p>
        <table width="100%">
            <tr>
                <th width="25%">Bank:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Name on Account:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Sort Code:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
            <tr>
                <th>Account No:</th>
                <td width="75%" class="text-placeholder">&nbsp;</td>
            </tr>
        </table>
    <?php endif; ?>
</div>
<div class="cut-note">Print this form, include the above part in your package and post to the address below.</div>
<div class="section address cut-top">
    <p>
        SMG<br><br>
        <?php echo empty( $this->send_address ) ? '' : $this->send_address ?>
    </p>
</div>
</body>

View Content

I want to write a guessing game that gives a user four tries to guess a number between 1 and 10.
The problem is that every time the user hits submit, count is reset to zero and 1 is added. Please help.
Here is my code:

<html>
<head>
<title>Guessing Game </title>
</head>
<h1>Guessing Game </h1>
   <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
   <input type="hidden" name="count" value="<?php $count++; ?>" />
   <p><input type="text" name="guess" /></p>
   <p><input type="submit" value="Guess" /></p>
   </form>

</body>
</html>

<?php

   $random = rand(1,10);
   $guess = $_POST['guess'];

   if ($guess >= 10)
   {
      echo"Guess has to be lower than 10";
   }
   elseif (isset($guess) && ($guess <= 1))
   {
      echo "Guess has to be higher than 1";
   }
   else
   {

         if ($guess == $random)
         {
            echo "Congratulations. You Win!!!!";
            $count = 4;

         }
         elseif (isset($guess) && ($guess != $random))
         {
            echo "Try again";


            $count++;

         }
         elseif (($count == 4) && ($guess != $random))
         {
            echo "Game Over. You Lose!!!";
         }

      }


?>