i have a form that posts info to the ajax page to insert into the db.
But for some reason it's not working.
add_company.php
<?php include_once 'head.php'; ?>
<script type="text/javascript">
$(document).ready(function(){
$("input#same").click(function(){
if ($("input#same").is(':checked')) {
// Checked, copy values
$("input#company_postal_address").val($("input#company_street_address").val());
$("input#company_postal_suburb").val($("input#company_street_suburb").val());
$("input#company_postal_state").val($("input#company_street_state").val());
$("input#company_postal_postcode").val($("input#company_street_postcode").val());
} else {
// Clear on uncheck
$("input#company_postal_address").val("");
$("input#company_postal_suburb").val("");
$("input#company_postal_state").val("");
$("input#company_postal_postcode").val("");
}
});
});
$(document).ready(function() {
$('#errorConsole').hide();
$('form[name=companyDetails]').submit(function() {
$('#errorConsole').slideUp();
$.post('http://192.168.5.2/_intelara_2010/ajax.php', {
company_parent_id: $('[name=company_parent_id]').val(),
company_name: $('[name=company_name]').val(),
company_street_address: $('[name=company_street_address]').val(),
company_street_suburb: $('[name=company_street_suburb]').val(),
company_street_state: $('[name=company_street_state]').val(),
company_street_postcode: $('[name=company_street_postcode]').val(),
company_postal_address: $('[name=company_postal_address]').val(),
company_postal_suburb: $('[name=company_postal_suburb]').val(),
company_postal_state: $('[name=company_postal_state]').val(),
company_postal_postcode: $('[name=company_postal_postcode]').val(),
company_phone: $('[name=company_phone]').val(),
company_fax: $('[name=company_fax]').val(),
company_email: $('[name=company_email]').val(),
company_web: $('[name=company_web]').val(),
company_type: $('[name=company_type]').val(),
company_industry: $('[name=company_industry]').val(),
company_account_manager: $('[name=company_account_manager]').val(),
company_account_office: $('[name=company_account_office]').val(),
company_priority: $('[name=company_priority]').val()},
function(data) {
if(data.success){
$('#errorConsole').html(data.message).slideDown();
alert(data.record_id);
}else{
$('#errorConsole').html(data.message).slideDown();
}
}, 'json');
return false;
});
});
</script>
<div id="wrapper">
<div class="spacer"></div>
<table class="tblBKG" width="100%" border="0" cellspacing="0" cellpadding="0">
<tbody>
<tr>
<td width="100%" style="padding:10px 20px;">
<div id="content">
<h1>Add Contacts.</h1>
<div class="break"></div>
<div id="errorConsole"></div>
<div id="contact_form">
<form name="companyDetails" action="<?php $_SERVER['PHP_SELF']; ?>" method="POST">
<fieldset>
<legend>Company Details:</legend>
<label for="company_name">Company Name:</label>
<input type="text" name="company_name" id="company_name" class="medium" /><br />
<div id="con_wrapper">
<div id="con_left">
<label for="company_account_manager">Account Manager:</label>
<input type="text" name="company_account_manager" id="company_account_manager" class="tiny" /><br />
</div>
<div id="con_right">
<label for="company_account_office">Account Office:</label>
<select name="company_account_office" class="tinySelect">
<option value="" selected>-- Select One --</option>
<option value="Brisbane">Brisbane</option>
<option value="Toowoomba">Toowoomba</option>
</select>
</div>
</div>
<span class="clear" />
<label for="company_priority">Priority:</label>
<input type="text" name="company_priority" id="company_priority" class="micro" /><br />
<label for="company_parent_id">Parent:</label>
<input type="text" name="company_parent_id" id="company_parent_id" class="micro" /><br />
<div id="con_wrapper">
<div id="con_left">
<label for="company_street_address">Street Address:</label>
<input type="text" name="company_street_address" id="company_street_address" class="tiny" /><br />
<label for="company_street_suburb">Suburb / City:</label>
<input type="text" name="company_street_suburb" id="company_street_suburb" class="tiny" /><br />
<label for="company_street_state">State:</label>
<input type="text" name="company_street_state" id="company_street_state" class="tiny" /><br />
<label for="company_street_postcode">Postcode:</label>
<input type="text" name="company_street_postcode" id="company_street_postcode" class="tiny" /><br />
</div>
<div id="con_right">
<label for="company_postal_address">Postal Address:</label>
<input type="text" name="company_postal_address" id="company_postal_address" class="tiny" /><br />
<label for="company_postal_suburb">Suburb / City:</label>
<input type="text" name="company_postal_suburb" id="company_postal_suburb" class="tiny" /><br />
<label for="company_postal_state">State:</label>
<input type="text" name="company_postal_state" id="company_postal_state" class="tiny" /><br />
<label for="company_postal_postcode">Postcode:</label>
<input type="text" name="company_postal_postcode" id="company_postal_postcode" class="tiny" /><br />
<input id="same" name="same" type="checkbox" /> Copy Street Address.<br />
</div>
</div>
<span class="clear" />
<div id="con_wrapper">
<div id="con_left">
<label for="company_phone">Phone:</label>
<input type="text" name="company_phone" id="company_phone" class="tiny" />
</div>
<div id="con_right">
<label for="company_fax">Fax:</label>
<input type="text" name="company_fax" id="company_fax" class="tiny" />
</div>
</div>
<span class="clear" />
<div id="con_wrapper">
<div id="con_left">
<label for="company_email">Email:</label>
<input type="text" name="company_email" id="company_email" class="tiny" />
</div>
<div id="con_right">
<label for="company_web">Web:</label>
<input type="text" name="company_web" id="company_web" class="tiny" />
</div>
</div>
<span class="clear" />
<div id="con_wrapper">
<div id="con_left">
<label for="company_type">Type:</label>
<select name="company_type" class="tinySelect">
<option value="" selected>-- Select One --</option>
<option value="client">Client</option>
<option value="supplier">Supplier</option>
</select>
</div>
<div id="con_right">
<label for="company_industry">Industry:</label>
<select name="company_industry" class="tinySelect">
<option value="" selected>-- Select One --</option>
<?php echo $net->get_industry_codes(); ?>
</select>
</div>
</div>
<span class="clear" /><br />
<input type="submit" name="submit" value="submit" />
</fieldset>
</form>
<br />
<form name="contactDetails" action="#" method="POST">
<fieldset>
<legend>Contacts Details:</legend>
Name: <input type="text" size="30" /><br />
Email: <input type="text" size="30" /><br />
Date of birth: <input type="text" size="10" />
</fieldset>
</form>
</div>
</div>
</td>
</tr>
</tbody>
</table>
<?php include "footer.php"; ?>
ajax.php
<?php
session_start();
// Setup Our Connection Vars
include 'connect_db.php';
if($_POST){
$company_parent_id = $POST_['company_parent_id'];
$company_name = $POST_['company_name'];
$company_street_address = $POST_['company_street_address'];
$company_street_suburb = $POST_['company_street_suburb'];
$company_street_state= $POST_['company_street_state'];
$company_street_postcode = $POST_['company_street_postcode'];
$company_postal_address = $POST_['company_postal_address'];
$company_postal_suburb = $POST_['company_postal_suburb'];
$company_postal_state = $POST_['company_postal_state'];
$company_postal_postcode = $POST_['company_postal_postcode'];
$company_phone = $POST_['company_phone'];
$company_fax = $POST_['company_fax'];
$company_email = $POST_['company_email'];
$company_web = $POST_['company_web'];
$company_type = $POST_['company_type'];
$company_industry = $POST_['company_industry'];
$company_account_manager = $POST_['company_account_manager'];
$company_account_office = $POST_['company_account_office'];
$company_priority = $POST_['company_priority'];
$company_date_time = date("Y-m-d");
print_r($_POST);
print_r($company_parent_id .' '. $company_name);
$query = "INSERT INTO tbl_companies (company_id,company_parent_id,company_name,company_street_address,company_street_suburb,company_street_state,company_street_postcode,company_postal_address,company_postal_suburb,company_postal_state,company_postal_postcode,company_phone,company_fax,company_email,company_web,company_type,company_industry,company_account_manager,company_account_office,company_priority,company_date_time) VALUES(NULL, '$company_parent_id','$company_name','$company_street_address','$company_street_suburb','$company_street_state','$company_street_postcode','$company_postal_address','$company_postal_suburb','$company_postal_state','$company_postal_postcode','$company_phone','$company_fax','$company_email','$company_web','$company_type','$company_industry','$company_account_manager','$company_account_office','$company_priority','$company_date_time')";
$result = mysql_query($query) or die("add Company fatal error: ".mysql_error());
if($result){
$data['success'] = true;
$data['record_id'] = mysql_insert_id();
$data['message'] = "Record successfully inserted!";
}else{
$data['success'] = false;
$data['message'] = "Record failed inserted!";
}
echo json_encode($data);
}
?>
