{"id":13587,"date":"2024-03-15T07:27:11","date_gmt":"2024-03-15T07:27:11","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/"},"modified":"2025-08-05T20:37:08","modified_gmt":"2025-08-05T20:37:08","slug":"what-is-the-function-of-mysqli_num_rows-in-php","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/","title":{"rendered":"mysqli_num_rows PHP Function: Usage Guide"},"content":{"rendered":"<p>The mysqli_num_rows function in PHP is used to retrieve the number of rows in a MySQL query result. It takes a MySQLi result object as a parameter and returns the number of rows in the result set.<\/p>\n<p>The syntax of the function is as follows:<\/p>\n<pre class=\"post-pre\"><code class=\"lang-php\">mysqli_num_rows(mysqli_result $result): int|false\r\n<\/code><\/pre>\n<p>$result is a MySQLi result object which can be obtained by executing an SQL query and using the mysqli_query function. The function will return an integer value indicating the number of rows in the result set, or return false if an error occurs.<\/p>\n<p>Here is an example demonstrating how to use the mysqli_num_rows function to get the number of rows in a query result.<\/p>\n<pre class=\"post-pre\"><code class=\"lang-php\">\/\/ \u8fde\u63a5\u5230\u6570\u636e\u5e93\r\n$connection = mysqli_connect(\"localhost\", \"username\", \"password\", \"database\");\r\n\r\n\/\/ \u6267\u884c\u67e5\u8be2\r\n$query = \"SELECT * FROM users\";\r\n$result = mysqli_query($connection, $query);\r\n\r\n\/\/ \u83b7\u53d6\u884c\u6570\r\nif ($result) {\r\n    $numRows = mysqli_num_rows($result);\r\n    echo \"\u67e5\u8be2\u5230 {$numRows} \u884c\u6570\u636e\";\r\n} else {\r\n    echo \"\u67e5\u8be2\u5931\u8d25\";\r\n}\r\n\r\n\/\/ \u5173\u95ed\u8fde\u63a5\r\nmysqli_close($connection);\r\n<\/code><\/pre>\n<p>By using the mysqli_num_rows function, we can easily obtain the number of rows in the query result and process it accordingly. This is very useful for determining if the query result is empty or calculating the number of rows in the result set.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The mysqli_num_rows function in PHP is used to retrieve the number of rows in a MySQL query result. It takes a MySQLi result object as a parameter and returns the number of rows in the result set. The syntax of the function is as follows: mysqli_num_rows(mysqli_result $result): int|false $result is a MySQLi result object which [&hellip;]<\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[284,298,16077,660,18128],"class_list":["post-13587","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database","tag-mysql","tag-mysqli_num_rows","tag-php","tag-row-count"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>mysqli_num_rows PHP Function: Usage Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to use mysqli_num_rows() in PHP to count MySQL result rows. Get syntax, examples &amp; best practices.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"mysqli_num_rows PHP Function: Usage Guide\" \/>\n<meta property=\"og:description\" content=\"Learn how to use mysqli_num_rows() in PHP to count MySQL result rows. Get syntax, examples &amp; best practices.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T07:27:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-05T20:37:08+00:00\" \/>\n<meta name=\"author\" content=\"Olivia Parker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Olivia Parker\" \/>\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:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/\"},\"author\":{\"name\":\"Olivia Parker\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\"},\"headline\":\"mysqli_num_rows PHP Function: Usage Guide\",\"datePublished\":\"2024-03-15T07:27:11+00:00\",\"dateModified\":\"2025-08-05T20:37:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/\"},\"wordCount\":166,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database\",\"MySQL\",\"mysqli_num_rows\",\"PHP\",\"row count\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/\",\"name\":\"mysqli_num_rows PHP Function: Usage Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T07:27:11+00:00\",\"dateModified\":\"2025-08-05T20:37:08+00:00\",\"description\":\"Learn how to use mysqli_num_rows() in PHP to count MySQL result rows. Get syntax, examples & best practices.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"mysqli_num_rows PHP Function: Usage Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9\",\"name\":\"Olivia Parker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g\",\"caption\":\"Olivia Parker\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"mysqli_num_rows PHP Function: Usage Guide - Blog - Silicon Cloud","description":"Learn how to use mysqli_num_rows() in PHP to count MySQL result rows. Get syntax, examples & best practices.","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:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/","og_locale":"en_US","og_type":"article","og_title":"mysqli_num_rows PHP Function: Usage Guide","og_description":"Learn how to use mysqli_num_rows() in PHP to count MySQL result rows. Get syntax, examples & best practices.","og_url":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T07:27:11+00:00","article_modified_time":"2025-08-05T20:37:08+00:00","author":"Olivia Parker","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Olivia Parker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/"},"author":{"name":"Olivia Parker","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9"},"headline":"mysqli_num_rows PHP Function: Usage Guide","datePublished":"2024-03-15T07:27:11+00:00","dateModified":"2025-08-05T20:37:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/"},"wordCount":166,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database","MySQL","mysqli_num_rows","PHP","row count"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/","url":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/","name":"mysqli_num_rows PHP Function: Usage Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T07:27:11+00:00","dateModified":"2025-08-05T20:37:08+00:00","description":"Learn how to use mysqli_num_rows() in PHP to count MySQL result rows. Get syntax, examples & best practices.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-function-of-mysqli_num_rows-in-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"mysqli_num_rows PHP Function: Usage Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3ff7b3da0e45ac5dbbef2502f3cea8d9","name":"Olivia Parker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/56c66f189ba32a6f9eb50f31a38fe774e2a725c213d4070835ccc51b8fbbc54b?s=96&d=mm&r=g","caption":"Olivia Parker"},"url":"https:\/\/www.silicloud.com\/blog\/author\/oliviaparker\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13587","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=13587"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13587\/revisions"}],"predecessor-version":[{"id":157582,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/13587\/revisions\/157582"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=13587"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=13587"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=13587"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}