Posts in MySQL
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 MySQLi and PDO(PHP Data Objects). So, in this tutorial we will see how to use mysqli_connect in PHP to connect with database.
Hi guys, in this article we will learn about how to use Dynamic SQL Insert Query in PHP and MySQL. You will get bored of writing SQL insert query again and again as web developer. This approach will reduce the time which wasted on writing insert query in web application development. Each time not need to write complete insert code to add data.
One day i faced a problem for matching a single value holds in variable from a database column which holds comma separated values for search box