Hello Coders, here are not a very new topic for the experienced people but a very interesting topic for beginners who are always confused with these function as I mention on heading.
Today I elaborate all these with some small examples, I think you all understand very well after reading that one time. So let’s start.
Here is a table for better understanding, Suppose this is MySQL table and there is one row.
mytable.sql
id | username | password |
---|---|---|
1 | phpcodertech | 123456 |
mysql_fetch_row()
This function as the name suggests giving rows of the data which we set in the query. But one thing the values will come in order as we define on the query and indexed start with 0 and end with less than a number of selected column.
Here is the example which shows you how this is implemented on the code.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
<span class="pun"><?</span><span class="pln">php <strong>//this is you connection file included</strong> include</span><span class="pun">(</span><span class="str">'connect.php'</span><span class="pun">); </span><span class="pln"> $query</span><span class="pun">=</span><span class="pln">mysql_query</span><span class="pun">(</span><span class="str">"select * from mytable"</span><span class="pun">);</span><span class="pln"> $row</span><span class="pun">=</span><span class="pln">mysql_fetch_row</span><span class="pun">(</span><span class="pln">$query</span><span class="pun">); </span><span class="pln"><strong>//fething their data using array index</strong> echo $row</span><span class="pun">[</span><span class="lit">0</span><span class="pun">];</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="lit">1</span><span class="pun">];</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="lit">2</span><span class="pun">]; </span> <span style="color: #339966"><strong>Output: <span style="color: #333333">1 phpcodertech 123456</span></strong></span> <span class="pun">?></span> |
mysql_fetch_aasoc()
This is the second PHP function which is also used for data fetching but with different format. This is also called ASSOCIATIVE array format. Means on this array, all elements have their name with values. We fetch all value using their field name.
Like the following example,
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
<span class="pun"><?</span><span class="pln">php include</span><span class="pun">(</span><span class="str">'connect.php'</span><span class="pun">);</span><span class="pln"> $query</span><span class="pun">=</span><span class="pln">mysql_query</span><span class="pun">(</span><span class="str">"select * from mytable"</span><span class="pun">); </span><span class="pln"> <strong>//This is how we use this function</strong> $row</span><span class="pun">=</span><span class="pln">mysql_fetch_assoc</span><span class="pun">(</span><span class="pln">$query</span><span class="pun">); </span><span class="pln"> <strong>//after query fetching data using their field name</strong> echo $row</span><span class="pun">[</span><span class="str">'id'</span><span class="pun">];</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="str">'username'</span><span class="pun">];</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="str">'password'</span><span class="pun">]; <span style="color: #008000"><strong>Output: <span style="color: #333333">1 phpcodertech 123456</span></strong></span></span> <span class="pun">?></span> |
mysql_fetch_object()
All the above functions are using for fetch data from the database but with a different type. This function also does the same but fetch data from database using Object type. Please the example below for better understand.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
<span class="pun"><?</span><span class="pln">php include</span><span class="pun">(</span><span class="str">'connect.php'</span><span class="pun">);</span><span class="pln"> $query</span><span class="pun">=</span><span class="pln">mysql_query</span><span class="pun">(</span><span class="str">"select * from mytable"</span><span class="pun">); </span><span class="pln"><strong>//this is the source how we implement it</strong> $row</span><span class="pun">=</span><span class="pln">mysql_fetch_object</span><span class="pun">(</span><span class="pln">$query</span><span class="pun">); </span><span class="pln"> <strong>//on this fetch using object type</strong> echo $row</span><span class="pun">-></span><span class="pln">id</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">username</span><span class="pun">;</span><span class="pln"> echo $row</span><span class="pun">-></span><span class="pln">password</span><span class="pun">; </span> <span style="color: #008000"><strong>Output: <span style="color: #333333">1 phpcodertech 123456</span></strong></span> <span class="pun">?></span> |
mysql_fetch_array()
This function, fetch result from a database as an associative array, index numeric array and both numeric and associative at the same code.
See here on the example,
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
<span class="pun"><?</span><span class="pln">php include</span><span class="pun">(</span><span class="str">'connect.php'</span><span class="pun">);</span><span class="pln"> $query</span><span class="pun">=</span><span class="pln">mysql_query</span><span class="pun">(</span><span class="str">"select * from tb"</span><span class="pun">); </span><span class="pln"> $row</span><span class="pun">=</span><span class="pln">mysql_fetch_array</span><span class="pun">(</span><span class="pln">$query</span><span class="pun">);</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="str">'id'</span><span class="pun">];</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="str">'username'</span><span class="pun">];</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="str">'password'</span><span class="pun">];</span> <strong><span class="com">//On this both numeric and associative array will work</span></strong><span class="pln"> echo $row</span><span class="pun">[</span><span class="lit">0</span><span class="pun">];</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="lit">1</span><span class="pun">];</span><span class="pln"> echo $row</span><span class="pun">[</span><span class="lit">2</span><span class="pun">];</span> <span class="pun">?></span> |
Above all are the difference between these function, check if you have some improvements than please comment below.
Happy Coding…!