how do page?id=var's work

immanuelx2

i have a news page, that shows the title of the news and when they click the title, it will show the whole news..

How would i go about doing that (my news are orginized by ID). So basically viewnews.php?id=1 etc...

cassius

Maybe a read-up on "pagination" can give yo some hints, although this is usually more usefull when coding a forum or a message board...

check out this forum's faq:
http://www.phpbuilder.com/board/showthread.php?s=&threadid=10234923

immanuelx2

i see that they use it in a Next \ Previous way but all i want to do is have like index.php have a bunch of news links that go to viewnews.php?id=$id-of-the-selected-news

how is that possible... please show me some php examples that would be gooooood

cassius

I used this code on a message forum(which acts pretty much like a news-forum):
This is the readmsgs.php-file:

/This could be used as a link to your news-articles(from your header or whatever you desire/
<?php
//a link to your file could look like this:
<a href='readmsgs.php?id=$id_of_the_selected_news>$your_link_text</a>

You would have to make this fit your script/html-code to make it work of course.

You could use '$PHP_SELF?id=$id_of_the_selected_news' in stead of using 'your_file_name.php?id=$id_of_the_selected_news' -but my experience is that the most secure way is to use the accurate filename(in your case, I guess that would be viewnews.php?id=blablabla).

if your news-articles have an unique title, I would consider to use this as my ID, as it will ease the work to pass your article-id to your link...

Another solution is to make a function that receives the article-ID and returns the contents of that article(maybe the easiest and cleanest way to do it).

Hope this could help you. If not, I guess I need to se some more code to understand your case.

cassius

immanuelx2

Am i doing this right...

<html>
<head>
<?php include("css_style.php") ?>
</head>
<body>
<basefont face=verdana size=1>
<?php include("admin_header.php") ?>

<center>
<table cellpadding="15" border="0">
<td bgcolor="#000000">
<table cellpadding="5" border="1" bordercolor="#C1B19A" style="border-collapse: collapse">
<td bgcolor="#847969">
<font face=verdana size=1>
<?php

if (isset($id)) {
 mysql_connect("localhost", "user", "pass");

 $query = mysql_query("SELECT * FROM finaldawn.fd_news WHERE id = '$id'");

 echo 'Edit here...';
}
else {

 mysql_connect("localhost", "user", "pass");

 $query = mysql_query("SELECT * FROM finaldawn.fd_news ORDER BY id DESC");
 while ($row = mysql_fetch_array($query)) {
 echo '[<a href="' . $PHP_SELF . '?id=' . $row['ID'] . '">edit</a>] [<a href="remove_news.php?id=' . $row['ID'] . '">remove</a>] ' . $row['ID'] . ' <b><font color=#00FF00>' . $row['Date'] . '</font> ' . $row['Title'] . '</b><br>';

}

?>
</font>
</td>
</table>
</td>
</table>
</center>

</body>
</html>

When i view the page it says:
Parse error: parse error, unexpected $ in /usr/local/psa/home/vhosts/finaldawn.orphus.com/httpdocs/admin/edit_news.php on line 44

cassius

try changing your last "echo"-line with this code::

echo "[<a href='".$PHP_SELF."?id=".$row['username']."'> edit </a>] [<a href='remove_news.php?id=".$row['ID']."'> remove </a>] ".$row['ID']."<b><font color=#00FF00>". $row['Date']."</font> ".$row['Title']."</b><br>";

It seems like you like to jump in and out of sql/html/php with '.' ? ...I'm used to "." and this works fine with me:

//in php:

echo "<br><b><font color='000099'>Testing</font></b>".$mysql_fetch_array-result['tablefield_name']."";

Try the line(the first) I submitted. Don't know if it will work, but at least it works out with my (very) simple test...

cassius

immanuelx2

🙁

i still get the same error msg

cassius

i believe you actually missed out a bit on you {}'s .....

you end your "while"-loop, but not your "else-case", therefor you get a "parse error"

Try to put one more

before the

?>

- tag.

I tried a bigger test now, and I got the same error message as you did.

Then i checked the bracelets({}) against each other and found out that you missed one at the end....

hope this solves the problem(so far)...I just didn't think about checking that at first....if you use Textpad you can use ctrl+m while standing at one bracelet to find the corresponding bracelet.

cassius

immanuelx2

ty that did it 😃

cassius

Good to hear that it worked out for you. I would still consider to use this format when you "echo" html combined with php-variables:

echo "<b>This is html</b>".$php-variable."<font color='red'>Back in html-echo";

What i mean is that i suggest you use "." to jump in/out of php(i saw you did otherwise in your script when first submitted to this thread).

cassius

laserlight

Doesnt make much of a difference if the output is small and the parsed variables are few.

If you do plan to do that, then it would make more sense to use single quotes instead of double quotes, otherwise some ppl may assume you plan to get the variables parsed within the double quotes.