Em Andamento

osCommerce Inventory Editor Page

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!

Habilidades: PHP

Ver mais: oscommerce database editor, oscommerce inventory editor, well care, the seek, simply well, seek site, seek one, seek it, seek i, seek entry level, seek editor, seek see, one seek, my seek, want editor, it seek, int i, html text editor, html script editor, html form editor, form editor html, editor need, data entry validation access, connect care, unique ids users oscommerce

Acerca do Empregador:
( 1 comentário ) Sacramento, United States

ID do Projeto: #149486

Premiar a:

rajinfosolu

Dear Sir I have 4 years experience in php,mysql,smarty,oscommerce,ajax,javascript. Oscommerce:-- http://www.ifsqn.com http://sneakerlux.com http://www.plantlightingkit.com http://www.mdofpc.com http://www.uncommon-cent Mais

$75 USD em 3 dias
(48 Avaliações)
6.2

7 freelancers estão ofertando em média $84 para este trabalho

hautu

I'm be able to do it for you. regards.

$100 USD in 2 dias
(246 Comentários)
7.6
CreativeB24

Hello, We have gone through your requirement. This is a very simple job. We are ready to do it. We can deliver in next couple of [url removed, login to view] have our experienced teams for designing, development, testing, debugging and m Mais

$100 USD in 0 dias
(22 Comentários)
6.4
websoftinfo

Ready to start.. regards meena

$75 USD em 1 dia
(66 Comentários)
6.4
mailwork

You will be get the finished project in less than 24 hours if you provide enough details.

$60 USD in 0 dias
(3 Comentários)
4.2
silvermoonx

plz see pmb:)

$99 USD em 1 dia
(10 Comentários)
3.8
leedsit

Hello, We are very much interested to work on your project. Please look into PMB for our recently completed projects. We have developed projects in Php/MySql, [url removed, login to view], OsCommerce, Mambo, Joomla, Ruby on Rail, AJAX e Mais

$78 USD in 3 dias
(2 Comentários)
2.7