Using PHP and MySQL, create a Web page to be used for storing software development bug reports in a MySQL database. Include fields such as product name and version, type of hardware, operating system, frequency of occurrence, and proposed solutions. Include links on the main page that allow you to create a new bug report and update an existing bug report.
I have tried the various solutions provided previously for this exercise, but it does not work because every author leaves out pertinent information pertaining to the code required for parts of the form, which leads me to believe other code may also be incorrect and why none of the solutions are working. Please help!!
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Dashboard</title>
<link rel="stylesheet"
href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.css">
<script
src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script
src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.js"></script>
<style type="text/css">
.wrapper{
width: 650px;
margin: 0 auto;
}
.page-header h2{
margin-top: 0;
}
table tr td:last-child a{
margin-right: 15px;
}
</style>
<script type="text/javascript">
$(document).ready(function(){
$('[data-toggle="tooltip"]').tooltip();
});
</script>
</head>
<body>
<div class="wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-md-12">
<div class="page-header clearfix">
<h2 class="pull-left">Employees Details</h2>
<a href="create.php" class="btn btn-success pull-right">Add
New Employee</a>
</div>
<?php
// Include config file
require_once "config.php";
// Attempt select query execution
$sql = "SELECT * FROM softdetails";
if($result = mysqli_query($link, $sql)){
if(mysqli_num_rows($result) > 0){
echo "<table class='table table-bordered
table-striped'>";
echo "<thead>";
echo "<tr>";
echo "<th>product name</th>";
echo "<th>version</th>";
echo "<th>type of hardware</th>";
echo "<th>OS</th>";
echo "<th>Frequency of occurence</th>";
echo "<th>Proposed Solutions</th>";
echo "</tr>";
echo "</thead>";
echo "<tbody>";
while($row = mysqli_fetch_array($result)){
echo "<tr>";
echo "<td>" . $row['pName'] . "</td>";
echo "<td>" . $row['pVersion'] . "</td>";
echo "<td>" . $row['hardwareType'] . "</td>";
echo "<td>" . $row['OS'] . "</td>";
echo "<td>" . $row['freqOfOccurence'] . "</td>";
echo "<td>" . $row['propSol'] . "</td>";
echo "<td>";
echo "<a href='read.php?id=". $row['pName'] ."' title='View
Record' data-toggle='tooltip'><span class='glyphicon
glyphicon-eye-open'></span></a>";
echo "<a href='update.php?id=". $row['pName'] ."' title='Update
Record' data-toggle='tooltip'><span class='glyphicon
glyphicon-pencil'></span></a>";
echo "<a href='delete.php?id=". $row['pName'] ."' title='Delete
Record' data-toggle='tooltip'><span class='glyphicon
glyphicon-trash'></span></a>";
echo "</td>";
echo "</tr>";
}
echo "</tbody>";
echo "</table>";
// Free result set
mysqli_free_result($result);
} else{
echo "<p class='lead'><em>No records were
found.</em></p>";
}
} else{
echo "ERROR: Could not able to execute $sql. " .
mysqli_error($link);
}
// Close connection
mysqli_close($link);
?>
</div>
</div>
</div>
</div>
</body>
</html>
Using PHP and MySQL, create a Web page to be used for storing software development bug reports in...
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...
PHP Programming In this project, you will create a Web page that allows visitors to your site to sign a guest book that is saved to a database. Create a new document in your text editor and type the <!DOCTYPE> declaration, <html> element, document head, and <body> element. Use the strict DTD and “Guest Book” as the content of the <title> element. Add the following text and elements to the document body: <h2>Enter your name to sign our guest book</h2>...
10. Write a one-page summary of the attached paper? INTRODUCTION Many problems can develop in activated sludge operation that adversely affect effluent quality with origins in the engineering, hydraulic and microbiological components of the process. The real "heart" of the activated sludge system is the development and maintenance of a mixed microbial culture (activated sludge) that treats wastewater and which can be managed. One definition of a wastewater treatment plant operator is a "bug farmer", one who controls the aeration...