Create a simple single page data entry for that also lists records, saving data to a mysql table.
Single php/html page:
List all from `position` table where status = 'open' order by id
form to add a record (no edit page needed)
button to close a record in the list. (no confirmation needed)
Submitting a new record submits form fields to DB table columns - status defaults to "open"
Closing a record changes status to "closed"
Clean simple layout/html
CREATE TABLE `positions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`symbol` varchar(60) NOT NULL,
`open_date` date DEFAULT NULL,
`close_date` date DEFAULT NULL,
`status` varchar(12) DEFAULT NULL,
`long_short` int(11) NOT NULL DEFAULT '0',
`open_price` decimal(6,2) NOT NULL DEFAULT '0.00',
`close_price` decimal(6,2) NOT NULL DEFAULT '0.00',
`quantity` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`)
22 freelancers are bidding on average $42 for this job
Hello, I can develop the page for you. It is pretty simple and straight forward Relevant Skills and Experience Experience working on html, css, php and mysql Proposed Milestones $25 CAD - m
Hi, I can create it today. I have 6+ years exp in PHP, WordPress and web design. Please enable chat for further details. Regards: Sarita Mahar Relevant Skills and Experience PHP Proposed Milestones $30 CAD - FINAL
Thank you very much! for giving me a chance to write my proposal for your website, Relevant Skills and Experience All Proposed Milestones $15 CAD - Lets do it