What Is MySQL Full-Text Search?What Is MySQL Full-Text Search?

What Is MySQL Full-Text Search?

A:-Introduction to MySQL Full-Text Search Summary: in this tutorial, we will introduce you to MySQL full-text search and its features. MySQL supports text searching by using the LIKE operator and regular expression. However, when the text column is large and…

Continue Reading
MySQL triggers are stored programs that are executed automatically to respond to specific events associated with table e.g., insert, update or delete a record

What is Mysqli Trigger?

Introduction on Triggers A trigger is a set of actions that are run automatically when a specified change operation (SQL INSERT, UPDATE, or DELETE statement) is performed on a specified table. Triggers are useful for tasks such as enforcing business…

Continue Reading
What Is Load Balancing?

What Is Load Balancing?

Load balancing refers to efficiently distributing incoming network traffic across a group of backend servers, also known as a server farm or server pool. Modern high-traffic websites must serve hundreds of thousands, if not millions, of concurrent requests from users or clients and return…

Continue Reading
PL/SQL interview questions and answers

PL/SQL interview questions and answers

1. What is PL/SQL? PL/SQL is a procedural language that has both interactive SQL and procedural programming language constructs such as iteration, conditional branching. 2. What is the basic structure of PL/SQL? PL/SQL uses block structure as its basic structure.…

Continue Reading
Stripe Payment Gateway Integration in PHP

Stripe Payment Gateway Integration in PHP

The Stripe payment gateway provides an easy and powerful way to accept credit cards directly on the web application. Stripe make it easy to integrate checkout system and collect payment on the website. The Stripe API is a powerful solution…

Continue Reading
Connecting PHP to MySQL on Bluemix

Connecting PHP to MySQL on Bluemix

Connecting PHP to MySQL on Bluemix Most of the PHP I write runs on Bluemix – it’s IBM self-service cloud, and since I work there, they pay for my accounts 🙂 There are a bunch of databases you can use…

Continue Reading
Building an FTP Client in Python

Building an FTP Client in Python

Why FTP in Python? A simple FTP solution allows for any number of networking applications. Whether you need to run regular (unencrypted) backups to a remote service, or run regular downloads from the same, this guide will help you to…

Continue Reading