Create a Web page named SoftwareRep.html to be used for storing software development bug reports in a MySQL database named SoftwareReport. Include fields such as product name and version, type of hardware, operating system, frequency of occurrence, and proposed solutions. Name the PHP script as SoftwareRep.php

HTML file

PHP file

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

$pname = $_POST['pname']; $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)"; $insStmt = $conn->prepare($insQuery); $insStmt->bindParam(':pname',$pname); $insStmt->bindParam(':version',$version); $insStmt->bindParam(':hardware',$hardware); $insStmt->bindParam(':os',$os); $insStmt->bindParam(':freq',$freq); $insStmt->bindParam(':solutions',$solutions); $insStmt->execute(); ?>

Okay, so I already have the top part done. I'm needing help with this second part below in bold...

Create a separate Web form named SoftwareUpdate.html to be used for updating an existing bug report from the database above. Name the PHP script as SoftwareUpdate.php