SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

getting array as input from PHP to DB and to do process

534103Dec 10 2009 — edited Dec 11 2009

Hi Friends,

Just now starting to work with oracle 11g,

This is my requirement,

TEXTPHOTO OBJECT
(
    [NAME] 	=> 
    [TEXT] 	=> 
    [PHOTOS] 	=> 
	Array
        (
        [0] => TEXTPHOTO OBJECT
                (
                    [PHOTOCROPWIDTH] 	=> 259
                    [FLASHWIDTH] 	=> 306.85
                    [PHOTOID] 		=> 465
                    [FLASHHEIGHT] 	=> 383.6
                    [ROTATION] 		=> 0
                    [FLASHXVALUE] 	=> -256
                    [CROPXVALUE] 	=> 24
                    [CROPYVALUE] 	=> 0
                    [FLASHYVALUE] 	=> -320
                    [EFFECTID] 		=> 
                    [CROPHEIGHT] 	=> 384
                    [CROPWIDTH] 	=> 390
                )
	[1] => TEXTPHOTO OBJECT
                (
                    [PHOTOCROPWIDTH] 	=> 259
                    [FLASHWIDTH] 	=> 306.85
                    [PHOTOID] 		=> 470
                    [FLASHHEIGHT] 	=> 383.6
                    [ROTATION] 		=> 0
                    [FLASHXVALUE] 	=> -256
                    [CROPXVALUE] 	=> 24
                    [CROPYVALUE] 	=> 0
                    [FLASHYVALUE] 	=> -320
                    [EFFECTID] 		=> 
                    [CROPHEIGHT] 	=> 384
                    [CROPWIDTH] 	=> 390
                )

	[2] => TEXTPHOTO OBJECT
                (
                    [PHOTOCROPWIDTH] 	=> 270
                    [FLASHWIDTH] 	=> 285.20
                    [PHOTOID] 		=> 465
                    [FLASHHEIGHT] 	=> 371.6
                    [ROTATION] 		=> 0
                    [FLASHXVALUE] 	=> -052
                    [CROPXVALUE] 	=> 28
                    [CROPYVALUE] 	=> 0
                    [FLASHYVALUE] 	=> -312
                    [EFFECTID] 		=> 
                    [CROPHEIGHT] 	=> 400
                    [CROPWIDTH] 	=> 520
                )
        )

    [PRODUCTID] 			=> 1032
    ..
    ....

)

I need to get this as an input to my Stored Procedure and to separate the array values and
to insert those values corresponding to my tables.

I need your help to work out this PHP object with ORACLE.

Thanks,
Dharan V

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 8 2010

Added on Dec 10 2009

2 comments

334 views