Create connection.php file and include all CRUD operation’s file for connect database. <?phperror_reporting(0);$DB_HOST = ‘localhost’;$DB_USER = ‘root’; $DB_PASS = ”;$DB_NAME =  ‘mysql’;$conn = mysqli_connect($DB_HOST,$DB_USER,$DB_PASS,$DB_NAME);// Check […]

    #Step1: Create just databse in your phpMyAdmin  Ex: test_table.sql #Step2: put sql databse file in bin folder Ex: E:wamp64binmysqlmysql5.7.26binDBtest_table.sql # Open CMD# Step3: Change […]

# Open CMD# Step1: Change the directory folder current directory to mysql bin directory. C:UsersPHPKishan> cd D:wamp64binmysqlmysql5.7.19bin ↲ # Step2: write below command line and […]

SELECT * from product_order WHERE YEAR(order_date) = YEAR(CURRENT_DATE – INTERVAL 1 MONTH) and MONTH(order_date) = MONTH(CURRENT_DATE – INTERVAL 1 MONTH)

SELECT * from product_order WHERE MONTH(order_date) = MONTH(NOW()) and YEAR(order_date) = YEAR(NOW())

SELECT * from product_order WHERE yearweek((order_date), 1) = yearweek(curdate(), 0)

SELECT * from product_order WHERE DATE(order_date) =  DATE(NOW() – INTERVAL 1 DAY)

SELECT * from product_order WHERE DATE(order_date) = DATE(NOW())

Create Family Tree In PHP 1st Step : Create these belove file and database 　　- CSS : style.css, ddsmoothmenu.css, ddsmoothmenu-v.css 　　- JS : ddsmoothmenu.js 　　- […]