Skip to main content

Posts

Showing posts from September, 2021

Database Table For Login

 Login Table Database Design : Click to see design Ideas Mostly all web applications contains  login module as second module of their project.  Generally first module is signup or say registration module of any web project.   Click :  Registration Table Basic Fields Although username or email id and password is used for login credentials. First of all we are going to take a simple , easy and fast way to create login table for your web project.  After this we will take a deep look of Login Section of a website.  Although a login table may contain as simple as only two or three fields . Most important is password and then email id or say username. For a normal size project below few fields are enough to handle login process of a web application. You may also like this post:  Advance Login Features So consider below snapshot of login table , which is taken from phpmyadmin tool. By clicking below link you can download a copy of sql file of above structrure. Download Login Table sql

PhpMyAdmin Tutorial

  Introduction to Phpmyadmin tool   Hi all , this web page reading will give you the basic as well as advanced knowledge about phpmyadmin tool. Phpmyadmin is freely available on the internet.  Basically phpmyadmin is a server tool for handling dbms mysql or mariadb . It is  written in php programming language. All jobs done by using phpmyadmin interface , can be achieve by text queries.  So question arise why we use this tool ? Phpmyadmin main purpose is to give user a fast and easy way to manipulate his/her database. Before this , programmer used CUI. It is 'Character User Interface' or Command Line User Interface. By using GUI(GRAPHICAL USER INTERFACE) it become very easy to insert , update , delete any database table data. Mostly all queries of mysql also supported by PhpMyAdmin tool. Following are the key features of phpmyadmin software :  1. By using this tool you can easily browse database tables , views ,  indexes etc. 2. All database operations like executing queries ,