PHPize Online / SQLize Online  /  SQLtest Online

<?php $name = "Barry Block"; $email = "barry.b@gmail.com"; $balance = 500; $student_sql = " insert into student (student_name, email) values ( :name, :emailAddress )"; $stmt = $pdo->prepare($student_sql); $stmt->execute([':name'=>$name, ':emailAddress'=>$email]); $bill_sql = " insert into bill (student_id, total_balance) select id, :balance from student where email = :emailAddress"; $stmt = $pdo->prepare($bill_sql); $stmt->execute([':balance'=>$balance, ':emailAddress'=>$email]); $query = "SELECT * from student join bill on bill.student_id = student.id;"; $stmt = $pdo->prepare($query); $stmt->execute(); $students = $stmt->fetch(PDO::FETCH_ASSOC); print_r($students);