after joining tables, primary key field is not showing in var_dump($rsnew). Showing in Field List and how to add in view and $rsnew array. Any guidance please. Thankscreated 4 tables
create table main (id int PRIMARY key AUTO_INCREMENT, name1 varchar(30), mobile varchar(20));
create table child1 (id1 int AUTO_INCREMENT, id int not null default 0, amt1 int not null default 0, PRIMARY KEY (`id1`, `id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
create table child2 (id2 int AUTO_INCREMENT, id int not null default 0, amt2 int not null default 0, PRIMARY KEY (`id2`, `id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
create table child3 (id3 int AUTO_INCREMENT, id int not null default 0, amt3 int not null default 0, PRIMARY KEY (`id3`,`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
created view [main_child]
SELECT main.name1 AS name1, main.mobile AS mobile, child1.amt1 AS amt1,
child2.amt2 AS amt2, child3.amt3 AS amt3, main.id AS mainid, child1.id AS
mid1, child2.id AS mid2, child3.id AS mid3
FROM ((main JOIN
child1 ON main.id = child1.id) JOIN
child2 ON main.id = child2.id) JOIN
child3 ON main.id = child3.id
main → id
$vn = $rsnew[‘mainid’];
child1 → id [master id linked with main, store via execute sql query]
child2 → id [master id linked with main, store via execute sql query]
child3 → id [master id linked with main, store via execute sql query]3 Voucher Generated with 3 Unique Id linked with main table → Id
$rsnew[“mainid”] wants to insert in child tables.Row_inserting
$this->UpdateTable = "main";
var_dump($rsnew);
$amt1 = $rsnew['amt1'];
$amt2 = $rsnew['amt2'];
$amt3 = $rsnew['amt3'];
$vn = $rsnew['mainid'];
echo $vn;
//unset($rsnew);
$this->setSuccessMessage("Voucher tested.");
die();
Execute( "INSERT INTO main (name1, mobile) VALUES (".$rsnew['name1'].",".$rsnew['mobile'].")" );
Execute( "INSERT INTO child1 (id, amt1) VALUES (".$vn.",".$amt1.");" );
Execute( "INSERT INTO child2 (id, amt2) VALUES (".$vn.",".$amt2.");" );
Execute( "INSERT INTO child2 (id, amt3) VALUES (".$vn.",".$amt3.");" );
$this->setSuccessMessage("Voucher saved successfully");
return FALSE;
showing error
Notice: Undefined index: mainid in C:\xampp\htdocs\prodcat\models\MainChild.php on line 1573
