Insert

1. Insert single value

https://www.phptutorial.net/php-pdo/php-pdo-insert/

<?php

$pdo = require_once 'connect.php';

// insert a single publisher

$name = 'Macmillan';

$sql = 'INSERT INTO publishers(name) VALUES(:name)';

$statement = $pdo->prepare($sql);

$statement->execute([

':name' => $name

]);

$publisher_id = $pdo->lastInsertId();

echo 'The publisher id ' . $publisher_id . ' was inserted'; 

2. insert multiple value

<?php

$pdo = require_once 'connect.php';

$names = [

'Penguin/Random House',

'Hachette Book Group',

'Harper Collins',

'Simon and Schuster'

];

$sql = 'INSERT INTO publishers(name) VALUES(:name)';

$statement = $pdo->prepare($sql);

foreach ($names as $name) {

$statement->execute([

':name' => $name

]);

} 

3. insert general

$s6="insert into year1_1 (SubID, Name, Teacher, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10, Comment) values ('$t20', '$t21', '$t22', '$t23', '$t24', '$t25', '$t26', '$t27', '$t28', '$t29', '$t30', '$t31', '$t32', '$t33')";

 mysqli_query($con, $s6);