Get all mysql selected rows into an array

Question

I am wondering if there a function in php that can allow me put all my selected data in an array  Currently i am using mysql fetch array and as i have read in the manual that function won t fetch every record in the table    result   mysql query  SELECT   FROM  tableName                 array   mysql fetch array  result      echo json encode  array

User · Answer

Loop through the results and place each one in an array use mysqli fetch all   to get them all at one time

User · Answer

You could try    rows   array    while  row   mysql fetch array  result      array push  rows   row     echo json encode  rows

User · Answer

I would suggest the use of MySQLi or MySQL PDO for performance and security purposes  but to answer the question   while  row   mysql fetch assoc  result          json      row     echo json encode  json     If you switched to MySQLi you could do    query    SELECT   FROM table    result   mysqli query  db   query     json   mysqli fetch all   result  MYSQLI ASSOC   echo json encode  json

User · Answer

you can call mysql fetch array   for no of row time

User · Answer

name array     while  result mysql fetch array  res          name   array  Id   gt  result  id             here you want to fetch all         records from table like this          then you should get the array         from all rows into one array

[php] Get all mysql selected rows into an array

Examples related to php

Examples related to mysql

Examples related to arrays