Entries by John Behrens

There were highly idiologic discussions about if you should test your privates or not with unit testing or not, in my opinion especially during Development with private methods performing for example calculations it could be useful to Unit Test these. At least during development you make sure that these functions already work, and finally it´s better to change accessibility than just to set accessibility lower to make testing possible. Before PHP 5.3.2 it was not possible to change the accessibility but with the new ReflectionMethod it is. But this feature needs to be used with care, it´s made for unit testing and maybe very special other cases wich are not in my mind yet. Using some magic reflection stuff always makes code very hard to read, maybe you think it´s fance but others might get confused a lot.
Using the ReflectionMethod introduced in PHP 5.3.2
ReflectionMethod::SetAccesible
ReflectionMethod Class

PHP Unit Developer Sebastian Bergmann wrote an article about Testing Your Privates
Sebastians Bergmanns Example:

To manipulate the result Zend_Controller_Request_Http::isXmlHttpRequest() maybe for testing XML Controllers in PHP Unit you just need to set the HTTP_X_REQUESTED_WITH value to XMLHttpRequest Zend_Controller_Request_Http::isXmlHttpRequest() does nothing more than checking for this. Zend_Controller_Request_Http::isXmlHttpRequest() from Zend Framework Code

This is a short tutorial how to remove duplicated entries from MySQL DB Table First idea was just to do a simple DELETE statement on a SubSelect Unfortunatelly this gives back an error message. #1093 - You can't specify target table 'ex_user' for update in FROM clause MySQL Documentation says about that

Error 1093 (ER_UPDATE_TABLE_USED) SQLSTATE = HY000 Message = "You can't specify target table 'x' for update in FROM clause" This error occurs in cases such as the following: UPDATE t1 SET column2 = (SELECT MAX(column1) FROM t1); You can use a subquery for assignment within an UPDATE statement because subqueries are legal in UPDATE and DELETE statements as well as in SELECT statements. However, you cannot use the same table (in this case, table t1) for both the subquery's FROM clause and the update target.

I was searching for a solution without using temporary table but didn´t find one yet. Well thats it.

I always liked some kind of auto generated model to access a database. I liked it the way Symfony does or the Zend Framework Tool. But anytime using a generator is also a bit of mess. The actual Zend Framework quickstart example has a 3 files way of implementing a Model, a Model Class, Model Mapper Class and Model DB Table ClassFew, so for one DB Table you always have to create 3 classes which look almost similar, most times you just copy and paste those, and change a few things. So i decided to create an very flexible model class, where you just need to define the properties and nothing more getter and sette methods will be called by magic functions. Even it has export function to an array. You don´t have to create anything but you can create your own functions for getter and setter methods which would override the default ones. In later state it could be possible to add a filter configurable in the model, but for first step i would like to keep it as slim as possible. The Danymic DBTable and DynamicMapper class are not tested yet, will post theme here later.

This example shows how to create an Zend Framework based SOAP Server and connect to it by a Java Client. The process itself is really easy but some things ara a bit tricky for example at the status were i created it there were some problems if using WS style for the SOAP Server so i decided to use RPC style. The Server basically allows a user to logon by credentials and gives back a userstatus, the Java Client is connecting through this service and requesting the userstatus. The Soap Server Class Zend Controller for the Soap Server Java Client Code With Netbeans a webservice client is really easy to create, right click on the project create new "Web Service Client" More Information: http://netbeans.org/kb/docs/websvc/jax-ws.html JAX RPC Style works better with Zend Framework and PHP. The Stub and Port classes will be Auto generated by Netbeans, so you don´t need to worry about that.

Using the OSAPI Open Social API, i noticed there is no session storage available by default, so this is a very quick way to implement a PHP-Session Bages Storage

I was working with which is a usefull function if you create forms using AJAX request. Simple usage is easy Executes the URL Item Add and replaces content of the Element with item_list with it´s result. Well what i would like to now is a Form which is permanent viewable and will reset itself if sended. What i guessed Well who that doesn´t work, form_remote_tag doesnt know an property called id, you have to hang it behind as html code This way it works, too bad the documentation on it is that poor. But 10 Reasons why Symfony **cks helped me out finding the right solution. However i still think updating a whole element with the list is the wrong way, i would like to use JSON and DOM Manipulation for that, to add exact one entry to the list, i gonna work that out now.

Searching the web i found a lot of solutions and ToolTip Plugins wie z.b. Simpletip oder really simple tooltop, but after i had a short look at some i decided that they are all more or less usefull. The most usuable entry i found was a short entry at Stackoverflow telling me anything i need to know. My basic requirement was, Javascript code has to be Seperated from the design and the Webpage content. So my php template looks like this So this was set cause whoever willing to change the content or layer of the tool-tip or preview div, however you like to call it, should be able to change it without touching the JS functionallity. So what i need to added now was CSS definition to hide tool-tip layer. So anybody could change layout later. Now everything is needed is not an extra plugin or collection of plugins it´s just a few lines of JS code using jquery I always wonder wy people code so many plugins for just so simple things, keep anything more complicated. Okay maybe it´s easier reusable but through most of them will not be maintained in one year or maybe are already lying arround for month, it is easier to just do it yourself. Even this solutions has some Advantages cause the Tooltip Div is already existing inside the site, Javascript doesnt need to pass through all links like for example here. And also a crawler would be able to read the content of the Tooltip Divs easiely. But however in some cases it makes sense to read the content of the Tooltip-Layers later for example if they requery more data, big pictures, calculations etc, it might be an option to read them later by Ajax Request.

It took me a little while to figure out to solve a standard problem like sending an template or view script as email, the main problem is the original documentation doesn´t show anything about it, just sending email with text from a string, and if you search on the web, you find mostly the same thing or solutions which were not satisfying me. The mail Template "mail.phtml" could contain text or HTML. Finally i choosed out this method as the best for sending email in Zend Framework Projects, maybe there would be one more better way, if i could put the subject inside the template file, i gonna save that for later.

User generated content in multilingual enviorments brings up new internationalizations problems, in a social network or other enviorment with a lot of User Generated content, I18N could not be sticked strictly to the user, and even a content or discussion could be spreaden through different languages. On usual websites a language is assigned to the frontend user, also on Youtube where it causes some problems. I always recieve Mails like

Komentarze do filmu „>videoname<” Comentario sobre ">videoname<" publicado Reactie van >userwhopostedcomment< op ,>videoname<' Nouveau commentaire sur ">videoname<" Kommentar zu ">videoname<" gepostet" gepostet

Which all mean your video ... has been commented by ..., but it´s alsways in the default language to the commentor, no matter what my language is and no matter which language the comment is Written in. Comments itself are mostly written in english or the language the video is in. A solution could be to send it just in the recipient´s default language instead the actual frontend language, it would just make it easier for the recipient.

Jeroen - Moie Video, echt Leuk Tommy - Why are all the Comments in Dutch Franz - Die Holländer finden ihre Sprache so Toll Antje - Ihre Sprache ist auch Supertoll Joost - Duits is alleen voor Moffen Tommy - In English Please Joost - German is for Kauts Only Franz - Geh doch Käse essen du Kaaskopp

As you see users could communicate through different Languages, and maybe they even like it and switch Languages during a conversation, if you wanna run your site with an international flavour this is acceptable. Language Detection Language Detection could be usefull, to translate auto detection for example, but you could also hide content with Language Detection For Example: I got a Guestbook entry on my Dutch Netlog, somebody commentet the guestbook in German with something like "Hi ich habe ein bischen Deutsch gelernt, Wie geht es dir? viele grüsse". This entry were hidden cause it weren´t written in my actual frontend Language (Dutch), but actually i had choosen German as native language in my profile. So if you use something like Language Detection to hide content from foreign Languages, you must consider a user could be able to understand more than one language. Hiding content from the user is mostly a bad decission, cause even if the user is not able to read information might be usefull. The better way is always to sign the entry as an entry with different language and offer automated translation possibility. Where it could make sense to hide content is if a user is doing a general search on contents, at least in order of the search results.

http://extraordinaire.me/web-development/bootstrap-zend-framework/

Some days ago i started my first Java project including a GUI, first i began with using eclipse and the beginning was fine, until i came to that point were i had to create the GUI Interface. I didn´t had the intension to define my GUI in writing lines of code, i was mostly searching for something to design a GUI by moving arround some buttons and editor boxes like in Visual Studio or Delphi. After a few tryouts with outdated tutorials i could finally install the Visial Editor for Eclipse by using this tutorial, i noticed that comfortable solution i am searching for, searching arround how to work with it i just found out, the VE is propably not able to do what i tried. So i decided to try out Netbeans, and i were completly satisfied, download and installation were quite easy and the GUI Designer does it´s work almost perfectly, you don´t have to waste your time in configurating layouts just move them arround with drag and drop, almost as good as in Delphi. So what i decided was stop to use Eclipse for that Java stuff and start to use Netbeans and so far Netbeans hits all of my needs exactly, even seems to be more out of one piece than eclipse. Maybe gonna try it out Netbeans for PHP aswell.

1. The .yml YAML format is very vulnerable for type errors, just one space to much and it breaks
2. Version incompatibility, well to upgrade your symfony framework always cause problems and is not to
3. Too much configuration files. Symfony has too much points were you can configure it or overwrite other configuration, so you never can be sure if it works the way you expect.
4. Documentation is hard to search, a bunch of tutorials but no real documentation even not all parts are up to date. for example try to find documentation about "form_remote_tag" a complete searchable function reference would be helpfull.
5. view.yml files, why should i put logic, like that my ajax request has no Layout to a configuration file?, I prefer it where the request is handled.
6. You Always have to clear the cache during develloping, and sometimes you just forget.
Well there are very positives things of Symfony Framework but these made me most annoyed during Symfony Development.

Here is a list of my most used Symfony command line rool commands Generate a new module php symfony generate:module application modelname Generate Schema from database

I always build the Schema from the Database, cause it is easier to Maintain the Database than the Schema file, you can use yoru default Database tool e.q. PhpMyAdmin or MySql Workbench, even there is no chance that sombody implements Database changes wich could be overwritten.

Generate Model Generating the Forms Generate Module from Table

Note: the TableNameCamelCase is using Uppercase letter before any underscore e.q. TableNameExample for table_name_example

Well calculating age in PHP seems to be not that big thing Date calculation is something wich would be a good topic for Programming for Beginners Lesson 2 It is not that much used cause Databases give a lot of nice date calculating functions like MySQL DateDiff or similar function on other Database. PHP has not had a DateDiff function from home until PHP 5.3, unfortunatelle the PHP Version on server was 5.2.4 so i could not use the PHP DateDiff Function from the new DateTime Functions. Cause i was a bit lazy i thought it might be easy to find a usefull function to calculate Age in PHP but anything i found was a bunch of useless forum discussions and not 100% correct working answers so i wrote an own one. The problem is 365 days is not the correct number of days for a year. Every 4 years there are 366 cause of the leap year But every 100 years there is no leap year. Like 1900 But every 400 years there is. Like 2000 So for every 4 years of age, this method gets wrong one more day. A more correct calculation would be Could still have some combinations were it returns a wrong result, so the first example is still better. Maybe i gonna past a full datediff function later once, otherwise upgrade to PHP 5.3, so as i will do soon.