DaniWeb Forum Index > Web Development > PHP

need help with an array

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Mar 2009

Posts: 42

Reputation: sassenach is an unknown quantity at this point

Solved Threads: 0

sassenach

Offline

Light Poster

need help with an array

Jun 30th, 2009

I am using wysiwygPro editor and i want to be able to display the menu titles coming from the database.

This is an example layout:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$editor->links = array(
    array('title'=>'Home', 'URL'=>'/'),
    array('title'=>'About Us','URL'=>'/about/', 'children'=>array(
        array('title'=>'Company History','URL'=>'/about/history.php'),
        array('title'=>'Franchise Information','URL'=>'/about/franchise.php'),
        array('title'=>'Shareholders Information','URL'=>'/about/shareholders.php'),
    )),
    array('title'=>'Services', 'URL'=>'/services/'),
    array('title'=>'Contact Us', 'URL'=>'/contact/'),
);
$editor->links = array(
    array('title'=>'Home', 'URL'=>'/'),
    array('title'=>'About Us','URL'=>'/about/', 'children'=>array(
        array('title'=>'Company History','URL'=>'/about/history.php'),
        array('title'=>'Franchise Information','URL'=>'/about/franchise.php'),
        array('title'=>'Shareholders Information','URL'=>'/about/shareholders.php'),
    )),
    array('title'=>'Services', 'URL'=>'/services/'),
    array('title'=>'Contact Us', 'URL'=>'/contact/'),
);

So this is my SELECT query with the array. But i cant seem to get it right.

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$menuQ = mysql_query("SELECT menu_id, title FROM menu ORDER BY menu_id ASC") or trigger_error("Query: $menuQ\n<br />MySQL Error: " .mysql_error());				
if(mysql_num_rows($menuQ) > 0){
    echo 'array(';
    while ($menuR = mysql_fetch_array($menuQ, MYSQL_ASSOC)) {
            //echo $menuR['title'].'<br/>';
            $mylinks[] = array('title'=>''.$menuR['title'].'', 'URL'=>'/?mid='.$menuR['menu_id'].'');            
    }
    echo ');';
    $editor->links = array($mylinks);    
}
$menuQ = mysql_query("SELECT menu_id, title FROM menu ORDER BY menu_id ASC") or trigger_error("Query: $menuQ\n<br />MySQL Error: " .mysql_error());				
if(mysql_num_rows($menuQ) > 0){
    echo 'array(';
    while ($menuR = mysql_fetch_array($menuQ, MYSQL_ASSOC)) {
            //echo $menuR['title'].'<br/>';
            $mylinks[] = array('title'=>''.$menuR['title'].'', 'URL'=>'/?mid='.$menuR['menu_id'].'');            
    }
    echo ');';
    $editor->links = array($mylinks);    
}

can anyone correct me please?

thanks

•

Join Date: Jun 2009

Posts: 219

Reputation: ayesha789 is an unknown quantity at this point

Solved Threads: 3

ayesha789

Offline

Posting Whiz in Training

Re: need help with an array

-2

Jun 30th, 2009

Please search in tutorialized.com

Ayesha

•

Join Date: Feb 2008

Posts: 90

Reputation: jino is an unknown quantity at this point

Solved Threads: 6

jino

Offline

Junior Poster in Training

Re: need help with an array

-1

Jun 30th, 2009

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$result		= mysql_query($sql);//execute query
if(mysql_num_rows($result)>0)
{
	$i=0;
	while($row=mysql_fetch_object($res))
	{	
		$data[$i]['table_id']	= $row->table_id;
		$data[$i]['title']		= $row->table_title;
		$mylinks				= $data[$i]['title'];
		$i++;
 
	}
}
$result		= mysql_query($sql);//execute query
if(mysql_num_rows($result)>0)
{
	$i=0;
	while($row=mysql_fetch_object($res))
	{	
		$data[$i]['table_id']	= $row->table_id;
		$data[$i]['title']		= $row->table_title;
		$mylinks				= $data[$i]['title'];
		$i++;
		
	}
}

Now $mylinks is an array having the values titles.
Hope this will do the work.

Last edited by peter_budo; Jul 1st, 2009 at 1:03 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

We only have to do a very few things right in our life, so long as we don't do too many things wrong.

•

Join Date: Jun 2007

Posts: 1,227

Reputation: kkeith29 has a spectacular aura about

Solved Threads: 167

kkeith29

Offline

Nearly a Posting Virtuoso

Re: need help with an array

Jun 30th, 2009

What is your database layout like?

How are you handling the children? Do you have any logic in place for those.

•

Join Date: Mar 2009

Posts: 42

Reputation: sassenach is an unknown quantity at this point

Solved Threads: 0

sassenach

Offline

Light Poster

Re: need help with an array

Jul 1st, 2009

ok so i got it to work. this works:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$menuQ = mysql_query("SELECT menu_id, title FROM menu ORDER BY menu_id ASC") or trigger_error("Query: $menuQ\n<br />MySQL Error: " .mysql_error());               
if(mysql_num_rows($menuQ) > 0){
    while ($menuR = mysql_fetch_array($menuQ, MYSQL_ASSOC)) {
        $mylinks[] = array('title'=>''.$menuR['title'].'', 'URL'=>'/index.php?mid='.$menuR['menu_id'].'');           
    }
    $editor->links = $mylinks;
}
$menuQ = mysql_query("SELECT menu_id, title FROM menu ORDER BY menu_id ASC") or trigger_error("Query: $menuQ\n<br />MySQL Error: " .mysql_error());               
if(mysql_num_rows($menuQ) > 0){
    while ($menuR = mysql_fetch_array($menuQ, MYSQL_ASSOC)) {
        $mylinks[] = array('title'=>''.$menuR['title'].'', 'URL'=>'/index.php?mid='.$menuR['menu_id'].'');           
    }
    $editor->links = $mylinks;
}