Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 03, 2024

I need php code that should edit sql database entered by html5 FORM (name , description , location ). like if we have a sql

I need php code that should edit sql database entered by html5 FORM (name , description, location<select> ).</p> <p dir="ltr">like if we have a sql table (name=Sam,) (description=I'm very good and need car) and (location=Taxas), </p> <p dir="ltr">please help me with php code that could make edit like change the name or the location and submit the new inputs to sql table.</p> <p dir="ltr">php PDO please</p> </h2> </section> <section class="answerHolder"> <div class="answerHolderHeader"> <div class="answer-heading"> <h2>Step by Step Solution</h2> </div> <div class="answerReviews"> <div class="starReview"> <div class="starIcon"> </div> <div class="starText"> </div> </div> </div> </div> <div class="answerSteps"> <p>There are <span>3</span> Steps involved in it</p> <div class="step"> <h3>Step: 1</h3> <img src="https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp" width="759" height="271" alt="blur-text-image" loading="lazy" decoding="async" fetchpriority="low"> <div class="step1Popup"> <h3>Get Instant Access to Expert-Tailored Solutions</h3> <p>See step-by-step solutions with expert insights and AI powered tools for academic success</p> <button class="view_solution_btn step1PopupButton">View Solution</button> </div> </div> <div class="step"> <h3 class="accordion">Step: 2</h3> <div class="panel"> <img src="https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp" width="975" height="120" alt="blur-text-image" loading="lazy" decoding="async" fetchpriority="low"> <button class="view_solution_btn stepPopupButton">Sign Up to view</button> </div> </div> <div class="step"> <h3 class="accordion">Step: 3</h3> <div class="panel"> <img src="https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp" width="975" height="120" alt="blur-text-image" loading="lazy" decoding="async" fetchpriority="low"> <button class="view_solution_btn stepPopupButton">Sign Up to view</button> </div> </div> </div> </section> </div> <div class="expertRight"> <section class="AIRedirect"> <div class="AIHolder"> <h2>Ace Your Homework with AI</h2> <p>Get the answers you need in no time with our AI-driven, step-by-step assistance</p> <a class="AILink" href="/ask_ai">Get Started</a> </div> </section> <section class="relatedBook"> <div class="bookHolder" bis_skin_checked="1"> <div class="relatedBookHeading" bis_skin_checked="1"> <h2>Recommended Textbook for</h2> <object class="freeTagImage" type="image/svg+xml" loading="lazy" data="https://dsd5zvtm8ll6.cloudfront.net/includes/images/rewamp/document_product_info/free.svg" alt="free-icon"></object> </div> <div class="bookMainInfo" bis_skin_checked="1"> <div class="bookImage" bis_skin_checked="1"> <a href="/textbooks/sams-teach-yourself-beginning-databases-in-24-hours-1st-edition-9780672324925"> <img src="https://dsd5zvtm8ll6.cloudfront.net/si.question.images/book_images/64f01dcadc131_48813.jpg" width="100" height="131" alt="Sams Teach Yourself Beginning Databases In 24 Hours" loading="lazy"> </a> </div> <div class="bookInfo" bis_skin_checked="1"> <h3 class="bookTitle"> <a href="/textbooks/sams-teach-yourself-beginning-databases-in-24-hours-1st-edition-9780672324925"> Sams Teach Yourself Beginning Databases In 24 Hours </a> </h3> <div class="bookMetaInfo" bis_skin_checked="1"> <p class="bookAuthor"> <b>Authors:</b> <span>Ryan Stephens, Ron Plew</span> </p> <p class="bookEdition"> 1st Edition </p> <p class="bookEdition"> 067232492X, 978-0672324925 </p> </div></div></div> <a href="/textbooks/computer-science-ado-net-2392" class="viewMoreBooks">More Books</a> </div> </section> </div> </section> <section class="relatedQuestion"> <div class="relatedQuestionHolder"> <h4>Students also viewed these Databases questions</h4> <div class="relatedQuestionSliderHolder"> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/journalize-the-entries-for-the-following-adjustments-at-january-31" > Journalize the entries for the following adjustments at January 31, the end of the accounting period: a. Amortization, $5,000. b. Prepaid insurance used, $500. c. Interest expense accrued, $400. d.... </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/study-help/psychology-2e/4-why-would-clinicians-probably-not-use-extinction-ie-planned-1988979" > 4. Why would clinicians probably not use extinction (i.e., planned ignoring) to reduce SIBs in a young child with a developmental disorder? </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star active half">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/lisa-mendes-and-brad-lee-work-in-the-sales-department" > Lisa Mendes and Brad Lee work in the sales department of an AT&T Wireless Store. Lisa has been signing in an average of 48 new cell phone customers every month with a standard deviation of 22, while... </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star active half">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/study-help/questions/write-a-java-method-gettestarraysstring-filename-that-returns-an-int-10111009" > write a java method, getTestArrays(String filename) that returns an int array (int[][]). Your method will use the passed in String as a fully qualified path to a file that you will open, read into an... </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star active half">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/study-help/questions/i-will-appreciate-f-3920123" > i will appreciate A paper describes a study in which researchers observed wait times in coffee shops in Boston. Both wait time and gender of the customer were observed. The mean wait time for a... </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star active half">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/study-help/questions/question-10-of-13-you-noticed-that-a-fast-food-1867522" > Question 10 of 13 You noticed that a fast food restaurant's operating cycle is 30 days. Would this suggest the restaurant is selling food beyond its expiration date? Select an answer: No, because the... </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star active half">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/study-help/questions/on-31-december-20x0-the-inventory-of-v-was-completely-1876592" > On 31 December 20X0 the inventory of V was completely destroyed by fire. The following information is available: Inventory at 1 December 20X0 at cost GHS28,400. Purchases for December 20X0 GHS49,600.... </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star active half">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/study-help/questions/-1881823" > Sandhill Company offers a five-year warranty on its products. Sandhill previously estimated warranty costs to be 3% of sales but in 2025 revised this estimate to 1% due to process and quality control... </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star active half">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/study-help/questions/wa-cost-assignment-louvre-corp-applies-the-weighted-average-method-1883747" > WA cost assignment Louvre Corp. applies the weighted average method for process costing. The following production and cost per EUP data are available for Louvre Corp. for February: Units completed... </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star active half">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/study-help/questions/the-december-31-2021-adjusted-trial-balance-for-the-blueboy-1887803" > The December 31, 2021, adjusted trial balance for the Blueboy Cheese Corporation is presented below. Account Title Cash Debits 55,000 Credits Accounts receivable 275,000 Prepaid rent 7,500 Inventory... </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star active half">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/study-help/intercultural-communication/3-what-kinds-of-presentations-do-you-think-would-work-2117214" > 3 What kinds of presentations do you think would work best as podcasts? What kinds would not work well? Are podcasts useful outside academia? </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star active half">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/study-help/intercultural-communication/consider-your-specific-speech-purposewhat-are-your-objectives-for-your-2117212" > Consider your specific speech purposewhat are your objectives for your informative speech? Now consider what types of presentation aids might help you achieve your purpose. How might you use aids to... </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> <div class="relatedQuestionCart "> <div class="relatedQuestionCartHeader"> <h3>Question</h3> <div class="relatedStarRating"> <span class="star active">★</span><span class="star active">★</span><span class="star active">★</span><span class="star active half">★</span><span class="star">★</span> </div> </div> <a class="relatedQuestionText" href="/study-help/intercultural-communication/2-imagine-that-you-have-to-give-an-informative-speech-2117209" > 2 Imagine that you have to give an informative speech about a sexual topic in front of your nursing class. How would you approach the subject? Would you handle it differently if you were speaking in... </a> <div class="relatedQuestionCartFooter"> <div class="relatedHistory"> <p> Answered: <span>1 week ago</span> </p> </div> </div> </div> </div> </div> </section> <hr class="expert-separator"> <section class="next-previous-button"> <div class="navigationButtons" bis_skin_checked="1"> <a class="previousQuestionButton" href="/study-help/questions/question-number-1-detail-the-study-of-tradeoffs-between-the-8977132">Previous Question</a> <a class="nextQuestionButton" href="/study-help/questions/warren-company-plans-to-depreciate-a-new-building-using-the-8977134">Next Question</a> </div> </section> </div> <div class="promo items-center justify-center hidden" style="margin-left:-15px;"> <div class="app_promo"> <div class="app_promo_headline"> <img class="app_promo_icon" alt="Mobile App Logo" width="40" height="40" loading="lazy" src="includes/images/mobile/finalLogo.png"> <p class="app_promo_title font-sans items-center">View Answer in SolutionInn App</p> </div> <button class="app_promo_action redirection question_open_url='q_id=8977133&q_type=2'"> Download on the App Store </button> <button class="btn btn-default app_promo_dismiss"> Continue with the mobile website </button> </div> </div> </main> </div> <div class="blank-portion"></div> <footer> <div class="container footerHolder"> <div class="footerLinksFlex"> <div class="footerLinksCol col-md-3 col-lg-3 col-sm-6 col-6"> <p>Services</p> <ul> <li><a href="/site-map">Sitemap</a></li> <li><a href="/fun/">Fun</a></li> <li><a href="/study-help/definitions">Definitions</a></li> <li><a href="/tutors/become-a-tutor">Become Tutor</a></li> <li><a href="/study-help/categories">Study Help Categories</a></li> <li><a href="/study-help/latest-questions">Recent Questions</a></li> <li><a href="/study-help/questions-and-answers">Expert Questions</a></li> </ul> </div> <div class="footerLinksCol col-md-3 col-lg-3 col-sm-6 col-6"> <p>Company Info</p> <ul> <li><a href="/security">Security</a></li> <li><a href="/copyrights">Copyrights</a></li> <li><a href="/privacy">Privacy Policy</a></li> <li><a href="/conditions">Terms & Conditions</a></li> <li><a href="/solutioninn-fee">SolutionInn Fee</a></li> <li><a href="/scholarships">Scholarship</a></li> </ul> </div> <div class="footerLinksCol col-md-3 col-lg-3 col-sm-6 col-6"> <p>Get In Touch</p> <ul> <li><a href="/about-us">About Us</a></li> <li><a href="/support">Contact Us</a></li> <li><a href="/career">Career</a></li> <li><a href="/jobs">Jobs</a></li> <li><a href="/support">FAQ</a></li> <li><a href="/campus-ambassador-program">Campus Ambassador</a></li> </ul> </div> <div class="footerLinksCol col-md-3 col-lg-3 col-sm-6 col-12"> <p>Secure Payment</p> <div class="footerAppDownloadRow"> <div class="downloadLinkHolder"> <img src="https://dsd5zvtm8ll6.cloudfront.net/includes/images/rewamp/common/footer/secure_payment_method.png" class="img-fluid mb-3" width="243" height="28" alt="payment-verified-icon" loading="lazy"> </div> </div> <p>Download Our App</p> <div class="footerAppDownloadRow"> <div class="downloadLinkHolder mobileAppDownload col-md-6 col-lg-6 col-sm-6 col-6"> <img style="cursor:pointer;" src="https://dsd5zvtm8ll6.cloudfront.net/includes/images/rewamp/home_page/google-play-svg.svg" alt="SolutionInn - Study Help App for Android" width="116" height="40" class="img-fluid mb-3 redirection " app_type="1" loading="lazy"> </div> <div class="downloadLinkHolder mobileAppDownload col-md-6 col-lg-6 col-sm-6 col-6"> <img style="cursor:pointer;" src="https://dsd5zvtm8ll6.cloudfront.net/includes/images/rewamp/home_page/apple-store-download-icon.svg" alt="SolutionInn - Study Help App for iOS" width="116" height="40" class="img-fluid mb-3 redirection" app_type="2" loading="lazy"> </div> </div> </div> </div> </div> <div class="footer-bottom"> <p>© 2024 SolutionInn. All Rights Reserved</p> </div></footer> <script defer> window.addEventListener("load",function(){jQuery(document).ready(function(t){t.ajax({type:"POST",url:"/",data:{trackUserActivity:!0,reqUri:document.URL,referer:document.referrer},success:function(t){}})})},!1),window.addEventListener("load",function(){jQuery(document).ready(function(t){t.ajax({type:"POST",url:"/",data:{insertCrawler:!0,reqUri:document.URL,parseTime:"0.056",queryTime:"0.01654768548584",queryCount:"30"},success:function(t){}})})},!1),window.addEventListener("load",function(){jQuery(document).ready(function(){function t(t="",n=!1){var i="itms-apps://itunes.apple.com/app/id6462455425",e="openApp://action?"+t;isAndroid()?(setTimeout(function(){return window.location="market://details?id=com.solutioninn.studyhelp",!1},25),window.location=e):isIOS()?(setTimeout(function(){return window.location=i,!1},25),window.location=e):(i="https://apps.apple.com/in/app/id6462455425",n&&(i="https://play.google.com/store/apps/details?id=com.solutioninn.studyhelp"),window.open("about:blank","_blank").location.href=i)}jQuery("#appModal").modal("show"),jQuery(".download-app-btn").click(function(){t(jQuery(this).attr("question_open_url"))}),jQuery(".redirection").click(function(){var n=jQuery(this).attr("question_open_url"),i=jQuery(this).attr("app_type");void 0!=n?1==i?t(n,!0):t(n,!1):1==i?t("",!0):t("",!1)}),jQuery(".app-notification-close").click(function(){jQuery(".app-notification-section").css("visibility","hidden");var t=new FormData;t.append("hide_notification",!0),jQuery.ajax({type:"POST",url:"/",data:t,cache:!1,contentType:!1,processData:!1,beforeSend:function(){},success:function(t){location.reload()}})})})},!1); </script> </body> </html>