From abcb2c27dedf8dff976d002a521c725746dace42 Mon Sep 17 00:00:00 2001
From: Saumit Dinesan <justsaumit@protonmail.com>
Date: Mon, 2 Oct 2023 21:33:19 +0530
Subject: Lab04: Properly formatting index.html and insert.php

---
 Lab04/insert.php | 60 ++++++++++++++++++++++++++++----------------------------
 1 file changed, 30 insertions(+), 30 deletions(-)

(limited to 'Lab04/insert.php')

diff --git a/Lab04/insert.php b/Lab04/insert.php
index 6a5a04f..717842e 100644
--- a/Lab04/insert.php
+++ b/Lab04/insert.php
@@ -14,40 +14,40 @@
         $dbname = "regformdata";
         $tablename = "regtable";
  
-// Create connection
-$conn = mysqli_connect($servername, $username, $password, $dbname);
+        // Create connection
+        $conn = mysqli_connect($servername, $username, $password, $dbname);
 
-// Check connection
-if ($conn === false) {
-    die("Connection failed: "
-        . mysqli_connect_error());
-}
+        // Check connection
+        if ($conn === false) {
+            die("Connection failed: " . mysqli_connect_error());
+        }
 
-$first_name = $_REQUEST['fname'];
-$last_name = $_REQUEST['lname'];
-$gender = $_REQUEST['gender'];
-$phone = $_REQUEST['phone'];
-$email = $_REQUEST['email'];
-$city = $_REQUEST['city'];
-$department = $_REQUEST['department'];
+        $first_name = $_REQUEST['fname'];
+        $last_name = $_REQUEST['lname'];
+        $gender = $_REQUEST['gender'];
+        $phone = $_REQUEST['phone'];
+        $email = $_REQUEST['email'];
+        $city = $_REQUEST['city'];
+        $department = $_REQUEST['department'];
+        
+        $sql = "INSERT INTO $tablename (fname, lname, gender, phone, email, city, department)
+        VALUES ('$first_name', '$last_name', '$gender', '$phone', '$email', '$city', '$department')";
 
-$sql2 = "INSERT INTO regform VALUES (first_name, last_name, gender, phone, email, city, department)";
-if(mysqli_query($conn, $sql)){
-    echo "<h3>Data stored in a database successfully."
-        . " Please browse your localhost php my admin"
-        . " to view the updated data</h3>";
+        if(mysqli_query($conn, $sql)){
+            echo "<h3>Data stored in a database successfully."
+                . " Please browse your localhost php my admin"
+                . " to view the updated data</h3>";
+        
+            echo nl2br("\n$first_name\n $last_name\n "
+                . "$gender\n $phone \n $email \n $city\n $department");
+        } else{
+            echo "ERROR: Could not insert the data values $sql. "
+                . mysqli_error($conn);
+        }
 
-    echo nl2br("\n$first_name\n $last_name\n "
-        . "$gender\n $phone \n $email \n $city\n $department");
-
-} else{
-	echo "ERROR: Could not insert the data values $sql. "
-		. mysqli_error($conn);
-}
-
-// Close connection
-mysqli_close($conn);
-?>
+        // Close connection
+        mysqli_close($conn);
+        ?>
     </center>
 </body>
  
-- 
cgit v1.2.3