Different result in phpMyAdmin and php

Question

In phpMyAdmin, I am writing

SELECT `class` FROM `teachers` WHERE `var1`=3;

I can give results. The Results are 5,6,7,8,9,10. I am Trying this code in Sublimetext3. code is like this :

<tr>            
    <?php 

    $classlistdata  = $db->getrows("SELECT `class` FROM `teachers` WHERE `var1`=3; ");
    foreach ($classlistdata as $ndcld) {     

    ?>
    <td height="25" colspan="3" ><span class="admin"><?php  echo ($ndcld); ?></span></td>

    <?php } ?>
</tr>

this code writing 6 times "array" . How can I fix it. I am new PHP. thanks for your answer.

What is the array you're getting in result? print_r($ndcld); will show you all the items of that array — Max Maximilian
– Max Maximilian, Commented Feb 8, 2018 at 15:03
getrows could be used to return more than one column, so each row is probably an array of values with one item. Im not into PHP but in c# you would get it ndcld["class"] — Cleptus
– Cleptus, Commented Feb 8, 2018 at 16:01

Koot · Accepted Answer · 2018-02-08 15:02:57Z

3

You should use echo $ndcld['class'];

answered Feb 8, 2018 at 15:02

Koot

4373 silver badges5 bronze badges

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

Comments

Twinfriends · Accepted Answer · 2018-02-08 15:06:03Z

0

I don't know whats behind the getrows method, but likely its just an normal SQL query since you get arrays. Well, in your case, ndcld is an array. An array containing all the queried attributes as an array key.

Change your code to:

$classlistdata  = $db->getrows("SELECT `class` FROM `teachers` WHERE `var1`=3; ");
foreach ($classlistdata as $ndcld) {     

?>
<td height="25" colspan="3" ><span class="admin"><?php echo $ndcld["class"]; ?></span></td>

<?php } ?>

That should do the job ;)

answered Feb 8, 2018 at 15:06

Twinfriends

1,9971 gold badge18 silver badges37 bronze badges

2 Comments

Paulie Over a year ago

Stop duplicating answers. (also 'class' -/- "class", see SQL query)

Twinfriends Over a year ago

@Kenyanke I'm okay with the "" '' part... but - dublicateing answers? Where? I was writing this answer while the other one was posted. Also, an answer here should actually contain some explanation. The other one doesn't provide any, even tho its a good answer.

Collectives™ on Stack Overflow

Different result in phpMyAdmin and php

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related