Hi I am able to get the last inserted ID in one function, but how am I able to use it in another function as it is being displayed as an undefined variable when outside of that function.
Thanks
EDIT:
code from class.user.php
public function one($first)
{
try
{
$stmt = $this->db->prepare("INSERT INTO table1(first) VALUES(:first)");
$stmt->bindParam(':first', $first);
$stmt->execute();
$newId = $this->db->lastInsertId();
return $stmt;
return $newId;
}
catch(PDOException $e)
{
echo $e->getMessage();
}
}
public function two($array, $newID)
{
try
{
foreach($array as $arrayText){
$this->db->beginTransaction();
$stmt = $this->db->prepare("INSERT INTO table2(arrayText, table1_id) VALUES(:array, :newId)");
$stmt->bindParam(':array', $arrayText);
$stmt->bindParam(':newId', $newId);
$stmt->execute();
$this->db->commit();
}
return $stmt;
}
catch(PDOException $e)
{
echo $e->getMessage();
}
}
php code
if(isset($_POST['btn']))
{
$first = trim($_POST['first']);
$array = $_POST['array'];
if($user->one($first) && $user->two($array, $newId))
{
Print '<script>alert("Added to database");</script>'; //Prompts the user
}
}
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…