soil-report-ai/newClientDetails.php

<script type="text/javascript">
    $(function(){

        $('#email').click(function(){
            $('#newClient').modal('show');
            return false;
        })

    });
</script>

<!-- Modal -->
<div class="modal fade" id="newClient" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true" style="display: block;">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                <h2 class="modal-title">Add New Client</h2>
            </div>
            <div class="modal-body">
                <form method="post" action="" id="newClientDetails" >

                    <input type="hidden" class="form-control" name="m_user" id="m_user" value="1" required>
                    <input type="hidden" class="form-control" name="modx_user_attributes" id="modx_user_attributes" value="1" required>

                    <div class="form-group">
                        <label for="name">Name:</label>
                        <input type="text" class="form-control" name="Nname" placeholder="Client Name" id="Nname" required >
                    </div>
                    <div class="form-group">
                        <label for="company">Company:</label>
                        <input type="text" class="form-control" name="Ncompany" placeholder="Company Name" id="Ncompany"  >
                    </div>
                    <div class="form-group">
                        <label for="email">Email address</label>
                        <input type="email" class="form-control" name="Nemail" placeholder="Email address" required id="Nemail"  >
                    </div>
                    <div class="form-group">
                        <label for="email">Mobile Number</label>
                        <input type="text" class="form-control" name="Nmobile" placeholder="" id="Nmobile"  >
                    </div>
                    <div class="form-group">
                        <label for="email">Phone Number</label>
                        <input type="text" class="form-control" name="Nphone" placeholder="" id="Nphone" value="[[+Nphone]]" >
                    </div>
                    <div class="form-group">
                        <label for="email">Fax Number</label>
                        <input type="text" class="form-control" name="Nfax" placeholder="" id="Nfax" >
                    </div>
                    <hr>
                    <div class="form-group">
                        <label for="address">Address:</label>
                        <input type="text" class="form-control" name="Naddress" placeholder="Address" required id="Naddress"  >
                    </div>
                    <div class="form-group">
                        <label for="state">Town / State:</label>
                        <input type="text" class="form-control" name="Nstate" placeholder="Town, State, Postcode" required id="Nstate"  >
                    </div>
                </form>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
                <button form="newClientDetails" class="btn btn-primary" type="Nsubmit" name="NCsubmit" value="NCsubmit">Save changes</button>
            </div>
        </div><!-- /.modal-content -->
    </div><!-- /.modal-dialog -->
</div>

<?php
error_reporting(E_ALL);
ini_set('display_errors', 1);

$sql = null;
$con = mysqli_connect("localhost", "root", "R3M0T31", "cropmonitor");


//Get figures
if(isset($_POST['NCsubmit'])){ //check if form was submitted
    $modx_id = (isset($_POST["m_user"])) ? $_POST["m_user"] : "";
    $modx_user_attributes = (isset($_POST["modx_user_attributes"])) ? $_POST["modx_user_attributes"] : "";
    $company = (isset($_POST["Ncompany"])) ? $_POST["Ncompany"] : "";
    $client = (isset($_POST["Nname"])) ? $_POST["Nname"] : "";
    $address = (isset($_POST["Naddress"])) ? $_POST["Naddress"] : "";
    $postcode = (isset($_POST["Nstate"])) ? $_POST["Nstate"] : "";
    $email = (isset($_POST["Nemail"])) ? $_POST["Nemail"] : "";
    $mobile = (isset($_POST["Nmobile"])) ? $_POST["Nmobile"] : "";
    $phone = (isset($_POST["Nmobile"])) ? $_POST["Nmobile"] : "";
    $fax = (isset($_POST["Nfax"])) ? $_POST["Nfax"] : "";


    // Check connection
    if (mysqli_connect_errno())
    {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }

    $sql = mysqli_query($con, "INSERT into `client_records`
            (
                modx_user_id,
                modx_user_attributes,
                company,
                client,
                address,
                state_postcode,
                email,
                phone,
                mobile,
                fax
            ) VALUES (
                '" . $modx_id . "',
                '" . $modx_user_attributes . "',
                '" . $company . "',
                '" . $client . "',
                '" . $address . "',
                '" . $postcode . "',
                '" . $email . "',
                '" . $phone . "',
                '" . $mobile . "',
                '" . $fax . "'
            )" );

    if ($sql === TRUE)
    {
        echo "<div class='form-group has-success'><input type='text' class='form-control1' id='inputSuccess1'>Success!</div>";
        echo "<button type='button' class='btn btn-default' data-dismiss='modal'>Close</button>";
    } else {
        die(mysqli_error($con)); // TODO: better error handling
        echo "<div class='form-group has-error'><input type='text' class='form-control1' id='inputError1'>Error</div>";
    }
}
?>