[RESOLVED] Dynamic Array

[rr1024]

Hello and thanks for reading my post.

I want to pass an array from one function to another however the trick I guess is the array needs to be evaluated or something?

This other function is a wysiwyg editor and I can hard code predefined links that work in it's popup for fast website links.

If I hard code in this function the following

$editor->set_links(array(
    array('0', '/demos.htm', 'Demos'),
    array('0', '/features.htm', 'Features'),
    array('0', '/index.asp', 'Home'),
    array('0', '/Orders/OrderPage.asp', 'Order'),
    array('0', '/requirements.htm', 'Requirements'),
    array('0', '/support/index.htm', 'Support'),
    array('1', '/support/LanguageDL.asp', 'Language Files'),
    array('1', '/support/manuals.php', 'Manuals'),
    array('1', '/xForum/default.asp?Group=5', 'Support Forum'),
    array('1', '/support/updates.php', 'Updates'),
));

The editor pop up shows all the links just fine so I though wow if I can do this maybe I can make it dynamic so I created a seperate function

FUNCTION linkArray ( $word )
{
                  $select = '* ';
                  $where = "`word_title` LIKE '" . sqlesc($word) . "%' ";
                  $order = "`word_title` ASC ";
                  $q = "SELECT $select FROM `sw_dictionary_words` WHERE $where ORDER BY $order ";


    $res = db_res( $q );

    WHILE ( $row = mysql_fetch_assoc( $res ) ) {
         $Word = str_replace(' ', '_', htmlesc($row['word_title'] ) );


       $MyLinkArra .= array('0', "{$Word}.html", "{$row['word_title']}");
       $MyLinkArra .= ",";

    }
    RETURN array($MyLinkArra);
}

Now what I want to do is pass the return value to the editor like this

$editor->set_links( linkArray ( $word ) );

But of course this doesn't seem to work, can anyone see what I'm doing wrong or is this not possible

[Roger_Ramjet]

Well, your linkarray function looks a bit wierd to me - do print_r on the return and I'm sure you'll not see what you expect.

FUNCTION linkArray ( $word )
{
                  $select = '* ';
                  $where = "`word_title` LIKE '" . sqlesc($word) . "%' ";
                  $order = "`word_title` ASC ";
                  $q = "SELECT $select FROM `sw_dictionary_words` WHERE $where ORDER BY $order ";


    $res = db_res( $q );
     $MyLinkArra = array();

    WHILE ( $row = mysql_fetch_assoc( $res ) ) {
         $Word = str_replace(' ', '_', htmlesc($row['word_title'] ) );

         $MyLinkArra[] = array('0', "{$Word}.html", "{$row['word_title']}");

    }
    RETURN $MyLinkArra;
} 

Try that and print_r the return.

[rr1024]

Hello thanks but unfortunately that didn't seem to work but your comment and proposed solution did lead me to something that may work but I'm not sure and won't be able to try it until I get home this evening.

I think maybe if I do something like

FUNCTION wysiwygLinkArray ( $word )
{
      $select = '* ';
      $where = "`word_title` LIKE '" . sqlesc($word) . "%' ";
      $order = "`word_title` ASC ";
      $q = "SELECT $select FROM `sw_dictionary_words` WHERE $where ORDER BY $order ";

    $res = db_res( $q );

    WHILE ( $row = mysql_fetch_assoc( $res ) ) {
         $WordLink = str_replace(' ', '_', htmlesc($row['word_title'] ) ).".html";
         array_push($MyLinkArra, array(0, $WordLink, $row['word_title']) );
    }

    RETURN array($MyLinkArra);
}

I believe it may generate the need array to look like

array(
    array('0', '/demos.htm', 'Demos'),
    array('0', '/features.htm', 'Features'),
    array('0', '/index.asp', 'Home'),
    array('0', '/Orders/OrderPage.asp', 'Order'),
    array('0', '/requirements.htm', 'Requirements'),
    array('0', '/support/index.htm', 'Support'),
    array('1', '/support/LanguageDL.asp', 'Language Files'),
    array('1', '/support/manuals.php', 'Manuals'),
    array('1', '/xForum/default.asp?Group=5', 'Support Forum'),
    array('1', '/support/updates.php', 'Updates'),
)

With your methode I ended up with Array in the displayed links section however you solution may have lead me in the right direction ...??? Thank you very much

[rr1024]

Forgot to come back and finish my post, the code above didn't work because I had pushed the array and then return array

Thanks for all the help guys! 🙂 🙂 🙂 🙂 🙂
Here is working code

FUNCTION wysiwygLinkArray ( $word )
{
      $select = '* ';
      $where = "`word_title` LIKE '" . sqlesc($word) . "%' ";
      $order = "`word_title` ASC ";
      $q = "SELECT $select FROM `sw_dictionary_words` WHERE $where ORDER BY $order ";

    $res = db_res( $q );

    WHILE ( $row = mysql_fetch_assoc( $res ) ) {
         $WordLink = str_replace(' ', '_', htmlesc($row['word_title'] ) ).".html";
         array_push(MyLinkArray, array(0, $WordLink, $row['word_title']) );
    }

    RETURN $MyLinkArray;
}