osCommerce Inventory Editor Page

osCommerce Inventory Editor Page is project number 149486 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider rajinfosolu)

Status:	Closed
Budget:	$30-100
Created:	06/01/2007 at 23:35 EDT
Bidding Ends:	06/06/2007 at 23:35 EDT
Project Creator:	rodneysparks   Buyer Rating: (1 reviews)
Description:	I need a very basic HTML/PHP page put together. It involves the following two tables in my osCommerce database: Table: products products_id - int(11) (unique id) products_model - varchar(12) products_weight - decimal(5,2) products_quantity - int(4) Table: products_description products_id - int(11) (unique id) products_description - text I need a PHP/HTML document made that is simply made up of a table with the following column headings: Part Number, Description, Weight, Stock Level populated with the following data fields: products_model, products_description, products_weight, products_quantity I want the first two fields just shown as text, but the second two fields editable as text box form fields. When the page loads, those two columns should be populated with the current database entries. All rows in the database must be shown on a single screen. A user should then be able to go and directly update multiple entries in the table and then hit a single "apply" button at the bottom of the page to store all of the values in the database. Values in the "weight" and "stock level" fields should both be editable at the same time. The weight entry must be validated as a positive number and rounded to two decimal places, and the stock level entry must be a positive or negative integer. If the validation fails on any one cell in the table, the page must not update any of the database entries. As far as formatting goes, all I want is for the table to be set up as an HTML table, with each field in a separate column and each row in a separate row. I can take care of the rest. The script must be provided with the following database access commands at the top of the file (or something similar), so I can enter my own database access parameter values: $username = "username"; $password = "password"; $hostname = "hostname"; $db = mysql_connect($hostname, $username, $password); // or die("Unable to connect to MySQL"); mysql_select_db("database",$db); That's it! I could probably figure it out myself, but it'd probably take me a whole Saturday, and that's no good. ;-) This is my first time on this site, so if it works out well, I'll probably seek out more help with my osCommerce installation. Man, that thing can be a time sink for someone not used to coding! As is suggested by this site, I'd need to see the script in action on your own server before sending payment. Thanks! Additional information submitted: 06/06/2007 at 19:33 EDT: I actually need to add one thing, which will probably be very easy for you to do... I'd like a box above the part number and description fields into which a text string can be entered (default value is "*") that would allow the user to filter the displayed table to show the records that fit that query string. For example, "T*" on the description field returns just the records for which the description starts with "T". I'm almost positive that this would just be part of the "SELECT" part of the query, and would be very easy to implement... Comments are welcome. Thanks!
Job Type:	PHP
Database:	MySQL
Operating system:	Linux
Bid count:	7
Average bid:	$ 84