Probleem

U wilt een query resultaat converteren in html.

Oplossing

Gebruik mysql parameters.

Voorbeeld

% mysql -e "SELECT * FROM limbs WHERE legs=0" uw_database
+————+——+——+
| thing | legs | arms |
+————+——+——+
| squid | 0 | 10 |
| octopus | 0 | 8 |
| fish | 0 | 0 |
| phonograph | 0 | 1 |
+————+——+——+
% mysql -H -e "SELECT * FROM limbs WHERE legs=0" uw_database
<TABLE BORDER=1>
<TR><TH>thing</TH><TH>legs</TH><TH>arms</TH></TR>
<TR><TD>squid</TD><TD>0</TD><TD>10</TD></TR>
<TR><TD>octopus</TD><TD>0</TD><TD>8</TD></TR>
<TR><TD>fish</TD><TD>0</TD><TD>0</TD></TR>
<TR><TD>phonograph</TD><TD>0</TD><TD>1</TD></TR>
</TABLE>