225953 Price Update Script

I need a small php/MYSql script to accomplish the following:

User enters a particular price and the script does the following:

After entering the following info in a simple form:


% increase/decrease(numeric)


round (checkbox)

The script will accomplish the following:

1) Searches the products database and finds all Price matches

2) reduce or increase the price by the percentage entered

3) round the dollar amount down by the number chosen (2 or 0)

4) If checked, round the result to the nearest $5 (no decimals)

5) Update the database with these new prices.


Price = $125

% = -25

Precision = 0

Round = yes

result = (93.75 = 93 = 95) 95 is entered back into the database.

Kemahiran: Semua Boleh, PHP, SQL

Lihat lagi: sql price, update products, info update, script update database mysql, reduce sql, mysql update checkbox, mysql number sql, php mysql sql example, example mysql script, sql reduce, php sql update, sql script mysql, php script searches, simple form php update mysql, php price update script, searches small, php form update database, simple update script php, php small database script, form update sql, php script example update database, increase script, script price increase, sql update, update database sql

Tentang Majikan:
( 10 ulasan )

ID Projek: #1972190

Dianugerahkan kepada:



$25 USD dalam sehari
(122 Ulasan)