Hi,
From a contenido website I need the data from the con_content table data in Excel to use for text in print catalog.
Mentioned that the HTML code is replaced during insert, probably because of security issues? I can't figure out how to transform it back to HTML.
Any help = highly appreciated!!
Thanks
Quokka
This is one example:
INSERT INTO `con_content` VALUES (372, 77, 2, 2, '%3CIMG+src%3D%22upload%2Fbilder%2Fkopje_rasverenigingen.gif%22+border%3D0%3E%3CBR%3EEstrela+Berghonden+Vereniging+Nederland%26nbsp%3B%3CBR%3E%3CA+href%3D%22http%3A%2F%2Fwww.estrela.nu%2F%22+target%3D_blank%3E%3CIMG+src%3D%22upload%2Fbilder%2Flink_website.gif%22+border%3D0%3E%3C%2FA%3E%26nbsp%3B', '', 'admin', '2005-06-17 10:16:26', '2005-06-17 10:17:58');
restore code from mysql
all code in this table is urlencoded...
you should import all data in a sql table und read all data again out with a simple sql query... when outputing data prepare each value with urldecode....
-> http://de.php.net/manual/en/function.urlencode.php
-> http://de.php.net/manual/en/function.urldecode.php
another way would be search and replace each encoded char with the right equivalent...
you should import all data in a sql table und read all data again out with a simple sql query... when outputing data prepare each value with urldecode....
-> http://de.php.net/manual/en/function.urlencode.php
-> http://de.php.net/manual/en/function.urldecode.php
another way would be search and replace each encoded char with the right equivalent...
*** make your own tools (wishlist :: thx)