Mysql UPDATE query using Join Statement
Here you can find how to use update query with join, difficult update query in join We often use join clauses to query rows in a table that have (in the case of INNER JOIN) or may not have (in…
Read MoreMysql UPDATE query using Join Statement
How to get maximum value in mysql table column using Codeigniter
to find max value form query select_max method in codeigniter CodeIgniter is a framework based on MVC principles. As a result, you would usually separate application logic, data abstraction and “output” into their respective areas for CodeIgniter use. In this case:…
or_where condition in Codeigniter
CodeIgniter is a framework based on MVC principles. As a result, you would usually separate application logic, data abstraction and “output” into their respective areas for CodeIgniter use. In this case: controllers, models and views. When someone trying to or conditions using…
How to use WHERE clauses in Codeigniter
CodeIgniter is a framework based on MVC principles. As a result, you would usually separate application logic, data abstraction and “output” into their respective areas for CodeIgniter use. In this case: controllers, models and views. When we want to restrict the query…
how to subtract days to date in php
In this tutorial i will show you how to subtract days to date in PHP. Many project need this type specialize so, let’s start in code so you are easily understand how to subtract days. You may also like How…
how to get yesterday date in php
In this tutorial i will show you how to get yesterday date in PHP means subtract one day. so lets start in code so you are easily understand how to subtract one day. You may also like How to add…
How to Integrate Instamojo Payment Gateway in Laravel 8
In this tutorial we going to learn How to Integrate Instamojo Payment Gateway in Laravel 5. Most of thing are already in Instamojo documentation we just going to see it in step so you will easily integrate without reading whole…
How to Checkbox value 0 or 1 using jquery
jquery tutorial If you have a checkbox in a form you can use jQuery to read and set the data 0 or 1 in the checkbox. When using jQuery and you wish to read whether a checkbox is checked or…
How to Create Dynamic XML Sitemap in PHP
Sitemaps prefer to be in XML format, but that does not mean that you have to write XML code for each page manually. Let’s build a XML sitemap together with PHP. sitemap is very play very important role in SEO…
php Mysql DELETE Query
If you want to delete a record from any MySQL table, then you can use the SQL command DELETE FROM. To understand Delete query, consider an Customers table, which is having following query First you can need database connection in…