Problem to clear data

neizo posted this at 00:02 — 2nd May 2007.

They have: 4 posts

Joined: May 2007

Hi, congratulations guys for this amazing forum!

There is any way to clear hidden data (like word does with the text) when imported into mysql?
The table is long text.

Thanx

kb posted this at 01:59 — 2nd May 2007.

He has: 1,380 posts

Joined: Feb 2002

Hidden? Define 'hidden', please.

neizo posted this at 15:59 — 6th May 2007.

They have: 4 posts

Joined: May 2007

Thanks for reply!
I have backend for a flash site, but when i paste text intro textarea of backend the php file send this text into mysql database. So when i load the swf file it calls the loadvariables php file for the text.
In swf file loads only the first 5 lines of the text and not all of it.

This text is from microsoft word, the problem is with hidden data into the text that I can see only in the database.
There any way to clear those hidden data and keep only the pure text? something like filter from mysql?

This hidden data is tags <> from word!

kb posted this at 18:08 — 6th May 2007.

He has: 1,380 posts

Joined: Feb 2002

Ok, I'm not sure I understand, but let me try and help....

You can load "hidden" data values with

You can get those values with the same methods you would anything else...a POST through a form, using whatever language you desire.

As for clearing data, if you want to have a form load with text inside it, and then clear when they click:

HTML:

<textarea name="my_text" id="the_textarea" onClick="disappear(the_textarea)">Entry text</textarea>

JavaScript:
function disappear(the_item) {
     document.getElementById(the_item).innerText = '';
}

Something like that? Granted, that's untested, and the .innerText value has limited usage (only certain tags, etc.) but that might be what you want?

Hopefully this helps...

neizo posted this at 10:40 — 7th May 2007.

They have: 4 posts

Joined: May 2007

Hi, thanks for that example, I want something like that but little different.

My php file to call the data from mysql looks like that:

<html>
<head>
<title>idc</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-7">
<link rel="stylesheet" href="pall.css" type="text/css">
</head>
<body>
<?
include("inc/connect.php");
$sql = "SELECT * from biografika ORDER BY ID";
$result1 = mysql_query($sql);
$countinc = 0;
while ($row2 = mysql_fetch_array($result1, MYSQL_ASSOC)) {
$countinc++;
echo "&row".$countinc."=". $row2['ID'].",".urlencode($row2['PROSOPO']).",".urlencode($row2['BIO']);
}
echo "&totalrows=".$countinc;
echo "&loaded=1";
mysql_close($link);
?>
</body>
</html>

and the data into mysql is like that:
<p style="margin-bottom: 0cm;">bla bla bla bla</p>'

This tag is the problem and if you copy from microsoft word some text and paste it anyware this tag is invisible.
I was wonder why the text not load into the scroller (flash side) and when I open phpmyadmin I saw this tag many times into the text.
That is the hidden data!

So after that I found the "Office 2003/XP Add-in: Remove Hidden Data" but nothing man:confused: it suppose to clear the data bu is not working..the tag is there again.

So, I want to pull out only the "bla bla bla" with no tags because my text scroller into the flash side has problem with this tag. I already check my sroller to render text as html and it working with others tag but not with the "style="margin-bottom: 0cm;" property of tag

Thanks for helping me on this