From 71a5768da1b297c807beee4e3c6a4942126c66e9 Mon Sep 17 00:00:00 2001 From: Saumit Dinesan Date: Thu, 28 Sep 2023 16:29:16 +0530 Subject: Lab06: Creating a MySQL Database with PHP and Storing HTML Form Data --- Lab06/create_db.php | 23 +++++++++++++++++++++++ Lab06/create_table.php | 37 +++++++++++++++++++++++++++++++++++++ Lab06/form1.php | 36 ++++++++++++++++++++++++++++++++++++ Lab06/form1_submit.php | 34 ++++++++++++++++++++++++++++++++++ Lab06/test.php | 5 +++++ 5 files changed, 135 insertions(+) create mode 100644 Lab06/create_db.php create mode 100644 Lab06/create_table.php create mode 100644 Lab06/form1.php create mode 100644 Lab06/form1_submit.php create mode 100755 Lab06/test.php diff --git a/Lab06/create_db.php b/Lab06/create_db.php new file mode 100644 index 0000000..c220148 --- /dev/null +++ b/Lab06/create_db.php @@ -0,0 +1,23 @@ +connect_error) { + die("Connection failed: " . $conn->connect_error); +} + +//Create database +$sql = "CREATE DATABASE it_202000096"; +if ($conn->query($sql) === TRUE) { + echo "Database created successfully"; +} else { + echo "Error creating database: " . $conn->error; +} + +$conn->close(); +?> diff --git a/Lab06/create_table.php b/Lab06/create_table.php new file mode 100644 index 0000000..f11a89b --- /dev/null +++ b/Lab06/create_table.php @@ -0,0 +1,37 @@ +connect_error) { + die("Connection failed: " . $conn->connect_error); +} + +//Select the database +$conn->select_db($database); + +//Create table +$sql = "CREATE TABLE `$tableName` ( + id INT AUTO_INCREMENT PRIMARY KEY, + fname VARCHAR(50) NOT NULL, + lname VARCHAR(50) NOT NULL, + age INT, + gender VARCHAR(10), + phone VARCHAR(15), + email VARCHAR(100) +)"; + +if ($conn->query($sql) === TRUE) { + echo "Table created successfully"; +} else { + echo "Error creating Table: " . $conn->error; +} + +$conn->close(); +?> diff --git a/Lab06/form1.php b/Lab06/form1.php new file mode 100644 index 0000000..5348baf --- /dev/null +++ b/Lab06/form1.php @@ -0,0 +1,36 @@ + + + + + + + + diff --git a/Lab06/form1_submit.php b/Lab06/form1_submit.php new file mode 100644 index 0000000..f1cb514 --- /dev/null +++ b/Lab06/form1_submit.php @@ -0,0 +1,34 @@ + + + + Welcome
+ Your email address is:
+ "; + print_r($_POST); + echo ""; + $servername = "localhost"; + $username = "it"; + $password = "smit#1234"; + $dbname = "it_202000096"; + //Create connection + $conn = mysqli_connect($servername, $username, $password,$dbname); + //Check connection + if ($conn->connect_error) { + die("Connection failed: " . $conn->connect_error); + } + $fname= $_POST['fname']; + $lname= $_POST['lname']; + $age= $_POST['age']; + $gender= $_POST['gender']; + $email= $_POST['email']; + $sql = "INSERT INTO student (fname, lname, age, gender,email) VALUES ('$fname','$lname','$age','$gender','$email')"; + if (mysqli_query($conn, $sql)) { + echo "New record created successfully"; + } else { + echo "Error: " . $sql . "
" . mysqli_error($conn); + } + mysqli_close($conn); + ?> + + diff --git a/Lab06/test.php b/Lab06/test.php new file mode 100755 index 0000000..61f68d9 --- /dev/null +++ b/Lab06/test.php @@ -0,0 +1,5 @@ + + -- cgit v1.2.3