Home | How it works | Projects archive | Contact Us
Air Compressor Bot 		 
The Career Path of Freelance Programming Jobs 

   osCommerce Inventory Editor Page
Bidding Time:
01/06/2007 23:35 - 06/06/2007 00:00
Budget:
$30-100
Status:
 Closed


Job Type:
PHP
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!

Start your work-at-home career for $7.00. Get direct access to thousands of freelance and home-based jobs. Click here to find work now.

Related Projects:
Clone site 5 ( updated)
Content writing for hotels
Simple php fix
Mobile phone site logo
Design Your Own Dress Flash Pg

This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:
 Linux
Database System:
 MySQL
<<< back

Recent Projects Archive:

Tuesday - Monday - Sunday - Saturday - Friday - Thursday - Wednesday

View all freelance web projects
 
Home | Projects archive | RSS | Resources | Links | Contact Us © 2004-2008 ProjectsList.biz /0.685