Posts

Showing posts with the label mysql

error: Fatal error: Uncaught mysqli_sql_exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column

Error: Fatal error : Uncaught mysqli_sql_exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column Solution: mysqli_query($con, "SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));");

All type of date to a text formatted date in excel

Image
  =TEXT(A1,"yyyy-mm-dd")

classDbTable.php

Image
https://gist.github.com/milan-sahana/c42d56711cf1c707f40ae239619f9ec4

user table: Unique Email id by GENERATED index

 https://gist.githubusercontent.com/milan-sahana/789b560f079a54ea86f3570c62be0e8b/raw/786d79795faefe7e67721fe5cccc05a3b813dc1e/users.sql

disposable_email_domains

 https://gist.githubusercontent.com/milan-sahana/ca77512e97bd69766abb2d3f3bb17aa6/raw/2ee53992ce5ddfe7df91cf8a35649d6b605bf75b/disposable_email_domains