Lukket

ez-webpage01

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/[url removed, login to view]',

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

Færdigheder: HTML, MySQL, PHP

Se mere: rating engine, primary games, member rating, develop webpage, country rating, cost develop game, cost develop browser game, cost webpage, state room, rm, null, ez, descr, desc, browser games, update status php mysql, table jpg, mysql create database engine, webpage develop, comment mysql, usa phone email database, database players, schemas, unknown database, default player

Om arbejdsgiveren:
( 0 bedømmelser ) Morgan Hill, United States

Projekt-ID: #967742

14 freelancere byder i gennemsnit $99 for dette job

omtechnologies

Hi! Our PHP Experts can do this project for you professionally. Please check PMB for details.

$125 USD in 2 dage
(176 bedømmelser)
7.7
agilesols

lets do it...

$150 USD in 4 dage
(217 bedømmelser)
7.5
Softanz

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.

$60 USD på 1 dag
(59 bedømmelser)
6.0
inevy

Hi. Check PM please.

$30 USD in 0 dage
(4 bedømmelser)
3.2
visionP

sent you a PM

$30 USD in 2 dage
(10 bedømmelser)
2.9
rajivjindal08

Hi Lets do it.

$110 USD in 7 dage
(1 bedømmelse)
2.6
Asanamb

Hi, Please check Inbox for details and sample of our works done

$80 USD på 1 dag
(1 bedømmelse)
2.6
RWHarrington

Hello, I can complete this for you in less than a day. Please send me a PM with more information :). Thanks, Rich

$30 USD in 0 dage
(2 bedømmelser)
1.6
mminnovation

u can check these links for confirmation about our works

$200 USD in 2 dage
(0 bedømmelser)
0.0
TaniaSalma

i can complete this project ...plz send me PM with some information

$150 USD in 10 dage
(0 bedømmelser)
0.0
scpatel

I have experience. I can send you my work preference.

$75 USD på 1 dag
(0 bedømmelser)
0.0
mayurnetglobes

please see your pm

$200 USD in 3 dage
(0 bedømmelser)
0.0
KamaronSoftware

Should be pretty simple, I can easily do it in 4 days if designing from scratch, maybe a little more or less if there's an existing system.

$90 USD in 6 dage
(0 bedømmelser)
0.0
RyanPlatform9

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:)

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