mediumblob and html file
Hi all,
I'm working with a table where the invoice is in HTML format and stored in a mediumblob.
So when I retrieve the invoice and display it with the following code :
while (list($invoice) = mysql_fetch_row($result))
{
echo "$invoice";
}
Previously it was correctly managed : display a formatted invoice.
Now it shows the HTML code and nothing more.
Any idea in order to make sure the display will be correct ?
TIA
I'm working with a table where the invoice is in HTML format and stored in a mediumblob.
So when I retrieve the invoice and display it with the following code :
while (list($invoice) = mysql_fetch_row($result))
{
echo "$invoice";
}
Previously it was correctly managed : display a formatted invoice.
Now it shows the HTML code and nothing more.
Any idea in order to make sure the display will be correct ?
TIA
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you might have use stripslashes so try
echo stripslashes($invoice);
echo stripslashes($invoice);
Check is your database connections and queries are working fine.
If possible, could you post the entire result?
If possible, could you post the entire result?
ASKER
Hereafter the entire result :
<!-- admin part of invoice_print start --> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>ANS Natura</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <body> <table width="650" border="1" bordercolor="#333333" cellspacing="0"> <tr> <td colspan="5" align="center" valign="top"><font size="2" face="Arial, Helvetica, sans-serif"><b>ANS Natura</b></font> <br> <font size="1" face="Arial, Helvetica, sans-serif">Date: 29-09-04 16:14</font> </td> </tr> <tr> <td colspan="2" align="center" valign="top"><font size="1" face="Arial, Helvetica, sans-serif"><u>Information
<!-- admin part of invoice_print start --> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>ANS Natura</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <body> <table width="650" border="1" bordercolor="#333333" cellspacing="0"> <tr> <td colspan="5" align="center" valign="top"><font size="2" face="Arial, Helvetica, sans-serif"><b>ANS Natura</b></font> <br> <font size="1" face="Arial, Helvetica, sans-serif">Date: 29-09-04 16:14</font> </td> </tr> <tr> <td colspan="2" align="center" valign="top"><font size="1" face="Arial, Helvetica, sans-serif"><u>Information
1. Is there anything printing before this code?
2. Can we see the mediumblob text straight from the database without php?
2. Can we see the mediumblob text straight from the database without php?
From what I understand, the results are being pulled properly from the database but their display is messed. Right?
This really looks like a problem with an open ". Can you post the code as well?
This really looks like a problem with an open ". Can you post the code as well?
I would have asked that but I thought he wouldnt want to post all his code :/
ASKER
Hi,
Hereafter the complete code.
TIA
<?
$orderNumber = $_GET['fact'];
include("login.php");
include("bdd.inc.php");
$connect = @mysql_connect($serveur,$l
@mysql_select_db($base);
$query = "SELECT Invoice "; $query .= "FROM `nuke_pncommerce_invoices`
$query .= "WHERE OrderNumber = $orderNumber ";
$result = @mysql_query($query, $connect);
$errno = @mysql_errno($connect);
$error = @mysql_error($connect);
if ($errno != 0)
{
echo "Operation failed : $errno - $error<br />\n";
}
while (list($invoice) = mysql_fetch_row($result))
{
echo "$invoice";
}
?>
Hereafter the complete code.
TIA
<?
$orderNumber = $_GET['fact'];
include("login.php");
include("bdd.inc.php");
$connect = @mysql_connect($serveur,$l
@mysql_select_db($base);
$query = "SELECT Invoice "; $query .= "FROM `nuke_pncommerce_invoices`
$query .= "WHERE OrderNumber = $orderNumber ";
$result = @mysql_query($query, $connect);
$errno = @mysql_errno($connect);
$error = @mysql_error($connect);
if ($errno != 0)
{
echo "Operation failed : $errno - $error<br />\n";
}
while (list($invoice) = mysql_fetch_row($result))
{
echo "$invoice";
}
?>
As your only dealing with one record from one row:
while (list($invoice) = mysql_fetch_row($result))
{
echo "$invoice";
}
is pretty pointless, may as well just use:
echo mysql_result($result,0,"In
That will doubtfully fix your problem though, you can try
$invoice = mysql_result($result,0,"In
echo stripslashes($invoice);
But as the html seems to be outputed correctly its difficult to pinpoint the problem.
while (list($invoice) = mysql_fetch_row($result))
{
echo "$invoice";
}
is pretty pointless, may as well just use:
echo mysql_result($result,0,"In
That will doubtfully fix your problem though, you can try
$invoice = mysql_result($result,0,"In
echo stripslashes($invoice);
But as the html seems to be outputed correctly its difficult to pinpoint the problem.
ASKER
I copied the result in afile named invoice.html.
The browser processed it as a text file and not a HTML one. I'm under Windows and the table was filled under Linux.
So when I want to open the HTML file with Ultraedit, it asks me to convert or not the file.
Finally, it seems to be a problem of conversion between Unix format and Windows one and new line coding.
Any idea to solve it
TIA
The browser processed it as a text file and not a HTML one. I'm under Windows and the table was filled under Linux.
So when I want to open the HTML file with Ultraedit, it asks me to convert or not the file.
Finally, it seems to be a problem of conversion between Unix format and Windows one and new line coding.
Any idea to solve it
TIA
1) to get the file recognised as a html file add the following line to the top of the page
header('Content-type: text/html');
It will of course have to be parsed by the php engine (.php extension)
2)
>> Finally, it seems to be a problem of conversion between Unix format and Windows one and new line coding.
Unix systems use \n for new lines, Windows uses \r\n so you could try
$var = ""; //your text
$var = str_replace("\r","",$var);
echo $var;
header('Content-type: text/html');
It will of course have to be parsed by the php engine (.php extension)
2)
>> Finally, it seems to be a problem of conversion between Unix format and Windows one and new line coding.
Unix systems use \n for new lines, Windows uses \r\n so you could try
$var = ""; //your text
$var = str_replace("\r","",$var);
echo $var;
for 1) you might actually be able to get it to recongise the html by adding:
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
in the head section of the tags
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
in the head section of the tags
ASKER
Hi Diablo84,
I find that when I read the source code of the page, HTML entities are coded like this "<" = < so i use html_entity_decode to interpret correctly the code.
I find that when I read the source code of the page, HTML entities are coded like this "<" = < so i use html_entity_decode to interpret correctly the code.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
So far I don't know because i use a function written by somebody else. But i'll find it out.
Regards
Regards
ASKER
<!-- admin part of invoice_print start --> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>
...
and stops like this :
</table> <!-- admin part of invoice_print end --> </body> </html>