mysqlTag Archive

How to install and configure Opencart – 3.0.2 On CentOS – 7. DATE POSTED: 19-10-2018 What is Opencart and its real-time purpose in this world ? OpenCart is a free and open source  online e-commerce web application. It is written in PHP and uses MySQL to store its database. It has… Continue Reading How to install and configure Opencart – 3.0.2 On CentOS – 7.

Insert data into database using codeigniter Date posted: 04-oct-2018 Please follow  the steps to insert data into database using codeigniter Step 1: Create a new file under the path Application/controllers/Insert.php.Copy the below given code in your view. <?php class Insert extends CI_Controller { public function __construct() { //call CodeIgniter’s default… Continue Reading Insert data into database using codeigniter

Upgrading WordPress Manually in Centos 7 Date Posted : 20-09-2018 In this article, we are about to learn about how to upgrade WordPress version from rear end.We assuming that your have installed LAMP stack. Prerequisite : Acquaintance of WordPress,MySQL Assumptions: Centos 7 is running in your server WordPress version :… Continue Reading Upgrading WordPress Manually in Centos 7

Change mysql data directory on cPanel| Safely move mysql data directory – Centos Date Posted: 05-05-2018 This post explains on how to move or setup different data directory for mysql application. If there is no database exists, skip the first step. This post deals with moving data directory to /home/mysql… Continue Reading Change mysql data directory on cPanel| Safely move mysql data directory – Centos

Date Posted: 05-04-2018 In this we will explain MySql replace NULL values with empty string. Step1: You can create two different tables. using the following query. CREATE TABLE `users` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(16) NOT NULL, `name` varchar(40) DEFAULT NULL, `last_name` varchar(60) DEFAULT NULL, PRIMARY KEY… Continue Reading MySql replace NULL values with empty string

ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_520_ci” Date Posted: 04-10-2017 Recently, when we tried to resource the dump which we had taken on one server and tried to restore it on another server. The restore failed with an error: ERROR 1273 (HY000) at line 25: Unknown collation: ‘utf8mb4_unicode_520_ci”… Continue Reading Unknown collation: utf8mb4_unicode_520_ci

Posted Date:20-07-2017 In this we will explain mysql_query update using custom user created function Step 1: Create table name as product using following code CREATE TABLE `product` ( `pid` int(11) NOT NULL AUTO_INCREMENT, `pname` varchar(100) NOT NULL, `price` int(11) NOT NULL, `pimg` varchar(100) NOT NULL, `cat_id` int(11) NOT NULL, PRIMARY… Continue Reading Update query in php using function

Posted Date:04-08-2017 In this post we will explain dynamic column header and result from ajax call in jquery datatable   Step 1: Include jQuery  Plugin and css <link rel=”stylesheet” type=”text/css” href=”http://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.4/css/jquery.dataTables.css”> <source src=”http://code.jquery.com/jquery-2.2.4.min.js” integrity=”sha256-BbhdlvQf/xTY9gja0Dq3HiwQF8LaCRTXxZKRutelT44=” crossorigin=”anonymous”></source> <source type=”text/javascript” charset=”utf8″ src=”https://cdn.datatables.net/1.10.15/js/jquery.dataTables.min.js”></source> Step 2: Add the following script for data table initialization with… Continue Reading dynamic column header and result from ajax call in jquery datatable

Posted Date:08-05-2017 In this post we will explain dynamic dependent drop down list using html,php,mysql,ajax Dynamic Dependent dropdown list using php Step 1: Create a new file dropdown-ajax.php step 2: Create a mysql connection code inside dropdown-ajax.php <?php $host = ‘localhost’; $user = ‘root’; $pass = ”; mysql_connect($host, $user, $pass);… Continue Reading Dynamic Dependent drop down list using html,php,mysql,ajax

Date Posted:17-02-2017 This post we will explain on how to avoid duplicate mobile number update in user profile. Assumption: Table Name: ls_user Column name:phone, email Implementation: First,pass your email id and also pass new phone number second,run the query and check the number of rows zero mean execute next functionality… Continue Reading how to avoid inserting duplicate row in php while update user profile