Skip to content

AdnanTech

Programming tutorials

Menu
  • Python
  • PHP
    • Laravel
    • WordPress
  • Javascript
    • React JS
    • Node.js
    • Vue JS
  • Databases
    • MySQL
    • MongoDB
  • Mobile apps
    • Android
    • iOS
  • Tutorials
    • Ticketing system
    • Chat app
  • Blog
  • Projects
  • API
    • Social network API
  • Services
    • Hash Generator
    • World Clock
    • Word Counter
    • Currency Converter
    • Financial Ledger
    • Time Difference
    • Stopwatch & Timer
    • Google Maps
  • SAAS
    • Job Entry

Category: MySQL

Posted onFebruary 21, 2025February 21, 2025MySQL

Case-sensitive search in MySQL

by adnanafzal565

Learn how to do case-sensitive search in MySQL. By default, MySQL search text-based column values without case sensitivity. For example, if your database looks like…

Read More
Posted onJanuary 11, 2025January 11, 2025MySQL

Free tool to write API documentation – PHP, MySQL

by adnanafzal565

I was looking for a tool that allows me to write API documentation so I can provide it to the frontend developers and also for…

Read More
Posted onMay 22, 2025May 22, 2025Complete Projects

Real Estate website in PHP, MySQL, Laravel

by adnanafzal565

Real estate business that requires a website for their business, we are providing a free website for them in PHP and MySQL (Laravel framework). Screenshots…

Read More
Posted onAugust 20, 2024August 20, 2024MySQL

Password-less authentication in PHP and MySQL

by adnanafzal565

Previously we did password less authentication in Node JS and Mongo DB, in this article we will do it in PHP and MySQL. Suppose you…

Read More
Posted onMay 22, 2025May 22, 2025Complete Projects

TrustPilot clone – PHP, MySQL, Laravel

by adnanafzal565

A clone of TrustPilot website is created in PHP and MySQL using Laravel framework version 11. For frontend rendering, I am using Vue JS 3…

Read More
Posted onMay 22, 2025May 22, 2025Complete Projects

Job Portal website in PHP and MySQL – MVC

by adnanafzal565

A Job Portal website is created in PHP and MySQL using MVC architecture. MVC stands for Model-View-Controller and this architectural design is used by many…

Read More
Posted onMay 29, 2023MongoDB

MongoDB and MySQL equivalent queries

by adnanafzal565

Hello. In this article, we are going to show you some MongoDB and MySQL equivalent queries. This will help you greatly if you want to…

Read More
Posted onMay 18, 2025May 18, 2025Javascript

Convert datetime to local timezone – Javascript, PHP and MySQL

by adnanafzal565

In this article, you will learn how to convert UTC datetime to user’s local timezone using Javascript. Your database is centralized, but your user’s are…

Read More
Posted onApril 11, 2023Javascript

End-to-end encryption in Javascript, PHP and MySQL

by adnanafzal565

End-to-end encrypted chats are more secured than the ones where encryption is done on the server side. Because the messages get encrypted even before sending…

Read More
Posted onMay 17, 2025May 17, 2025MySQL

Laravel Soft Delete – Create a Trash Can using PHP and MySQL

by adnanafzal565

Laravel soft delete allows you to enable some models that will not be permanently deleted by just calling the delete() method. Instead, you need to…

Read More

Posts pagination

Page 1 Page 2 … Page 6 Next Page

Recent Posts

  • SAAS in React + Laravel – Job Entry
  • Show selected images from input type file – React
  • Add dynamic rows in React
  • Soft Delete 🗑 – Node.js, MongoDB
  • 2 ways to loop through a number in React

Recent Comments

  1. canada pharmaceuticals online generic on PDF view in browser and export as file – PHP
  2. System on (no title)
  3. adnanafzal565 on (no title)
  4. adnanafzal565 on (no title)
  5. System on (no title)

Archives

  • May 2025
  • March 2025
  • February 2025
  • January 2025
  • November 2024
  • September 2024
  • August 2024
  • July 2024
  • June 2024
  • May 2024
  • April 2024
  • March 2024
  • February 2024
  • January 2024
  • November 2023
  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • December 2022
  • November 2022
  • October 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • May 2021
  • April 2021
  • March 2021
  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020

Categories

  • Android
  • Complete Projects
  • CSS
  • FFmpeg
  • Git
  • htaccess
  • HTML
  • iOS
  • Javascript
  • Laravel
  • Leap Motion Controller
  • MEVN
  • MongoDB
  • MySQL
  • Node.js
  • PHP
  • Python
  • React JS
  • Swift
  • Tips & Tricks
  • Uncategorized
  • Vue JS
  • WordPress
Email: support@adnan-tech.com
AdnanTech © All rights reserved. 2013 - 2025