Skip to content

Arikato111/learn-member-mysql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

44 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

php MySQL Bootstrap

learn member with mysql

Get started

  • clone this repo and move file in folder to /htdocs/
  • create Database named eldenly
  • import eldenly.sql to Database
  • start your apache server
  • open http://localhost

Inside it

  • Bootstrap 5
  • NEXIT

TODOs

  • Register
  • Login
  • Show all members
  • Delete members
  • Edit members
  • Poll Manage (add Question and Answer)
  • Members can send Vote to Poll

Database [MySQL]

Databse name : eldenly

Table name : member

Field Type Key Extra
mem_id int(11) PRI AUTO_INCREMENT
mem_name varchar(100)
mem_address varchar(200)
mem_date date
mem_email varchar(100)
mem_tel varchar(20)
mem_user varchar(50)
mem_password varchar(50)
mem_status varchar(10)
mem_stat int(10)

Table name : poll

Field Type Key Extra
poll_id int(11) PRI AUTO_INCREMENT
poll_name varchar(200)
poll_date date
poll_member_id int(11)

Table name : poll_detail

Field Type Key Extra
poll_detail_id int(11) PRI AUTO_INCREMENT
poll_id varchar(200)
poll_detail_post varchar(200)
poll_detail_count int(10)

Table name : poll_post

Field Type Key Extra
poll_post_id int(11) PRI AUTO_INCREMENT
poll_poll_id int(11))
poll_post_member_id int(11)

Table name : webbord

Field Type Key Extra
web_id int(11) PRI AUTO_INCREMENT
web_name varchar(200)
web_date date
web_mem_id int(11)

Table name : webbord_detail

Field Type Key Extra
web_detail_id int(11) PRI AUTO_INCREMENT
web_id int(11)
web_detail_post varchar(200)
web_detail_date date
web_detail_mem_id int(11)

Releases

No releases published

Packages

No packages published