html table in php error

Question

This is my code

if ($result!==false) {
$html_table =<table align="center" border="1" cellspacing="0" cellpadding="10" width="1000" word-wrap="break-word" display="inline-block">
<tr><th>Bank</th><th>Projects</th><th>Status</th><th>PS Lead</th><th>Support</th><th>Remarks</th></tr>';

    foreach($result as $row){

    $html_table .= '<tr><td>' .$row["bankname"]. '</td><td>' .$row["bpiproject"]. '</td><td>' .$row["bpistatus"]. '</td><td>' . $row["bpips"] . '</td><td>' . $row["bpisupport"] .  '</td><td>' . $row["bpiremarks"] . '</td></tr>';

    }
}

 $conn = null;
 $html_table .= '</table>';
 echo $html_table;

and the error message says

Undefined variable: html_table in line 33

which is

$html_table .='</table>';

Possible duplicate of [PHP: "Notice: Undefined variable", "Notice: Undefined index", and "Notice: Undefined offset"](https://stackoverflow.com/questions/4261133/php-notice-undefined-variable-notice-undefined-index-and-notice-undef) — Matt, Jul 12 '17 at 03:22
You're got your quote marks all wrong. You need a quote right after `$html_table = ` — Difster, Jul 12 '17 at 03:23
Also, you should set borders, alignment, etc. using `style= ...` — Difster, Jul 12 '17 at 03:24
I already used this code in my other file and it works. but when I copy-pasted it, the error occur — user8230483, Jul 12 '17 at 03:26

score 0 · Accepted Answer · answered Jul 12 '17 at 03:36

0

first you are starting your table inside an if, which means if your condition is not met then the code inside if will not run.
another is you are starting your variable string without ' after $html_table Do this

$html_table = "";
if ($result!==false) {
$html_table ='<table align="center" border="1" cellspacing="0" cellpadding="10" width="1000" word-wrap="break-word" display="inline-block">
<tr><th>Bank</th><th>Projects</th><th>Status</th><th>PS Lead</th><th>Support</th><th>Remarks</th></tr>';

foreach($result as $row){

$html_table .= '<tr><td>' .$row["bankname"]. '</td><td>' .$row["bpiproject"]. '</td><td>' .$row["bpistatus"]. '</td><td>' . $row["bpips"] . '</td><td>' . $row["bpisupport"] .  '</td><td>' . $row["bpiremarks"] . '</td></tr>';

}
 $html_table .= '</table>';
}

 $conn = null;

 echo $html_table;

basically i have added $html_table = ""; before if condition and $html_table .= '</table>'; inside if condition. When your if condition is not met it will print blank $html_table

answered Jul 12 '17 at 03:36

Regolith

2,944
9
33
50

nothing. there's no more error but nothing shows on the screen – user8230483 Jul 12 '17 at 08:57
that means your `$result!==false` condition is not met. `$result` is `false` so the code inside the block is not executed. – Regolith Jul 12 '17 at 09:05
what is `$result`? what does it return `var_dump($result)` before `if` condition, and make sure that it is returning what you desire – Regolith Jul 12 '17 at 09:06
I did this $result==false and the table appeared! :) but there's an error saying "Invalid argument supplied for foreach()" – user8230483 Jul 12 '17 at 09:21
please `var_dump($result)` and see what is the output – Regolith Jul 12 '17 at 09:22
I put that before the if ($result!==false) and it says Parse error: syntax error, unexpected 'if' (T_IF) – user8230483 Jul 12 '17 at 09:25
you are missing `;` after `var_dump($result)`. – Regolith Jul 12 '17 at 09:26
oh sorry. here's the result bool(false) Notice: Undefined variable: html_table – user8230483 Jul 12 '17 at 09:27
you are not getting any value in `$result`. Therefore you cannot use that value in `foreach`. – Regolith Jul 12 '17 at 09:29
can you show code how `$result` is used before `if` condition? – Regolith Jul 12 '17 at 09:30
$result = $conn->query($sql); var_dump($result); if ($result!==false)-------- – user8230483 Jul 12 '17 at 09:31
actually I already used this code in other php file, it works. I copy-pasted it then there's an error – user8230483 Jul 12 '17 at 09:35
simple copy and paste will not work. you have to check if `$conn` or database connection is working and debug in procedural manner. – Regolith Jul 14 '17 at 03:39

html table in php error

1 Answers1