mysqli_fetch_array data into array and store in php variables

Question

i'm working on this PHP Code that i want to retrieve AVG Time and LAP time for each member in each swimming stroke. i want to store the data first into variables before retrieve to the HTML.

in following code i'm not getting any error. Only Getting Stroke Name. not AVGLaps or LapsTime

$sql = "SELECT strokeType,AVG(totalLaps),AVG(totalSeconds) FROM performance where members_memberId = '$memberid' GROUP BY strokeType";

$result=mysqli_query($con,$sql);
$performanceData = array();

while($row = mysqli_fetch_array($result)) {
  $performanceData[] =$row;
}

$stroke1 = $performanceData[0]['strokeType'];
$stroke2 = $performanceData[1]['strokeType'];
$stroke3 = $performanceData[2]['strokeType'];
$stroke4 = $performanceData[3]['strokeType'];

$strokeLaps1 = $performanceData[0]['totalLaps'];
$strokeLaps2 = $performanceData[1]['totalLaps'];
$strokeLaps3 = $performanceData[2]['totalLaps'];
$strokeLaps4 = $performanceData[3]['totalLaps'];

$strokeTime1 = $performanceData[0]['totalTime'];
$strokeTime2 = $performanceData[1]['totalTime'];
$strokeTime3 = $performanceData[2]['totalTime'];
$strokeTime4 = $performanceData[3]['totalTime'];

echo "StrokeName:".$stroke1.".";

lpg · Accepted Answer · 2015-03-26 21:56:01Z

3

You should declare an alias in your sql query:

$sql = "SELECT strokeType,AVG(totalLaps) AS avgTotalLaps,AVG(totalSeconds) AS avgTotalSeconds FROM performance where members_memberId = '$memberid' GROUP BY strokeType";

And then get the vars like:

$strokeLaps1 = $performanceData[0]['avgTotalLaps'];
...

answered Mar 26, 2015 at 21:56

lpg

4,9371 gold badge18 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

scrowler · Accepted Answer · 2015-03-26 21:59:37Z

1

If you are going to use totalLaps and totalTime as your associative index, then you need to alias the columns in the SQL statement.

SELECT strokeType, AVG(totalLaps) totalLaps, AVG(totalSeconds) totalTime

edited Mar 26, 2015 at 21:59

scrowler

24.4k10 gold badges67 silver badges99 bronze badges

answered Mar 26, 2015 at 21:56

phpmeh

1,8022 gold badges24 silver badges44 bronze badges

Collectives™ on Stack Overflow

mysqli_fetch_array data into array and store in php variables

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related