Create web pages for your database using PHP. You should have one page that will return...

Question

Question

Create web pages for your database using PHP. You should have one page that will return...

Create web pages for your database using PHP. You should have one page that will return all the information from the database. You should create additional pages that will allow you to do various queries of your database. You should be able to retrieve and insert data; also include functionality to delete data from your database. Create an html form that will allow you to enter in new information for the database. The information should be handled by a PHP script that will take the data and input it into the database. Create a separate home page that contains links to each of the web pages you create to access your database.

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

CREATE TABLE `Student`.`studentdetails` ( `stud_id` INT NOT NULL AUTO_INCREMENT , `firstname` VARCHAR(100) NOT NULL , `lastname` VARCHAR(100) NOT NULL , `subject` VARCHAR(100) NOT NULL , PRIMARY KEY (`stud_id`)) ENGINE = InnoDB; //This is a sample database

PHP code for display,Add and Delete are mentioned below

------------------------------------------------------------------------------------------------------------------------------------

home.html

-------------------------------------------------------------------------------------------------------

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Home Page</title>
</head>
<body>
<form>
<div class="container" style="padding: 16px;">
<h1>Home Page</h1>
<hr>
<p>

</p>
<p >
<a href="displays.php">View All Details</a>
</p>
<p>
<a href="addnewdata.html">Add</a>
</p>

</div>
</form>
</body>
</html>

---------------------------------------------------------------------------------------------------------------------------------------------------

display.php

----------------------------------------------------------------------------------------------------------------------------------------------------

<?php
$link = mysqli_connect("localhost", "root", "", "student");

// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$sql = "SELECT * FROM studentdetails";
if($result = mysqli_query($link, $sql))
{
if(mysqli_num_rows($result) > 0)
{
echo "<table>";
echo "<tr>";
echo "<th>Id</th>";
echo "<th>First Name</th>";
echo "<th>Last Name</th>";
echo "<th>Subject</th>";
echo "</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['stud_id'] . "</td>";
echo "<td>" . $row['firstname'] . "</td>";
echo "<td>" . $row['lastname'] . "</td>";
echo "<td>" . $row['subject'] . "</td>";
echo "<td><a href=\"delete.php?id=" . $row['stud_id'] . "\">Delete</a></td>";
echo "</tr>";
}
echo "</table>";
// Free result set
mysqli_free_result($result);
} else{
echo "No records matching your query were found.";
}
}
else
{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}
mysqli_close($link);
?>

--------------------------------------------------------------------------------------------------------------------------------------------------------

addnewdata.html

----------------------------------------------------------------------------------------------------------------------------------------------------------

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Add Record Form</title>
</head>
<body>
<form action="addnewdata.php" method="post">
<p>
<label for="firstname">First Name:</label>
<input type="text" name="first_name" id="firstName">
</p>
<p>
<label for="lastname">Last Name:</label>
<input type="text" name="last_name" id="lastName">
</p>
<p>
<label for="Subject">Subject:</label>
<input type="text" name="subject" id="subject">
</p>
<hr>
<input type="submit" value="Submit">
</form>
</body>
</html>

-------------------------------------------------------------------------------------------------------------------------------------------------------

addnewdata.php

-------------------------------------------------------------------------------------------------------------------------------------------------------

<?php

$link = mysqli_connect("localhost", "root", "", "student");

// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}

$first_name = mysqli_real_escape_string($link, $_REQUEST['first_name']);
$last_name = mysqli_real_escape_string($link, $_REQUEST['last_name']);
$subject = mysqli_real_escape_string($link, $_REQUEST['subject']);

// Attempt insert query execution
$sql = "INSERT INTO studentdetails (firstname, lastname, subject) VALUES ('$first_name', '$last_name', '$subject')";
if(mysqli_query($link, $sql)){
echo "Records added successfully.";
} else{
echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
}

// Close connection
mysqli_close($link);
?>

-------------------------------------------------------------------------------------------------------------------------------------------------------------

delete.php

------------------------------------------------------------------------------------------------------------------------------------------------------------

<?php

$link = mysqli_connect("localhost", "root", "", "student");

// Check connection
if($link === false){
die("ERROR: Could not connect. " . mysqli_connect_error());
}
$stud_id= $_GET['id'];
$sql = "DELETE FROM studentdetails WHERE stud_id='$stud_id'";

if (mysqli_query($link, $sql)) {
echo "Record deleted successfully";
} else {
echo "Error deleting record: " . mysqli_error($conn);
}

// Close connection
mysqli_close($link);
?>

Add a comment

Answer 2

Create web pages for your database using PHP. You should have one page that will return...

Homework Answers

Add Answer to:
Create web pages for your database using PHP. You should have one page that will return...

Post as a guest

Earn Coins

Create two web pages as follows: Page 1: An html page with a form that will...

PHP you need to create a form to allow the user to enter their name, email,...

Using PHP and MySQL, create a Web page to be used for storing software development bug reports in...

In this assignment you will combine HTML, PHP, and SQL in order to create a web...

Instructions Using Php and MySQL, database from Xampp In this assignment, you will create an application...

PHP Programming In this project, you will create a Web page that allows visitors to your...

The following needs to be on a basic web page using the PHP request-response model to...

PHP coding (please use mysqli instead of mysql) Create an Admin Control Panel page for your...

HTML Web Page project: Need help to create a web page exactly as the example below...

Create a folder named "TrainerApp". In that folder create the following files. Create a PHP file,...

Create web pages for your database using PHP. You should have one page that will return...

Homework Answers

Add Answer to: Create web pages for your database using PHP. You should have one page that will return...

Post as a guest

Earn Coins

Add Answer to:
Create web pages for your database using PHP. You should have one page that will return...