Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Development CodeIgniter 3.x Handling Stored Procedures that return multiple record sets
Handling Stored Procedures that return multiple record sets
#1
06-01-2017, 10:11 AM

Our database engineer is fond of creating stored procedures that return multiple record sets/results. I have had success in the past with hacking the CI 2 system files to accommodate multiple recordsets but now we are using CI 3.1.X and things have changed a little bit.

There are some known hacks that are used to add this functionality to CI 2.  Can these be added to CI 3?  We do a lot of data abstraction and visualization in our applications.

Thanks.
Reply
  • Offline Junie
    Member
  • ***
  • Posts: 53
    Threads: 6
    Joined: May 2017
    Reputation: -1
#2
06-02-2017, 11:20 AM
(This post was last modified: 06-02-2017, 11:21 AM by Junie.)

For me I don't practice stored procedures. I dont like it because of SECURITY REASON. I don't READ anymore about that.
Reply
#3
06-05-2017, 09:31 AM
(This post was last modified: 06-05-2017, 10:25 AM by ciadmin.)

(06-02-2017, 11:20 AM)Junie Wrote: For me I don't practice stored procedures. I dont like it because of SECURITY REASON. I don't READ anymore about that.

Junie your reply isn't helpful or constructive.
Reply
  • Offline skunkbad
    Senior Citizen
  • *****
  • Posts: 1,300
    Threads: 63
    Joined: Oct 2014
    Reputation: 86
#4
06-05-2017, 05:08 PM

(06-02-2017, 11:20 AM)Junie Wrote: For me I don't practice stored procedures. I dont like it because of SECURITY REASON. I don't READ anymore about that.

You should at least link us up to what you think is information claiming that stored procedures are a "security reason". What I've read is just the opposite, and can be found all over the place by searching on Google or whatever search engine you use.
Expert Website Development - Temecula, CA
Community Auth For CodeIgniter 3
Reply
  • Offline skunkbad
    Senior Citizen
  • *****
  • Posts: 1,300
    Threads: 63
    Joined: Oct 2014
    Reputation: 86
#5
06-05-2017, 05:16 PM
(This post was last modified: 06-06-2017, 01:06 AM by skunkbad.)

(06-01-2017, 10:11 AM)brocknessmonster Wrote: Our database engineer is fond of creating stored procedures that return multiple record sets/results. I have had success in the past with hacking the CI 2 system files to accommodate multiple recordsets but now we are using CI 3.1.X and things have changed a little bit.

There are some known hacks that are used to add this functionality to CI 2.  Can these be added to CI 3?  We do a lot of data abstraction and visualization in our applications.

Thanks.


Try this:


PHP Code:
public function test()
{
    $sql = 'CALL your_procedure()';
    $results = $this->multiple_result_array( $sql );

    echo '<pre>';
    var_dump($results);
    echo '</pre>';

    $sql = 'CALL your_procedure()';
    $results = $this->multiple_result( $sql );

    echo '<pre>';
    var_dump($results);
    echo '</pre>';
}

/**
 * This could go in MY_Model:
 */
public function multiple_result_array( $sql )
{
    if( empty( $sql ) )
        return NULL;

    $i = 0;
    $set = [];

    if( mysqli_multi_query( $this->db->conn_id, $sql ) )
    {
        do 
        {
            mysqli_next_result( $this->db->conn_id );
            
            if( FALSE != $result = mysqli_store_result( $this->db->conn_id ) )
            {
                $row_id = 0;

                while( $row = $result->fetch_assoc() )
                {
                    $set[$i][$row_id] = $row;
                    $row_id++;
                }
            }

            $i++;
        } 
        while ( mysqli_more_results( $this->db->conn_id ) );
    }

    return $set;
}

/**
 * This could go in MY_Model:
 */
public function multiple_result( $sql )
{
    if( empty( $sql ) )
        return NULL;

    $i = 0;
    $set = [];

    if( mysqli_multi_query( $this->db->conn_id, $sql ) )
    {
        do 
        {
            mysqli_next_result( $this->db->conn_id );
            
            if( FALSE != $result = mysqli_store_result( $this->db->conn_id ) )
            {
                $row_id = 0;

                while( $row = $result->fetch_object() )
                {
                    $set[$i][$row_id] = $row;
                    $row_id++;
                }
            }

            $i++;
        } 
        while ( mysqli_more_results( $this->db->conn_id ) );
    }

    return $set;
} 
Expert Website Development - Temecula, CA
Community Auth For CodeIgniter 3
Reply
  • Offline tatarespecia
    Newbie
  • *
  • Posts: 3
    Threads: 0
    Joined: Jan 2016
    Reputation: 0
#6
03-04-2018, 03:39 PM

@brocknessmonster, your solution seems to work though I have not tried it. I still would look for a pure CI3 way to do it.
Reply
  • Offline oscar1925
    Newbie
  • *
  • Posts: 9
    Threads: 2
    Joined: Feb 2017
    Reputation: 0
#7
03-05-2018, 11:49 PM

(06-05-2017, 05:16 PM)skunkbad Wrote:
(06-01-2017, 10:11 AM)brocknessmonster Wrote: Our database engineer is fond of creating stored procedures that return multiple record sets/results. I have had success in the past with hacking the CI 2 system files to accommodate multiple recordsets but now we are using CI 3.1.X and things have changed a little bit.

There are some known hacks that are used to add this functionality to CI 2.  Can these be added to CI 3?  We do a lot of data abstraction and visualization in our applications.

Thanks.


Try this:


PHP Code:
public function test()
{
    $sql = 'CALL your_procedure()';
    $results = $this->multiple_result_array( $sql );

    echo '<pre>';
    var_dump($results);
    echo '</pre>';

    $sql = 'CALL your_procedure()';
    $results = $this->multiple_result( $sql );

    echo '<pre>';
    var_dump($results);
    echo '</pre>';
}

/**
 * This could go in MY_Model:
 */
public function multiple_result_array( $sql )
{
    if( empty( $sql ) )
        return NULL;

    $i = 0;
    $set = [];

    if( mysqli_multi_query( $this->db->conn_id, $sql ) )
    {
        do 
        {
            mysqli_next_result( $this->db->conn_id );
            
            if( FALSE != $result = mysqli_store_result( $this->db->conn_id ) )
            {
                $row_id = 0;

                while( $row = $result->fetch_assoc() )
                {
                    $set[$i][$row_id] = $row;
                    $row_id++;
                }
            }

            $i++;
        } 
        while ( mysqli_more_results( $this->db->conn_id ) );
    }

    return $set;
}

/**
 * This could go in MY_Model:
 */
public function multiple_result( $sql )
{
    if( empty( $sql ) )
        return NULL;

    $i = 0;
    $set = [];

    if( mysqli_multi_query( $this->db->conn_id, $sql ) )
    {
        do 
        {
            mysqli_next_result( $this->db->conn_id );
            
            if( FALSE != $result = mysqli_store_result( $this->db->conn_id ) )
            {
                $row_id = 0;

                while( $row = $result->fetch_object() )
                {
                    $set[$i][$row_id] = $row;
                    $row_id++;
                }
            }

            $i++;
        } 
        while ( mysqli_more_results( $this->db->conn_id ) );
    }

    return $set;
} 



i try this and it works... my problem now is how to echo/view the records on my view using <?php foreach ($data as $rows): ?>

this is my data...

Code:
[color=#000000]

array(1) {
 [0]=>
 array(4) {
   [0]=>
   object(stdClass)#31 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(21) "Afro Asian Literature"
     ["loadid_id"]=>
     string(2) "12"
     ["grade1"]=>
     string(2) "80"
     ["grade2"]=>
     string(2) "79"
     ["grade3"]=>
     string(1) "0"
     ["grade4"]=>
     string(1) "0"
     ["average"]=>
     string(5) "39.75"
   }
   [1]=>
   object(stdClass)#32 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(18) "Araling Panlipunan"
     ["loadid_id"]=>
     string(1) "9"
     ["grade1"]=>
     string(2) "90"
     ["grade2"]=>
     string(2) "85"
     ["grade3"]=>
     string(2) "75"
     ["grade4"]=>
     string(2) "95"
     ["average"]=>
     string(5) "86.25"
   }
   [2]=>
   object(stdClass)#33 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(40) "Music, Arts, Physical Education, Health "
     ["loadid_id"]=>
     string(2) "11"
     ["grade1"]=>
     string(2) "81"
     ["grade2"]=>
     string(2) "83"
     ["grade3"]=>
     string(2) "89"
     ["grade4"]=>
     string(2) "90"
     ["average"]=>
     string(5) "85.75"
   }
   [3]=>
   object(stdClass)#34 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(21) "Philippine Literature"
     ["loadid_id"]=>
     string(1) "8"
     ["grade1"]=>
     string(2) "88"
     ["grade2"]=>
     string(1) "0"
     ["grade3"]=>
     string(1) "0"
     ["grade4"]=>
     string(1) "0"
     ["average"]=>
     string(2) "22"
   }
 }
}

[/color]

Help....
Reply
  • Offline Muthusamy
    PHP Developer
  • *
  • Posts: 5
    Threads: 0
    Joined: Mar 2018
    Reputation: 0
#8
03-06-2018, 02:01 AM
(This post was last modified: 03-06-2018, 02:28 AM by Muthusamy.)

(03-05-2018, 11:49 PM)oscar1925 Wrote:
(06-05-2017, 05:16 PM)skunkbad Wrote:
(06-01-2017, 10:11 AM)brocknessmonster Wrote: Our database engineer is fond of creating stored procedures that return multiple record sets/results. I have had success in the past with hacking the CI 2 system files to accommodate multiple recordsets but now we are using CI 3.1.X and things have changed a little bit.

There are some known hacks that are used to add this functionality to CI 2.  Can these be added to CI 3?  We do a lot of data abstraction and visualization in our applications.

Thanks.


Try this:


PHP Code:
public function test()
{
    $sql = 'CALL your_procedure()';
    $results = $this->multiple_result_array( $sql );

    echo '<pre>';
    var_dump($results);
    echo '</pre>';

    $sql = 'CALL your_procedure()';
    $results = $this->multiple_result( $sql );

    echo '<pre>';
    var_dump($results);
    echo '</pre>';
}

/**
 * This could go in MY_Model:
 */
public function multiple_result_array( $sql )
{
    if( empty( $sql ) )
        return NULL;

    $i = 0;
    $set = [];

    if( mysqli_multi_query( $this->db->conn_id, $sql ) )
    {
        do 
        {
            mysqli_next_result( $this->db->conn_id );
            
            if( FALSE != $result = mysqli_store_result( $this->db->conn_id ) )
            {
                $row_id = 0;

                while( $row = $result->fetch_assoc() )
                {
                    $set[$i][$row_id] = $row;
                    $row_id++;
                }
            }

            $i++;
        } 
        while ( mysqli_more_results( $this->db->conn_id ) );
    }

    return $set;
}

/**
 * This could go in MY_Model:
 */
public function multiple_result( $sql )
{
    if( empty( $sql ) )
        return NULL;

    $i = 0;
    $set = [];

    if( mysqli_multi_query( $this->db->conn_id, $sql ) )
    {
        do 
        {
            mysqli_next_result( $this->db->conn_id );
            
            if( FALSE != $result = mysqli_store_result( $this->db->conn_id ) )
            {
                $row_id = 0;

                while( $row = $result->fetch_object() )
                {
                    $set[$i][$row_id] = $row;
                    $row_id++;
                }
            }

            $i++;
        } 
        while ( mysqli_more_results( $this->db->conn_id ) );
    }

    return $set;
} 



i try this and it works... my problem now is how to echo/view the records on my view using <?php foreach ($data as $rows): ?>

this is my data...

Code:
[color=#000000]

array(1) {
 [0]=>
 array(4) {
   [0]=>
   object(stdClass)#31 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(21) "Afro Asian Literature"
     ["loadid_id"]=>
     string(2) "12"
     ["grade1"]=>
     string(2) "80"
     ["grade2"]=>
     string(2) "79"
     ["grade3"]=>
     string(1) "0"
     ["grade4"]=>
     string(1) "0"
     ["average"]=>
     string(5) "39.75"
   }
   [1]=>
   object(stdClass)#32 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(18) "Araling Panlipunan"
     ["loadid_id"]=>
     string(1) "9"
     ["grade1"]=>
     string(2) "90"
     ["grade2"]=>
     string(2) "85"
     ["grade3"]=>
     string(2) "75"
     ["grade4"]=>
     string(2) "95"
     ["average"]=>
     string(5) "86.25"
   }
   [2]=>
   object(stdClass)#33 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(40) "Music, Arts, Physical Education, Health "
     ["loadid_id"]=>
     string(2) "11"
     ["grade1"]=>
     string(2) "81"
     ["grade2"]=>
     string(2) "83"
     ["grade3"]=>
     string(2) "89"
     ["grade4"]=>
     string(2) "90"
     ["average"]=>
     string(5) "85.75"
   }
   [3]=>
   object(stdClass)#34 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(21) "Philippine Literature"
     ["loadid_id"]=>
     string(1) "8"
     ["grade1"]=>
     string(2) "88"
     ["grade2"]=>
     string(1) "0"
     ["grade3"]=>
     string(1) "0"
     ["grade4"]=>
     string(1) "0"
     ["average"]=>
     string(2) "22"
   }
 }
}

[/color]

Help....

I try this Please check the below code:

Code:
$test =Array( "0" => Array
(
    "0" => (Object)
        [
            "PRO_PRICE_CODE" => "AAA001001",
            "PRO_MST_NM" => "Promo Air Asia",
            "PRO_AMT_CUST" => "65000.00"
       ],

     "1" => (Object)
        [
            "PRO_PRICE_CODE" => "AAAnghngng001001",
            "PRO_MST_NM" => "Asia Airlines",
            "PRO_AMT_CUST" => "55000.00"
        ]
)

);

foreach ($test as $key => $value) {
    echo $value["0"]->PRO_PRICE_CODE;

    
}
Reply
  • Offline oscar1925
    Newbie
  • *
  • Posts: 9
    Threads: 2
    Joined: Feb 2017
    Reputation: 0
#9
03-06-2018, 02:47 AM

(03-06-2018, 02:01 AM)Muthusamy Wrote:
(03-05-2018, 11:49 PM)oscar1925 Wrote:
(06-05-2017, 05:16 PM)skunkbad Wrote:
(06-01-2017, 10:11 AM)brocknessmonster Wrote: Our database engineer is fond of creating stored procedures that return multiple record sets/results. I have had success in the past with hacking the CI 2 system files to accommodate multiple recordsets but now we are using CI 3.1.X and things have changed a little bit.

There are some known hacks that are used to add this functionality to CI 2.  Can these be added to CI 3?  We do a lot of data abstraction and visualization in our applications.

Thanks.


Try this:


PHP Code:
public function test()
{
    $sql = 'CALL your_procedure()';
    $results = $this->multiple_result_array( $sql );

    echo '<pre>';
    var_dump($results);
    echo '</pre>';

    $sql = 'CALL your_procedure()';
    $results = $this->multiple_result( $sql );

    echo '<pre>';
    var_dump($results);
    echo '</pre>';
}

/**
 * This could go in MY_Model:
 */
public function multiple_result_array( $sql )
{
    if( empty( $sql ) )
        return NULL;

    $i = 0;
    $set = [];

    if( mysqli_multi_query( $this->db->conn_id, $sql ) )
    {
        do 
        {
            mysqli_next_result( $this->db->conn_id );
            
            if( FALSE != $result = mysqli_store_result( $this->db->conn_id ) )
            {
                $row_id = 0;

                while( $row = $result->fetch_assoc() )
                {
                    $set[$i][$row_id] = $row;
                    $row_id++;
                }
            }

            $i++;
        } 
        while ( mysqli_more_results( $this->db->conn_id ) );
    }

    return $set;
}

/**
 * This could go in MY_Model:
 */
public function multiple_result( $sql )
{
    if( empty( $sql ) )
        return NULL;

    $i = 0;
    $set = [];

    if( mysqli_multi_query( $this->db->conn_id, $sql ) )
    {
        do 
        {
            mysqli_next_result( $this->db->conn_id );
            
            if( FALSE != $result = mysqli_store_result( $this->db->conn_id ) )
            {
                $row_id = 0;

                while( $row = $result->fetch_object() )
                {
                    $set[$i][$row_id] = $row;
                    $row_id++;
                }
            }

            $i++;
        } 
        while ( mysqli_more_results( $this->db->conn_id ) );
    }

    return $set;
} 



i try this and it works... my problem now is how to echo/view the records on my view using <?php foreach ($data as $rows): ?>

this is my data...

Code:
[color=#000000]

array(1) {
 [0]=>
 array(4) {
   [0]=>
   object(stdClass)#31 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(21) "Afro Asian Literature"
     ["loadid_id"]=>
     string(2) "12"
     ["grade1"]=>
     string(2) "80"
     ["grade2"]=>
     string(2) "79"
     ["grade3"]=>
     string(1) "0"
     ["grade4"]=>
     string(1) "0"
     ["average"]=>
     string(5) "39.75"
   }
   [1]=>
   object(stdClass)#32 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(18) "Araling Panlipunan"
     ["loadid_id"]=>
     string(1) "9"
     ["grade1"]=>
     string(2) "90"
     ["grade2"]=>
     string(2) "85"
     ["grade3"]=>
     string(2) "75"
     ["grade4"]=>
     string(2) "95"
     ["average"]=>
     string(5) "86.25"
   }
   [2]=>
   object(stdClass)#33 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(40) "Music, Arts, Physical Education, Health "
     ["loadid_id"]=>
     string(2) "11"
     ["grade1"]=>
     string(2) "81"
     ["grade2"]=>
     string(2) "83"
     ["grade3"]=>
     string(2) "89"
     ["grade4"]=>
     string(2) "90"
     ["average"]=>
     string(5) "85.75"
   }
   [3]=>
   object(stdClass)#34 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(21) "Philippine Literature"
     ["loadid_id"]=>
     string(1) "8"
     ["grade1"]=>
     string(2) "88"
     ["grade2"]=>
     string(1) "0"
     ["grade3"]=>
     string(1) "0"
     ["grade4"]=>
     string(1) "0"
     ["average"]=>
     string(2) "22"
   }
 }
}

[/color]

Help....

I try this Please check the below code:

Code:
$test =Array( "0" => Array
(
    "0" => (Object)
        [
            "PRO_PRICE_CODE" => "AAA001001",
            "PRO_MST_NM" => "Promo Air Asia",
            "PRO_AMT_CUST" => "65000.00"
       ],

     "1" => (Object)
        [
            "PRO_PRICE_CODE" => "AAAnghngng001001",
            "PRO_MST_NM" => "Asia Airlines",
            "PRO_AMT_CUST" => "55000.00"
        ]
)

);

foreach ($test as $key => $value) {
    echo $value["0"]->PRO_PRICE_CODE;   
}

[Image: lightbulb.gif] it somehow works...nice but do i need to always code..
Code:
<?php foreach ($data as $key => $value): ?>
  <?php echo "Sakto ".$value[0]->loadid_id; ?>
  <?php echo "Sakto ".$value[0]->subject; ?>
  <?php echo "Sakto ".$value[1]->loadid_id; ?>
  <?php echo "Sakto ".$value[1]->subject; ?>
 <?php endforeach; ?>

do you have a code to loop these data?
Reply
  • Offline Muthusamy
    PHP Developer
  • *
  • Posts: 5
    Threads: 0
    Joined: Mar 2018
    Reputation: 0
#10
03-06-2018, 04:08 AM
(This post was last modified: 03-06-2018, 04:10 AM by Muthusamy.)

(03-06-2018, 02:47 AM)oscar1925 Wrote:
(03-06-2018, 02:01 AM)Muthusamy Wrote:
(03-05-2018, 11:49 PM)oscar1925 Wrote:
(06-05-2017, 05:16 PM)skunkbad Wrote:
(06-01-2017, 10:11 AM)brocknessmonster Wrote: Our database engineer is fond of creating stored procedures that return multiple record sets/results. I have had success in the past with hacking the CI 2 system files to accommodate multiple recordsets but now we are using CI 3.1.X and things have changed a little bit.

There are some known hacks that are used to add this functionality to CI 2.  Can these be added to CI 3?  We do a lot of data abstraction and visualization in our applications.

Thanks.


Try this:


PHP Code:
public function test()
{
    $sql = 'CALL your_procedure()';
    $results = $this->multiple_result_array( $sql );

    echo '<pre>';
    var_dump($results);
    echo '</pre>';

    $sql = 'CALL your_procedure()';
    $results = $this->multiple_result( $sql );

    echo '<pre>';
    var_dump($results);
    echo '</pre>';
}

/**
 * This could go in MY_Model:
 */
public function multiple_result_array( $sql )
{
    if( empty( $sql ) )
        return NULL;

    $i = 0;
    $set = [];

    if( mysqli_multi_query( $this->db->conn_id, $sql ) )
    {
        do 
        {
            mysqli_next_result( $this->db->conn_id );
            
            if( FALSE != $result = mysqli_store_result( $this->db->conn_id ) )
            {
                $row_id = 0;

                while( $row = $result->fetch_assoc() )
                {
                    $set[$i][$row_id] = $row;
                    $row_id++;
                }
            }

            $i++;
        } 
        while ( mysqli_more_results( $this->db->conn_id ) );
    }

    return $set;
}

/**
 * This could go in MY_Model:
 */
public function multiple_result( $sql )
{
    if( empty( $sql ) )
        return NULL;

    $i = 0;
    $set = [];

    if( mysqli_multi_query( $this->db->conn_id, $sql ) )
    {
        do 
        {
            mysqli_next_result( $this->db->conn_id );
            
            if( FALSE != $result = mysqli_store_result( $this->db->conn_id ) )
            {
                $row_id = 0;

                while( $row = $result->fetch_object() )
                {
                    $set[$i][$row_id] = $row;
                    $row_id++;
                }
            }

            $i++;
        } 
        while ( mysqli_more_results( $this->db->conn_id ) );
    }

    return $set;
} 



i try this and it works... my problem now is how to echo/view the records on my view using <?php foreach ($data as $rows): ?>

this is my data...

Code:
[color=#000000]

array(1) {
 [0]=>
 array(4) {
   [0]=>
   object(stdClass)#31 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(21) "Afro Asian Literature"
     ["loadid_id"]=>
     string(2) "12"
     ["grade1"]=>
     string(2) "80"
     ["grade2"]=>
     string(2) "79"
     ["grade3"]=>
     string(1) "0"
     ["grade4"]=>
     string(1) "0"
     ["average"]=>
     string(5) "39.75"
   }
   [1]=>
   object(stdClass)#32 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(18) "Araling Panlipunan"
     ["loadid_id"]=>
     string(1) "9"
     ["grade1"]=>
     string(2) "90"
     ["grade2"]=>
     string(2) "85"
     ["grade3"]=>
     string(2) "75"
     ["grade4"]=>
     string(2) "95"
     ["average"]=>
     string(5) "86.25"
   }
   [2]=>
   object(stdClass)#33 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(40) "Music, Arts, Physical Education, Health "
     ["loadid_id"]=>
     string(2) "11"
     ["grade1"]=>
     string(2) "81"
     ["grade2"]=>
     string(2) "83"
     ["grade3"]=>
     string(2) "89"
     ["grade4"]=>
     string(2) "90"
     ["average"]=>
     string(5) "85.75"
   }
   [3]=>
   object(stdClass)#34 (9) {
     ["student"]=>
     string(2) "17"
     ["section"]=>
     string(8) "Hinam-is"
     ["subject"]=>
     string(21) "Philippine Literature"
     ["loadid_id"]=>
     string(1) "8"
     ["grade1"]=>
     string(2) "88"
     ["grade2"]=>
     string(1) "0"
     ["grade3"]=>
     string(1) "0"
     ["grade4"]=>
     string(1) "0"
     ["average"]=>
     string(2) "22"
   }
 }
}

[/color]

Help....

I try this Please check the below code:

Code:
$test =Array( "0" => Array
(
    "0" => (Object)
        [
            "PRO_PRICE_CODE" => "AAA001001",
            "PRO_MST_NM" => "Promo Air Asia",
            "PRO_AMT_CUST" => "65000.00"
       ],

     "1" => (Object)
        [
            "PRO_PRICE_CODE" => "AAAnghngng001001",
            "PRO_MST_NM" => "Asia Airlines",
            "PRO_AMT_CUST" => "55000.00"
        ]
)

);

foreach ($test as $key => $value) {
    echo $value["0"]->PRO_PRICE_CODE;   
}

[Image: lightbulb.gif] it somehow works...nice but do i need to always code..
Code:
<?php foreach ($data as $key => $value): ?>
  <?php echo "Sakto ".$value[0]->loadid_id; ?>
  <?php echo "Sakto ".$value[0]->subject; ?>
  <?php echo "Sakto ".$value[1]->loadid_id; ?>
  <?php echo "Sakto ".$value[1]->subject; ?>
 <?php endforeach; ?>

do you have a code to loop these data?

check this!!!
Code:
foreach ($test as $key => $value) {
    foreach ($value as $key1 => $value1) {
        echo $value1->PRO_PRICE_CODE;   
    }

    
}
Reply




Theme © iAndrew 2016 - Forum software by © MyBB