Set Same Time Zone in PHP & MySQL

Time Zones are important if you’re creating a social app which will include chat, social network and others which is interacted with the society. There are many time zones and you have to choose one to set in your server. I would totally recommend using UTC instead of your time zone in server. Web Server and Database server are different and they each have their own configuration. This includes the…

Auto Login Without Form in phpMyAdmin

If you’re using phpMyAdmin (PMA), you know that every time you use the application, you have to log in and when the cookie expires, you have to log in again. It’s an annoying thing to log in every time for a developer who needs to do work fast. There is a way to stop this annoying thing. It’s by disabling the login form and auto login when you visit phpMyAdmin.…

Create a Search Engine In PHP, MySQL | Part 3

This is the Part 3 of “How To Create A Search Engine In PHP”. In this part, We make additional adjustments and make the search engine more awesome and cool. DownloadDemo Bot Page Our crawler leaves a mark on every pages it visit. In other words a custom User Agent String goes with each requests to web pages. In the previous part, we set the user agent string as :…

Create a Search Engine In PHP, MySQL | Part 2

This is the Part 2 of “How To Create A Search Engine In PHP”. In this part, We’ll add code to files that are being displayed to the users. We make the database and the table in this part. DownloadDemo index.php The main page of our Web Search is index.php. It has a simple design and is not very advanced as Yahoo or something else. <?include("inc/functions.php");?> <html> <head> <?head("", array("index"));?>…

Create A Search Engine In PHP, MySQL | Part 1

When we all search on the web using Google, Yahoo or Bing, we are curious about how it works and how it gets all the information on the web. When us programmers started coding, we all wanted to create a search engine. I too attempted to create a search engine and I ultimately failed (3 years back). But now, I improved my coding skills, improved my knowledge and ideas. So,…

MySQL NOW() in JavaScript (UTC & Local)

If you know MySQL, you will certainly know the NOW() function that outputs the current date and time with the timezone of the MySQL server. For easy use and compatibility, we use UTC time zone for storing time in database. If you are running a web app that comply with MySQL, then you need the date function as same as the NOW(). So, I will give you a small function…