I have a Select box that has an option to select Price Plan. When the price plan is selected, i want it to populate the PaymentAmount input box with the cost of that price plan.
The code i have so far,
HTML:
- <form name='dataForm' method='post' action='client.add.proc.php' id='DataForm'>
- <table width='500' border='0' cellpadding='0' cellspacing='0'>
- <tr>
- <td width='150'><label>Payment Date</label></td>
- <td width='350'>
- <input type='hidden' name='Stage_field' value='AddContract' />
- <input type='hidden' name='Back_field' value='no' />
- <input type='text' name='paymentdate_field' id='dtepaymentdate'></td>
- </tr><tr>
- <td><label>Contract Type</label></td>
- <td>";
- makeSelectBox('typeofcover_field', true, "SELECT * FROM tbltypeofcover ORDER BY sortOrder", 'typeOfCoverID', 'typeOfCover', $_SESSION["TypeOfCoverID"], 'typeOfCoverID');
- echo"
- </td>
- </tr><tr>
- <td><label>Payment Amount (£)</label></td>
- <td><input type='text' name='paymentamount_field' id='paymentamount_field' value='{$_SESSION["PaymentAmount"]}'></td>
- </tr><tr>
- <td><label>Contract Start</label></td>
- <td><input type='text' name='contractstart_field' id='dtecontractstart' value='{$_SESSION["ContractStart"]}'></td>
- </tr><tr>
- <td><label>Contract End</label></td>
- <td><input type='text' name='contractend_field' id='dtecontractend' value='{$_SESSION["ContractEnd"]}'></td>
- </tr><tr>
- <td> </td>
- <td>
- <button type='submit' class='back_id' name='Back_field' value='yes'>Back</button>
- <button type='submit' onClick=\"validateData();\">Next</button>
- </td>
- </tr>
- </table>
- </form>
JQUERY:
$(document).ready(function(){
$('#typeofcover_field').change(function() {
sendValue($(this).val());
})
});
- function sendValue(str){
- $.post("client.add.contract_json.php", { sendToValue: str },
-
- function(data){
- $('#display').html(data.returnFromValue);
- }, "json");
- }
PHP - client.add.contract_json.php:
- require_once('_include/maininclude.php');
- $TypeOfCoverID = $_POST['typeofcover_field'];
- $SQL = "SELECT * FROM tbltypeofcover WHERE typeOfCoverID = '$TypeOfCoverID'";
-
- $Result = mysql_query($SQL, $link) or die('Error, query failed<br>'.$SQL);
- $Row = mysql_num_rows($Result);
-
- $TypeOfCover = $row['typeOfCover'];
- $Cost = $row['Cost'];
- $LandlordPackage = $row['landlordPackage'];
- $arr = array('input#paymentamount_field' => $Cost);
- echo json_encode( $arr );
if i browse client.add.contract_json.php i get displayed: {"input#paymentamount_field":null}
I think i am close, but seem to be going around in circles...
Thanks,
D