{"id":3317,"date":"2016-07-17T07:36:19","date_gmt":"2016-07-17T07:36:19","guid":{"rendered":"https:\/\/kiencang.net\/?p=3317"},"modified":"2016-07-17T07:36:19","modified_gmt":"2016-07-17T07:36:19","slug":"gioi-han-du-lieu-lua-chon-trong-mysql-va-php","status":"publish","type":"post","link":"https:\/\/kiencang.net\/gioi-han-du-lieu-lua-chon-trong-mysql-va-php\/","title":{"rendered":"Gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u l\u1ef1a ch\u1ecdn trong MySQL v\u00e0 PHP"},"content":{"rendered":"\n<p>MySQL cung c\u1ea5p c\u00e2u l\u1ec7nh LIMIT s\u1eed d\u1ee5ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh s\u1ed1 b\u1ea3n ghi d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1.<\/p>\n\n\n\n<p>C\u00e2u l\u1ec7nh LIMIT gi\u00fap d\u1ec5 d\u00e0ng cho vi\u1ec7c code cho nhi\u1ec1u trang k\u1ebft qu\u1ea3 ho\u1eb7c \u0111\u00e1nh s\u1ed1 trang v\u1edbi SQL, v\u00e0 n\u00f3 r\u1ea5t h\u1eefu d\u1ee5ng cho c\u00e1c b\u1ea3ng l\u1edbn. Tr\u1ea3 v\u1ec1 l\u01b0\u1ee3ng l\u1edbn b\u1ea3n ghi c\u00f3 th\u1ec3 l\u00e0m gi\u1ea3m hi\u1ec7u su\u1ea5t.<\/p>\n\n\n\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta mu\u1ed1n ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c h\u1ed3 s\u01a1 1-30 (bao g\u1ed3m) t\u1eeb m\u1ed9t b\u1ea3ng g\u1ecdi l\u00e0 &#8220;Orders&#8221;. C\u00e1c truy v\u1ea5n SQL sau \u0111\u00f3 s\u1ebd tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$sql = \"SELECT * FROM Orders LIMIT 30\";<\/code><\/pre>\n\n\n\n<p>Khi c\u00e2u l\u1ec7nh SQL \u1edf tr\u00ean ch\u1ea1y, n\u00f3 s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 30 b\u1ea3n ghi \u0111\u1ea7u ti\u00ean.<\/p>\n\n\n\n<p>N\u1ebfu ch\u00fang ta ch\u1ec9 mu\u1ed1n l\u1ef1a ch\u1ecdn c\u00e1c b\u1ea3n ghi t\u1eeb 16 t\u1edbi 25 th\u00ec l\u00e0m th\u1ebf n\u00e0o?<\/p>\n\n\n\n<p>MySQL c\u0169ng cung c\u1ea5p m\u1ed9t c\u00e1ch \u0111\u1ec3 x\u1eed l\u00fd \u0111i\u1ec1u n\u00e0y: s\u1eed d\u1ee5ng l\u1ec7nh OFFSET.<\/p>\n\n\n\n<p>C\u00e2u l\u1ec7nh SQL b\u00ean d\u01b0\u1edbi n\u00f3i r\u1eb1ng &#8220;tr\u1ea3 v\u1ec1 ch\u1ec9 10 b\u1ea3n ghi, b\u1eaft \u0111\u1ea7u t\u1eeb b\u1ea3n ghi 16 (OFFSET 15)&#8221;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$sql = \"SELECT * FROM Orders LIMIT 10 OFFSET 15\";<\/code><\/pre>\n\n\n\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00fa ph\u00e1p r\u00fat g\u1ecdn \u0111\u1ec3 \u0111\u1ea1t c\u00f9ng k\u1ebft qu\u1ea3:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$sql = \"SELECT * FROM Orders LIMIT 15, 10\";<\/code><\/pre>\n\n\n\n<p>Ch\u00fa \u00fd c\u00e1c con s\u1ed1 b\u1ecb \u0111\u1ea3o ng\u01b0\u1ee3c khi b\u1ea1n s\u1eed d\u1ee5ng d\u1ea5u ph\u1ea9y.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL cung c\u1ea5p c\u00e2u l\u1ec7nh LIMIT s\u1eed d\u1ee5ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh s\u1ed1 b\u1ea3n ghi d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1. C\u00e2u l\u1ec7nh LIMIT gi\u00fap d\u1ec5 d\u00e0ng cho vi\u1ec7c code cho nhi\u1ec1u trang k\u1ebft qu\u1ea3 ho\u1eb7c \u0111\u00e1nh s\u1ed1 trang v\u1edbi SQL, v\u00e0 n\u00f3 r\u1ea5t h\u1eefu d\u1ee5ng cho c\u00e1c b\u1ea3ng l\u1edbn. Tr\u1ea3 v\u1ec1 l\u01b0\u1ee3ng l\u1edbn b\u1ea3n ghi c\u00f3 th\u1ec3 &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[238],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u l\u1ef1a ch\u1ecdn trong MySQL v\u00e0 PHP &#8226; Ki\u1ebfn c\u00e0ng<\/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:\/\/kiencang.net\/gioi-han-du-lieu-lua-chon-trong-mysql-va-php\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u l\u1ef1a ch\u1ecdn trong MySQL v\u00e0 PHP &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"MySQL cung c\u1ea5p c\u00e2u l\u1ec7nh LIMIT s\u1eed d\u1ee5ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh s\u1ed1 b\u1ea3n ghi d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1. C\u00e2u l\u1ec7nh LIMIT gi\u00fap d\u1ec5 d\u00e0ng cho vi\u1ec7c code cho nhi\u1ec1u trang k\u1ebft qu\u1ea3 ho\u1eb7c \u0111\u00e1nh s\u1ed1 trang v\u1edbi SQL, v\u00e0 n\u00f3 r\u1ea5t h\u1eefu d\u1ee5ng cho c\u00e1c b\u1ea3ng l\u1edbn. Tr\u1ea3 v\u1ec1 l\u01b0\u1ee3ng l\u1edbn b\u1ea3n ghi c\u00f3 th\u1ec3 &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/gioi-han-du-lieu-lua-chon-trong-mysql-va-php\/\" \/>\n<meta property=\"og:site_name\" content=\"Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anhducnguyen87\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-17T07:36:19+00:00\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u l\u1ef1a ch\u1ecdn trong MySQL v\u00e0 PHP &#8226; Ki\u1ebfn c\u00e0ng","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:\/\/kiencang.net\/gioi-han-du-lieu-lua-chon-trong-mysql-va-php\/","og_locale":"vi_VN","og_type":"article","og_title":"Gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u l\u1ef1a ch\u1ecdn trong MySQL v\u00e0 PHP &#8226; Ki\u1ebfn c\u00e0ng","og_description":"MySQL cung c\u1ea5p c\u00e2u l\u1ec7nh LIMIT s\u1eed d\u1ee5ng \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh s\u1ed1 b\u1ea3n ghi d\u1eef li\u1ec7u tr\u1ea3 v\u1ec1. C\u00e2u l\u1ec7nh LIMIT gi\u00fap d\u1ec5 d\u00e0ng cho vi\u1ec7c code cho nhi\u1ec1u trang k\u1ebft qu\u1ea3 ho\u1eb7c \u0111\u00e1nh s\u1ed1 trang v\u1edbi SQL, v\u00e0 n\u00f3 r\u1ea5t h\u1eefu d\u1ee5ng cho c\u00e1c b\u1ea3ng l\u1edbn. Tr\u1ea3 v\u1ec1 l\u01b0\u1ee3ng l\u1edbn b\u1ea3n ghi c\u00f3 th\u1ec3 &hellip;","og_url":"https:\/\/kiencang.net\/gioi-han-du-lieu-lua-chon-trong-mysql-va-php\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2016-07-17T07:36:19+00:00","author":"Nguy\u1ec5n \u0110\u1ee9c Anh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n \u0110\u1ee9c Anh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"1 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/gioi-han-du-lieu-lua-chon-trong-mysql-va-php\/","url":"https:\/\/kiencang.net\/gioi-han-du-lieu-lua-chon-trong-mysql-va-php\/","name":"Gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u l\u1ef1a ch\u1ecdn trong MySQL v\u00e0 PHP &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2016-07-17T07:36:19+00:00","dateModified":"2016-07-17T07:36:19+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/gioi-han-du-lieu-lua-chon-trong-mysql-va-php\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/gioi-han-du-lieu-lua-chon-trong-mysql-va-php\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/gioi-han-du-lieu-lua-chon-trong-mysql-va-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"Gi\u1edbi h\u1ea1n d\u1eef li\u1ec7u l\u1ef1a ch\u1ecdn trong MySQL v\u00e0 PHP"}]},{"@type":"WebSite","@id":"https:\/\/kiencang.net\/#website","url":"https:\/\/kiencang.net\/","name":"Ki\u1ebfn c\u00e0ng","description":"\u00d4m l\u00fd thuy\u1ebft, h\u00f4n th\u1ef1c h\u00e0nh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kiencang.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16","name":"Nguy\u1ec5n \u0110\u1ee9c Anh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/kiencang.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","caption":"Nguy\u1ec5n \u0110\u1ee9c Anh"},"description":"Sinh n\u0103m 1987, t\u1ed1t nghi\u1ec7p Cao \u0111\u1eb3ng th\u1ef1c h\u00e0nh FPT qu\u00e3ng 2014, chuy\u00ean ng\u00e0nh Thi\u1ebft k\u1ebf website. T\u00f4i th\u00edch Content, SEO, Ads, T\u0103ng t\u1ed1c website v\u00e0 Th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed. B\u00ean c\u1ea1nh b\u00e0i t\u1ef1 vi\u1ebft, t\u00f4i c\u0169ng d\u1ecbch nhi\u1ec1u n\u1ed9i dung th\u00fa v\u1ecb c\u1ee7a c\u00e1c t\u00e1c gi\u1ea3 kh\u00e1c nhau. FB c\u00e1 nh\u00e2n: facebook.com\/anhducnguyen87. Email li\u00ean h\u1ec7: guiemailchotoi@gmail.com","sameAs":["https:\/\/www.facebook.com\/anhducnguyen87\/"],"url":"https:\/\/kiencang.net\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3317"}],"collection":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/comments?post=3317"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3317\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=3317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=3317"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=3317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}