Contacter le RP

Pour utiliser cette fonctionnalité, vous devez bénéficier d'un compte Babbler.

arrow_back

Babbler permet aux journalistes et communicants de collaborer plus simplement.

En vous connectant, vous pourrez accéder gratuitement aux espaces presse des centaines d'entreprises de vos secteurs qui sont sur Babbler, entrer en contact direct avec leurs équipes RP mais aussi y partager vos prochains sujets !

Leurs espaces presse sont sur Babbler :

Vous êtes à 1 clic de l'inscription !

Précédent

Content de vous revoir !

Communiqué

User Management System in PHP using Stored Procedure
timer minutes de lecture minute de lecture

Copier le lien
A stored procedure is a set of SQL commands that have been compiled and stored on the database server.

Cliquez sur l'image pour obtenir le format original

Project NameUser Management System in PHP Stored Procedure
Language UsedPHP5.6, PHP7.x
DatabaseMySQL 5.x
User Interface DesignHTML, AJAX,JQUERY,JAVASCRIPT
Web BrowserMozilla, Google Chrome, IE8, OPERA
SoftwareXAMPP / Wamp / Mamp/ Lamp (anyone)
Last Updated02 July 2021

This project is developed in PHP using Stored Procedure.

A stored procedure is a set of SQL commands that have been compiled and stored on the database server.
Once the stored procedure has been “stored”, client applications can execute the stored procedure over and over again without sending it to the database server again and without compiling it again.
Stored procedures improve performance by reducing network traffic and CPU  load.


Comparison with dynamic SQL

  • Remove overhead
  • Avoidance of network  traffic
  • Encapsulation of business  logic
  • Delegation of access-rights
  • Some protection from SQL injection attacks

This project have two modules

  • User Module
  • Admin Module

User Modules

  • User can signup
  • User can log in to the system.
  • User Password Recovery
  • After login user can edit his/her own profile.
  • Change password.

Admin Modules

  • Admin can log in to the system.
  • Admin Password Recovery.
  • After login admin can view the admin dashboard.
  • Manage all the user(Update and delete the user profile).
  • Change Password.

Stored Procedure used in this Project

User module

  • sp_signup (used for user signup)
  • sp_checkemailavailabilty (check the email available for registration or not)
  • sp_userlogin (used for user login)
  • sp_userpwdrecoveryvalidation (used for password recovery user validation)
  • sp_userpwdrecoveryvalidation (if user details verified by the above-stored procedure then it will reset the user password)
  • sp_userprofile (used to view user profile)
  • sp_userupdateprofile (used to update the user profile details) Note: This procedure used in both module
  • sp_useremailupdation (used to update user email id) Note: This procedure used in both module
  • sp_usercurrentpwdvalidate (used to valid user current password  for change password)
  • sp_userchangepwd (if the password is validated by the above-stored procedure then this stored procedure  used to change the user password)

Admin module

  • sp_adminlogin (used for admin login)
  • sp_adminpwdrecoveryvalidation (used for password recovery admin validation)
  • sp_adminpasswordrecovery (if admin details verfied by above stored procedure then it will reset the admin password)
  • sp_adminprofile (used to view admin profile details)
  • sp_admindashboard (used for admin dashboard)
  • sp_recent15users (used to view the 15 recent registered user at dashboard)
  • sp_allregisteredusers (used to view all registered users)
  • sp_userdeletion (used to delete user profile)
  • sp_userupdateprofile (used to updat the user profile details)   Note: This procdure used in both module
  • sp_useremailupdation (used to update user email id)   Note: This procdure used in both module
  • sp_admincurrentpwdvalidate (used to valid admincurrent password  for change password)
  • sp_adminchangepwd (if the password is validate by above stored procedure then this store used to change the admin password)

How to run the User Management System in PHP Stored Procedure

1.Download the zip file

2.Extract the file and copy ums-sp folder

3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/html)

4.Open PHPMyAdmin (http://localhost/phpmyadmin)

5.Create a database with name umspsdb

6.Import regdb.sql file(given inside the zip package in SQL file folder)

7.Run the script http://localhost/ums-sp

User Credential
Username: anujk@gmail.com
Password: Test@123
or Register a new user

Admin Credential
Username: admin
Password: Test@123

Blog : https://phpgurukul.com/user-management-system-in-php-using-stored-procedure

Autres actualités de la marque

inscrit avec succès

Félicitations, vous êtes inscrit sur BABBLER !

Pour découvrir dès maintenant toutes les actualités qui vous attendent sur Babbler, consultez votre newsfeed !

Vos domaines ont été préselectionnés. Vous pouvez les compléter en cliquant ici