I’ve read an article about database design. It’s very simple but I try to design my databases/tables following that article. But there is one thing that is also important. You need to design your tables and their relations so that you can get almost everything your need with as much queries as possible. This is a part that MySQL-s complex queries are very useful. In two last jobs that I did I needed to optimize script as much as possible. One project is a plugin for WordPress that I’m currently working on. When ever I do something I give my best to do it right and I really try to design relations and queries very good. Here are some examples of queries that I needed.
Read the rest
If you ever had a bank account you are familiar with TAN-s (Transaction Authentication Number). What we will do today, is create user login using that kind of system. This will be just simple overview how to do it so you can create more complex and secure login systems. You need to have basic knowledge about classes, HTML, CSS and AJAX because I will not explain in depth what I do. Read the rest