I'm using a field in my database of MySQL of type "long text", in which I'm
storing all the page HTML. Here is an example:-
Code: Select all
<H2 align="center">Collectorates</H2>
<table><tr><td ><img src="../../media/images/body/misc/spacer.gif" alt=""
border="0" height="9" width="2"></td></tr></table>
<TABLE width="96%" class="linear"
cellSpacing="0" cellPadding="3" border="2" style="BORDER-BOTTOM-STYLE:
double; BORDER-TOP-STYLE: double; BORDER-LEFT-STYLE: double;
BORDER-RIGHT-STYLE: double;">
<tr valign="top" bgcolor="#CECABD"
bordercolor="#CECABD">
<td width="43" valign="top"><p align="center">Serial
No. </p></td>
<td width="425" valign="top"><p align="center">Area
</p></td>
<td width="122" valign="top"><p
align="center">Collectorate of Federal Excise </p></td>
</tr>
<tr>
<td width="43" valign="top"><p>1 </p></td>
<td width="425" valign="top"><p>Sindh excluding
Karachi Division </p></td> ... ... ...I'm using PHPMyAdmin to insert my data into MySQL.
Actually this is a whole page of a particular section, and it is available
in the database because I want admin to even change the text through his
Administrator Login.
Now here is the point where the problem arises. When I open this text into a
<textarea> and then execute the update query for the Updation with this
wholw HTML text, it gives me error.
Actually the spaces or quote marks does not let me save this data into the
database.
There must be some function through which I can attain this thing... Beacuse
when I did the same in PHPMySQL, it lets me save the changes and PHPMySQL is
also made in PHP...
Thanks for your time.