Hi,
a lot of wuestions ahs risen after using web2py, if i just got time to
write them here. One of the latest is, that id like to know, how to
retrieve data with correct encoding from database. My situatio is,
that i have a php serialized data field, which i want to get to web2py
application. I have a PHPUnserialize class for that, but unserializing
fails because there seems to be special characters on database field
data. I have an example here:
"""
a:2:{s:10:"allintitle";i:97;s:5:"pages";a:5:{i:0;a:13:{s:3:"url";s:
35:"http://www.angelfire.com/ill/niche/";s:16:"google_pagetitle";s:
52:"CHAPTER 16:Friedrich Nietzsche: The Anti-Philosopher";s:
15:"google_pagerank";i:0;s:12:"google_links";s:1:"2";s:
10:"alexa_rank";s:3:"786";s:11:"alexa_reach";s:3:"619";s:
13:"alexa_linksin";s:6:"67,533";s:15:"yahoo_backlinks";i:0;s:
9:"msn_links";i:0;s:15:"alltheweb_links";i:0;s:15:"altavista_links";i:
0;s:9:"seo_stats";a:6:{s:4:"body";i:0;s:4:"meta";i:0;s:2:"h1";i:0;s:
3:"alt";i:0;s:3:"url";i:0;s:5:"title";i:0;}s:15:"keyword_density";d:0;}
i:1;a:13:{s:3:"url";s:65:"http://corporatecartoons.blogspot.com/
2007/03/nietzshe-niche.html";s:16:"google_pagetitle";s:35:"Scrambled
Toast: The Nietzshe Niche";s:15:"google_pagerank";i:1;s:
12:"google_links";b:0;s:10:"alexa_rank";s:9:"5,490,647";s:
11:"alexa_reach";s:9:"4,692,194";s:13:"alexa_linksin";s:2:"81";s:
15:"yahoo_backlinks";s:1:"1";s:9:"msn_links";i:0;s:
15:"alltheweb_links";s:2:"97";s:15:"altavista_links";s:2:"97";s:
9:"seo_stats";a:6:{s:4:"body";i:0;s:4:"meta";i:0;s:2:"h1";i:0;s:
3:"alt";i:0;s:3:"url";i:0;s:5:"title";i:0;}s:15:"keyword_density";d:0;}
i:2;a:13:{s:3:"url";s:61:"http://www.scribd.com/doc/9330/Nietzsche-
Philosophy-and-Truth";s:16:"google_pagetitle";s:32:"Nietzsche -
Philosophy and Truth";s:15:"google_pagerank";i:1;s:12:"google_links";b:
0;s:10:"alexa_rank";s:3:"312";s:11:"alexa_reach";s:3:"262";s:
13:"alexa_linksin";s:6:"10,649";s:15:"yahoo_backlinks";s:1:"1";s:
9:"msn_links";i:0;s:15:"alltheweb_links";s:2:"32";s:
15:"altavista_links";s:3:"594";s:9:"seo_stats";a:6:{s:4:"body";i:27;s:
4:"meta";i:0;s:2:"h1";i:0;s:3:"alt";i:0;s:3:"url";i:0;s:5:"title";i:0;}
s:15:"keyword_density";d:0;}i:3;a:13:{s:3:"url";s:66:"http://
clicheniche.wordpress.com/2007/09/15/philosophy-by-example/";s:
16:"google_pagetitle";s:37:"Philosophy By Example « Cliche Niche";s:
15:"google_pagerank";i:2;s:12:"google_links";b:0;s:10:"alexa_rank";s:
10:"27,056,874";s:11:"alexa_reach";s:10:"26,656,375";s:
13:"alexa_linksin";s:1:"3";s:15:"yahoo_backlinks";i:0;s:
9:"msn_links";i:0;s:15:"alltheweb_links";s:1:"6";s:
15:"altavista_links";s:1:"6";s:9:"seo_stats";a:6:{s:4:"body";i:0;s:
4:"meta";i:0;s:2:"h1";i:0;s:3:"alt";i:0;s:3:"url";i:0;s:5:"title";i:0;}
s:15:"keyword_density";d:0;}i:4;a:13:{s:3:"url";s:38:"http://
www.nichephilosophersstone.com/";s:16:"google_pagetitle";s:57:"Niche
Philosopher's Stone - Turns Tiny Things to Gold";s:
15:"google_pagerank";i:0;s:12:"google_links";s:2:"19";s:
10:"alexa_rank";s:9:"1,855,647";s:11:"alexa_reach";s:9:"2,730,154";s:
13:"alexa_linksin";i:0;s:15:"yahoo_backlinks";s:2:"17";s:
9:"msn_links";s:1:"2";s:15:"alltheweb_links";s:2:"13";s:
15:"altavista_links";s:2:"14";s:9:"seo_stats";a:6:{s:4:"body";i:1;s:
4:"meta";i:0;s:2:"h1";i:0;s:3:"alt";i:0;s:3:"url";i:1;s:5:"title";i:1;}
s:15:"keyword_density";d:0.02;}}}
"""
"Philosophy By Example « Cliche" part shows errorneous characters when
i use DAL to seek data. How should i decode data and what should i do
in this case?
Another thing is, that on webeditor (appadmin) toggle code should keep
latest setting, not switching back to on state after submitting edited
text. In some cases plain text edit without editor features is so much
faster, that id like to edit just in textarea mode.
-Marko
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
