saving data on two tables, the parent and child table

[omphilesithole]

I have two table and both on have the status field, a parent table called crimereport and a child table called assignreport,
so once i assign a report under that id i need to also update the parent table to change the status as assigned, what i did so far on the assignreport_dml.php under the insert function i did the following code:

$o=array('silentErrors' => true);
sql('update `crimereport` set `status`=' . ($data['status'] ) . " where `id`='".makeSafe($selected_id)."'", $o);

But its not doing anything am not sure if am doing it right or wrong please help??

Thanks

[tmathew]

I too want to achieve the same. Anyone to help?

[a.gneady]

sql('update `crimereport` set `status`=' . ($data['status'] ) . " where `id`='".makeSafe($selected_id)."'", $o);

You should change $selected_id in the where clause to the value of the lookup field ... So, assuming the lookup field is named crimereport_id, the query should be:
sql('update `crimereport` set `status`=' . ($data['status'] ) . " where `id`='".makeSafe($data['crimereport_id'])."'", $o);

[tmathew]

Can anyone please tell me the purpose of the ' . ' (dot) used in the above syntax?
Is there some documentation which I can use for reference when writing codes in AppGini Hooks/other areas?
Is this standard PHP syntax itself? Eventhough I have programming knowledge, I am totally new to PHP/MySQL/HTML/etc (web app dev). That is why this question.

I have used a syntax similar to the bove to update a field in the same table, not in a second table. But it just displays a blank screen. I have spent almost 2 days looking for a solution to this simple issue. The syntax is
sql('update `VEHICLER2ODETAILS` set `emiamount` =` . (($data['renttoownprice'] - $data['downpaymentdefault']) * ($data['$servicerate'] / 100))/30 . " where `id`='".makeSafe($id)."'",$o);
'id' is the primary key field of the record. So I used makeSafe($id). I do not know whether this is correct or not. Hope someone will help me.

[Satya Kavala]

Hi,
$sql='update `VEHICLER2ODETAILS` set `emiamount` =` . (($data['renttoownprice'] - $data['downpaymentdefault']) * ($data['$servicerate'] / 100))/30 . " where `id`='".makeSafe($id)."';
sql($sql,$o);

here '.' (dot) operator for representing variable in php


function write_log($data)
{
$file = 'error_log.txt';
$current = file_get_contents($file);
$current .= $data."\n";
file_put_contents($file, $current);
}

Place the above function on lib.php



write_log($data['renttoownprice']);//place the line of code in .php file where the query is presented.like that take all the values if presented or not
write_log($sql);//it will displays the query, here also you can find is the query is forming perfectly or not?

once you run your application, error_log.txt file will be generated there you can see the result of the variables and query formation.

Thanks

[tmathew]

Thank you Satya

[Satya Kavala]

Hi,
You are most welcome tmathew .

Thanks&Regards
satya Kavala
[email protected].
+91-9951156428