Last year while i was the administrator of a one of popular turkish it community we’ve made a programming contest which was cancelled for a reason of no contestants. The subject of contest was to make a blogging program including two parts. First part was the client side part which contestants need to made a blog administration interface. Second part was the web part which contestants need to made a web interface.

The idea of this subject was this : Making administration panels is a so hard process. So why don’t we make administration section with a more object oriented language like Delphi?

While contest some people made critics including that we were wanting a program which we were planning to sell it!

This critics made me sick. Then i wrote a program similar to contest. I wrote a “Delphi Component Index” site which can be still accessable via www.componentbeacon.com

I made web site with PHP and client side with Delphi. Site uses mySQL.

Lets go in detail.

Read the rest of this entry »

Tags: .net, ajax, delphi, focus on code, ide, idea, php, programming, web programming

If you make a tag system and want to make a tag cloud page which will writes tags in different sizes accoring to use time refer to Tag Cloud document. That’s an easy and practical way for you. (Document Mirror on Focus on Code (186KB))

If you want to learn CSS Positioning or need a manual in your pocket you can refer to Learn CSS Positioning in Ten Steps article. That’s a very good and simple article including most of positioning styles. (Document Mirror on Focus on Code (88KB))

If you want to read and write to TWebBrowser component on Delphi you can refer to How to read and write form elements article. Article contains most wishes while using TWebBrowser. Before using these just insert Microsoft HTML Object Library to your project and add MSHTML_TLB class to your uses block.(Document Mirror on Focus on Code (52KB))

Tags: css, delphi, php, programming, tags, twebbrowser

I’ve searched for if there was a good solution for database driven application which uses tags. Finally i found a blog entry discussing tags and database schemas.

In that entry “Toxi Solution” is the best solution. Simply the schema is like this :

I liked this schema and using it for 4 months in my projects. I’m not only using this for tags on my projects that most of table “references” are done like this. This is an old and good system for referencing tables.

For future references you can download a copy from Focus on Code : Tags_ Database schemas.mht (204KB)

Tags: database, programming, schema, sql, tags

When using Zeos Database Objects you can encounter some problems about charset. The main charset problem will be that you’re using a charset different than latin1. In this case you can get some errors while showing or fetching data from mySQL.

We have a simple solution :

Read the rest of this entry »

Tags: charset, database, delphi, errors, mysql, programming, solutions, zeoslib

PNG Delphi is Delphi Component (or Class) for doing PNG operations through Delphi. It has lots of functions and procedures to manipulate PNG files.

For example if you want to load a PNG image practically to a TImage area simply write this code :

Read the rest of this entry »

Tags: component, delphi, png, programming

If a field’s type is TEXT ( like LONGTEXT, MEDIUMTEXT etc) and we try to show it on a DBGrid it’ll be shown like (MEMO). But everyone in the world want to show some part of the TEXT field to user. For example you want to show user first 200 characters of the TEXT field.

To solve this situation;

Read the rest of this entry »

Tags: database, dbgrid, delphi, programming, solutions

If you’re trying to get the contents of a page which has an utf-8 encoding using PHP’s socket functions (fsockopen, fgets, etc) may be you take some strange text which is parted or sliced into unknown parts like this :

Read the rest of this entry »

Tags: php, programming, sockets, solutions, utf-8