summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--Lab06/create_db.php23
-rw-r--r--Lab06/create_table.php37
-rw-r--r--Lab06/form1.php36
-rw-r--r--Lab06/form1_submit.php34
-rwxr-xr-xLab06/test.php5
5 files changed, 135 insertions, 0 deletions
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 @@
+<?php
+$servername = "localhost";
+$username = "it";
+$password = "smit#1234";
+
+//Create connection
+$conn = new mysqli($servername, $username, $password);
+
+//Check connection
+if ($conn->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 @@
+<?php
+$servername = "localhost";
+$username = "it";
+$password = "smit#1234";
+$database = "it_202000096";
+$tableName = "studentdb";
+
+//Create connection
+$conn = new mysqli($servername, $username, $password);
+
+//Check connection
+if ($conn->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 @@
+<html>
+<head>
+ <style>
+ select {
+ margin-bottom: 10px;
+ }
+ #submit {
+ margin-top: 10px;
+ }
+ </style>
+</head>
+<body>
+ <form action="form1_submit.php" method="post">
+ <label for="fname">First Name:</label><br>
+ <input type="text" id="fname" name="fname"><br>
+
+ <label for="lname">Last Name:</label><br>
+ <input type="text" id="lname" name="lname"><br>
+
+ <label for="age">Age: </label><br>
+ <input type="number" id="age" name="age"><br>
+
+ <label for="gender">Gender:</label><br>
+ <select id="gender" name="gender">
+ <option value="Male">Male</option>
+ <option value="Female">Female</option>
+ <option value="Other">Other</option>
+ </select><br>
+
+ <label for="email">Email Address:</label><br>
+ <input type="email" id="email" name="email"><br>
+
+ <input type="submit" id="submit" value="Submit">
+ </form>
+</body>
+</html>
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 @@
+<html>
+
+<body>
+ Welcome <?php echo $_POST["fname"]; ?><br>
+ Your email address is:<?php echo $_POST["email"]; ?><br>
+ <?php
+ echo "<pre>";
+ print_r($_POST);
+ echo "</pre>";
+ $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 . "<br>" . mysqli_error($conn);
+ }
+ mysqli_close($conn);
+ ?>
+</body>
+</html>
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 @@
+<?php
+echo "Hello world";
+
+?>
+