{"id":15011,"date":"2021-09-20T14:12:36","date_gmt":"2021-09-20T14:12:36","guid":{"rendered":"https:\/\/freehost.page\/?p=15011"},"modified":"2021-09-20T14:12:36","modified_gmt":"2021-09-20T14:12:36","slug":"php-lay-nhanh-data","status":"publish","type":"post","link":"https:\/\/kiencang.net\/php-lay-nhanh-data\/","title":{"rendered":"T\u1ea1o h\u00e0m PHP l\u1ea5y d\u1eef li\u1ec7u nhanh t\u1eeb b\u1ea3ng CSDL"},"content":{"rendered":"\n<p>N\u1ebfu b\u1ea1n hay ph\u1ea3i thao t\u00e1c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u th\u00ec \u0111\u00e2y c\u00f3 th\u1ec3 l\u00e0 c\u00e1ch nhanh g\u1ecdn \u0111\u1ec3 l\u1ea5y data. N\u00f3 l\u00e0 c\u00e1ch kh\u00e1 l\u01b0\u1eddi bi\u1ebfng, nh\u01b0ng c\u00f3 t\u00e1c d\u1ee5ng.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&lt;?php\n\n\/* \n * PHP functions to get data faster v1.2\n * MIT License\n * Nguyen Duc Anh - freehost.page\n *\/\n\n\n\/\/\/====================================================================\n\n\nfunction default_table(){\n    $tab = 'new_data_name'; \/\/ t\u00ean b\u1ea3ng m\u1eb7c \u0111\u1ecbnh\n\nreturn $tab;    \n}\n\n\/\/\/\/\/\/\/\/\/\n\nfunction table($limit) { \/\/ xu\u1ea5t to\u00e0n b\u1ed9 d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng\n    require 'database.php';\n    $tab = default_table();\n\n    if (!is_numeric($limit)) {$limit = 10;}\n\n    if ($limit == -1) {$qr = \"SELECT * FROM $tab\";} \/\/ -1 ngh\u0129a l\u00e0 kh\u00f4ng gi\u1edbi h\u1ea1n s\u1ed1 l\u01b0\u1ee3ng b\u1ea3n ghi, c\u00e1c s\u1ed1 kh\u00e1c th\u00ec tu\u00e2n theo s\u1ed1 \u0111\u00f3\n    else {$qr = \"SELECT * FROM $tab LIMIT $limit\";}\n\n    $rs = $db-&gt;query($qr); \/\/ foreach result \u0111\u1ec3 l\u1ea5y m\u1ed9t t\u00ean c\u1ed9t c\u1ee5 th\u1ec3\n\nreturn $rs;}\n\n\/\/\/==================================================================== End code<\/code><\/pre>\n\n\n\n<ul><li><code>default_table()<\/code> \u0111\u1ec3 thi\u1ebft l\u1eadp t\u00ean m\u1eb7c \u0111\u1ecbnh cho b\u1ea3ng, ph\u00f2ng khi b\u1ea1n c\u00f3 nhi\u1ec1u b\u1ea3ng kh\u00e1c nhau mu\u1ed1n thao t\u00e1c, v\u00e0 thi tho\u1ea3ng mu\u1ed1n thay \u0111\u1ed5i t\u00ean m\u1eb7c \u0111\u1ecbnh n\u00e0y;<\/li><li><code>table($limit)<\/code> ch\u00ednh l\u00e0 data m\u00e0 ta s\u1ebd l\u1ea5y, trong \u0111\u00f3 <code>$limit<\/code> l\u00e0 gi\u1edbi h\u1ea1n s\u1ed1 h\u00e0ng d\u1eef li\u1ec7u;<\/li><li>N\u1ebfu \u0111\u1ea7u v\u00e0o l\u00e0 -1 (<code>$limit<\/code>), v\u00ed d\u1ee5<code> table(-1)<\/code>, ngh\u0129a l\u00e0 b\u1ea1n l\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng d\u1eef li\u1ec7u, t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t.<\/li><li>N\u1ebfu <code>$limit<\/code> nh\u1eadp v\u00e0o kh\u00f4ng ph\u1ea3i s\u1ed1 (do b\u1ea1n thao t\u00e1c nh\u1ea7m) th\u00ec l\u1ea5y gi\u00e1 tr\u1ecb 10.<\/li><li>N\u1ebfu <code>$limit<\/code> l\u00e0 s\u1ed1 c\u1ee5 th\u1ec3, v\u00ed d\u1ee5 1000, th\u00ec c\u00f3 ngh\u0129a l\u00e0 n\u00f3 l\u1ea5y 1000 h\u00e0ng d\u1eef li\u1ec7u;<\/li><li>V\u00ec c\u1ed9t d\u1eef li\u1ec7u c\u1ee7a t\u00f4i \u00edt, n\u00ean t\u00f4i l\u1ea5y c\u1ea3 b\u1ea3ng, b\u1ea1n n\u00e0o th\u00edch c\u00f3 th\u1ec3 \u0111i\u1ec1u ch\u1ec9nh m\u00e3 \u0111\u1ec3 thao t\u00e1c v\u1edbi ch\u1ec9 c\u1ed9t d\u1eef li\u1ec7u m\u00e0 c\u00e1c b\u1ea1n mu\u1ed1n;<\/li><\/ul>\n\n\n\n<p>T\u00f4i c\u00f2n vi\u1ebft th\u00eam hai h\u00e0m kh\u00e1 ng\u1edb ng\u1ea9n d\u01b0\u1edbi \u0111\u00e2y, g\u1ecdi l\u00e0 si\u00eau l\u01b0\u1eddi:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/\/=============================================================================\n\nfunction b() { \/\/ t\u00e1ch d\u00f2ng\n    $rs = '&lt;br&gt;';\n    \nreturn $rs;    \n}\n\n\/\/\/\/\/\/\/\/\/\n\nfunction s() { \/\/ c\u00e1ch nhau\n    $rs = ' | ';\n    \nreturn $rs;    \n}\n\n\/\/\/=============================================================================<\/code><\/pre>\n\n\n\n<p>D\u00f9ng \u0111\u1ec3 xu\u1ed1ng d\u00f2ng nhanh v\u00e0 t\u00e1ch c\u00e1c th\u00f4ng tin. Khi t\u00f4i mu\u1ed1n xu\u1ed1ng d\u00f2ng ch\u1ec9 c\u1ea7n g\u00f5 <code>b()<\/code> th\u1ebf l\u00e0 xong thay v\u00ec <code>'&lt;br&gt;'<\/code>;<\/p>\n\n\n\n<p>D\u0129 nhi\u00ean c\u00e1i n\u00e0y l\u00e0m tr\u00ean localhost v\u00ec l\u01b0\u1eddi th\u00f4i c\u00e1c b\u1ea1n, n\u1ebfu ch\u1ea1y m\u00e3 th\u1ef1c tr\u00ean m\u00e1y ch\u1ee7 tr\u1ef1c tuy\u1ebfn, l\u00e0m th\u1ebf n\u00e0y kh\u00f4ng hay ch\u00fat n\u00e0o v\u00ec \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn hi\u1ec7u su\u1ea5t. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>N\u1ebfu b\u1ea1n hay ph\u1ea3i thao t\u00e1c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u th\u00ec \u0111\u00e2y c\u00f3 th\u1ec3 l\u00e0 c\u00e1ch nhanh g\u1ecdn \u0111\u1ec3 l\u1ea5y data. N\u00f3 l\u00e0 c\u00e1ch kh\u00e1 l\u01b0\u1eddi bi\u1ebfng, nh\u01b0ng c\u00f3 t\u00e1c d\u1ee5ng. default_table() \u0111\u1ec3 thi\u1ebft l\u1eadp t\u00ean m\u1eb7c \u0111\u1ecbnh cho b\u1ea3ng, ph\u00f2ng khi b\u1ea1n c\u00f3 nhi\u1ec1u b\u1ea3ng kh\u00e1c nhau mu\u1ed1n thao t\u00e1c, v\u00e0 thi tho\u1ea3ng mu\u1ed1n &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>T\u1ea1o h\u00e0m PHP l\u1ea5y d\u1eef li\u1ec7u nhanh t\u1eeb b\u1ea3ng CSDL &#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\/php-lay-nhanh-data\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u1ea1o h\u00e0m PHP l\u1ea5y d\u1eef li\u1ec7u nhanh t\u1eeb b\u1ea3ng CSDL &#8226; Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"N\u1ebfu b\u1ea1n hay ph\u1ea3i thao t\u00e1c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u th\u00ec \u0111\u00e2y c\u00f3 th\u1ec3 l\u00e0 c\u00e1ch nhanh g\u1ecdn \u0111\u1ec3 l\u1ea5y data. N\u00f3 l\u00e0 c\u00e1ch kh\u00e1 l\u01b0\u1eddi bi\u1ebfng, nh\u01b0ng c\u00f3 t\u00e1c d\u1ee5ng. default_table() \u0111\u1ec3 thi\u1ebft l\u1eadp t\u00ean m\u1eb7c \u0111\u1ecbnh cho b\u1ea3ng, ph\u00f2ng khi b\u1ea1n c\u00f3 nhi\u1ec1u b\u1ea3ng kh\u00e1c nhau mu\u1ed1n thao t\u00e1c, v\u00e0 thi tho\u1ea3ng mu\u1ed1n &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/php-lay-nhanh-data\/\" \/>\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=\"2021-09-20T14:12:36+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=\"2 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T\u1ea1o h\u00e0m PHP l\u1ea5y d\u1eef li\u1ec7u nhanh t\u1eeb b\u1ea3ng CSDL &#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\/php-lay-nhanh-data\/","og_locale":"vi_VN","og_type":"article","og_title":"T\u1ea1o h\u00e0m PHP l\u1ea5y d\u1eef li\u1ec7u nhanh t\u1eeb b\u1ea3ng CSDL &#8226; Ki\u1ebfn c\u00e0ng","og_description":"N\u1ebfu b\u1ea1n hay ph\u1ea3i thao t\u00e1c v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u th\u00ec \u0111\u00e2y c\u00f3 th\u1ec3 l\u00e0 c\u00e1ch nhanh g\u1ecdn \u0111\u1ec3 l\u1ea5y data. N\u00f3 l\u00e0 c\u00e1ch kh\u00e1 l\u01b0\u1eddi bi\u1ebfng, nh\u01b0ng c\u00f3 t\u00e1c d\u1ee5ng. default_table() \u0111\u1ec3 thi\u1ebft l\u1eadp t\u00ean m\u1eb7c \u0111\u1ecbnh cho b\u1ea3ng, ph\u00f2ng khi b\u1ea1n c\u00f3 nhi\u1ec1u b\u1ea3ng kh\u00e1c nhau mu\u1ed1n thao t\u00e1c, v\u00e0 thi tho\u1ea3ng mu\u1ed1n &hellip;","og_url":"https:\/\/kiencang.net\/php-lay-nhanh-data\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2021-09-20T14:12:36+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":"2 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/php-lay-nhanh-data\/","url":"https:\/\/kiencang.net\/php-lay-nhanh-data\/","name":"T\u1ea1o h\u00e0m PHP l\u1ea5y d\u1eef li\u1ec7u nhanh t\u1eeb b\u1ea3ng CSDL &#8226; Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2021-09-20T14:12:36+00:00","dateModified":"2021-09-20T14:12:36+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/php-lay-nhanh-data\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/php-lay-nhanh-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/php-lay-nhanh-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"T\u1ea1o h\u00e0m PHP l\u1ea5y d\u1eef li\u1ec7u nhanh t\u1eeb b\u1ea3ng CSDL"}]},{"@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\/15011"}],"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=15011"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/15011\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=15011"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=15011"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=15011"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}