Home » Tutorials » PHP/MySQL

PHP/MySQL

Force URLs to lowercase with htaccess and PHP

htaccess wallpaper

When optimizing your website (SEO) you must check if your website URLs load both with lowercase and uppercase letters. For example mysite.com/My-URL and mysite.com/my-url. It may even be mixed. This is bad and if you don’t fix it, it may harm your website optimization. The solution is to force browsers to redirect all URLs to the lowercase version. The Australian ...

Read More »

Creating Simple Responsive HTML5 and PHP Contact Form

responsive email form php

In this tutorial I will show you how to create a responsive html5 contact form for your website in just a few minutes. Having a Contact form is essential for any website, because this is the connection with your visitors and clients. The form is divided in two parts – the HTML5/CSS3 Responsive part and the PHP backend code part ...

Read More »

Creating JSON API with pagination

The goal of today’s tutorial is to create a REST API with pagination. The API will get several values from MySQL and then convert them to JSON format. For the purpose of the tutorial we will get the post_title and the post_date from ftutorials’s MySQL. In your real API you can print whatever data you want. Create a file api.php ...

Read More »

Export cyrillic mysql database to csv

cyrillic encoding

Very common encoding problem is when you are trying to export cyrillic mysql database to CSV for MS Excel. We all know what is the normal export procedure – go to phpMyAdmin > select the desired table and click Export. For Export Method choose Custom – display all possible options. Then change the encoding to utf-16. The problem when you ...

Read More »