what wrong's with this coding?????????
Posted: Wed May 12, 2004 10:08 am
can anybody help me to solve this problem??? i want list the image using php.. what wrong's for this coding????????
<?php
@ $db = mysql_pconnect('localhost','root');
if (!$db)
{
echo 'Error: no record to database. Please try again later.';
exit;
}
mysql_select_db('mobile');
$query = "SELECT * FROM `images`";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
if(!$num_results)
{
echo 'No user can be found...Please search again!';
exit();
}
printf("<TABLE BORDER WIDTH=\"100%%\">\n");
printf("<TR>
<TD><B>id</B></TD>
<TD><B>sixfourdata</B></TD>
</TR>\n");
while (($row = mysql_fetch_object($result))){
printf("<TR>
<TD>%s</TD>
<TD>%s</TD>
</TR>\n",
$row->imgid, base64_decode($row->sixfourdata));}
printf("</TABLE>\n");
mysql_free_result($result);
?>
<?php
@ $db = mysql_pconnect('localhost','root');
if (!$db)
{
echo 'Error: no record to database. Please try again later.';
exit;
}
mysql_select_db('mobile');
$query = "SELECT * FROM `images`";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
if(!$num_results)
{
echo 'No user can be found...Please search again!';
exit();
}
printf("<TABLE BORDER WIDTH=\"100%%\">\n");
printf("<TR>
<TD><B>id</B></TD>
<TD><B>sixfourdata</B></TD>
</TR>\n");
while (($row = mysql_fetch_object($result))){
printf("<TR>
<TD>%s</TD>
<TD>%s</TD>
</TR>\n",
$row->imgid, base64_decode($row->sixfourdata));}
printf("</TABLE>\n");
mysql_free_result($result);
?>