by ds | Sep 25, 2014 | MySQL, PHP
Scenario You have to move a MySQL database table to another database, but you have many other tables, functions, routines, events etc. which access it. Before moving it, it is not enough to find only the tables containing foreign keys, but also find functions etc....
by ds | Jul 28, 2014 | MySQL, PHP
Problem Framework CakePHP sets strings to null which are loaded from database tables and contain special characters like German Umlaute. Solution In app/Config/database.php, add to your config array: ‘encoding’ => ‘utf8’ Example: public...
by ds | May 23, 2014 | PHP
Scenario After upgrading from PHP 5.3 to 5.5, Smarty returns empty strings when using e.g. “html_options” etc., if the “values” or “output” array contains special characters like German Umlaute (ä, ü, …). Reason From PHP 5.4...
by ds | Dec 11, 2013 | C# .Net, PHP
What I was trying to achieve was to write a simple SMS web interface to send text messages via an old GSM modem (Huawei E270) which is connected to USB. I wanted to write it myself because of existing database contacts integration etc. So after installing the Huawei...
by ds | Jul 22, 2013 | PHP
Problem An unregistered customer tries to checkout (without login), but the wizard does not show the shipping info page automatically after choosing “ship to this address” and clicking the button – the user has to click directly on “shipping...
by ds | Jul 20, 2013 | PHP
Basically, this tutorial provides a good way to upgrade, but you have to notice some additional things: Do not run the update directly on your live system! Better try it on a local test installation. Some images and CSS settings have to be changed manually before....
