PHP - MySQL Database Search needed.
$30-5000 USD
Paid on delivery
Please ask any questions before bidding. This will run on Linux system. Read detailed requirements. Was not able to post it all here.
## Deliverables
Since it was too hard and costly for my current code to be modified to add a markup amount column I decided to let coders create their own that will work with my information. I hope this will be much more simple to do. This is just a private thing I'm setting up with the hopes of selling parts. Will save me having to look them all up in a book. I have a MySQL database called vtwin with a table called parts. I used this to create the table setup. This can be changed if needed but needs to have the 6 parts fields so the data file can be imported easily. The CSV file looks like this. 10-0040,89.90,132.21,EA, 22,"CAM COVER, CHROME" ** Read possible Change Note near Bottom. CREATE TABLE IF NOT EXISTS `parts` ( `id` int(6) NOT NULL auto_increment, `part_num` varchar(15) NOT NULL default '', `dealer` varchar(10) NOT NULL default '', `retail` varchar(10) NOT NULL default '', `uom` varchar(10) NOT NULL default '', `page`varchar(5) NOT NULL default '', `product_desc` varchar(75) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; I need a page with one field that I can enter a part number or key word and search the database and display the results. Note: "This is all two rows across." You searched for: “"10-0000"?? # Part #....... Dealer Cost..... Retail....... UOM Type ....... Page # Description 1 10-0000 887.90 1057.02 SET 11 S&S ENGINE CASE SET If the key word finds more than one listing keep the listing to a max of 20 per page. If there is more than 20 then have it do this 18 10-0292 1375 1636.90 KIT 11 S&S ENGINE CASE SET 19 10-0294 999 1189.29 SET V-TWIN ENGINE CASE SET 20 10-0340 2725 3244.05 SET 11 DELKRON ENGINE CASE SET Results 1 to 20 of 268. Current | 2 | 3 | Last | Next » I need a mark-up of 12% added to "Dealer Cost". I do not need to update the database just the displayed amount. Please hard code this in the php so I can change it as needed. It would be great if the mark-up amount can be placed between Dealer & Retail amounts. *** CHANGE NOTE *** Change option for mark-up If it's easier to add percentage field in the database and read that for the markup, then I can add an extra field coma/space between UOM and Page easily to the CSV file and import to database table. 10-0040,89.90,132.21,EA,[markup], 22,"CAM COVER, CHROME" There will need to be a simple script or perl operation to update the complete database with the markup since I will update the full database monthly and would need to run it so the mark-up is correct. Then the search code will need to read the database with the extra field. But have markup displayed between Your Cost and Retail. CREATE TABLE IF NOT EXISTS `parts` ( `id` int(6) NOT NULL auto_increment, `part_num` varchar(15) NOT NULL default '', `dealer` varchar(10) NOT NULL default '', `retail` varchar(10) NOT NULL default '', `uom` varchar(10) NOT NULL default '', `markup` varchar(10) NOT NULL default '', `page`varchar(5) NOT NULL default '', `product_desc` varchar(75) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
Project ID: #3638611