2 php scripts that will update mysql database

you are using one mysql table and updating it using rules below

[url removed, login to view]

orders are assigned batchids they all need to be assigned binID (each order has its own binID) values 1-200 are available.

so add to the order table


the first part of the script is to run and remove binIDs from orders that no longer require it, so any order that is set to Status=Packed its binID will be cleared.

next the script runs it looks up orders that are set to "stock allocated=YES" and have no value in "binID" and is batchorder=N it will then give each order a binid between 1-200 (there may be more than 200 orders that are set to stock alloted yes so it will give IDs to the oldest orders this can use orderDate.


[url removed, login to view]

add a field called batchid

top of the script i need a config section where i can define a 'batchqty=' value.

the script searches through the orderstbl any order that is batch_order=Y and Stockallocated=YES and Status=''

so in this example the value in the batchqty=25 so the oldest 25 orders would be batch0001, the next batch of 25 is batch0002

Habilidades: Servicios web de Amazon, PHP, Arquitectura de software, Verificación de software, Web Hosting, Gestión de páginas web, Verificación de páginas web

Ver más: mysql database software, architecture define, update mysql, stock update, run and update, php software architecture mysql, PHP SCRIPTS, packed, update status script php, script update database mysql, update status php mysql, status update script, update stock, mysql update field, mysql update values, using scripts, update values mysql, mysql remove table, php run batch script, php script searches

Información del empleador:
( 107 comentarios ) Southport, United Kingdom

Nº del proyecto: #2768841

Adjudicado a:


See private message.

$100.3 USD en 3 días
(484 comentarios)

4 freelancers están ofertando el promedio de $113 para este trabajo


See private message.

$100.3 USD en 3 días
(9 comentarios)

See private message.

$100 USD en 3 días
(3 comentarios)

See private message.

$150.45 USD en 3 días
(0 comentarios)