*************

SQL code: Upload dump Copy Format Clear

-- Create the students table CREATE TABLE students ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, class VARCHAR(50) NOT NULL ); -- Create the grades table CREATE TABLE grades ( id INT AUTO_INCREMENT PRIMARY KEY, student_id INT, test_name VARCHAR(100) NOT NULL, score INT NOT NULL, test_date DATE NOT NULL, FOREIGN KEY (student_id) REFERENCES students(id) );

SQL Server: Preserve result

Result: Copy Clear

PHP code: Copy Format Clear

<?php if ($_SERVER["REQUEST_METHOD"] === "POST") { $name = $_POST['name']; $class = $_POST['class']; // Perform database insertion // (Assuming you have a database connection established) $sql = "INSERT INTO students (name, class) VALUES ('$name', '$class')"; $result = mysqli_query($conn, $sql); if ($result) { echo "Student added successfully"; } else { echo "Error adding student: " . mysqli_error($conn); } mysqli_close($conn); } ?>  <form method="post" action="add_student.php">  </form>

PHP version:

Show: Warnings Notice

Result: Copy Clear

our telegram chat

VPS servers at the highest possible quality

PHP versions: PHP 5.6, PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2.13
RDBMS versions: MySQL 5.7, MySQL 5.7 Sakila (ReadOnly), MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), MariaDB 10, MariaDB 10 Sakila (ReadOnly), SQLite 3, PostgreSQL 10 Bookings (ReadOnly), PostgreSQL 11, PostgreSQL 12, PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, Firebird 4.0, Firebird 4.0 (Employee), Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 23c Free, SOQOL

PHPize Online / SQLize Online / SQLtest Online