Today I will discuss MySQLi Prepared Statement and its Benefits. Prepared statements provide a better way to execute SQL queries. Apart from being safe, the prepared statements allow the reusability of code. Since the statement need to be prepared once and can be executed any number of times by just replacing the parameters, these statements …
Examples of Database Connectivity Using MySQLi in PHP
This article presents Database Connectivity Using MySQLi in PHP. Create a database with the ‘CREATE DATABASE’ command using a PHP program. (https://www.programmingempire.com/creating-a-database-with-mysqli/) How to create a database table in a MySQL database? (https://www.programmingempire.com/example-of-creating-a-mysql-database-table-using-php/) Insert Records Using HTML Form in a Database Table (https://www.programmingempire.com/inserting-a-record-in-a-database-table-using-mysqli-in-php/) Using Prepared Statement in PHP to insert a record. (https://www.programmingempire.com/inserting-record-using-prepared-statement-in-php/) How to …
Types of Errors in PHP and How to Handle Them
In this article, I am going to discuss the Types of Errors in PHP and How to Handle Them. There are four types of errors that a PHP Script can generate. Syntax errors or compile errors Runtime errors or fatal errors Warnings Notice Errors Syntax Errors (Compile Errors) Syntax errors are those errors that the …
MERN Stack Important Concepts
Today I will discuss MERN Stack Important Concepts. Basically, MERN Stack is another technology stack that uses JavaScript. Similarly, we use it to develop web applications. Like MEAN stack, we can develop full-stack web applications using MERN Stack. The four key components of MERN Stack are MongoDB, Express, React, and Node. Evidently, MERN Stack uses …
Overview of Mean Stack
This article provides an Overview of Mean Stack. Basically, it is a JavaScript-based full-stack technology stack that enables developers to build modern web applications faster. Since JavaScript is the language to develop both client-side and server-side development, developers need to learn a single language only. Besides, this technology stack provides a simple, cost-effective solution. Also, …
Getting Started With MongoDB
In this article on Getting Started With MongoDB, I will introduce a NoSQL database called MongoDB. Basically, it is a document-oriented database that is widely used in creating scalable web applications. Since it is a non-relational database, so it doesn’t contain rows and columns. Instead, it has document-oriented storage. We can create a database without …
Working With Directories in PHP
Working With Directories in PHP involves creating a directory, changing directories, listing the content of a directory, and also deleting a directory. PHP provides several in-built functions that enable us to perform operations on directories. The following section discusses some of these functions. Functions for Working With Directories in PHP To begin with, we create …
Performing File Operations in PHP
In this article, I will discuss Performing File Operations in PHP. Since file handling is an important feature in many applications. So, all programming languages offer a library of in-built functions for file handling. As a matter of fact, PHP provides a number of methods to create, read, and manipulate files and directories. The following …
A Brief Description of move_uploaded_file() Function in PHP
This article presents A Brief Description of move_uploaded_file() Function in PHP. For the purpose of uploading a file, we use the move_uploaded(_file() function. Basically, it takes two parameters as the input. While the first parameter indicates the name of the uploaded file. Similarly, the second parameter indicates the location to which the file needs to …
PHP Library Functions for Uploading Files
In fact, there are several PHP Library Functions for Uploading Files that we use in our script. The following section discusses these functions in brief. Brief Introduction to PHP Library Functions for Uploading Files file_exists() In order to find whether a file or directory exists or not we use this function. Before uploading a file, …