I gang

Web-based directory with simple update

We have a spreadsheet in Excel with dates/events in columns and attending members in rows and then simply a number in the box where they are attending. The first event they are attending is 1 the next 2 and so on. If they attend four events there row changes colour from that event and forward and if they attend ten events it changes again and then four more times as they attend even more events. At the end of each row the total number of attended events is listed.

We now want to move this to our website and add two new pages. I guess the easiest way is to save data in a MySQL database. These pages will only be available for admins. The two pages are:

1. A page that list all members (in reverse order) with there membership number, Membership name, surname and total attended events. This is the only page where real names are shown. If a member is selected all his previously attended events should appear in a new window and the full real name..

On this page there should also be a "add new member-button" this should open a box to insert his/hers real name and membership name. This should automatically give him/her a membership number. A warning should appear if the name already exists and ask for a new name. If the membership number is an even hundred a warning with "Are you sure you want #name# to be member number X00?"

2. A page with all events (in date order with newest first) and if the event is opened a small box with attending members and some statistics: how many previous events each person has attended, how many events in a row the person have attended and a color box that matches his total attended events color as explained above. We also want a "red-X" beside the member that delete him/her from the event.

At the top of this page there should be a "create new event-button" that opens a box asking for date and name of event.

There should also be a "register member to event-button" next to events. When this button is pushed a box to insert the members membership name in appears, it would be nice if this had autofill from the list of members to ensure that the name is spelled correctly and registered to the correct member.

There should also be a "delete event-button" next to the events. The deletion must be confirmed before executed.

I have attached a small picture of how the spreadsheet look today. The spreadsheet is 900 members long and a couple of hundred events wide.

Færdigheder: Dataindførsel, Excel, MySQL, PHP

Se mere: web page spreadsheet, top statistics, spreadsheet web page, page reverse, matches statistics, matches list, list matches, membership directory, members directory, guess the, excel based, event directory, attending events, excel colour, rows insert, php list directory, php delete mysql row, event spreadsheet, mysql web spreadsheet, excel delete row, web based mysql, simple forward, data entry excel mysql, move data excel, excel already exists

Om arbejdsgiveren:
( 1 bedømmelse ) Uppsala, Sweden

Projekt-ID: #1004388

Tildelt til:

gutibs

Hello, please check PMB for details. Thanks!

$150 USD på 1 dag
(44 bedømmelser)
5.3

15 freelancere byder i gennemsnit $143 for dette job

mindware97

We are a team of highly qualified professionals with years of experience in software development, web development, Graphics/Multimedia, and Data entry. We are dedicated to provide complete IT services to customer's nee Mere

$200 USD in 11 dage
(27 bedømmelser)
5.9
vbexcel

Excel VBA expert.

$180 USD in 3 dage
(28 bedømmelser)
5.5
sv3tli0

Hi I am able to do this for you please check my PM

$160 USD in 3 dage
(23 bedømmelser)
4.3
creadobe

Please check PM

$60 USD in 5 dage
(9 bedømmelser)
4.2
tomkus

Hi! I am interested in your project. Please check your PM. Thanks!

$220 USD in 10 dage
(4 bedømmelser)
3.8
chitrad

I can do it in a perfect manner

$150 USD in 10 dage
(1 bedømmelse)
1.4
ITVeda

Please check PM.

$150 USD in 10 dage
(1 bedømmelse)
0.9
wajack

Hi, Please see PMB, thank u

$179 USD in 4 dage
(1 bedømmelse)
2.6
basith10112

i can do it

$155 USD in 3 dage
(0 bedømmelser)
0.0
cadg120773

It's a little bit hard to understand but I want to work on this project. Very interesting. Please can you consider me as your applicant? I will wait for your reply about this job. I am available now.

$30 USD in 7 dage
(0 bedømmelser)
0.0
freelancer153

I can do that......

$100 USD på 1 dag
(0 bedømmelser)
0.0
gjosiah2011

Hi, I thank you for the job opening. I have the pleasure applying for your kind and immediate considerations, since at the moment am available and willing to undertake the job as per the agreed terms and conditions. Mere

$150 USD in 30 dage
(0 bedømmelser)
0.0
paki09

Hi There: I am IT professional and can do your jobs with 100% QA and 100% accuracy. Have done this kind of job of many organizations. Also doing web projects since 8-9 years. I am new in this site but MUST provide Mere

$100 USD in 7 dage
(0 bedømmelser)
0.0
jukechrn

I am a full-time student working towards my BSIT with a concentration in Web Design. I graduate in 8/12. I am a single mom that desperately needs an income!!! I am a hard worker, a self starter, and highly motivate Mere

$250 USD in 10 dage
(0 bedømmelser)
0.0
nehul

I am intrested in this job.

$70 USD in 7 dage
(0 bedømmelser)
0.0