Adding parent and child record at same time

Hi,
yes you need to use After record added event for this purpose.

Here is a sample code:

global $conn;

Hi Jane:
I tried your sample code and It produced me an error. I'm posting my actual tables and the function I wrote.

Hopefully you'll be able to point out my error.
_stfstaffmd ( parent table)

ID

EmployeeNumber

Surname

GivenName

SeniorityDate

SeniorityHours

OfficeSeniorityDate

MyStatus

MyPosition

Address

ApartmentNumber

City

PostalCode

Telephone

SecurityAccessNumber



_stfstaffdetails (child table)

ID

StaffID

SeniorityDate

SeniorityHours

OfficeSeniorityDate

MyStatus

MyPosition

Address

ApartmentNumber

City

PostalCode

Telephone

SecurityAccessNumber
<?php

function AfterAdd(&$values)

{

global $conn;

$id = mysql_insert_id();

$strInsert = "insert into stf_staffdetails (StaffID,SeniorityDate,SeniorityHours,OfficeSeniorityDate,MyStatus,MyPosition, Address,ApartmentNumber,City,PostalCode,Telephone,SecurityAccessNumber) values (".$id.", '".$values["SeniorityDate"]."', '".$values["SeniorityHours"]."', '".$values["OfficeSeniorityDate"]."', '".$values["MyStatus"]."', '".$values["MyPosition"]."', '".$values["Address"]."', '".$values["ApartmentNumber"]."', '".$values["City"]."', '".$values["PostalCode"]."', '".$values["Telephone"]."', '".$values["SecurityAccessNumber"]."')";

db_exec($strInsert,$conn);
}

return true;

?>
So as before, I would like to be able to automatically insert the corresponding values in the parent table to the corresponding values in the child table with the autoincrement ID in the parent table to populate the StaffID field in the child table.
Thanks in advance.

Hi,
you need to enter the code on the Eventstab in PHPRunner.

Don't modify generated files.

Hi Alexy:
I have also tried to add the event using the phprunner,

but what happens is that, instead of inserting the data into the child table, the added data is duplicated several times in the parent table.

Hi Alexy:
Let me rephrase that, the error I get when I use phprunner to add the after record added event is:
Missing argument 1 for AfterAdd(), called in

D:\WebDev\OfficeL\STAFF_PHP4265Test\stf_staffmd_add.php on line 479 and defined
What does that mean?
Thanks

Hi,
this error means that you've missed some arguments in the AfterAdd function.

I recommend you to add your code on the Events tab in the PHPRunner. In this case PHPRunner generates correct function header with all arguments.

Hi Jane:
I did add the code using the Events tab in the PHPRunner, and that was the error it was giving me.

Would you be able to show me the full code based on my previous entries.
Thanks,

Please publish your project on Demo Account and post a URL to your pages here or send it to [email=support@xlinesoft.com]support@xlinesoft.com[/email] along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.

Thanks for all your help Jane and Alexey.

Much appreciated.

Hi forum,

mrpeeble, did you get this resolved? I am getting the same error message. Could you post the code that did work? Many thanks,

Dave