{"id":8390,"date":"2022-09-13T09:04:39","date_gmt":"2022-09-13T03:34:39","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/"},"modified":"2022-09-13T09:04:39","modified_gmt":"2022-09-13T03:34:39","slug":"solved-create-top-ten-list-of-items-in-php-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/","title":{"rendered":"[Solved] Create top ten list of items in php [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-14135738\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"14135738\" data-parentid=\"14135574\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>To do this, first you must get the movies from the database and list them.<\/p>\n<p>For example, a simple select-query that selects all the movies and shows them to the user using a while-loop.<\/p>\n<pre><code>$get_movies = mysqli_query(\"SELECT * FROM `movies`\");\n\nwhile($row_movies = mysql_fetch_array($get_movies);)\n{\necho $row_movies['title'];\n}\n<\/code><\/pre>\n<p>You then allow the user to rate the movies, using a select-box that you can show on the same row.<\/p>\n<p>Now, when the user selects, say for example 4; you save that value to the database (using javascript to automatically post the form), and reload the page. The next time the list loads, the select-boxes contain every number from 1 &#8211; 10, except for 4 since it&#8217;s already been used. You can also use <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/www.w3schools.com\/ajax\/default.asp\">AJAX<\/a> to do this.<\/p>\n<p>Of course, you will need a column in the database that holds the rating of the movie. And also, to make sure that the correct row is selected, you can always create one form per row holding the ID of the movie in a hidden field.<\/p>\n<p>To ensure that the user doesn&#8217;t cheat your script by de-activating javascript, you can always filter your script using PHP to make sure that there is only one form being sent, and to make sure that the ID actually exists in your database. And also, don&#8217;t forget to escape the strings used in your mysql queries.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\"><\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Create top ten list of items in php [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] To do this, first you must get the movies from the database and list them. For example, a simple select-query that selects all the movies and shows them to the user using a while-loop. $get_movies = mysqli_query(&#8220;SELECT * FROM `movies`&#8221;); while($row_movies = mysql_fetch_array($get_movies);) { echo $row_movies[&#8216;title&#8217;]; } You then allow the user to rate &#8230; <a title=\"[Solved] Create top ten list of items in php [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/\" aria-label=\"More on [Solved] Create top ten list of items in php [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[339],"class_list":["post-8390","post","type-post","status-publish","format-standard","hentry","category-solved","tag-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Create top ten list of items in php [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Create top ten list of items in php [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] To do this, first you must get the movies from the database and list them. For example, a simple select-query that selects all the movies and shows them to the user using a while-loop. $get_movies = mysqli_query(&quot;SELECT * FROM `movies`&quot;); while($row_movies = mysql_fetch_array($get_movies);) { echo $row_movies[&#039;title&#039;]; } You then allow the user to rate ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-13T03:34:39+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Create top ten list of items in php [closed]\",\"datePublished\":\"2022-09-13T03:34:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/\"},\"wordCount\":235,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/\",\"name\":\"[Solved] Create top ten list of items in php [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-13T03:34:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Create top ten list of items in php [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Create top ten list of items in php [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Create top ten list of items in php [closed] - JassWeb","og_description":"[ad_1] To do this, first you must get the movies from the database and list them. For example, a simple select-query that selects all the movies and shows them to the user using a while-loop. $get_movies = mysqli_query(\"SELECT * FROM `movies`\"); while($row_movies = mysql_fetch_array($get_movies);) { echo $row_movies['title']; } You then allow the user to rate ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/","og_site_name":"JassWeb","article_published_time":"2022-09-13T03:34:39+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Create top ten list of items in php [closed]","datePublished":"2022-09-13T03:34:39+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/"},"wordCount":235,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/","name":"[Solved] Create top ten list of items in php [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-13T03:34:39+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-create-top-ten-list-of-items-in-php-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Create top ten list of items in php [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/8390","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=8390"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/8390\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=8390"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=8390"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=8390"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}