[Resolved] url fragmented in form

fr8

I want to be able to edit my data from mysql.
I can add/display/edit/delete the data without a problem except when there is a link in the code.

example:

<a href="someurl">Name of URL</a>

what im having trouble with is when the data is pulled from the database (mysql). when the text is displayed in the form it will fragment. what i mean by this the form will have "<a hre" then the end of the form and then the rest of the text will be on the ouside to where i cant edit it.
what i have is this:

the editing of the information

<form method="post"action="<?php echo $PHP_SELF?>">
<input type="hidden"name="pid"value="<?php echo $myrow["pid"]?>">
cid: <input type="Text"name="cid"value="<?php echo $myrow["cid"]?>"><br>
title: <input type="Text"name="title"value="<?php echo $myrow["title"]?>"><br>
subtitle: <input type="Text"name="subtitle"value="<?php echo $myrow["subtitle"]?>"><br>
active: <input type="Text"name="active"value="<?php echo $myrow["active"]?>"><br>
page_header: <input type="Text"name="page_header"value="<?php echo $myrow["page_header"]?>"><br>
text: <input type="Text"name="text"value="<?php echo $myrow["text"]?>"><br>
page_footer: <input type="Text"name="page_footer"value="<?php echo $myrow["page_footer"]?>"><br>
signature: <input type="Text"name="signature"value="<?php echo $myrow["signature"]?>"><br>
<input type="Submit" name="update" value="Update information"></form>

DigitalExpl0it

when you insert html into a database you will need to convert all characters to somthing else then convert them back

like " ' %
things that commonly used in php

that mysql field with the url is that a long text/text what? perhaps a blob?

DigitalExpl0it

also looking at your code you forogt to add ; after each varible

here try this first

<form method="post"action="<?php echo $PHP_SELF; ?>">
<input type="hidden" name="pid" value="<?php echo $myrow["pid"]; ?>">
cid: <input type="Text" name="cid" value="<?php echo $myrow["cid"]; ?>"><br>
title: <input type="Text" name="title" value="<?php echo $myrow["title"]; ?>"><br>
subtitle: <input type="Text" name="subtitle" value="<?php echo $myrow["subtitle"]; ?>"><br>
active: <input type="Text" name="active" value="<?php echo $myrow["active"]; ?>"><br>
page_header: <input type="Text" name="page_header" value="<?php echo $myrow["page_header"]; ?>"><br>
text: <input type="Text" name="text" value="<?php echo $myrow["text"]; ?>"><br>
page_footer: <input type="Text" name="page_footer" value="<?php echo $myrow["page_footer"]; ?>"><br>
signature: <input type="Text" name="signature" value="<?php echo $myrow["signature"]; ?>"><br>
<input type="Submit" name="update" value="Update information"></form>

fr8

they are as follows DigitalExpl0it.

pid int(10)
cid int(10)
title varchar(255)
subtitle varchar(255)
active int(1)
page_header text
text text
page_footer text
signature text
date datetime

adding the ; with the code did not work.

fr8

anyone know what i can do to fix this

fr8

was going threw all of my threads that i started and marking the ones completed Resolved. Then i saw this one. I now know how to fix it. What i do is use preg_replace. When the data is inserted i replace the characters needed. When the data is spit back out i reverse it. works like a charm. probly not the best way but it works.