From 1b5fa4e89b6013584ef1f636c1ce5e14ec827836 Mon Sep 17 00:00:00 2001
From: Saumit Dinesan <justsaumit@protonmail.com>
Date: Tue, 3 Oct 2023 01:23:48 +0530
Subject: Lab04: HTML Form Validation- adding .env and README

---
 Lab04/create_table.php | 18 ++++++++++++------
 1 file changed, 12 insertions(+), 6 deletions(-)

(limited to 'Lab04/create_table.php')

diff --git a/Lab04/create_table.php b/Lab04/create_table.php
index 1cc0069..a704d5e 100644
--- a/Lab04/create_table.php
+++ b/Lab04/create_table.php
@@ -1,9 +1,15 @@
 <?php
-$servername = "db";
-$username = "example";
-$password = "example";
-$database = "regformdata";
-$tableName = "regtable";
+require __DIR__ . '/vendor/autoload.php';
+
+use Dotenv\Dotenv;
+$dotenv = Dotenv::createImmutable(__DIR__);
+$dotenv->load();
+
+$servername = getenv('DB_SERVER');
+$username = getenv('DB_USERNAME');
+$password = getenv('DB_PASSWORD');
+$database = getenv('DB_NAME');
+$tableName = getenv('DB_TABLE');
 
 // Create connection
 $conn = new mysqli($servername, $username, $password);
@@ -35,4 +41,4 @@ if ($conn->query($sql) === TRUE) {
 }
 
 $conn->close();
-?>
\ No newline at end of file
+?>
-- 
cgit v1.2.3