Sometimes we need to connect one server file to another server database. This type of connection is called a Remote MySQL connection. In this tutorial, we are going to see how to connect remote MySQL database in PHP. Let’s dive in. Suppose we have two servers Server 1 and Server 2 and we have to … Read more
This article is about 9 useful dates related MySQL query. When we need to get record from database of a particular time period, these MySQL useful query will make task easy to do. In this tutorial we will learn MySQL query to get current record, last week, last month, last year record. Get Last one … Read more
In previous tutorial we have seen how to Insert Data into Database using PHP MySQLi and we understand how to add records in mysql database table using PHP. In this tutorial we will discuss how to select data from database table using PHP MySQLi. This post will let you help to understand how to fetch … Read more
In this tutorial we will see how to Insert Data into Database using PHP MySQLi. First we create a database then table after that we start to insert data into database table using php mysqli.Mysqli is extended version of MySQL. We will use mysqli to access mysql database. To insert data in database table we … Read more
In previous article, we have discussed that MySQL is depreciated and their alternative options are MySQLi and PDO(PHP Data Object) . In that you have learned how to set up connection using MySQLi in PHP with procedural and object-oriented approach. In this tutorial you will get how to set up a PHP MySQL connection using … Read more
MySQLi is the improved extension of MySQL. MYSQLi (“i” stands from “improved”) extension is used in PHP to provide an interface of MySQL Database. In PHP version 5.5 or later MySQL_connect will not be usable. It means that MySQL is deprecated and will be removed in future. Alternative for PHP 5 version and later are … Read more