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><\/p> <p>PHP file<\/p> <p><?php $servername = \"localhost\"; $username = \"\"; $password = \"\"; $dbname = \"SoftwareReport\"; $conn = new PDO(\"mysql:host=$servername;dbname=$dbname\", $username, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); <\/p> <p> $pname = $_POST['pname']; $version = $_POST['version']; $hardware = $_POST['hardware']; $os = $_POST['os']; $freq = $_POST['freq']; $solutions = $_POST['solutions'];<\/p> <p> $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(); ?><\/p> <p>Okay, so I already have the top part done. I'm needing help with this second part below in bold... <\/p> <p><strong>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<\/strong><\/p>", "transcribed_text": "", "related_book": { "title": "Flash XML Applications Use AS2 And AS3 To Create Photo Galleries Menus And Databases", "isbn": "0240809173, 978-0240809175", "edition": "1st Edition", "authors": "Joachim Schnier", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/6507d3b4c527f_54986.jpg", "uri": "\/textbooks\/flash-xml-applications-use-as2-and-as3-to-create-photo-galleries-menus-and-databases-1st-edition-9780240809175", "see_more_uri": null }, "question_posted": "2024-09-06 11:03:46", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/refer-to-exhibit-23-and-briefly-describe-the-frauds-that", "description": "Refer to Exhibit 2.3 and briefly describe the frauds that were perpetrated at the following companies. For each company, categorize the fraud as involving primarily (1) asset misappropriation, or (2)...", "stars": 3.5 }, { "url": "\/study-help\/theory-of-probability\/there-are-two-machines-one-of-which-is-used-as-1986167", "description": "There are two machines, one of which is used as a spare. A working machine will function for an exponential time with rate and will then fail. Upon failure, it is immediately replaced by the other...", "stars": 3.5 }, { "url": "\/merrick-grows-and-sells-blueberries-maine-wild-blueberry-co-agreed", "description": "Merrick grows and sells blueberries. Maine Wild Blueberry Co. agreed to buy all of Merricks crop under a contract that left the price unliquidated. Merrick delivered the berries, but a dispute arose...", "stars": 3 }, { "url": "\/study-help\/questions\/bob-and-ted-are-partners-bob-is-a-70-10048781", "description": "Bob and Ted are partners. Bob is a 70 % partner and Ted is a 30 % partner. They have decided to liquidate the partnership. Liquidation expenses are estimated to be $ 6,000. The partnership balance...", "stars": 3 }, { "url": "\/study-help\/questions\/record-the-following-events-in-journal-entry-form-assume-that-652704", "description": "Record the following events in Journal entry form. Assume that Lazarus Company uses a perpetual inventory system. E. Lazarus Co. paid $19,550 to HTP Company, the amount owed related to a purchase of...", "stars": 3 }, { "url": "\/study-help\/questions\/1how-do-i-identify-my-target-market-2what-are-the-8489932", "description": "1.How do I identify my target market? 2.What are the key factors for a successful business plan? 3.How can I improve my companys cash flow? 4.What are the most effective ways to market a small...", "stars": 3 }, { "url": "\/study-help\/questions\/1what-is-the-renaissance-and-why-is-it-significant-in-8489933", "description": "1.What is the Renaissance, and why is it significant in art history? 2.How does Romanticism differ from Neoclassicism in art? 3.What is the significance of the Mona Lisa in art history? 4.How did the...", "stars": 3 }, { "url": "\/study-help\/questions\/question-1-what-is-cultural-relativism-and-how-does-it-8489934", "description": "Question 1: What is cultural relativism, and how does it influence the study of cultures?", "stars": 3 }, { "url": "\/study-help\/questions\/how-does-the-concept-of-hegemony-relate-to-culture-8489935", "description": "How does the concept of hegemony relate to culture?", "stars": 3 }, { "url": "\/study-help\/questions\/a-3-phase-induction-motor-is-wound-for-poles-and-8489936", "description": "a 3 phase induction motor is wound for poles and is supplied from 3 phase 50 Hz system .calculate 1. the synchronous speed,2.speed of the motor when slip is .04 and 3.the rotor frequency when the...", "stars": 3 }, { "url": "\/study-help\/international-human-resource-management\/comprehend-the-links-between-human-resource-management-hrm-practices-and-2118211", "description": "Comprehend the links between human resource management (HRM) practices and high performance.", "stars": 3 }, { "url": "\/study-help\/international-human-resource-management\/identify-the-key-aims-of-the-recruitment-process-plan-a-2118213", "description": "Identify the key aims of the recruitment process. Plan a recruitment campaign.", "stars": 3 }, { "url": "\/study-help\/international-human-resource-management\/identify-the-various-ways-that-technology-can-enhance-a-recruiting-2118216", "description": "Identify the various ways that technology can enhance a recruiting exercise.", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/romello-will-issue-one-of-the-several-types-of-opinions-9317760", "next": "\/study-help\/questions\/what-is-a-cyber-physical-system-9317762" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Computer Science", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/computer-science" }, { "name": "Databases", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/computer-science-databases" }, { "name": "Create a Web page named SoftwareRep.html to be used for storing software", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/create-a-web-page-named-softwarerephtml-to-be-used-for-9317761" } ], "skill_details": { "skill_id": "656", "skill_name": "Databases", "parent

{ "key_pair_value_system": true, "answer_rating_count": "", "question_feedback_html": { "html_star": "", "html_star_feedback": "" }, "answer_average_rating_value": "", "answer_date_js": "2024-09-06T11:03:46-04:00", "answer_date": "2024-09-06 11:03:46", "is_docs_available": "", "is_excel_available": "", "is_pdf_available": "", "count_file_available": 0, "main_page": "student_question_view", "question_id": "9317761", "url": "\/study-help\/questions\/create-a-web-page-named-softwarerephtml-to-be-used-for-9317761", "question_creation_date_js": "2024-09-06T11:03:46-04:00", "question_creation_date": "Sep 06, 2024 11:03 AM", "meta_title": "[Solved] Create a Web page named SoftwareRep.html | SolutionInn", "meta_description": "Answer of - Create a Web page named SoftwareRep.html to be used for storing software development bug reports in a MySQL database n | SolutionInn", "meta_keywords": "create,web,page,named,softwarerephtml,storing,software,development,bug,reports,mysql,database", "question_title_h1": "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", "question_title": "Create a Web page named SoftwareRep.html to be used for storing software", "question_title_for_js_snippet": "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 SoftwareRep PHP file 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", "question_description": "

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<\/p>

HTML file<\/p>

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><\/p> <p>PHP file<\/p> <p><?php $servername = \"localhost\"; $username = \"\"; $password = \"\"; $dbname = \"SoftwareReport\"; $conn = new PDO(\"mysql:host=$servername;dbname=$dbname\", $username, $password); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); <\/p> <p> $pname = $_POST['pname']; $version = $_POST['version']; $hardware = $_POST['hardware']; $os = $_POST['os']; $freq = $_POST['freq']; $solutions = $_POST['solutions'];<\/p> <p> $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(); ?><\/p> <p>Okay, so I already have the top part done. I'm needing help with this second part below in bold... <\/p> <p><strong>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<\/strong><\/p>", "transcribed_text": "", "related_book": { "title": "Flash XML Applications Use AS2 And AS3 To Create Photo Galleries Menus And Databases", "isbn": "0240809173, 978-0240809175", "edition": "1st Edition", "authors": "Joachim Schnier", "cover_image": "https:\/\/dsd5zvtm8ll6.cloudfront.net\/si.question.images\/book_images\/6507d3b4c527f_54986.jpg", "uri": "\/textbooks\/flash-xml-applications-use-as2-and-as3-to-create-photo-galleries-menus-and-databases-1st-edition-9780240809175", "see_more_uri": null }, "question_posted": "2024-09-06 11:03:46", "step_by_step_answer": "The Answer is in the image, click to view ...", "students_also_viewed": [ { "url": "\/refer-to-exhibit-23-and-briefly-describe-the-frauds-that", "description": "Refer to Exhibit 2.3 and briefly describe the frauds that were perpetrated at the following companies. For each company, categorize the fraud as involving primarily (1) asset misappropriation, or (2)...", "stars": 3.5 }, { "url": "\/study-help\/theory-of-probability\/there-are-two-machines-one-of-which-is-used-as-1986167", "description": "There are two machines, one of which is used as a spare. A working machine will function for an exponential time with rate and will then fail. Upon failure, it is immediately replaced by the other...", "stars": 3.5 }, { "url": "\/merrick-grows-and-sells-blueberries-maine-wild-blueberry-co-agreed", "description": "Merrick grows and sells blueberries. Maine Wild Blueberry Co. agreed to buy all of Merricks crop under a contract that left the price unliquidated. Merrick delivered the berries, but a dispute arose...", "stars": 3 }, { "url": "\/study-help\/questions\/bob-and-ted-are-partners-bob-is-a-70-10048781", "description": "Bob and Ted are partners. Bob is a 70 % partner and Ted is a 30 % partner. They have decided to liquidate the partnership. Liquidation expenses are estimated to be $ 6,000. The partnership balance...", "stars": 3 }, { "url": "\/study-help\/questions\/record-the-following-events-in-journal-entry-form-assume-that-652704", "description": "Record the following events in Journal entry form. Assume that Lazarus Company uses a perpetual inventory system. E. Lazarus Co. paid $19,550 to HTP Company, the amount owed related to a purchase of...", "stars": 3 }, { "url": "\/study-help\/questions\/1how-do-i-identify-my-target-market-2what-are-the-8489932", "description": "1.How do I identify my target market? 2.What are the key factors for a successful business plan? 3.How can I improve my companys cash flow? 4.What are the most effective ways to market a small...", "stars": 3 }, { "url": "\/study-help\/questions\/1what-is-the-renaissance-and-why-is-it-significant-in-8489933", "description": "1.What is the Renaissance, and why is it significant in art history? 2.How does Romanticism differ from Neoclassicism in art? 3.What is the significance of the Mona Lisa in art history? 4.How did the...", "stars": 3 }, { "url": "\/study-help\/questions\/question-1-what-is-cultural-relativism-and-how-does-it-8489934", "description": "Question 1: What is cultural relativism, and how does it influence the study of cultures?", "stars": 3 }, { "url": "\/study-help\/questions\/how-does-the-concept-of-hegemony-relate-to-culture-8489935", "description": "How does the concept of hegemony relate to culture?", "stars": 3 }, { "url": "\/study-help\/questions\/a-3-phase-induction-motor-is-wound-for-poles-and-8489936", "description": "a 3 phase induction motor is wound for poles and is supplied from 3 phase 50 Hz system .calculate 1. the synchronous speed,2.speed of the motor when slip is .04 and 3.the rotor frequency when the...", "stars": 3 }, { "url": "\/study-help\/international-human-resource-management\/comprehend-the-links-between-human-resource-management-hrm-practices-and-2118211", "description": "Comprehend the links between human resource management (HRM) practices and high performance.", "stars": 3 }, { "url": "\/study-help\/international-human-resource-management\/identify-the-key-aims-of-the-recruitment-process-plan-a-2118213", "description": "Identify the key aims of the recruitment process. Plan a recruitment campaign.", "stars": 3 }, { "url": "\/study-help\/international-human-resource-management\/identify-the-various-ways-that-technology-can-enhance-a-recruiting-2118216", "description": "Identify the various ways that technology can enhance a recruiting exercise.", "stars": 3 } ], "next_back_navigation": { "previous": "\/study-help\/questions\/romello-will-issue-one-of-the-several-types-of-opinions-9317760", "next": "\/study-help\/questions\/what-is-a-cyber-physical-system-9317762" }, "breadcrumbs": [ { "name": "Study help", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers" }, { "name": "Computer Science", "link": "https:\/\/www.solutioninn.com\/study-help\/questions-and-answers\/computer-science" }, { "name": "Databases", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/computer-science-databases" }, { "name": "Create a Web page named SoftwareRep.html to be used for storing software", "link": "https:\/\/www.solutioninn.com\/study-help\/questions\/create-a-web-page-named-softwarerephtml-to-be-used-for-9317761" } ], "skill_details": { "skill_id": "656", "skill_name": "Databases", "parent_id": "8" } }