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

PicsArt_10-10-09.37.32.png

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.

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.

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

id
username
fullname
password
email
phone
country
ref
balance
sid
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.

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

Sort:

Trending

[-]

bdcommunity (72) 6 years ago

Hi @kibria365!

Your post has been upvoted by @bdcommunity.

You can support us by following our curation trail or by delegating SP to us.

20 SP, 50 SP, 100 SP, 300 SP, 500 SP, 1000 SP.

If you are not actively voting for Steem Witnesses, please set us as your voting proxy.

Feel free to join BDCommunity Discord Server.

$0.00

1 vote

steem-contest (43) 6 years ago (edited)

Your tutorial is very interesting. Keep update this tutorial.

Total line :219
Total Words:1122

Support from @steem-contest.

gotgame (64) 6 years ago

Nice, this is quite interesting

khushikk (25) 6 years ago

Thank you for updating the 2nd tutorial. I finished all the work. All codes are working fine and i successfully build my mYsql database.

😆😆😆

steem-ua (64) 6 years ago

Your post was upvoted by @steem-ua, new Steem dApp, using UserAuthority for algorithmic post curation!
Your post is eligible for our upvote, thanks to our collaboration with @utopian-io!
Feel free to join our @steem-ua Discord server

utopian-io (71) 6 years ago

Hey, @kibria365!

Thanks for contributing on Utopian.
We’re already looking forward to your next contribution!

Get higher incentives and support Utopian.io!
Simply set @utopian.pay as a 5% (or higher) payout beneficiary on your contribution post (via SteemPlus or Steeditor).

Want to chat? Join us on Discord https://discord.gg/h52nFrV.

Vote for Utopian Witness!