Episode of Luffy hand island no bouken 3gpgolkes
Episode of luffy hand island no bouken 3gpgolkes
episode of luffy hand island no bouken 3gpgolkes
episode of luffy hand island no bouken 3gpgolkes
episode of luffy hand island no bouken 3gpgolkes
Episode of luffy hand island no bouken 3gpgolkesQ:
php call mysql stored procedure
I have been trying to call a stored procedure and just can't seem to get it to work. The reason why is because I am adding some type of validation that will be included in the stored procedure. Basically the idea is to have one form submit the job to the database and other tables to be updated via stored procedure.
This is my stored procedure:
DELIMITER $$
CREATE PROCEDURE `update_price`(
IN _job_id bigint,
IN _type_id bigint,
IN _sku_id bigint,
IN _quantity_id bigint,
IN _line_id bigint,
IN _ppr_id bigint,
IN _tax_id bigint,
IN _tax_percentage decimal(5,2))
BEGIN
update job_tbl
set job_status = 1
where job_id = _job_id;
update payment_tbl
set invoice_id = _invoice_id,
inv_method = _inv_method,
tax_id = _tax_id,
tax_percentage = _tax_percentage,
bill_to = _bill_to,
bill_from = _bill_from,
invoice_amount = _invoice_amount,
invoice_currency = _invoice_currency,
invoice_reference = _invoice_reference,
currency = _currency,
payment_id = _payment_id,
due_date = _due_date,
charge_type = _charge_type,
inv_fee = _inv_fee,
contact = _contact,
payment_source = _payment_source, be359ba680
Related links:
Comments