Auto updating form text fields

englishder · December 6, 2014

Here goes.

I am trying to retrieve info. from mySql database and update 3 textfields.

I also have 4 selects on the form that need populating during the running of the program. My problem is using console I can see the info - Customer name - but it does not appear in the text field. The onchange request in the DIV container seems to be where it fails. Here are the files I am using:

1. add_an_order.php

<html>
<head>

<title>Add an Order</title>

<link href = "css/style.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="include/jquery-1.11.1.min.js"></script>

</head>

<body>

<div id="header"><img src="images/logo.png" /></div>

<div id="nav">

    <div id="nav_wrapper">
        <ul>
            <li><a href="index.php">Orders</a></li><li>
            <a href="customers.php">Customers</a></li><li>
            <a href="contacts.php">Contacts</a></li><li>
            <a href="batteries.php">Batteries</a></li><li>
            <a href="#">Queries</a>
            </li>
        </ul>
    </div>

</div>

<div id="main">

<?php

echo '<h3 id="menOpt">Add an Order</h3><hr>';

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

    $errors = array();

    $required_fields = array('customer_name', 'customer_address', 'city', 'telephone');
    foreach ($required_fields as $fieldname) {
        if (!isset($_POST[$fieldname]) || empty($_POST[$fieldname])) {
            $errors[] = strtoupper($fieldname);
        }
    }

    if (empty($errors)) {

        include ('include/dbconnect.php');

        $name = mysqli_real_escape_string($con, trim(strip_tags($_POST['customer_name'])));
        $contact = mysqli_real_escape_string($con, trim(strip_tags($_POST['contact'])));
        $address = mysqli_real_escape_string($con, trim(strip_tags($_POST['customer_address'])));
        $city = mysqli_real_escape_string($con, trim(strip_tags($_POST['city'])));
        $telephone = mysqli_real_escape_string($con, trim(strip_tags($_POST['telephone'])));
        $telephone = preg_replace('/[^0-9]/', '', $telephone);

        if (isset($_POST['deepc'])) {
            $deepc = 1;
        } else {
            $deepc = 0;
        }

        if (isset($_POST['problemc'])) {
            $problemc = 1;
        } else {
            $problemc = 0;
        }

        $problem = mysqli_real_escape_string($con, trim(strip_tags($_POST['problem'])));

        if (isset($_POST['blacklist'])) {
            $blacklist = 1;
        } else {
            $blacklist = 0;
        }

        if (isset($_POST['pickup'])) {
            $pickup = 1;
        } else {
            $pickup = 0;
        }


        $query = "INSERT INTO customers (
                    customer_name, contact, customer_address, city, telephone, deep_cycle,
                    problem_customer, problem, blacklist, pickup)
                  VALUES ('$name', '$contact', '$address', '$city', '$telephone', $deepc,
                    $problemc, '$problem', $blacklist, $pickup)";

        $r = mysqli_query($con, $query);

        if (mysqli_affected_rows($con) == 1) {

            echo '<p class="success">Customer has been successfully added.</p>';

        } else {

            $message = "Could not add customer.";
            $message .= "<br />" . mysqli_error($con);

        }

        mysqli_close($con);

    } else { // We have errors.

        $message = count($errors) . " error(s) on the form.";

    }

} // End: if ($_SERVER['REQUEST_METHOD'] == 'POST').

*/

// Leave PHP and display the form.
?>

<?php if (!empty($message)) {
    echo '<p class="error">' . $message . '</p>';
} ?>
<?php
// Output list of fields that have errors.
if (!empty($errors)) {
    echo '<p class="error">';
    foreach ($errors as $error) {
        echo $error . '<br />';
    }
    echo '</p>';
}

?>

<div class="container">
    <form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
        <fieldset>
            <label>Business: <span class="important"> *</span><select name="customer_name" id="customer_name" onchange="request_fill(this.value)"
                value="<?php if (isset($_POST['customer_name'])) echo $_POST['customer_name']; ?>" ></select></label>
            <label>Address: <input type="text" name="address" id="add_a"
                value="<?php if (isset($_POST['customer_address'])) echo $_POST['customer_address']; ?>" /></label>
            <label>City: <input type="text" name="city" id="city"
                value="<?php if (isset($_POST['city'])) echo $_POST['city']; ?>" /></label>
            <label>Phone: <input type="text" name="telephone"
                value="<?php if (isset($_POST['telephone'])) echo $_POST['telephone']; ?>" /></label>

            <label>Manufacturer: <span class="important"> *</span><select name="manufacturer" id="manufacturer" onchange="request_mod(this.value)"
                value="<?php if (isset($_POST['manufacturer'])) echo $_POST['manufacturer']; ?>" ></select></label>

            <label>Model: <span class="important"> *</span><select name="model" id="model" onchange="form_yr(this.value)"
                value="<?php if (isset($_POST['model'])) echo $_POST['model']; ?>" ></select></label>

            <label>Year: <span class="important"> *</span><select name="battery" id="bat_disp"
                value="<?php if (isset($_POST['battery'])) echo $_POST['year'] ?>" ></select></label>

            <label>Quantity: <span class="important"> *</span><input type="text" name="quantity" id="quantity"
                value="<?php if (isset($_POST['quantity'])) echo $_POST['quantity']; ?>" /></label>
            <label>Warranty ? <input type="checkbox" name="warranty"
                <?php if ($_POST['warranty']) echo " checked"; ?> /></label>
            <label>Exchange ? <input type="checkbox" name="exchange"
                <?php if ($_POST['exchange']) echo " checked"; ?> /></label>
            <input type="submit" name="submit" value="Add Order" /> or
                    <a href="index.php">Cancel</a>
        </fieldset>
    </form>
</div>

<script type="text/javascript" src="include/functions.js"></script>

<script>
$(document).ready(function() {

    $('.container').hide();
    $('.container').fadeIn(1000);

    request_cust();
    request_man();

});
</script>

<?php include ('include/footer.php');

2. request_fill

3. battery_parser.php

<?php

include_once("include/dbconnect.php");

if (isset($_POST['cust2'])) {
       $cust2 = $_POST['cust2'];
       $sql = "SELECT customer_address FROM customers WHERE customer_id = 2";
       $query = mysqli_query($con, $sql);
       $dataString = '';
       while($row = mysqli_fetch_array($query, MYSQLI_ASSOC)){
           $add = $row["customer_address"];
           $dataString = $add;
       }
       mysqli_close($con);

       echo $dataString;
       exit();

   } else {
       exit();
   }

?>

Sign In

Auto updating form text fields

Recommended Posts

englishder

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information