{"id":234,"date":"2020-12-06T15:33:32","date_gmt":"2020-12-06T10:03:32","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=234"},"modified":"2021-01-08T17:44:59","modified_gmt":"2021-01-08T12:14:59","slug":"php-mysql-count-no-of-rows","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/php-mysql-count-no-of-rows\/","title":{"rendered":"No. of Rows Count"},"content":{"rendered":"\n<p class=\"wp-block-zozuk-wphindi\">MySQL Query Execute \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u091c\u094b \u0930\u093f\u091c\u0932\u094d\u091f \u0906\u092f\u093e, \u0909\u0938\u0915\u0940 No of Rows Count \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e \u0907\u0938 \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u091c\u0948\u0938\u093e \u0915\u0940 \u0906\u092a \u092a\u094d\u0930\u0949\u092c\u094d\u0932\u092e \u092b\u0947\u0938 \u0915\u0930\u0924\u0947 \u0939\u094b\u0902\u0917\u0947 \u0915\u0940 \u092f\u0926\u093f \u0915\u093f\u0938\u0940 SQL&nbsp; \u0938\u0947 \u0915\u094b\u0908 \u092d\u0940 row return&nbsp; \u0928\u0939\u0940\u0902 \u0939\u0941\u090f \u0939\u094b \u0924\u094b \u0939\u092e\u0947\u0902 \u0935\u0939 \u092a\u0930 \u0915\u0941\u091b \u0914\u0930 HTML&nbsp; \u0936\u094b \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0914\u0930 \u092f\u0926\u093f rows&nbsp; return&nbsp; \u0939\u0941\u090f \u0939\u094b \u0924\u094b \u0939\u092e\u0947\u0902 rows&nbsp; \u0915\u093e \u0921\u093e\u091f\u093e \u0936\u094b \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">$rowcount \u0935\u0947\u0930\u093f\u090f\u092c\u0932 \u092e\u0947\u0902 \u0915\u093e\u0909\u0902\u091f \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0906 \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 \u0907\u0938\u0915\u0940 \u092c\u0947\u0938 \u092a\u0930 \u0939\u092e condition&nbsp; \u0932\u0917\u093e \u0915\u0930 \u0906\u0917\u0947 \u0915\u0940 coding&nbsp; \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<h3 class=\"has-black-color has-text-color wp-block-heading\">Return Rows Count<\/h3>\n\n\n\n<pre title=\"Return no of Rows\" class=\"wp-block-code\"><code lang=\"php\" class=\"language-php\">&lt;?php\n\ninclude(\"dbcmd.php\");\n\n$dbc = new DBCmd();\n$con = $dbc->connect();\n\n$ls_SQL = \"SELECT List of Columns FROM TableName WHERE whereclause\"; \n$result = $dbc->query($ls_SQL);\n$rowcount=mysqli_num_rows($result);\n\necho \"Count No. Of Rows Return : $rowcount\";\n\n$dbc->close();\n?><\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0939\u092e\u0928\u0947 \u092f\u0939\u093e\u0901 \u092a\u0930 \u0938\u092e\u091d\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0938\u093f\u0930\u094d\u092b \u0909\u0924\u0928\u093e \u0939\u0940 \u092a\u093e\u0930\u094d\u091f \u092c\u0924\u093e\u092f\u093e \u0939\u0948\u0902 \u092f\u0926\u093f \u0906\u092a\u0915\u094b \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u0915\u0928\u0947\u0915\u094d\u0936\u0928 \u0938\u0947 Related  Coding  \u091a\u093e\u0939\u093f\u090f \u0924\u094b \u0906\u092a <a href=\"https:\/\/selfimagination.in\/tips\/dbcmd\/\">\u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964<\/a><\/p>\n\n\n\n<div style=\"height:27px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"has-black-color has-text-color wp-block-heading\">Rows Affected Count<\/h3>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u091c\u092c \u092d\u0940 \u0939\u092e \u0915\u094b\u0908 MySQL \u092e\u0947\u0902 \u0905\u092a\u0921\u0947\u091f \u091a\u0932\u093e\u0924\u0947  \u0939\u0948\u0902 \u0924\u094b \u0909\u0938 \u0905\u092a\u0921\u0947\u091f \u0938\u0947 \u0915\u093f\u0924\u0928\u0947 Rows \u092e\u0947\u0902 Change \u0906\u092f\u0947 \u092f\u0939 \u092a\u0924\u093e \u0932\u0917\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e \u0907\u0938 \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">Query&nbsp; Execution&nbsp; \u0915\u0947 \u091c\u0938\u094d\u091f \u092c\u093e\u0926 \u092e\u0947\u0902 \u0939\u0940 \u0906\u092a\u0915\u094b \u092f\u0939 \u092b\u0902\u0915\u094d\u0936\u0928 \u0915\u0949\u0932 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u092f\u0926\u093f \u0907\u0938 \u092c\u093f\u091a \u092e\u0947\u0902 \u0915\u094b\u0908 \u0914\u0930 Update SQL Execute \u0939\u0941\u090f \u0924\u094b \u092f\u0939 \u092c\u093e\u0926 \u0935\u093e\u0932\u0947 Query \u0915\u0947 \u0905\u092a\u0921\u0947\u091f \u0915\u093e\u0909\u0902\u091f \u092c\u0924\u093e\u0928\u0947 \u0932\u0917\u0947\u0917\u093e\u0964 <\/p>\n\n\n\n<pre title=\"Count Affected Rows\" class=\"wp-block-code\"><code lang=\"php\" class=\"language-php\">$dbc-&gt;query($query);\necho  mysqli_affected_rows($con);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0926\u093f \u0906\u092a \u0928\u0947 \u0905\u092d\u0940 \u0905\u092d\u0940 coding&nbsp; \u0915\u0930\u0928\u093e start&nbsp; \u0915\u093f\u092f\u093e \u0939\u094b \u0914\u0930 \u0906\u092a <a href=\"https:\/\/blog.sql.selfimagination.in\/\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL \u0938\u0940\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u094b \u0924\u094b , \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964<\/a><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939 SELECT, INSERT, UPDATE, and DELETE \u0938\u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0940 Queries \u0915\u0947 \u092c\u093e\u0926 Affected&nbsp;Rows \u0915\u093e\u0909\u0902\u091f \u0915\u0930\u0924\u093e \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u091c\u092c \u092d\u0940 \u0939\u092e PHP \u0915\u093e \u0915\u094b\u0908 \u092b\u0949\u0930\u094d\u092e \u092c\u0928\u093e\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0921\u0947\u091f\u093e\u092c\u0947\u0938 \u0938\u0947 \u0930\u093f\u0932\u0947\u091f\u0947\u0921 coding&nbsp; \u0915\u0930\u0924\u0947 \u0938\u092e\u092f \u0939\u092e\u0947\u0902 \u092c\u0939\u0941\u0924 \u0938\u0940 \u0915\u092e\u093e\u0902\u0921 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u091c\u093f\u0938\u0938\u0947 \u0939\u092e \u0915\u092e coding&nbsp; \u092e\u0947\u0902 \u0930\u093f\u091c\u0932\u094d\u091f \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0915\u0930 \u0938\u0915\u0947\u0964 <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">mysqli_num_rows and mysqli_affected_rows \u0907\u0938\u0940 \u0915\u093e Example&nbsp; \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Return Rows Count Rows Affected Count<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3,5],"tags":[],"class_list":["post-234","post","type-post","status-publish","format-standard","hentry","category-php","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=234"}],"version-history":[{"count":27,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/234\/revisions"}],"predecessor-version":[{"id":506,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/234\/revisions\/506"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}