Today I will discuss an example of Deleting Multiple Records with mysqli in PHP Using Form Input. Suppose we have a database table and we want to allow the user to delete some or all of the records. Since user will access the application through a web interface, the delete option should be available on …
Installing Django on Windows
In this article I will discuss Installing Django on Windows. Django is a python based framework for web development. In order to get more details on Django framework as well as its features and benefits, read this article. (https://www.programmingempire.com/introduction-to-django-framework-and-its-features/) Since Django is a python based framework, so first you need to ensure that Python is …
Django Practice Exercise
The following Django Practice Exercise will help you learn the Django framework. How to create a Django project using the command line? Since we use a Django app in a project, first, you need to learn creating an app. So, create a ‘Hello World’ Django app. Also, create a Django Form using form.py. When should …
Features and Benefits of PHP Data Objects and How to Use
In this article, I will discuss the Features and Benefits of PHP Data Objects and how to use it with a MySQL database. In fact, PDO is an API that we can use to access a database. Unlike MySQLi, we can use PDO with a number of databases. For instance, PDO supports MySQL, MS SQL …
Working with phpMyAdmin – Creating Users and Assigning Privileges
In this article on Working with phpMyAdmin – Creating Users and Assigning Privileges, I will explain how to create a user for a database and how to assign privileges to that user. Also developed in PHP, phpMyAdmin is a tool that allows the users to manage MySQL database. Basically, it is a free software tool …
Understanding SQLite Database With Examples
In this article on Understanding SQLite Database With Examples, I will explain what is SQLite and when you should use it. Here you will also find some examples of using SQLite. When you need to use a light weight, cross-platform, and open-source database, SQLite is the best choice. It is a serverless database. In other …
Introduction to Django Framework and its Features
In this article on Introduction to Django Framework and its Features, I will explain the Python Web Development Framework Django. Also, I will discuss why this framework is preferred by web developers and its distinguishing features. Basically, Django is a python based framework that enables you to build web applications fast and in a simpler …
MySQLi Prepared Statement and its Benefits
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 …