Building a Online Lotto Web Application. Tutorial -2 : Creating User data storing and management database by SQL.

Repository

https://github.com/kibriakk/lotto

You will learn From This full tutorial.

• How to make a online lottery managemment script & Site
• Steem Payment Getway Setup
• Auto Payment getway Building
• User login,Registration System Building
• Php to MySql Data input
• MySql to Php data showing
• Token Transaction System Building
• Buy & Sell ticket System Build via Php and mysql
• Text to QR code generator builder
• Online live Chat plugin Builder
• Admin mode build via php
• Php from Builder.

You will learn from this tutorial part

• How to create mysql in cpanel
• How to create table in mysql database via sql command
• How to create columns and set data type and other option via sql command
• How to set auto increasement function in a column
• How to build a database to keep user information safe.

Requirements

• Php 5.1 or higher
• My SQL 5.1 or higher
• Hosting or Server
• Basic knowledge on Php, My SQL, HTML,CSS

Difficulty

Basic

Description

I am kibria a web and blockchain Developer.

This is the 2nd part of "How to build a lotto /lottery /gambling site using Php and MySQL without using any framework."

The tutorial is so large. So I will post every tutorial part by part in my steemit blog.

Part -1 : Building a Online Lotto Web Application. Tutorial -1 : basic function of the lotto web application.(connecting mysql in website by function.php)

Part -2 : Creating Database for user management and keeping safe users information.

So lets start-

In the previous tutorial we have learn how to make function.php and build the connection between web application to mysql.

In this part we will learn, how to make the database and how to create users information table for keeping users all information. This is the most nessesary step.

I have shared a link of mysql database file. which can directly import users table and structure, column into your database. But We need to learn Everything about making this. So please avoid the shortcut rules and use the original methood.

1. First we need to login to our Cpanel and create database and database users. If you don't know to create it see the screenshot

In the database section click on the "Mysql® Database" Then you can see this picture.

write your database name and create.

Then create database user.

Add user into database

Select "all previllage" and click on "make changes"

Open php myadmin from cpanel.
you can see that a new database in the left bar. click on the database.

1. you can create manually table from it. But I tech you the SQL system. Which can help you to know SQL command.

open the sql tab and write down bellow code,

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(16) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `password` varchar(40) NOT NULL,
  `email` varchar(40) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `ref` int(11) NOT NULL DEFAULT 1,
  `balance` varchar(20) NOT NULL DEFAULT '0',
  `sid` varchar(255) NOT NULL,
  `ticket` varchar(20) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `users` is a command to create a table and table name is "users".
In the bracket () there is some command which is used to create column in the table. first word in '' is the column name. 2nd word is data_type(size). 3rd word is null value and 4th word is default value. All the column is divided by commas.

Click on go now.

Here is the column name

1. id
2. username
3. fullname
4. password
5. email
6. phone
7. country
8. ref
9. balance
10. sid
11. ticket

3)Index 'id' and 'username' :
Now we will modify 'id' column as primary and 'username' column as username. So need to write this command line.

ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

• Here "ALTER TABLE" is the command which means create a condition.
• users means the table name.
• ADD PRIMARY KEY ('id') is the command to add the 'id' column as primary and ADD UNIQUE KEY 'username'('username') is the command to add 'username' column as a unique key for username function.
  

1. Now we need to add a system to increase value automatically for 'id'.
   For example, if a new user add the id will be 1. if another user add the new users id will be 2. then 3,4,5...

So we should write this command

ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

Then click on go.

So the Creating 'user' table finished.

Here is the full code.

--
-- Table structure for table `users`
--
CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `username` varchar(16) NOT NULL,
  `fullname` varchar(255) NOT NULL,
  `password` varchar(40) NOT NULL,
  `email` varchar(40) NOT NULL,
  `phone` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `ref` int(11) NOT NULL DEFAULT 1,
  `balance` varchar(20) NOT NULL DEFAULT '0',
  `sid` varchar(255) NOT NULL,
  `ticket` varchar(20) DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
COMMIT;

The Table structure is look like this picture.

I hope everyone realize the methood. Please comment if you have any problem. I will be happy for your commemt.

The tutorial of part -2 has been finished. We will learn user login and registration in the next tutorial tommorow.

Previous tutorial

• Building a Online Lotto Web Application. Tutorial -1 : basic function of the lotto web application.(connecting mysql in website by function.php)

Proof of work done

https://github.com/kibriakk/lotto