Re: HTML button display problem
| From: | markbm | Date: | Tue, 23 Jul 2002 03:48:59 +0000 |
| Subject: | Re: HTML button display problem | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20720@lists.php.net to get a copy of this message | ||
Thanks for the reply. When I added:
<tr>
<td colspan=3 ><center>
<?php printf($result[PAYPAL_BUTTON]);
echo mysql_errno() . ": " . mysql_error() . "\n";?>
</center>
</td>
</tr>
</td> </center>
</tr>
It returned the value 0:, which to me is saying that its not pulling back
the data, but I'm not sure why. The data in the PAYPAL_BUTTON field is:
<FORM method="POST" >
<P><INPUT type="submit" value="Submit" name="subBut">
</FORM>
I will paste the entirety of my code for your reference. I'm stumped.
Thanks again.
Mark
CODE:
=============================
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title><<website.com>></title>
<base target="main">
</HEAD>
<BODY vlink=#003399" link= #003399" background=main_files/background.gif
class=ltBackground>
<IMG alt=spacer height=1 src="main_files/spacer.gif" vspace=5 width=1><BR>
<!-- Set up connection to database -->
<?php
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("website_com",$db);
$result = mysql_query("SELECT * FROM PRODUCTS where HPG_PLAN_ID =
'$planid'",$db);
?>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0
width=766>
<TBODY>
<TR>
<TD vAlign=top height="100%" border=1>
<TABLE align=center border=0 cellPadding=0 cellSpacing=3 cols=2
width=708 height="60%">
<TBODY>
<TR valign=top>
<TD class=bodyText width="701" height="438" border=1>
<font size=16px face="Verdana, Arial, Helvetica, sans-serif">
<?php
printf("<b>Plan ID:</b> %s<br>\n",
mysql_result($result,0,"HPG_PLAN_ID"));
?>
</font>
<img src="main_files/darkgrey_bar.gif" height="38">
<table border=2 width=100%>
<?php
if ($result[PLAN_NAME]<>" ") {;
printf ("<tr valign=top><font size=13px face=Verdana, Arial,
Helvetica, sans-serif>");
printf ("<td colspan=3><b>Plan Name:</b>
%s<br>\n", mysql_result($result,0,"PLAN_NAME"));
printf ("</td>");
printf ("</tr></font>");
};
?>
<tr>
<td colspan=3><?php printf("<b>Plan
Description:</b>
%s<br>\n", mysql_result($result,0,"PLAN_DESCRIPTION")); ?>
</td>
</tr>
<tr>
<td> <?php printf("<b>Heated Sq.
Ft:</b>
%s<br>\n", mysql_result($result,0,"HEAT_SQ_FT")); ?>
</td>
<td><?php printf("<b>Exterior:</b>
%s<br>\n",
mysql_result($result,0,"EXTERIOR")); ?>
</td>
<td><?php printf("<b>Number of
Bedrooms:</b>
%s<br>\n", mysql_result($result,0,"NUM_BEDROOMS")); ?>
</td>
</tr>
<tr>
<td> <?php printf("<b>Un-Heated Sq.
Ft:</b>
%s<br>\n", mysql_result($result,0,"UNHEAT_SQ_FT")); ?>
</td>
<td><?php printf("<b>Foundation
Type(s):</b>
%s<br>\n", mysql_result($result,0,"FOUNDATION")); ?>
</td>
<td><?php printf("<b>Number of
Baths:</b>
%s<br>\n", mysql_result($result,0,"NUM_BATHS")); ?>
</td>
</tr>
<tr>
<td> <?php printf("<b>Total Sq.
Ft:</b>
%s<br>\n", mysql_result($result,0,"TOTAL_SQ_FT")); ?>
</td>
<td><?php printf("<b>Number of
Floors:</b>
%s<br>\n", mysql_result($result,0,"NUM_FLOORS")); ?>
</td>
<td><?php printf("<b>Roof
Type(s):</b>
%s<br>\n", mysql_result($result,0,"ROOF_TYPE")); ?>
</td>
</tr>
<tr>
<td> <?php printf("<b>Bonus Room:</b>
%s<br>\n", mysql_result($result,0,"BONUS_ROOM")); ?>
</td>
<td><?php printf("<b>Garage:</b>
%s<br>\n",
mysql_result($result,0,"GARAGE")); ?>
</td>
<td><?php printf("<b>Number of
Cars:</b>
%s<br>\n", mysql_result($result,0,"NUM_CARS")); ?>
</td>
</tr>
<tr>
<td><?php printf("<b>Roof Pitch:</b>
%s<br>\n",
mysql_result($result,0,"ROOF_PITCH")); ?>
</td>
<td><?php printf("<b>Width:</b>
%s<br>\n",
mysql_result($result,0,"WIDTH")); ?>
</td>
<td><?php printf("<b>Depth:</b>
%s<br>\n",
mysql_result($result,0,"DEPTH")); ?>
</td>
</tr>
<tr>
<td><?php printf("<b>Sec. Roof
Pitch:</b>
%s<br>\n", mysql_result($result,0,"SEC_ROOF_PITCH")); ?>
</td>
<td><?php printf("<b>Main Ceiling
Height:</b>
%s<br>\n", mysql_result($result,0,"MAIN_CEIL_HEIGHT")); ?>
</td>
<td>
</td>
</font>
</tr>
<tr>
<td colspan=3 ><center>
<?php printf($result[PAYPAL_BUTTON]);
echo mysql_errno() . ": " . mysql_error() . "\n";?>
</center>
</td>
</tr>
</td> </center>
</tr>
<tr>
<td bgcolor=#F0F8FF colspan=3><font size=5><b>Optional
Products / Services:</b>
</td></font>
</tr>
<tr>
<td><?php printf("<b>Materials List
Available:</b> %s<br>\n",
mysql_result($result,0,"MAT_LIST"));
?>
</td>
<td><?php printf("<b>Reproducible Sets
Available:</b> %s<br>\n",
mysql_result($result,0,"REPRODUCIBLE")); ?>
</td>
<td><?php printf("<b>Color Rendering
Available:</b> %s<br>\n",
mysql_result($result,0,"COLOR_REND"));
?>
</td>
</tr>
<tr>
<td><?php printf("<b>Right-Reading Reverse Floorplan
Available:</b> %s<br>\n",
mysql_result($result,0,"RR_REVERSE"));
?>
</td>
<td><?php printf("<b>Mirror Reverse Floorplan
Available:</b> %s<br>\n",
mysql_result($result,0,"MIRROR_REV"));
?>
</td>
<td><?php printf("<b>CAD Files
Available:</b>
%s<br>\n", mysql_result($result,0,"CAD_FILES")); ?>
</td>
</tr>
<tr>
<td colspan=3 >
</td>
</tr>
<tr>
<td colspan=3 bgcolor=#F0F8FF><font size=5> <b>Front
Elevation:<b>
</td> </font>
</tr>
<tr>
<td colspan=3 >
<?php echo "<img
src='http://www.website.com/index_files/main_files/$planid/"
.
mysql_result($result, 0,'FRONT_REND')."'>'"; ?>
</td>
</tr>
<tr>
<td colspan=3 bgcolor=#F0F8FF><font size=5> <b>First Floor
Plan:<b>
</td></font>
</tr>
<tr>
<td colspan=3 >
<?php echo "<img
src='http://www.website.com/index_files/main_files/$planid/"
.
mysql_result($result, 0,'FLRPLAN_1')."'>'"; ?>
</td>
</tr>
<?php
if ($result[FLRPLAN_2]<>" ") {
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF>");
printf ("<font size=5> <b>Second Floor Plan:<b>
</td></font>") ;
printf ("</tr>") ;
printf ("<tr>");
printf ("<td colspan=3 >") ;
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"
.
mysql_result($result, 0,'FLRPLAN_2')."'>'";
printf (" </td>") ;
printf ("</tr> ");
};
if ($result[FLRPLAN_3]<>" ") {;
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF><font size=5>
<b>Third Floor Plan:<b> ");
printf ("</td></font> ");
printf ("</tr> ");
printf ("<tr> ");
printf ("<td colspan=3 >");
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"
.
mysql_result($result, 0,'FLRPLAN_3')."'>'";
printf ("</td> ");
printf ("</tr> ");
};
if ($result[REAR_REND]<>" ") {;
printf ("<tr>");
printf (" <td colspan=3 bgcolor=#F0F8FF><font size=5>
<b>Rear Elevation:<b> ");
printf (" </td></font> ");
printf ("</tr> ");
printf ("<tr> ");
printf ("<td colspan=3 >");
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"
.
mysql_result($result, 0,'REAR_REND')."'>'";
printf ("</td> ");
printf ("</tr> ");
};
if ($result[SIDE_REND1]<>" ") {;
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF><font size=5>
<b>Side Elevation 1:<b> ");
printf ("</td></font> ");
printf ("</tr> ");
printf ("<tr> ");
printf ("<td colspan=3 >");
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"
.
mysql_result($result, 0,'SIDE_REND1')."'>'";
printf ("</td> ");
printf ("</tr> ");
};
if ($result[SIDE_REND2]<>" ") {;
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF><font size=5>
<b>Side Elevation 2:<b> ");
printf ("</td></font> ");
printf ("</tr> ");
printf ("<tr> ");
printf ("<td colspan=3 >");
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"
.
mysql_result($result, 0,'SIDE_REND2')."'>'";
printf ("</td> ");
printf ("</tr> ");
};
if ($result[OTHER_IMG1]<>" ") {;
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF><font size=5>
<b>Other Images:<b> ");
printf ("</td></font> ");
printf ("</tr> ");
printf ("<tr> ");
printf ("<td colspan=3 >");
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"
.
mysql_result($result, 0,'OTHER_IMG1')."'>'";
if ($result[OTHER_IMG2]<>" ") {;
echo "<br><img
src='http://www.website.com/index_files/main_files/$planid/"
.
mysql_result($result, 0,'OTHER_IMG2')."'>'";
};
printf ("</td> ");
printf ("</tr> ");
};
if ($result[REL_PLAN1]<>" ") {;
printf ("<tr>");
printf ("<td colspan=3 > ");
printf ("</td>");
printf ("</tr>");
printf (" <tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF><font size=4>
<b>Like this plan, but its not exactly what you're looking for? ");
printf ("Check out these similar plan(s): <b>");
printf (mysql_result($result, 0,'REL_PLAN1'),
mysql_result($result,0,"REL_PLAN1"));
};
if ($result[REL_PLAN2]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN2'),
mysql_result($result,0,"REL_PLAN2"));
};
if ($result[REL_PLAN3]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN3'),
mysql_result($result,0,"REL_PLAN3"));
};
if ($result[REL_PLAN4]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN4'),
mysql_result($result,0,"REL_PLAN4"));
};
if ($result[REL_PLAN5]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN5'),
mysql_result($result,0,"REL_PLAN5"));
};
if ($result[REL_PLAN6]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN6'),
mysql_result($result,0,"REL_PLAN6"));
};
if ($result[REL_PLAN7]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN7'),
mysql_result($result,0,"REL_PLAN7"));
};
if ($result[REL_PLAN8]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN8'),
mysql_result($result,0,"REL_PLAN8"));
};
if ($result[REL_PLAN9]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN9'),
mysql_result($result,0,"REL_PLAN9"));
};
printf ("</td></font>");
printf ("</tr>");
printf ("</font> ");
printf ("</table>");
//include files
include("includes/footer.php");
?>
</SPAN></p>
</TD>
</TR>
</TD>
</TR>
</TBODY>
</TABLE>
</TD>
</TR>
</TBODY>
</TABLE>
</BODY></HTML>
=============================
"David Robley" <robleyd@paradise.net.nz> wrote in message
news:MPG.17a769c4579fd9f989753@news.php.net...
> In article <20020722234029.37825.qmail@pb1.pair.com>, markbm@hotmail.com
> says...
> > It doesn't bring back any HTML when I view the source:
> >
> > <tr>
> > <td colspan=3 ><center>
> >
> >
> > </center>
> > </td>
> > </tr>
> >
> > I tried the addslashes and stripslashes but I'm not sure that I had the
> > syntax right. Any ideas? Thanks.
> >
> > Mark
> >
> > "Dasmeet Singh" <dasmeet@tunmail.com> wrote in message
> > news:3D3930CD.1090907@tunmail.com...
> > > Markbm wrote:
> > > > I am working through an issue where I'm trying to display HTML code,
> > stored
> > > > in a text field in a MySQL database. The code that I have looks
like
> > this:
> > > >
> > > > <tr>
> > > > <td colspan=3 ><center>
> > > > <?php printf($result[PAYPAL_BUTTON]); ?>
</center>
> > > > </td>
> > > > </tr>
> > > >
> > > > This code displays nothing when viewed on the web server, although
the
> > > > contents of the db field are:
> > > >
> > > > <FORM method="POST" >
> > > > <P><INPUT type="submit" value="Submit"
> > > > name="subBut">
> > > > </FORM>
> > > >
> > > > Question:
> > > >
> > > > 1. How do I get this code to display correctly (i.e. create the
button
> > /
> > > > not show the underlying HTML)?
> > > >
> > > > Any help would be greatly appreciated. Thanks for your help.
> > > >
> > > > Mark
> > > >
> > > >
> > > >
> > >
> > > Can you tell what HTML do you get from web server..ie when you view
>
> Check that your mysql query is working correctly and actually returning
> data - mysql_error is a useful debugging tool. If all else fails, try
> showing the code you are using to retrieve from the db.
>
> --
> David Robley
> Temporary Kiwi!
>
> Quod subigo farinam