Here’s the entire code.
Its awfully messy as I’ve not yet tidied it up. Hope you can make sense of it:
[php]<?php
$hostname_db_main = “localhost”;
$username_db_main = “tmsonlin_main”;
$password_db_main = “**************”;
$database_db_main = “tmsonlin_main”;
$dbconn = mysqli_connect($hostname_db_main,$username_db_main,$password_db_main,$database_db_main) or die ('ERROR: Could not connect to database!');
$connection = $dbconn;
if (isset($_POST[‘submitted’])) {
include(‘Connections/db_main.php’);
// SET UP POST DATA VARIABLES
$clientid = htmlentities($_POST[‘clientid’]);
mysqli_real_escape_string($dbconn, $clientid);
$fname = htmlentities($_POST[‘fname’]);
mysqli_real_escape_string($dbconn, $fname);
$sname = htmlentities($_POST[‘sname’]);
mysqli_real_escape_string($dbconn, $sname);
$company = htmlentities($_POST[‘company’]);
mysqli_real_escape_string($dbconn, $company);
$address1 = htmlentities($_POST[‘address1’]);
mysqli_real_escape_string($dbconn, $address1);
$address2 = htmlentities($_POST[‘address2’]);
mysqli_real_escape_string($dbconn, $address2);
$town = htmlentities($_POST[‘town’]);
mysqli_real_escape_string($dbconn, $town);
$county = htmlentities($_POST[‘county’]);
mysqli_real_escape_string($dbconn, $county);
$pcode = htmlentities($_POST[‘pcode’]);
mysqli_real_escape_string($dbconn, $pcode);
$telno = htmlentities($_POST[‘telno’]);
mysqli_real_escape_string($dbconn, $telno);
$email = htmlentities($_POST[‘email’]);
mysqli_real_escape_string($dbconn, $email);
//CREATE SQL PREPARED STATEMENT
$mysqli = new mysqli('localhost','tmsonlin_main','moosh!man!000','tmsonlin_main');
$stmt = $mysqli->stmt_init();
if (!stmt) {
echo "Init Failed: Error Code L22";
} else {
$insert="INSERT INTO clients (clientid, fname, sname, company, address1, address2, town, county, pcode, telno, email)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ";
if ($stmt->prepare($insert)) {
$stmt->bind_param('issssssssss', $clientid, $fname, $sname, $company, $address1, $address2, $town, $county, $pcode, $telno, $email);
$stmt->execute();
$stmt->close();
echo "Customer Added To Database";
} else {
echo "PREPARE FAILED";
}
}
$mysqli->close();
}
?>
Theatre Management System | Clients
ADD NEW CLIENT**
<div class="row">
<div class="col-lg-12">
<div class="col-lg-2"><label class="label">Surname :</label></div>
<div class="col-lg-6"><input type="text" id="sname" name="sname" class="form-control" ></input></div>
</div>
</div>
<p></p>
<div class="row">
<div class="col-lg-12">
<div class="col-lg-2"><label class="label">Company Name :</label></div>
<div class="col-lg-6"><input type="text" name="company" id="company" class="form-control" ></input></div>
</div>
</div>
<p></p>
<div class="row">
<div class="col-lg-12">
<div class="col-lg-2"><label class="label">Address 1 :</label></div>
<div class="col-lg-10"><input type="text" name="address1" id="address1" class="form-control" ></input></div>
</div>
</div>
<p></p>
<div class="row">
<div class="col-lg-12">
<div class="col-lg-2"><label class="label">Address 2 :</label></div>
<div class="col-lg-10"><input type="text" name="address2" id="address2" class="form-control" ></input></div>
</div>
</div>
<p></p>
<div class="row">
<div class="col-lg-12">
<div class="col-lg-2"><label class="label">Town / City :</label></div>
<div class="col-lg-3"><input type="text" name="town" id="town" class="form-control" ></input></div>
</div>
</div>
<p></p>
<div class="row">
<div class="col-lg-12">
<div class="col-lg-2"><label class="label">County :</label></div>
<div class="col-lg-3"><input type="text" name="county" id="county" class="form-control" ></input></div>
</div>
</div>
<p></p>
<div class="row">
<div class="col-lg-12">
<div class="col-lg-2"><label class="label">Post Code :</label></div>
<div class="col-lg-3"><input type="text" name="pcode" id="pcode" class="form-control" ></input></div>
</div>
</div>
<p></p>
<div class="row">
<div class="col-lg-12">
<div class="col-lg-2"><label class="label">Contact Number :</label></div>
<div class="col-lg-3"><input type="text" name="telno" id="telno" class="form-control" ></input></div>
</div>
</div>
<p></p>
<div class="row">
<div class="col-lg-12">
<div class="col-lg-2"><label class="label">Email Address :</label></div>
<div class="col-lg-10"><input type="email" name="email" id="email" class="form-control" required ></input></div>
</div>
</div>
<p></p>
<div class="row">
<div class="col-lg-12">
<div class="col-lg-2"></div>
<div class="col-lg-2"> <input type="submit" value="Add New Client" class="btn btn-success form-control"></input></input></div>
</div>
</div>
<input type="hidden" name="clientid" value="" />
</form></p>
</div>
</div>
</div>
</div>
<div class="content">
<p>
<?php
// DISPLAY RECORD INSERTION CONFIRMATION
?>
</p>
</div>
<div id="footer">
<div class="left">
<div class="right">
<div class="footerlink">
<p class="lf">Copyright © 2015 Carl Young <a href="#">Theatre Management System</a> - All Rights Reserved</p>
<p class="rf">Version: Beta 1.0.1</p>
<div style="clear:both;"></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<script type="text/javascript"> Cufon.now();</script>
<!-- END PAGE SOURCE -->
</body>
[/php]
