Database Driven Navigation System

ghost

0 0

17 years ago

Right, due to the outcome of my last thread I am ditching the script from php-fusion and making my own Database Driven Navigation System … So … Config.php =

// database settings
$hostname=&quot;localhost&quot;;
$username=&quot;********&quot;;
$password=&quot;********&quot;;
$database=&quot;dotticms&quot;;
$con = mysql_connect($hostname, $username, $password)
 	or die(&quot;Unable to connect to MySQL&quot;);
mysql_select_db($database, $con);
?&gt;```

And Navigation.php =
```markup&lt;?php
include (&quot;extension.inc&quot;);	
include (&quot;config.&quot;.$php);
include (&quot;core.&quot;.$php);
(&quot;SELECT * FROM sitelinks WHERE pos&lt;=&#39;50&#39; ORDER BY pos&quot;);
?&gt;```

Hokay, I am new to using sql and php together ... So ... 

My database dotticms has a table called sitelinks ...
Site links contains 
id
name
link
pos
class

I just need to use name for the text to be displayed
I just need link to be the location when the name is clicked
I just need position their order and etc.
Any help please...
I want it like =

&lt;a href=$link class=$class&gt;$name&lt;/a&gt;

Ty 
Dotti

spyware

Banned

0 0

17 years ago

You must be fucking kidding right? RIGHT?!

Did you just cut off the code you didn't understand, and now you're asking us how to code your cms.

Somehow that doesn't seem right. Look kid, first go try to do it yourself, if you have any questions then, you can come back, post any errors (if any) and show you actually put some effort into this.

ghost

0 0

17 years ago

okay then … if you agree to stop having ago at me … This is what i have now ….

include (&quot;extension.inc&quot;);	
include (&quot;config.&quot;.$php);
include (&quot;core.&quot;.$php);
$query  = (&quot;SELECT * FROM sitelinks WHERE pos&lt;=&#39;50&#39; ORDER BY pos&quot;);

while(list($name,$link,$class) = $result)

echo (&quot;&lt;a href=&quot;.$result[&#39;link&#39;].&quot; class=&quot;.$result[&#39;class&#39;].&quot;&gt;&quot;.$result[&#39;name&#39;].&quot;&lt;/a&gt;&quot;);
?&gt;```

Wrote it myself ... From stuff i picked up from w3 schools and various other sites ...