I need a user friendly webpage that allows authorized users to connect to a MySQL database via a browser and make entries (additions, modifications, deletions) to member & member_rating tables, if authorized to do so. Also, I need a screen (webpage) that allows authorized users to make entries (additions, modifocations, deletions) to the events table and ensure member id# exists; and, if they make a mistake to be able update the data so it is correct.
How much would it cost for someone to develop a PHP/MYSQL webpage to do what I want?
DATABASE Schemas
Tables (Member, Member_Rating, Games, Events, Member_Rating_Chg, Room)
CREATE TABLE `member` ( `num` int(10) unsigned NOT NULL auto_increment,
`fname` varchar(25) NOT NULL,
`lname` varchar(25) NOT NULL,
`sex` char(1) NOT NULL,
`dob` date NOT NULL,
`street` varchar(25) NOT NULL,
`city` varchar(25) NOT NULL,
`state` varchar(25) NOT NULL,
`zip` varchar(10) NOT NULL,
`country` varchar(25) NOT NULL default 'USA',
`startdate` date NOT NULL,
`enddate` date NOT NULL default '2020-12-31',
`phone` varchar(25) NOT NULL,
`email` varchar(25) NOT NULL,
`ref` int(11) NOT NULL,
`defroom` int(11) NOT NULL COMMENT 'member default rm',
`status` char(1) NOT NULL default 'A',
`pic` varchar(75) NOT NULL default 'http://domain/players/[login to view URL]',
PRIMARY KEY (`num`),
UNIQUE KEY `player` (`fname`,`lname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=643 ;
CREATE TABLE `member_rating` ( `mnum` int(11) NOT NULL,
`gtype` int(11) NOT NULL default '1',
`rating` int(11) NOT NULL,
PRIMARY KEY (`mnum`,`gtype`,`rating`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `games` ( `type` int(11) NOT NULL COMMENT 'type of game',
`descr` varchar(25) NOT NULL COMMENT 'description',
PRIMARY KEY (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `events` ( `edate` date NOT NULL,
`room` int(11) NOT NULL,
`mnum` int(11) NOT NULL,
`gtype` int(11) NOT NULL,
`matches` int(11) NOT NULL,
`edollars` int(11) NOT NULL,
PRIMARY KEY (`edate`,`room`,`mnum`,`gtype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `member_rating_chg` ( `num` int(11) NOT NULL,
`mrcdate` date NOT NULL,
`gtype` int(11) NOT NULL,
`orate` int(11) NOT NULL,
`nrate` int(11) NOT NULL,
`desc` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
C
Dear sir, After reading your project details,we are interested in this project and would like to bid on this project. Please view my PMB for more details. Thank you.
Hi, I can complete this project for you very quickly, to a high standard and with an absolute minimum of fuss. Please check PM for further details. Thanks:)