Phpflow.com
  • Php
  • Jquery
  • Mysql
  • angular
  • HTML5
  • Misc
    • DevOps
    • WordPress
    • jquery Plugin
    • Contact US
    • Privacy Policy
  • Live Demos

Mysql

How to Insert Data into MySQL Using PHP if it Doesn’t Exist

Last Updated: March 31, 2024March 31, 2024| By: PHPFlow Team
PHP mysql insert into if not exists

in this article, We’ll learn “INSERT INTO IF NOT EXISTS” with examples. We’ll also provide examples demonstrating its effective implementation. We will cover both core PHP and Laravel approaches. This allows you to add data to a table only if a matching record does not already exist.

Continue reading


Simple Example of MySQL Date Comparison

Last Updated: October 18, 2023October 18, 2023| By: PHPFlow Team
Simple Example of MySQL Date Comparison

This tutorial helps to understand MySQL Date Comparison with examples. MySQL offers a rich set of functions and operators to handle date and time data. We’ll go through working with dates in date comparison.

Continue reading


ERROR 2002 : Can’t connect to MySQL server through socket

Last Updated: October 25, 2022October 25, 2022| By: PHPFlow Team
MySQL ERROR 2002

in this tutorial, We’ll Learn how to fix MySQL ERROR 2002 Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock.

Continue reading


Set Dark Theme on MySQL Workbench

Last Updated: September 28, 2022September 28, 2022| By: PHPFlow Team
Set Dark Theme on MySQL Workbench

in this tutorial, we’ll learn How to enable MySQL Workbench dark theme on Windows and Linux. Only macOS and Linux support dark themes in MySQL Workbench.

Continue reading


Concatenate Multiple Columns in MySQL

Last Updated: September 24, 2022September 24, 2022| By: PHPFlow Team
sql select concatenate multiple columns

in this tutorial, We’ll concatenate two or multiple columns in MySQL.We will select the values and concat multiple columns using MySQL inbuilt method.

Continue reading


Posts navigation

Older posts
Search for:

  • Facebook
  • Twitter
  • feedburner
  • pinterest
  • youtube

Subscribe Youtube Channel

Parvez Alam
Meet Parvez Alam, a seasoned professional with 12 years of hands-on experience in PHP, MySQL, AngularJS, HTML, and CSS. With a passion for crafting robust web solutions.
Parvez Alam
  • Popular
  • Recent
  • convert xml into array
    How To Convert XML To Associative Array in PHP Aug 9, 2012
  • export-to-excel with php and mysql
    Exporting Data from MySQL to Excel using PHP Nov 7, 2014
  • treeview
    How to Create Dynamic Tree View Menu Dec 11, 2012
  • How To Send Email From Localhost Using PHP Sep 4, 2012
  • insert-php-array-into-mysql-table
    Insert PHP Array into MySQL Table Nov 11, 2015
  • pagination in php
    Simple tutorial of pagination in php with Demo May 18, 2012
  • Website login with google account/yahoo account
    Website Login With Google or Yahoo/WordPress/OAL Account May 23, 2015
  • datatable-with-php
    DataTables Example – Server-side Processing with PHP Sep 20, 2014
  • zend-rest-webservice
    Top 8 RESTful API Frameworks for PHP in 2022 Jul 12, 2012
  • Import-csv-file-using-mysql-and-php
    How To Import CSV File Into MySQL Using PHP Jul 19, 2012
  • php-aws-sdk-laravel
    Configure and Retrieve S3 Information Using Laravel PHP-AWS-SDK Sep 1, 2024
  • What is the Purpose of php-eol in PHP
    What is the Purpose of php_eol in PHP? Mar 3, 2024
  • Laravel Table Relationships Methods With Example
    Laravel Table Relationship Methods With Example Feb 29, 2024
  • Exploring the Power of Laravel Eloquent Join
    Exploring the Power of Laravel Eloquent Join? Feb 20, 2024
  • Installation of Laravel Valet
    Quick and Easy Installation of Laravel Valet Feb 4, 2024
  • What is Laravel Soft Delete
    What is Laravel Soft Delete and How Does it Work? Jan 26, 2024
  • laaravel-blade-common-practices
    Common Practices for Laravel Blade Template Jan 22, 2024
  • Laravel firstOrNew, firstOrCreate, firstOr, updateOrCreate With Example
    Laravel firstOrNew, firstOrCreate, firstOr, updateOrCreate With Example Jan 16, 2024
  • How to Use String Interpolation in PHP
    How to Use String Interpolation in PHP Jan 10, 2024
  • Database Queries with Laravel's whereNull
    Database Queries with Laravel’s whereNull Jan 5, 2024
  • PHPFlow Team on XML Sitemap Generator using PHP

    You need to update - SITE_URL in sitemap-config.php

  • mike on XML Sitemap Generator using PHP

    It only generates 1 entry never indexes

  • PHPFlow Team on Web Push Notification Using OneSignal and PHP

    you need to store details in db and use that that details (...)

  • Sam on Web Push Notification Using OneSignal and PHP

    How to get user id for future personal

  • sanjay on Creating Template in CodeIgniter 3 Using Bootstrap Theme

    This is a very informative article. Thanks for sharing (...)

  • PHPFlow Team on Google Map with a Marker with PHP & Google Map API

    You need to set your API key, first time google is (...)

  • Adell on Google Map with a Marker with PHP & Google Map API

    why it is not

  • Parvez on How to Insert Data into MySQL Using PHP if it Doesn’t Exist

    yes, thanks for your valuable

  • Rick James on How to Insert Data into MySQL Using PHP if it Doesn’t Exist

    Compare and contrast to INSERT IGNORE Except for burning (...)

  • Parvez on Create Admin Login and Logout Page

    You need to implement RBAC in your web app. OR you can use (...)

Home | About Us | Contact Us | Privacy Policy
Copyright © 2012 - 2024 www.phpflow.com All rights reserved.
x