Why is MySQL search query not returning each row in 1 index of an array?
I'm fairly new to PHP and I've been stumped on this issue for a while now (been searching everywhere but no help really).
I'm attempting to search for all the data in a data table ("Select * FROM X") and that seems to work fine.
However when I try to return/echo the data, encoding into JSON format as an array (I'd like 1 row as 1 index in the array) it does wierd things.
Heres the code I currently use;
$SQL = "SELECT * FROM `units`";
$Result = mysqli_query($link, $SQL) or die ("DB ERROR");
$Total = mysqli_num_rows($Result);
if($Total > 0)
{
$rows = mysqli_fetch_array($Result, MYSQLI_NUM);
$row_count = mysqli_num_rows($Result);
while($row = mysqli_fetch_array($Result))
{
echo json_encode(array($row));
}
}
This then gets used in Unity (C#) via;
JSONObject obj = new JSONObject(loadUnitsWWW.text);
Debug.Log(obj);
The results of which are;
[{"0":"2", "unitID":"2","1":"Tanks","unitName":"Tanks","2":"Ground","unitType":"Ground"},[],[],[],[],[],[],[],[],[],[],[]]
it seems to be trying to return EVERYTHING for some reason, including the column names. But I've no idea why it'd return the same results multiple times (and no idea where the 0 came from).
As I said, I'm fairly inexperienced with PHP, as such its very likely something (in fact I'm certain) something is wrong with that code, I've tried a for loop such as;
for($i = 0; $i < $row_count; $i++) {...}
but to no avail (it returns something like:
["1",[],[],"",null,null,null,{},null,null,null.null[],""..........]
Heres the data table layout if it helps;
unitID | unitName | unitType
1 | infantry | Ground <br>
2 | Tanks | Ground <br>
3 | Support | Ground <br>
4 | Artillery | Ground <br>
. <br>
.
There are 13 items in the table
Your answer
Follow this Question
Related Questions
Can I add a table to a mySQL database using C#? 0 Answers
C# safe connect to MySQL database. Download and upload data via PHP script. 1 Answer
display data from mysql 0 Answers
WebGL Build strange exception 0 Answers
WWW not working on my PHPs 0 Answers