Don’t you have sometimes the problem that you don’t know how to begin when you are programming a class or so?
You are thinking and thinking of how you could design the class or class hierachy (Polymorphism) that it is easy to understand, lightweight, not so much time consuming to implement it and so on…
Then after hours of thinking you have a solution but you are never sure if it’s really okay like that. You just implement the class and if something does not fit you have to change it.
But now think of it, is that really reasonable? You put so much time into designing a class or class hierachy but for what? That you can change everything in let’s say 200 files where you used that class? That shouldn’t be!

As an example we take a communication with a database. The standard in PHP is to use MySQL, that’s okay but what happens if you want to use PostgresSQL now? You maybe will have to change every query statement because it can be case that in this dialect something is written different than in the other. So it’s hard for use to change the database system just by replacing the connect call to a new one. We not only have the problem with the SQL statements, but you have to change the calls of the SQL statements too.

Here you can see a PHP example to know what I mean by that.

// Using PostgresSQL
$conString= "host=localhost port=5432 ".
                 "dbname=DATABASE ".
                 "user=USERNAME ".
                 "password=PASSWORD";
$connection = pg_connect($conString);

$sql = "SELECT field FROM table WHERE field = '$something' ";
$result = pg_query($connection, $sql);
$fetch = pg_fetch_row($result);

pg_close($connection);

// -------------------
// Using MySQL
$connection = mysql_connect("localhost", "USERNAME", "PASSWORD");
mysql_select_db ("DATABASE", $connection); 

$sql = "SELECT field FROM table WHERE field = '$something' ";
$result = mysql_query($sql, $connection);
$fetch = mysql_fetch_row($result);

mysql_close($connection);

Here we don’t have a problem with the SQL statement, but what happens if you use the function mysql_query for about 500 times in 200 different files? Try to change that! Somebody will probably say now that there are tools which you can use to make such mass operations, but that’s not the point! What do you want to do now if we have a SQL statement that is not compatible to other SQL systems? You have to change nearly everything in your application to correct that. It’s really time consuming, so we should try to get to find a solution.

First of all think about something like a DAO class. DAO (Data Access Object) is really nice and saves you a lot of time. In a DAO class you make methods which give you back objects as result. Let’s say you have something like showing news on a website. Then make a method getNews() and just use that method everywhere you need the news. You can define parameters for that method and so on but you always get let’s say an array of news objects from that method. That’s really nice because you don’t have to think about what the name of the column was and so on, your IDE will suggest the methods and variables. This kind of system is very simmilar in some points to an ORM (Object Relation Mapping) system which don’t has any foreign keys but the objects which is related to the foreign keys. Of course you still have to implement data classes for each table but this will help you a lot.

So now we have a DAO object which handles the connection to the database and provides methods which give us arrays of objects but we still have the compability problem to other systems, for this I suggest to use PDO (PHP Data Object) in PHP. In Java we have JDBC, in .NET Linq and so on. With PDO you have only one class which uses drivers to communicate with the database systems, you only have methods like query() and fetch() so we don’t have to rename the calls any more.

// Using PDO
$connectionString = "mysql:host=localhost;dbname=DATABASE";
$user = "USERNAME";
$pass = "PASSWORD";
$pdo = new PDO($connectionString, $user, $pass);

$sql = "SELECT field FROM table WHERE field = '$something' ";
$stmt= $pdo->query($sql);
$fetch = $stmt->fetch(PDO::FETCH_NUM);

$stmt->closeCursor();

As you can see, it’s easy and the best is, if you change the database system, you just have to change the connection string!

I hope you enjoyed this article and you will go on reading my texts about design patterns!

If anyone is interested in watching the live presentation just make a comment then I will post the address and when the presentation will be!
Here again the account for testing the Blazebit CMS.

Blazebit CMS ( Nick: Demo | Password: demo123)

The CMS will change a lot in the next weeks so don’t wonder when we get a new design and new functionalities!

We are really proud of it and when we get the final decision about that I will try to complete the CMS until that day. The CMS will get redesigned by Bernd Artmueller and we will also get a new Webdesign for our portfolio.
There will be many companies to look at how the students are doing and with that CMS we will be probably the stars of the day

So in the next days I will let you know how it is going on.
By the way you can test and check our CMS if you want to.

At the moment we are changing the structure a bit so there will be major changes to the CMS.

• Blazebit – Our main site, will be redesigned soon…
• Blazebit CMS ( Nick: Demo | Password: demo123) – redesigned in few weeks…

I hope you like it and maybe give me some feedback of what I could change!

These calculation times are from PHP.NET so as you can see SHA512 takes twice as long as SHA256 for calculation but your applications will be more secure! SHA512 has 128 hex characters and I haven’t found any database yet which you can use to get the plaintext from a hash. The only way to crack a SHA512 is by using a password dictionary and for this I would recommend you to use a SALT.

The SALT should contain special characters like ‘$’, ‘%’, ‘&’ and so on. With the special characters it is much harder for a cracker to crack the hashes with dictionaries!

Here an example of hashing with SHA512 and a SALT.

	$Algo = "sha512";
	$Salt = "!§$%&/()=?";
	$Password = "Hello";

	echo $Password;
	echo hash($Algo, $Salt.$Password.$Salt);

This will give you the following output…

Hello
009afe8d638e00b1b51fbe33666b337d57d9bc3819ec6ceba3e5dc5e984390cd95979994a02cb…

Nice heh? 128 hex characters! =D
I hope you enjoyed this article and you will try to use SHA512 instead of MD5, SHA1 or SHA256!

Here a short description about what TAPI is.
The Telephony Application Programming Interface (TAPI) is a Microsoft Windows API, which provides computer telephony integration and enables PCs running Microsoft Windows to use telephone services.
With it you can control a telephone which uses this TAPI. You can listen for calls, make calls and many other things.

For this project I only needed to make a call by clicking on a number in the browser, of course it should work in every browser.
First of all we will check how to get the number from the browser to the telephone. A client has installed the telephone so we need a client solution. So what can we do on the client to pass a number as parameter via TAPI to a telephone? Probably via desktop command line application which is using the TAPI-Library.
Okay now we know how will communicate with the telephone, but how will that application get the number from browser?
On way could be via Javascript, which is probably not realizable. The other choice and I think that’s the last option we have is to register a new protocol, like HTTP. So we have for example something like “phone:0123456789″ instead of “http://…”.

How can we register such a protocol now?
I don’t know how to do that on UNIX Systems but on Windows we just need a registry entry!

REGEDIT4

[HKEY_CLASSES_ROOT\PROTOCOL_NAME]
@=”URL:PROTOCOL_NAME Protocol”
“URL Protocol”=”"

[HKEY_CLASSES_ROOT\PROTOCOL_NAME\shell]
[HKEY_CLASSES_ROOT\PROTOCOL_NAME\shell\open]
[HKEY_CLASSES_ROOT\PROTOCOL_NAME\shell\open\command]
@=”\”PATH_TO_EXE\” \”%1\”"

By replacing the PROTOCOL_NAME with your own protocol and the PATH_TO_EXE with the absolute path to your exe file you can pass parameters to the program.

tapi.reg

REGEDIT4

[HKEY_CLASSES_ROOT\phone]
@=”URL:phone Protocol”
“URL Protocol”=”"

[HKEY_CLASSES_ROOT\phone\shell]
[HKEY_CLASSES_ROOT\phone\shell\open]
[HKEY_CLASSES_ROOT\phone\shell\open\command]
@=”\”C:\\TAPI\\TapiCall.exe\” \”%1\”"

The %1 is for a parameter, you will get that parameter through the arguments in the main method.
I have made a batch file which installs the the whole thing…

install.bat

mkdir “C:\TAPI”
copy Interop.TAPI3Lib.dll “C:\TAPI”
copy TapiCall.exe “C:\TAPI”
tapi.reg

This batch file creates the directory TAPI on C: and copies the files which are needed and finally executes the regedit file.
Now we just need the program which sends the number to the TAPI-Device.
I decided to use C# because I found a TAPI Library for C# and of course because I know C# really good.
It is easy to make programs with C#, you can be really fast and the community is really big.
I used an example from Codeprojects to test the dialing process and the final solution look like that…

Here you can see the main method which takes the main parameters and parses it.
Don’t forget to include the TAPI-Library.

Finally the call method which takes the number as string. Here i use the line which name contains “Agfeo” because the TAPI devices are from Agfeo.

When you click on a link now which has the value phone:123456 in the href attribute the program sends the number 123456 to the TAPI device to and starts the call.
This is a browser independent solution of using your own protocol on a windows machine via browsers.
I hope this helped you a bit if you try to make something like that.

The Visual Studio Project is in the source files which you can download here.

TAPI Project Files

By the way it uses the Crypter Class, so if you have not read that article so far check it out here.

Crypter Class

I wasn’t active for a long time now. I had really much to do so far.
I worked a lot in my school holidays in Graz which is located in the south of Austria (Styria).
3 weeks ago the school started and now I will write a diploma in programming.
Because I have to document all the stuff I do I will keep you update of what I am doing.

Here a short introduction of what I will do…

The project is called, Reporting in the project SAS III
SAS (School Administration Software) is a big program for schools in Austria.
Many schools use this to manage all things they need for a school year, for example managing data of students, teachers, other personal, generate lists of classes and so on…
There are really many functions. You can’t imagine how big it is.
Yeah and my job is to make the reporting for that system.

It’s not easy because at the moment there are about 200 different reports, and these reports have to be available in formats like, XML, CSV, PDF and many more.
So it’s a hard thing to write those Reports all by hand. That’s why we will use JasperReports!
I will tell you more soon, now we will make a kind of study about the topic Reporting.

In this article I will explain how to create a PHP Class to encrypt end decrypt any data with a given password. It is object oriented programmed and uses in PHP existing algorithms.

Read through the whole Tutorial at Nettuts

Special thanks to my good friend and classmate Bernd Artmueller (www.berndartmueller.at).He designed this WordPress Theme and gave it to me for my blog. It is really nice and I know that he has a lot of potential! Great work mate, as go on like that!

Well now something about me and my wonderful life! My name is Christian Beikov and I am 18 years old. I currently live in Boeheimkrichen in Austria, but I will move soon to Kapelln, which is located just a few kilometers away. I have a girlfriend called Alex and I really love her, I think she is the one I want to marry someday, nah I am absolutely sure that I want to.

I started with project oriented programming about 2 years ago. A schoolmate and I wanted to make a game programmed in C#. We learned how to work together and finally decided to set up a new project after we succeeded our game project. That was a simple website for his uncle and we did a really nice job! I made a simple CMS for his specific content which was realized with the Dojo-Framework in the Frontend.

Now we want to found a company and sell our software. You can visit our site here: http://www.blazebit.com. And now we’re currently working on our own CMS and searching for new clients.

I will try to post at least every week a new tutorial about PHP classes or some other topics related to programming (including the source files).

I hope you will like my tutorials and would be really pleased if you visit my again!