{"id":884,"date":"2010-01-09T22:42:25","date_gmt":"2010-01-09T21:42:25","guid":{"rendered":"http:\/\/blogg.ngn.nu\/index.php\/2010\/01\/09\/fortfarande-kallt-som-attan\/"},"modified":"2016-11-23T13:46:33","modified_gmt":"2016-11-23T11:46:33","slug":"fortfarande-kallt-som-attan","status":"publish","type":"post","link":"https:\/\/blogg.ngn.nu\/index.php\/2010\/01\/09\/fortfarande-kallt-som-attan\/","title":{"rendered":"Fortfarande kallt som attan&#8230;"},"content":{"rendered":"<p>\n\ts&ouml;mn ok.\n<\/p>\n<p>\n\t<strong>Motion<\/strong><br \/>\n\tHar det varit skralt med. Lite orolig f&ouml;r mina kn&auml;n s&aring; det har bara blivit lite l&auml;tt tr&auml;ning med Wii Fit. Kylan h&aring;ller mig inne&#8230;\n<\/p>\n<p>\n\t<strong>Bes&ouml;k<\/strong><br \/>\n\tHar vi haft. V&auml;nnen M var h&auml;r med hunden Tippex.\n<\/p>\n<p>\n\tKort d&auml;refter kom brodern med flickv&auml;n, de fick testa Wii, lite&#8230;\n<\/p>\n<p>\n\t<strong>Programmering<\/strong><br \/>\n\tHar det blivit en hel del idag.\n<\/p>\n<p>\n\tNu har jag blivit &#39;v&auml;n&#39; med &#39;h&auml;ndelsekedjan&#39;: HTML-dokument visar &#39;spelet&#39;, laddar en JavaScript-fil. JavaScriptet sk&ouml;ter den basala kontrollen av vad som skrivs och visas. F&ouml;r mer &#39;avancerad&#39; analys anv&auml;nder jag en MySQL databas som jag placerat p&aring; &#39;min&#39; (virtuella) server&nbsp;p&aring; mitt WebbHotell.<br \/>\n\tF&ouml;r att komma &aring;t den databasen har jag en s.k. php-sida som &ouml;ppnar, tar emot och &#39;visar&#39; ett resultat av en databasf&ouml;rfr&aring;gan. Det sker via SQL. F&ouml;r att f&aring; svaret fr&aring;n php-sidan och kunna skicka databasfr&aring;gan, fr&aring;n JavaScript s&aring; anv&auml;nder jag en s.k. AJAX-funktion. &#8230; f&ouml;r att det ska visas p&aring; HTML-sidan.\n<\/p>\n<p>\n\tF&ouml;rst valde jag att l&auml;gga &#39;svar&#39; i en s.k. textarea. De &auml;r i ett avseende enkla att hantera men det finns inget s&auml;tt att f&aring; t.ex. olika stilar etc. S&aring; jag fick &#39;koda om&#39; det hela och anv&auml;nda mig av en s.k. lagertagg, en DIV.\n<\/p>\n<p>\n\tD&aring; d&ouml;k n&auml;sta problem upp. Den text som fanns i databasen, med &aring;&auml;&ouml; t.ex. visades som &#39;konstiga tecken&#39;, i &#39;DIV&#39;:en.\n<\/p>\n<p>\n\tHar klurat ut att det d&auml;r beror p&aring; en &#39;svaghet&#39; i php och det finns en massa mer eller mindre kr&aring;ngliga s.k. workarounds.\n<\/p>\n<p>\n\tJag valde att ers&auml;tta alla &aring;&auml;&ouml;&Aring;&Auml;&Ouml; med deras respektive s.k. &#39;Entity Number&#39;:\n<\/p>\n<p>\n\t<big><code>&aring; = &amp;#229;<br \/>\n\t&auml; = &amp;#228;<br \/>\n\t&ouml; = &amp;#246;<br \/>\n\t&Aring; = &amp;#197;<br \/>\n\t&Auml; = &amp;#196;<br \/>\n\t&Ouml; = &amp;#214;<br \/>\n\t&copy; = &amp;#169;<\/code><\/big>\n<\/p>\n<p>\n\tEn bra referenssida &auml;r: <a href=\"http:\/\/www.whoishostingthis.com\/resources\/iso-8859-1\/\" target=\"_blank\">http:\/\/www.whoishostingthis.com\/resources\/iso-8859-1\/<\/a>\n<\/p>\n<p>\n\tJag gjorde detta val mest beroende p&aring; att all HTML-kod (som ocks&aring; lagras i databasen som s.k. textstr&auml;ngar) som t.ex. <big><code>&lt;br&gt;<\/code><\/big>(ny rad), <big><code>&lt;i&gt;&lt;\/i&gt;<\/code><\/big>(kursiv text), <big><code>&lt;strong&gt;&lt;\/strong&gt;<\/code><\/big>(fet text) inte beh&ouml;ver &#39;omvandlas&#39; (till entitiekoder).\n<\/p>\n<p>\n\tDet finns annars en php-funktion som man kan experimentera med: <a href=\"http:\/\/php.net\/manual\/en\/function.htmlentities.php\" target=\"_blank\">htmlentities()<\/a>\n<\/p>\n<p>\n\t<strong>H&auml;lsol&auml;get<\/strong>:<br \/>\n\tSom n&auml;mnt, inledningsvis, det finns lite oro f&ouml;r mina kn&auml;n. Annars ok.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>s&ouml;mn ok. Motion Har det varit skralt med. Lite orolig f&ouml;r mina kn&auml;n s&aring; det har bara blivit lite l&auml;tt tr&auml;ning med Wii Fit. Kylan h&aring;ller mig inne&#8230; Bes&ouml;k Har vi haft. V&auml;nnen M var h&auml;r med hunden Tippex. Kort &hellip; <a href=\"https:\/\/blogg.ngn.nu\/index.php\/2010\/01\/09\/fortfarande-kallt-som-attan\/\">Forts\u00e4tt l\u00e4sa <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[570,448,392],"tags":[750,747,311,751,571,307,749,295],"class_list":["post-884","post","type-post","status-publish","format-standard","hentry","category-besok-upplevelse-halsa","category-halsa","category-programmering","tag-ajax","tag-html","tag-javascript","tag-mysql","tag-nintendo-wii","tag-php","tag-sql","tag-webbhotell"],"_links":{"self":[{"href":"https:\/\/blogg.ngn.nu\/index.php\/wp-json\/wp\/v2\/posts\/884","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogg.ngn.nu\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogg.ngn.nu\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogg.ngn.nu\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blogg.ngn.nu\/index.php\/wp-json\/wp\/v2\/comments?post=884"}],"version-history":[{"count":1,"href":"https:\/\/blogg.ngn.nu\/index.php\/wp-json\/wp\/v2\/posts\/884\/revisions"}],"predecessor-version":[{"id":11370,"href":"https:\/\/blogg.ngn.nu\/index.php\/wp-json\/wp\/v2\/posts\/884\/revisions\/11370"}],"wp:attachment":[{"href":"https:\/\/blogg.ngn.nu\/index.php\/wp-json\/wp\/v2\/media?parent=884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogg.ngn.nu\/index.php\/wp-json\/wp\/v2\/categories?post=884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogg.ngn.nu\/index.php\/wp-json\/wp\/v2\/tags?post=884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}