Explain PHP/MySQL in Simple Terms [duplicate]

Question

I have the code below and was hoping someone could clarify what the highlighted/commented/obvious lines was doing please

$result = mysqli_query($db, "SELECT * FROM `tblName` WHERE `id`='" . mysqli_real_escape_string($db, $_GET['id']) . "' LIMIT 0, 1");
$row = mysqli_fetch_assoc($result);
foreach($row as $name => $value) {  // THIS ONE I NEED HELP WITH
    ...
}

Does it basically say "for each column..." - this is where I get stuck

Hardly simple terms! Let's assume I need to explain it to my mother or child.... or at least a colleague who understands databases but not PHP — pee2pee
– pee2pee, Commented Dec 27, 2016 at 20:31
@JeremyHarris that hardly is going to help OP. "This question concerns how it works under the bonnet" OP is not looking for that — PeeHaa
– PeeHaa, Commented Dec 27, 2016 at 20:31
You're right, it basically says "in the row of data returned, take each column as $name and it's value as $value". — Serg Chernata
– Serg Chernata, Commented Dec 27, 2016 at 20:32
@pee2pee I have a massive answer written, but the question was closed (in fairness I started that close vote). Maybe it will help: pastebin.com/f5hXdgD4 — Jeremy Harris
– Jeremy Harris, Commented Dec 27, 2016 at 21:05

TheValyreanGroup · Accepted Answer · 2016-12-27 20:41:00Z

2

It's a foreach loop. So it can be translated to...

for every object in the $row variable, assign that object to the new variable $name, with its corresponding value as $value

That will loop N times, where N is the number of rows returned. Each time the loop is iterated, the $name and $value variables are re-initialized to the new row's contents.

edited Dec 27, 2016 at 20:41

answered Dec 27, 2016 at 20:38

TheValyreanGroup

3,5992 gold badges16 silver badges32 bronze badges

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

4 Comments

pee2pee Over a year ago

Just wanted to be sure it included the column names rather than just records

TheValyreanGroup Over a year ago

Yes. That's what adding the => does.

pee2pee Over a year ago

Will accept this as answer as soon as I can

Sammitch Over a year ago

That's not at all "what the => does", $name will contain the row's numeric index in the result set, and $value will contain the row itself. Whether or not the row includes the column names depends entirely on which fetch function is called. In this case calling fetch_assoc is what gets the column names as keys in the $row array.

Collectives™ on Stack Overflow

Explain PHP/MySQL in Simple Terms [duplicate]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related