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)