convert mysql code into php code
Posted: Fri Jul 31, 2009 12:32 am
Hello all I have the following sql statements which I need to convert to php compatible code:
Can anyone help me with the conversion?
Code: Select all
CREATE procedure ImportArticles(ArtNo int(10), ArtDesc varchar(300), ArtBody varchar(300), Price Decimal(6,2), ImageName varchar(50), ImagePath varchar(100), Op int(1))
begin
declare xnid int(10);
declare xfid int(10);
declare xvid int(10);
SET xnid = 0;
SET xfid = 0;
SET xvid = 0;
case Op
when 0 then
begin
SELECT count(nid) INTO xnid FROM uc_products WHERE ArticleNo = ArtNo;
IF xnid > 0 then
begin
SELECT nid INTO xnid FROM uc_products WHERE ArticleNo = ArtNo;
UPDATE uc_products SET sell_price = Price WHERE nid = xnid;
UPDATE node_revisions SET title = ArtDesc, body = ArtBody, teaser = ArtBody WHERE nid = xnid;
IF ImageName <> '' then
begin
SELECT DISTINCT field_uc_image_fid INTO xfid FROM files f, content_type_product ctp WHERE ctp.nid = xnid;
IF xfid > 0 then
UPDATE files SET filename = ImageName, FilePath = ImagePath WHERE fid = xfid;
end IF;
end;
end IF;
end;
else
begin
SELECT max(nid) INTO xnid FROM node;
SET xnid = xnid + 1;
INSERT INTO node(nid, vid, type, LANGUAGE, title) VALUES(xnid, xnid, 'product', 'fr', ArtDesc);
INSERT INTO node_revisions(nid, vid, title, body, teaser) VALUES (xnid, xnid, ArtDesc, ArtBody, ArtBody);
INSERT INTO uc_products(vid,nid,Articleno, sell_price) VALUES (xnid,xnid,ArtNo, Price);
IF ImageName <> '' then
begin
SELECT max(fid) INTO xfid FROM files;
SET xfid = xfid + 1;
INSERT INTO files(fid,uid,filename,filepath,filemime,STATUS) VALUES (xnid,1,Imagename,ImagePath,'image/jpeg',1);
SELECT max(vid) INTO xvid FROM content_type_product;
SET xvid = xvid + 1;
INSERT INTO content_type_product(vid, nid, field_uc_image_fid) VALUES (xvid, xnid, xfid) ;
end;
end IF;
end;
end IF;
end;
when 1 then
begin
SELECT nid INTO xnid FROM uc_products WHERE ArticleNo = ArtNo;
UPDATE uc_products SET sell_price = Price WHERE nid = xnid;
UPDATE node_revisions SET title = ArtDesc, body = ArtBody, teaser = ArtBody WHERE nid = xnid;
IF ImageName <> '' then
begin
SELECT DISTINCT field_uc_image_fid INTO xfid FROM files f, content_type_product ctp WHERE ctp.nid = xnid;
IF xfid > 0 then
UPDATE files SET filename = ImageName, FilePath = ImagePath WHERE fid = xfid;
end IF;
end;
end IF;
end;
end case;
end