UNSIGNED — When to use it">MySQL UNSIGNED — When to use it

May 21st, 2011 Dan No comments

A lot of people may ask them­selves when devel­op­ing data­bases when to use the UNSIGNED keyword.

So what’s the dif­fer­ence between a “signed” integer and an “unsigned” integer?

An “unsigned” integer can not be neg­at­ive but the upside is that you can have a big­ger range of pos­it­ive numbers.

I think the fol­low­ing types explain themselves:

Tiny­int -> Signed range -> –128 to 127
Tiny­int -> Unsigned range -> 0 to 255

Medi­umint -> Signed range -> –8388608 to 8388607.
Medi­umint -> Unsigned range -> 0 to 16777215

Bigint -> Signed range -> –9223372036854775808 to 9223372036854775807
Bigint -> Unsigned range -> 0 to 18446744073709551615

That’s should explain it. Short but inform­at­ive… hopefully!

Categories: General stuff Tags: , ,

PHP5 and Curl (Filters ReTweets)">Twitter Scan class using PHP5 and Curl (Filters ReTweets)

May 13th, 2011 Dan 1 comment

The other day I star­ted work­ing on a Twit­ter pro­ject and what I need to do is to scan Twit­ters pub­lic timeline and get a cer­tain amount of tweets from a cer­tain user. On top of that it needs to be filtered by hashtags.

After brows­ing the net for a little while I found a fant­astic class on script­play­ground.

I imple­men­ted it in my pro­ject and it worked like a charm.… until I wanted to fil­ter out ReTweets. I simply couldn’t find any addi­tional para­meter for the Twit­ter Search API that could do that for me. I mean I tried to put –RT and all that sort of stuff into the search-call but it simply didn’t work out for me.

Maybe I did some­thing wrong. If so, I would highly appre­ci­ate a com­ment that will widen my horizon!

So I decided to extend the class myself and provide it for any­one who might find it useful.

Read more…

Daily A[n]d[roid]obe

May 13th, 2011 Dan No comments

… is the name of the new daily magazine I cre­ated on paper.li. It’s all about Adobe Flash — Flex — Cata­lyst and Android punch lines! So stay tuned and subscribe!

Daily A[n]d[roid]obe.

Categories: General stuff Tags: ,

Neat Tool — Auto Aero Colors

May 12th, 2011 Dan No comments

I was just brows­ing for the latest ver­sion of Tor­toise SVN when I stumbled upon this neat little tool which imple­ments a fea­ture into your Win­dows 7 OS that will be avail­able in Win­dows 8 (or what ever they are gonna call it).

It changes your win­dows aero color depend­ing on the over­all col­our of your wall­pa­per. Check it out, it works like a charm!

Categories: Software Tags: , ,

New Design and Custom Header online!

May 3rd, 2011 Dan 6 comments

Here it is… my new design with a cus­tom header that I cre­ated last night.
The design was ori­gin­ally cre­ated by patembe.
You can throw the social net­work icons around and be amazed by the phys­ics. If you double-click the items you will be redir­ec­ted to my pro­file page of the cor­res­pond­ing social network.

Enjoy and leave me a com­ment if you like it…

PHP">Sorting a multidimensional array in PHP

May 1st, 2011 Dan 3 comments

After search­ing the inter­net for some­thing trivial like the sort­ing a mul­ti­di­men­sional array I found the fol­low­ing solution.

Read more…

Categories: PHP Tags: , ,

NET 3.5 — Getting Started Tutorial">Flex 4 + FluorineFX + .NET 3.5 — Getting Started Tutorial

April 19th, 2011 Dan 23 comments
Today we will look into get­ting a proper setup for con­nect­ing a Flex 4 applic­a­tion to a .NET backend.
I have found sev­eral tutori­als on that topic on the inter­net but none of them covered the whole pro­cess in one go. So I had to gain my know­ledge by com­bin­ing what I’ve learned from sev­eral dif­fer­ent tutori­als and mak­ing some guesses in the end to make it work.
To spare you this — some­times tedi­ous — pro­cess I will guide you through the install­a­tion and con­fig­ur­a­tion of Flex 4 with Flu­or­ineFX to con­nect to a .NET backend.
Let’s get started.
Read more…

FIX!">WordPress plugin generated unexpected output during activation — FIX!

April 15th, 2011 Dan 1 comment

You are here because as a Word­Press plu­gin developer you are exper­i­en­cing the fol­low­ing error:

The plu­gin gen­er­ated 8 char­ac­ters of unex­pec­ted out­put
dur­ing activ­a­tion. If you notice “head­ers already sent” mes­sages,
prob­lems with syn­dic­a­tion feeds or other issues, try deac­tiv­at­ing or
remov­ing this plugin.

I solved the issue by doing the following…

Read more…

Categories: PHP, WordPress Tags: , ,

SWF file — FIX!">Flash Security Error #2028 — Local-with-filesystem SWF file — FIX!

April 6th, 2011 Dan 9 comments

Hi every­one,

I developed this web applic­a­tion for a cli­ent of mine. It was run­ning fine on a server but now they want an off­line for present­a­tion pur­poses.
So they asked me to do some changes (load local pic­tures etc…) and deploy an off­line version.

So while doing that I dis­covered the fol­low­ing error:

Flash Security Error

Flash Secur­ity Error — fpdownload.adobe.com

This error occurs when I tried to open the HTML file that embeds the SWF in my browser.

Read more…

PHP">Retrieving Twitter’s Public Timeline with PHP

April 1st, 2011 Dan 3 comments

I am just play­ing around with Twitter’s PHP Lib­rary twit­ter­libphp and cre­ated this little application.

You can see the res­ults here.

Read more…

Categories: Coding, PHP, Twitter Tags: , ,