I'm trying to update specific fields in my form after fetching data from a database using AJAX and JSON.
Here is the code snippet:
In my form:
<div class="form">
<?php $form=$this->beginWidget('CActiveForm', array(
'id'=>'anagrafica-form',
// Note: Ensure your controller action handles ajax validation correctly when enabling it.
// You can refer to CActiveForm class documentation for more details.
'enableAjaxValidation'=>false,
)); ?>
<p class="note">Fields with <span class="required">*</span> are required.</p>
<?php echo $form->errorSummary($model); ?>
<div class="row">
<?php echo $form->labelEx($model,'codicefiscale'); ?>
<?php echo $form->textField($model,'codicefiscale',array('size'=>20,'maxlength'=>16)); ?>
<?php echo $form->error($model,'codicefiscale'); ?>
<div id="bottone_ricerca" style="display:inline;">
<?php
echo CHtml::ajaxButton( 'Ricerca',
$this->createUrl('anagrafica/popolaAnagrafica'),
array(
'type' => 'POST',
'datatype' => 'json',
'data' => array('codfisc' => 'js:$(\'#AnagraficaForm_codicefiscale\').val()'),
'success' => 'function(response){
$("#cand").html(response);
$("#'.CHTML::activeId($model,'cognome').'").val(response.cognome);
$("#'.CHTML::activeId($model,'nome').'").val(response.nome);
$("#'.CHTML::activeId($model,'email').'").val(response.email);
}'
),
array()
);
?>
</div>
<div id="cand">
</div>
</div>
<div class="row">
<?php echo $form->labelEx($model,'cognome'); ?>
<?php echo $form->textField($model,'cognome',array('size'=>35,'maxlength'=>30)); ?>
<?php echo $form->error($model,'cognome'); ?>
</div>
<!-- Other form fields go here -->
<?php $this->endWidget(); ?>
</div><!-- form -->
In my controller:
public function actionPopolaAnagrafica()
{
$codfisc = Yii::app()->request->getParam('codfisc');
echo $codfisc;
if (Yii::app()->request->isAjaxRequest) {
if ($codfisc == '') {
echo CJSON::encode(array(
'error' => 'true',
'status' => 'Invalid request.'
));
Yii::app()->end();
} else {
$sql = "SELECT * FROM user WHERE username = '".$codfisc . "'";
$cmd = Yii::app()->db->createCommand($sql);
$result = $cmd->queryRow();
if($result) {
echo CJSON::encode(array(
'error' => 'false',
'status' => 'Existing Codice Fiscale',
'username' => $result['username'],
'cognome' => $result['cognome'],
'nome' => $result['nome'],
'email' => $result['email']
)
);
Yii::app()->end();
} else {
echo CJSON::encode(array(
'error' => 'true',
'status' => 'The codice fiscale ' . $codfisc . ' does not exist.'
));
Yii::app()->end();
}
}
}
The issue is that I am unable to update the fields. The response received is:
xxxyyyddxdd{"error":"false","status":"Codice Fiscale esistente","cognome":"Cognome","nome":"Nome","email":"[email protected]"}
However, the expected response should be:
{"error":"false","status":"Existing Codice Fiscale", "username":"xxxyyyddxdd","cognome":"Cognome","nome":"Nome","email":"[email protected]"}
Where did I go wrong?
Appreciate any assistance. Thank you.