soil-report-ai/post.php

<?php
//$modx_user = $modx->user->get('id');
$modx_user = 1;

$con = mysqli_connect("localhost", "cropmonitor", "brvnCcaEYxlPCS3", "cropmonitor");
// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$result = mysqli_query($con, "SELECT * FROM `client_records` Where `modx_user_id` = $modx_user ");
// mysqli_query returns false if something went wrong with the query

if ($result === FALSE) {
    die(mysqli_error($con)); // TODO: better error handling
} else {
?>
<div class='col-md-12 form-group'>
    <label for='client_id'>Current Client</label><?php
    //$modx_user = $modx->user->get('id');
    $modx_user = 1;

    $result = mysqli_query($con, "SELECT * FROM `client_records` Where `modx_user_id` = $modx_user ");

    // mysqli_query returns false if something went wrong with the query

    if ($result === FALSE) {
        die(mysqli_error($con)); // TODO: better error handling
    } else {
    ?>
    <div class='col-md-12 form-group'>
        <label for='client_id'>Current Client</label>
        <div><select name='client_id' id='client_id' class='form-control1' onChange='Choice();'>
            <option>Select current client or add new client below...</option>
            <?php
        while ($row=mysqli_fetch_array($result)){
            ?>
            <option value="<?php echo $row['id']; ?>" id="<?php echo $row['id']; ?>"><?php echo $row['id'] . " - " . $row['client'] . " - " . $row['company']; ?></option>
            <?php
        }
            ?>

            </select></div>
    </div>
    <?php
    }
    ?>



    <script type="text/javascript">
        <?php
    $index = 0;
    while ($row = mysqli_fetch_array($result))
    {
        ?>
        var email[<?php echo $index; ?>] = <?php echo $row['email']; ?>;
        var name[<?php echo $index; ?>] = <?php echo $row['name']; ?>;
        var company[<?php echo $index; ?>] = <?php echo $row['company']; ?>;
        var site_address[<?php echo $index; ?>] = <?php echo $row['site_address']; ?>;
        var state_postcode[<?php echo $index; ?>] = <?php echo $row['state_postcode']; ?>;
            <?php
        $index++;
    }
            ?>
    </script>

    <?php
    mysqli_close($con);
    ?>

    <script type="text/javascript">
        function Choice() {
            y = document.getElementById("client_id");

            document.getElementById("email").value = email[y.selectedIndex];
            document.getElementById("name").value = name[y.selectedIndex];
            document.getElementById("company").value = company[y.selectedIndex];
            document.getElementById("site_address").value = site_address[y.selectedIndex];
            document.getElementById("state_postcode").value = state_postcode[y.selectedIndex];
        }
    </script>

    <div class="col-md-6 form-group">
        <label for="email">Email address<span class="error">*</span></label>
        <input type="email" class="form-control" name="email" id="email" value="" required autocomplete="on">
    </div>
    <div class="col-md-6 form-group">
        <label for="client_name">Client Name<span class="error">*</span></label>
        <input type="text" class="form-control" name="name" id="name" value="" required autocomplete="on">
    </div>
    <div class="col-md-6 form-group">
        <label for="company_name">Company Name</label>
        <input type="text" class="form-control" name="company" id="company" value="" autocomplete="on">
    </div>
    <div class="col-md-6 form-group">
        <label for="site_address">Site Address</label>
        <input type="text" class="form-control" name="site_address" id="site_address" value="" autocomplete="on">
    </div>
    <div class="col-md-6 form-group">
        <label for="state_postcode">State & Postcode</label>
        <input type="text" class="form-control" name="state_postcode" id="state_postcode" value="" autocomplete="on">
    </div>
    <div><select name='client_id' id='client_id' class='form-control1' onChange='Choice();'>
        <option>Select current client or add new client below...</option>
        <?php
    while ($row=mysqli_fetch_array($result)){
        ?>
        <option value="<?php echo $row['id']; ?>" id="<?php echo $row['id']; ?>"><?php echo $row['id'] . " - " . $row['client'] . " - " . $row['company']; ?></option>
        <?php
    }
        ?>

        </select></div>
</div>
<?php
}
?>
<script type="text/javascript">
    <?php
    $index = 0;
    while ($row = mysqli_fetch_array($result))
    {
    ?>
    var email[<?php echo $index; ?>] = <?php echo $row['email']; ?>;
    var name[<?php echo $index; ?>] = <?php echo $row['name']; ?>;
    var company[<?php echo $index; ?>] = <?php echo $row['company']; ?>;
    var site_address[<?php echo $index; ?>] = <?php echo $row['site_address']; ?>;
    var state_postcode[<?php echo $index; ?>] = <?php echo $row['state_postcode']; ?>;
        <?php
        $index++;
    }
        ?>
</script>

<?php
mysqli_close($con);
?>

<script type="text/javascript">
    function Choice() {
        y = document.getElementById("client_id");

        document.getElementById("email").value = email[y.selectedIndex];
        document.getElementById("name").value = name[y.selectedIndex];
        document.getElementById("company").value = company[y.selectedIndex];
        document.getElementById("site_address").value = site_address[y.selectedIndex];
        document.getElementById("state_postcode").value = state_postcode[y.selectedIndex];
    }
</script>

<div class="col-md-6 form-group">
    <label for="email">Email address<span class="error">*</span></label>
    <input type="email" class="form-control" name="email" id="email" value="" required autocomplete="on">
</div>
<div class="col-md-6 form-group">
    <label for="client_name">Client Name<span class="error">*</span></label>
    <input type="text" class="form-control" name="name" id="name" value="" required autocomplete="on">
</div>
<div class="col-md-6 form-group">
    <label for="company_name">Company Name</label>
    <input type="text" class="form-control" name="company" id="company" value="" autocomplete="on">
</div>
<div class="col-md-6 form-group">
    <label for="site_address">Site Address</label>
    <input type="text" class="form-control" name="site_address" id="site_address" value="" autocomplete="on">
</div>
<div class="col-md-6 form-group">
    <label for="state_postcode">State & Postcode</label>
    <input type="text" class="form-control" name="state_postcode" id="state_postcode" value="" autocomplete="on">
</div>