Search jQuery

jQuery Forum

jQuery, AJAX and JSON

in Getting Started • 12 years ago

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,

Replies(2)

speedpack..

Hi,

this seems to be a PHP issue rather than a jQuery / ajax issue.
If you just go to the page, it is very likely to return NULL as you don't pass a long the typeofcover_field attribute. I would debug the PHP really, as that is what is causing the print of the null value in the ajax string ;)

---
http://www.flexin.be

danian

Re: Re: jQuery, AJAX and JSON

12 years ago

Speedpacket.gma,

Thanks for your reply,

I took you advice and tried the php code which did have a minor error. However still was not populating the input#paymentamount_field field. The correct php code is:

require_once('_include/maininclude.php');
$TypeOfCoverID = $_POST['typeofcover_field'];
$SQL = "SELECT * FROM tbltypeofcover WHERE typeOfCoverID = '$TypeOfCoverID'";
$Result = mysql_query($SQL) or die("Client Details not fetched: ".mysql_error()."<br>SQL:$SQL");
$Row = mysql_fetch_array($Result);
$TypeOfCover = $Row['typeOfCover'];
$Cost = $Row['Cost'];
$LandlordPackage = $Row['landlordPackage'];
$arr = array('input#paymentamount_field' => $Cost);
echo json_encode( $arr );

To test this code i browsed to the file client.add.contract_json.php and got the result: {"input#paymentamount_field":null},

so i decided to change the SQL to $SQL = "SELECT * FROM tbltypeofcover WHERE typeOfCoverID = '5'"; and got a result of {"input#paymentamount_field":"180.00"}

which is correct, but still not populating the input#paymentamount_field...

So i seem to have 2 problems, first of all the query is not being populated with the typeofcover_field, and secondly the result is not being passed back to the input#paymentamount_field...

Thanks again...

Top Reply

Response title

Attachments

jQuery Forum

jQuery, AJAX and JSON

Replies(2)

Re: jQuery, AJAX and JSON

Re: Re: jQuery, AJAX and JSON

Statistics

Tags

Actions

Related Posts