Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

turn this for loop into a foreach loop query ( $sql ) ; $database - > bind ( :ID _ , $id )

turn this for loop into a foreach loop
query($sql);
$database->bind(":ID_", $id);
$database->execute();
$rows = $database->object();
$countable=count($rows);
for ($rowNum =1; $rowNum <= $countable; $rowNum++){
$getID ='ID_'. $rowNum;
$id = $_POST[$getID];
echo "$id ";
$getRelatedID = 'relatedID_'. $rowNum;
$RelatedID = $_POST[$getRelatedID];
echo "$RelatedID";
$getFName='EmployeeFName_'.$rowNum;
$EmployeeFName=$_POST[$getFName];
echo "$EmployeeFName ";
foreach ($rows as $key => $val){
// Process data here if needed
// For example, update other fields based on $val
$sql = "UPDATE javascripttest.liscence SET ID=:id, RelatedID = :RelatedID,
EmployeeFName=:EmployeeFName WHERE id = :id";
$database->query($sql);
$database->bind(":id", $id);
$database->bind(":RelatedID", $RelatedID);
$database->bind(":EmployeeFName", $EmployeeFName);
$database->execute();
//EmployeeFName
}
}
?>

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inductive Databases And Constraint Based Data Mining

Authors: Saso Dzeroski ,Bart Goethals ,Pance Panov

2010th Edition

1489982175, 978-1489982179

Students also viewed these Databases questions