Author Archives: Deve L. Oper

Pain will teach you that …

SELECT * is bad if you don’t know how large the amount of data can be you get back. … doing a while loop over an unknown amount of data from said SELECT * is even worse. … doing this … Continue reading

Posted in coffee, heavy metal (e.g. lead), PHP | Leave a comment

Kniffeliges OOP – Part 1

The Plan My friend is quite fond of a game named ‘Kniffel’ or ‘Yahtzee’ and as we are seldom in the same place, I started thinking about a way to play it via internet. Of course I want to write … Continue reading

Posted in OOP, PHP | Tagged , , , | Leave a comment

OXID eShop CE 4.6.0

In OXID eShop from a different point of view I described how to run OXID eShop Community Edition without database views. The obstacles of a cheap webpack 😉 Time for an update, as OXID Community Edition 4.6.0 is out now. … Continue reading

Posted in oxshop, PHP | Tagged , , , , , | Leave a comment

MySQL – The Name of the Table

Beware when renaming a table if there are other tables around that have foreign keys on the renamed table. Following case: we want to exchange some table against a better structured one but for some reason do not want to … Continue reading

Posted in howto, mysql | Leave a comment

MySQL hates you …

… if it is badly treated 😉 This post will show something about MySQL locks, transactions and autocommit. Before we start, here’s some useful stuff to know: You get the MySQL connection id with SELECT CONNECTION_ID(); You get information about … Continue reading

Posted in howto, mysql | Leave a comment