Skip to main content

How to make has many function in expression engine


Step 1: Make an array


$rel=array();

$rel['exp_incoming_product']['id']='order_id';

$rel['exp_incoming_product']['level']=1;

Notes: 1) Here exp_incoming_product is table name from which you want to make
2) order_id id foreign key of table.

$data=$this->hasMany('exp_incoming_order',$rel,$member_id,'member_id');

Notes: 1)  Here exp_incoming_order is table 
hasMany function

function hasMany($t1,$tables,$id,$t1_id_name)
{
ee()->db->select('*');
ee()->db->from($t1);
ee()->db->order_by('id','desc');
ee()->db->where($t1_id_name,$id);
$query1 = ee()->db->get();
$data=array();
foreach($query1->result_array() as $key_1=>$result) 
{
foreach($result as $key=>$value1) 
{
$data[$key_1][$t1][$key]=$value1;
}
}
foreach($data as $single=>$part) {
foreach($tables as $table=>$value2) {
ee()->db->select('*');
ee()->db->from($table);
ee()->db->where($value2['id'],$part[$t1]['id']);
$query2 = ee()->db->get();
foreach($query2->result_array() as $key2=>$result2) 
{
foreach($result2 as $key3=>$value3) 
{
$data[$single][$table][$key2][$key3]=$value3;
}
}
}
}
return $data; 
} 


Comments

Popular posts from this blog

Generate XML file in Cakephp

Steps to Generate XML file using CakePHP: Step-1 Enable to parse xml extension in config route.php file.     Router::parseExtensions('xml'); Step-2 Add Request Handler Component to the Controller    var $components = array(‘RequestHandler’); Step-3 Add controller Action For XML Generation in Post Controller     function generateXMLFile()     {         if ($this->RequestHandler->isXml()) { // check request type             $this->layout = 'empty'; // create an empty layout in app/views/layouts/empty.ctp              }        }  Add header code in empty layout <?php header('Content-type: text/xml');?> <?php echo $this->Xml->header(); ?> <?php echo $content_for_layout; ?> Step-4 Set up View To generate XML Create xml folder inside Posts vi...

How To Create Shortcodes In WordPress

We can create own shortcode by using its predified hooks add_shortcode( 'hello-world', 'techsudhir_hello_world_shortcode' ); 1. Write the Shortcode Function Write a function with a unique name, which will execute the code you’d like the shortcode to trigger: function techsudhir_hello_world_shortcode() {    return 'Hello world!'; } Example: [hello-world] If we were to use this function normally, it would return Hello world! as a string 2. Shortcode function with parameters function techsudhir_hello_world_shortcode( $atts ) {    $a = shortcode_atts( array(       'name' => 'world'    ), $atts );    return 'Hello ' . $a['name'] . !'; } Example: [hello-world name="Sudhir"] You can also call shortcode function in PHP using do_shortcode function Example: do_shortcode('[hello-world]');

How to replace plain URLs with links

Here we will explain how to replace Urls with links from string Using PHP $string ='Rajiv Uttamchandani is an astrophysicist, human rights activist, and entrepreneur. Academy, a nonprofit organization dedicated to providing a robust technology-centered education program for refugee and displaced youth around the world.  CNN Interview - https://www.youtube.com/watch?v=EtTwGke6Jtg   CNN Interview - https://www.youtube.com/watch?v=g7pRTAppsCc&feature=youtu.be'; $string = preg_replace('@(https?://([-\w\.]+)+(:\d+)?(/([\w/_\.%-=#]*(\?\S+)?)?)?)@', '<a href="$1">$1</a>', $string); Using Javascript <script> function linkify(inputText) {     var replacedText, replacePattern1, replacePattern2, replacePattern3;     //URLs starting with http://, https://, or ftp://     replacePattern1 = /(\b(https?|ftp):\/\/[-A-Z0-9+&@#\/%?=~_|!:,.;]*[-A-Z0-9+&@#\/%=~_|])/gim;     replacedText = inputT...