Hi Guys

I know i am probably trying to invent a wheel ! However, the only way i can learn the language is to try and build something with it. What better way than to build my CMS whereby i can use it in future.

Already created my database and am tryin to build a dynamic me.

The menu should pick up the title and url of the file from my database.

The address of the url is showing fine and i am struggling to put the title in that url. Below is my code:

<?php
require('testconnection.php');
// Request to pick up the menu title
$sql="SELECT * from content";
$cmd=mysql_query($sql);
if (!$cmd) {
exit('<p>Error performing query' .
'at this time.</p>');
}
while ($row=mysql_fetch_array($cmd))
{
$menu=$row['menu'];
$filename=$row['filename'];
echo '<p>' . '<a href="'. $_SERVER['PHP_SELF'].
'?showmenu='. $filename. '">'.
'$menu </a></p>';
}
?>
And the result i get on the browser is this:
$menu
$menu
$menu
$menu
$menu
$menu
$menu
Pls enlighten. Will keep trying even while i posted this. Thanks a million.

Change:

PHP Code:

'$menu </a></p>'; 


to:

PHP Code:

"$menu </a></p>"; 


Php only parses variables in strings when using double quotes.

No, single quotes is correct because of the double quotes in the html echo, just move the variable outside the quote.

PHP Code:

echo '<p>' . '<a href="'. $_SERVER['PHP_SELF'] . '?showmenu='. $filename. '">' . $menu . '</a></p>'; 


EDIT: DOH! READ the whole string, techwench. Edit code above for variable. :P

Why don't you just use this... It would be much easier:

<?php 
$phpself = $_SERVER['PHP_SELF'];
require('testconnection.php'); 
// Request to pick up the menu title 
$sql="SELECT * FROM content"; 
$cmd=mysql_query($sql) or die('Error performing query: '.mysql_error());
 
while ($row=mysql_fetch_array($cmd)) 
{ 
extract($row);
echo "<p><a href=$phpself?showmenu=$filename\\$menu</a></p>"; 
} 
?>

That should do the trick... The extract() call basically turns all the variables in $row['varname'] and makes them just $varname - It saves a ton of typing.

Originally Posted by techwench

No, single quotes is correct because of the double quotes in the html echo, just move the variable outside the quote.

PHP Code:

echo '<p>' . '<a href="'. $_SERVER['PHP_SELF'] . '?showmenu='. $filename. '">' . $menu . '</a></p>'; 


EDIT: DOH! READ the whole string, techwench. Edit code above for variable. :P

Sure, but that doesn't mean you can't use double quotes and escape those inside the string, both ways are good.

Hi Guys

Tks for the help.

Implemented wht techwench taught and its working fine.

Am now trying to control the data. Its seems with my abv code, the main page is displaying all the article at one go without any control.

Will try to figure out myself and hopefully my answer is wht yu guys might provide. Seriously i am wondering if i shud re-invent the wheel agn since there are so many free cms in mkt!

Haha....