Please help me if you know.
(Why cannot delete item)
I have page view loop data from database.
This code in view.php and one function for delete.
<script>
function Mdelete(it)
{
var vouc="<?php echo $modelheader->ZVOUCHER; ?>";
$.post('<?php echo Yii::app()->createAbsoluteUrl("expense/deletedetail"); ?>',{id:vouc,it:it});
}
</script>
<table>
<tr><?php $myitem = "";
$it="";
foreach($query as $data) {
if($data["ZVOUCHER"]==$modelheader->ZVOUCHER){?>
<td><?php echo $data["ZITEM"] ?></td>
<td><?php echo $data["ZEXP_DATE"] ?></td>
<td><?php echo $data["ZEXP_CAT"] ?></td>
<td><?php echo $data["ZEXP_TEXT"] ?> </td>
<td><?php echo $data["ZREC_AMT"] ?> </td>
<td><?php echo $data["ZTRAN_CURR"] ?> </td>
<td><?php echo $data["ZEXC_RATE"] ?> </td>
<td><?php echo $data["ZAMOUNT"] ?> </td>
<td>
<a href="javascript:Mdelete(<?php echo $it=$data["ZITEM"];?>)">Remove</a></td> </tr><?php }} ?>
</table>
This page expenseController
Code in page expenseController.php
public function actionDeletedetail()
{
$it = $_REQUEST['it'];
$id = $_REQUEST['id'];
$modeldetail = new ZfiExpenseDetail();
$sql='DELETE FROM zfi_expense_detail WHERE ZVOUCHER=:ZVOUCHER AND ZITEM=:ZITEM' ;
$params = array("ZVOUCHER" => $id,
"ZITEM" => $it
);
$command = Yii::app()->db->createCommand();
$command->setText($sql)->execute($params);
$command->execute();
}
Why cannot delete item that i click. Please you help!