Security
Headlines
HeadlinesLatestCVEs

Headline

CVE-2023-24654: Simple Customer Relationship Management (CRM) System using PHP Free Source Code

Simple Customer Relationship Management System v1.0 was discovered to contain a SQL injection vulnerability via the name parameter under the Request a Quote function.

CVE
#sql#vulnerability#web#apache#java#php

Submitted by oretnom23 on Tuesday, November 29, 2022 - 15:00.

This project is entitled Simple Customer Relationship Management (CRM) System. It is a web-based application that was developed using PHP and MySQL Database. It provides certain business customers with an online platform where they can submit quotation requests and issue tickets. It has a pleasant user interface using the Bootstrap Framework. This project is consist of user-friendly features and functionalities.

****How does the Simple Customer Relationship Management (CRM) System work?****

This Simple Customer Relationship Management (CRM) System can be accessed by 2 different user roles which are the Administrator and the Customers. The Administrator can access the admin panel of the system while the Customer has access to the customer side of the application.

The Administrator user is the one who is in charge of managing the important data on the system. This side of the system requires the Admin User to log in with his/her valid system credentials in order to access and manage the system on the admin side. Here, the administrator is able to read and manage the quotation requests of the customers and the same as well on the created or issued tickets of the customers. Aside from that, the admin can also list the registered customers’ accounts.

The Customers are required to signup and log in to the system in order to gain access to the different features and functionalities on the Customer Side. They submit quotation requests and tickets. The customer can only access and manage the list of quotation requests and tickets that he or she submitted.

****Features and Functionalities****

Here are the different features and functionalities of the Simple Customer Relationship Management (CRM) System

****Admin Site****

  • Login and Logout
  • Dashboard
    • Data Summary
    • Visitors Graph
  • List and Manage Tickets
  • List and Manage Customers’ Quotation Requests
  • List All Users’ Access Logs
  • List and Manage Registered Users’ Accounts
  • Update/Change Password

****Customer Site****

  • Login and Registration
  • Dashboard
  • Create Quotation Request
  • List Tickets
  • Create Ticket
  • View Ticket Details
  • View and Manage Profile
  • Update/Change Password

****Technologies****

Here is the list of Technologies to develop the Simple Customer Relationship Management (CRM) System:

  • HTML
  • CSS
  • PHP
  • MySQL Database
  • Bootstrap Framework
  • DataTables
  • JavaScript
  • jQuery Library

The Simple Customer Relationship Management (CRM) System Project source code zip file is provided on this website and is free to download. Feel Free to download the source code and modify it to meet your own requirements.

****Snapshots********Admin Dashboard****

****Quote Request Details (Admin)****

****Ticket List (Admin)****

****Customer Dashboard****

****Quote Request Form (Customer-Side)****

****Ticket Form (Customer-Side)****

****How to Run?****

****Requirements****

  • Download and Install any local web server such as XAMPP.
  • Download the provided source code zip file. (download button is located below)

****System Installation/Setup****

  1. Open your XAMPP Control Panel and start ****Apache**** and ****MySQL****.
  2. Extract the downloaded source code zip file.
  3. Copy the extracted source code folder and paste it into the XAMPP’s “htdocs” directory.
  4. Browse the ****PHPMyAdmin**** in a browser. i.e. ****http://localhost/phpmyadmin****
  5. Create a new database named ****scrm_db****.
  6. Import the provided ****SQL**** file. The file is known as ****scrm_db.sql**** located inside the database folder.
  7. Browse the Simple Customer Relationship Management (CRM) System in a browser. i.e. ****http://localhost/php-scrm/****.

****Admin Default Access:****

Username: admin
Password: admin123

****DEMO VIDEO****

That’s it! I hope this Simple Customer Relationship Management (CRM) System Project in PHP and MySQL Database helps you with what you are looking for and that you’ll find something useful in the source code file itself.

Explore more on this website for more Tutorials and Free Source Codes.

****Enjoy :)****

  • 5237 views

CVE: Latest News

CVE-2023-50976: Transactions API Authorization by oleiman · Pull Request #14969 · redpanda-data/redpanda
CVE-2023-6905
CVE-2023-6903
CVE-2023-6904
CVE-2023-3907