HomeworkLib
Question

Create a Web page to be used for storing software development bug reports in a 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. On the main page you display all the reported bugs (hint: use a table). Include a link at the bottom of the page which takes you to another page where you can create a new bug report. Furthermore, add a link after every filed bug report, which takes you to a page where you can update the selected existing bug report. When updating an existing bug report make sure the input fields are filled with the input already given, so the user knows what the input was before updating. This input can be retrieved from the database.

It need to be done using php&mysqli( 3 pagees, one where I have a table to display a table with the details of the report, a page where you create a bug report, and one for an update. Thank you, I have some codes but they are not working.

Maybe you can help me,

Thank you

engineering   Computer-Science   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

ANSWER:

<html>
<head>
  <title>SoftwareRep</title>
</head>
<body>
  <form method="post" action="SoftwareRep.php">
   <input type="text" name="pname" placeholder="Product Name" required>
   <input type="text" name="version" placeholder="Product Version" required>
   <input type="text" name="hardware" placeholder="Type of Hardware" required>
   <input type="text" name="os" placeholder="Operating System" required>
   <input type="text" name="freq" placeholder="Frequency of Occurence" required>
   <input type="text" name="solutions" placeholder="Proposed Solutions" required>
   <input type="submit" name="submit">
  </form>
</body>
</html>

// The php file - SoftwareRep.php

<?php
$servername = "localhost";
    $username = "";    #your mysql username here
    $password = "";    #your mysql password here
    $dbname = "SoftwareReport";
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password); #creating the connection using the above data
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);      #settig up the error mode of the connection

    $pname = $_POST['pname'];         #fetching the variables from posted html form
    $version = $_POST['version'];
    $hardware = $_POST['hardware'];
    $os = $_POST['os'];
    $freq = $_POST['freq'];
    $solutions = $_POST['solutions'];

    $insQuery = "insert into table1 values (:pname,:version,:hardware,:os,:freq,:solutions)";  #create the mysql query
    $insStmt = $conn->prepare($insQuery);    #prepare a preparedstatement using the above the query
    $insStmt->bindParam(':pname',$pname);    #binding the parameters (placeholders) with variables
    $insStmt->bindParam(':version',$version);
    $insStmt->bindParam(':hardware',$hardware);
    $insStmt->bindParam(':os',$os);
    $insStmt->bindParam(':freq',$freq);
    $insStmt->bindParam(':solutions',$solutions);
    $insStmt->execute();        #execute the prepared statement.
?>

//The mysql queries assuming the database name to be SoftwareReport as specified and the table name to be table1 since it has not been specified. The answer does not include a zip file as it is impossible to upload a zip file

//create database

create database SoftwareReport;

//open / use the database

//create the table table1

create table table1 (pname varchar(20),version varchar(10),hardware varchar(10),os varchar(20),freq int(3),solutions varchar(50));

0 0
Add a comment
Know the answer?
Add Answer to:
Create a Web page to be used for storing software development bug reports in a MySQL...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

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

    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...

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

    PHP coding (please use mysqli instead of mysql) Create an Admin Control Panel page for your shop. Your admin page can perform the following tasks: Add product to the database. (Only text information) Delete product from the database View products from the database Edit/update product to the database Challenge: Can upload the image of each product to the database Read and display the products from database in home page

  • Using MySQL and PHP keep it simple This assignment you will be making a form that...

    Using MySQL and PHP keep it simple This assignment you will be making a form that will do one of three things in a database -          It will add a record -          It will update a record -          It will search for a record Your database will contain a table for keeping a record of all your friends and family and should contain: First name Last name Phone number Address City State Zip Birthdate Username Password The sex of the...

  • 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...

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

    Instructions Using Php and MySQL, database from Xampp In this assignment, you will create an application using PHP and MySQL, incorporating all of the skills that you have learned throughout the course. As you complete the project, be sure that you are using the correct format and syntax as well as the appropriate structure for your coding. To move forward to the next module, you will need to demonstrate mastery by scoring an 80% or higher. If you score less...

  • I want solution by wampserver 4. Database Programming [8 Marks) a. Create a database in wampserver...

    I want solution by wampserver 4. Database Programming [8 Marks) a. Create a database in wampserver with your National ID. b. Create the table structure with your college ID Number, for the all fields with the proper filed name, data type, size and constraint. c. Modify your php program with necessary mysql database connection. d. When you click register button [in the registration form], save the record into the database and display the result in table format. c. When you...

  • You need to implement a web application that is split in three parts, namely, Webpage, PHP...

    You need to implement a web application that is split in three parts, namely, Webpage, PHP and MySQL. Each of them will be used accordingly to solve a simple problem described below. Remember to implement the logic in the most secure way of your knowledge. PHP Implement a PHP function that reads in input a string from the user and store it in a table (e.g., in a field called "Content Name"). The function should be able to read the...

  • You need to implement a web application that is split in three parts, namely, Webpage, PHP and My...

    You need to implement a web application that is split in three parts, namely, Webpage, PHP and MySQL. Each of them will be used accordingly to solve a simple problem described below. Remember to implement the logic in the most secure way of your knowledge. PHP Implement a PHP function that reads in input a string from the user and store it in a table (e.g., in a field called "Content Name"). The function should be able to read the...

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

    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>...

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

    In this assignment you will combine HTML, PHP, and SQL in order to create a web form that allows a manager to add films to the sakila database. You will also create a method to allow the manager to view a list of all films along with their related information, and a list of actors in the movies. Task 1 Create an initial HTML page titled manager.html with 2 buttons. The first button will be labeled “View Films”, and the...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT