In how many ways we can retrieve the date in the result set
of mysql using PHP?
Answers were Sorted based on User's Feedback
Answer / vasan.
4 ways
1. mysql_fetch_rows
2. mysql_fetch_object
3. mysql_fetch_assoc
4. mysql_fetch_array
| Is This Answer Correct ? | 57 Yes | 4 No |
Answer / bijay.behera9911033016@orissa
1. mysqli_fetch_rows
2. mysqli_fetch_object
3. mysqli_fetch_assoc
4. mysqli_fetch_array
| Is This Answer Correct ? | 22 Yes | 4 No |
Answer / ankish kumar
What is the difference between all these 4 versions:
1. mysqli_fetch_rows
2. mysqli_fetch_object
3. mysqli_fetch_assoc
4. mysqli_fetch_array
| Is This Answer Correct ? | 9 Yes | 1 No |
Answer / binoyav
1) mysql_result: returns the value of a field in a recordset.
Note: This function is slower than mysql_fetch_row(), mysql_fetch_array(), mysql_fetch_assoc() and mysql_fetch_object()
2) mysql_fetch_array(): function returns a row from a recordset as an associative array and/or a numeric array. Note: Its a misconception that, this function will return all rows. Its completely wrong, it will return only a single row at a time as like mysql_fetch_row
3) mysql_fetch_row(): returns a row from a recordset as a numeric array
4) mysql_fetch_assoc(): returns a row from a recordset as an associative array. No numerical indices available for this
5) mysql_fetch_object(): returns a row from a recordset as an object
| Is This Answer Correct ? | 2 Yes | 2 No |
please explain me mail function in php
Which php framework is best?
What is the function of mysql_real_escape_string in php?
What is $this in php?
How to delete an element from an array?
How can we know that a session is started or not? Rushmore-Consultancy 3 why we use @symbol before the variable HCL 3 How can you insert javascript in php code? TCS 9 How can you parse files that were not ending with .php by using Apache? 1 What is the difference between InnoDb tables and MyIsam Tables in php 1 Hi all, I have a problem in Apache on windows xp.I tried to unistall apache and install it again. But when in did the installation again, and tried to run apache, i get the following error message, Socketaddresse can just be used once. Make_sock: could not build to address 0.0.0.0.80 No listening sockets available.Shutting down Unable to open logs. and i also get (error) OS2. The system cannot fine the installed service named "Apache2". Please i need some one to help me out with this.I'm really fustrated cuz i need this stuff working as fast as possible. PLEASE HELP ME 2 1.Where are the sessions storing ? 2.What are the contents of a session file ? 3.If the server is loaded with too many session files there is a possibility of server crash. How can we solve this issue? 4. How does php server identify that the particular session belongs to particular user ? For ex: If two users A and B logged from different machine, separate session files (say 1 and 2) will be created in the server. But how the php knows that 1 belongs to A and 2 belongs to B ? TCS 3 How to send Email using PHP with MySQL in Linux Server?.. 3 Write a query to to delete duplicate rows? 3 How i can integrate merchant payment get way in zen cart? in php? plz help me BA-Continnum-Solutions 1 how to maintained the session from one page to another page based on the url and then entered into the first page is logging into instead of secondpage it goes to the another url.ie first login session togoes to the one url and next login session it goes to another url how is it possible in php please give me answer in that question iCynergy 1 Is there a way to encrypt text from php? 4 What’s the difference between sort(), assort() and ksort? Under what circumstances would you use each of these? 1 Write the code for upload a video file in PHP.How will You Play this in Your Page.? Convex-Digital 2 how to select the multiple data in selection button xasis-technologies 1 what are the current or latest versions of LAMP ? Linux, Apache, MySql, PHP 3 WWhat is the functionality of md5 function in PHP? 6 how php works with oracle? 1 what mode to use when creating dirs with mkdir? 1 How to upload a file (may be a .txt or a .doc file) from a php script/file? 1 For more PHP Interview Questions Click Here Copyright Policy | Terms of Service | Help | Site Map 1 | Articles | Site Map | Site Map | Contact Us | interview questions urls External Links
what are the differents between 'action' and 'target' in form tag?
Explain about the data types in PHP?
What is the interface in php?
Tell me can you extend a final defined class?
What are the new features available in php 7?
Describe PHP error and logging information?