3 methods to tweak your MySQL database result pages

Most people use PHP and MySQL together and there are several reasons to do so: It’s easy, fast and powerful! If you create a MySQL database result, the data is not formatted and looks ugly. The following functions or code examples will help you to create better looking MySQL database result pages. Continue reading 3 methods to tweak your MySQL database result pages

Convert string to slug and other custom string functions

Recently I needed a function to convert a company name into a slug. As an example this slug is for the URL of a customer detail page. Since those names (the customer database table has more than 1300 records) contains special characters like “é” or “ë”, I needed a function that can handle this too. A quick Google search has provided something like this: Continue reading Convert string to slug and other custom string functions

Create a dynamic select menu with PHP

In many HTML forms or content management systems the form element “SELECT” is used frequently. If you use your PHP code inside the standard HTML element the code will be nearly unreadable. Adding extra options is not really fun. This small handy function will produce a select menu based on an associative array. Just define an array and call the function, that’s all you need to do. Continue reading Create a dynamic select menu with PHP