MySQLi OOP

Customer Relationship Management (CRM) System in PHP with Source Code

This is a simple PHP Project entitled Customer Relationship Management (CRM) System. This system provides a certain company an online platform to manage interactions with their customers or potential customers. The system allows the customer/potential customers to request a quotation for the services they selected in the system. The system also has a ticketing feature which is mainly built to

Simple ChatBot Application using PHP with Source Code

This is a simple Web Application Project entitled Simple ChatBot Application. This project was develop using PHP Programming Language. This chatbot application can simulate conversations with the end-users. The end-user can ask/query anything with this application and the chatbot will automatically respond accordingly to the queries/questions. The program has an admin panel where can admin user of

How to Sum Column in MySQL using PHP/MySQLi

In this tutorial, I'm going to show you how to sum MySQL columns using PHP/MySQLi. I've also included in this tutorial the use of GROUP BY in MySQLi query and the 2 MySQLi methods which I have included in the comments. This tutorial does not include a good design but will give you an idea of the topic. Getting Started Download and Install XAMPP or any equivalent to run PHP script. Open the XAMPP's

How to Create a Dynamic Dropdown Menu using PHP/MySQLi and Bootstrap 4

This tutorial tackles on how to create a dynamic dropdown menu using PHP with MySQLi-OOP and Bootstrap 4. Currently, the latest version of Bootstrap is 4 and has several changes from the later version. We are going to use Bootstrap 4's nav tag to create our menu where we put dynamic content in the dropdown.

How to Create a Simple Area Chart using Google Charts API

This tutorial tackles on how to create a simple Area Chart using Google Chart API with PHP and MySQLi extension OOP. Charts primary provides a statistical presentation of data within our application or systems. Google Chart API is a web service created by Google that provides graphical chart for data supplied by the user.

How to Create a Simple Bar Chart using Google Charts API

This tutorial tackles on how to create a simple Bar Chart using Google Chart API with PHP and MySQLi extension OOP. Charts primary provides a statistical presentation of data within our application or systems. Google Chart API is a web service created by Google that provides graphical chart for data supplied by the user