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!

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!

Habilidades: PHP

Ver mais: cre loaded enter products_id, oscommerce database editor, oscommerce inventory editor, well care, update oscommerce 2.2 to 2.3.1, the seek, simply well, seek site, seek seek, seek password, seek one, seek it, seek i, seek entry level, seek editor, seek and see, php my inventory, password seek, one seek, need and editor, my seek, i want an editor, it seek, i seek password, int i

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:-- [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] 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, asp.net, OsCommerce, Mambo, Joomla, Ruby on Rail, AJAX e Mais

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