[RESOLVED] How to make a $_GET index

visualed

Hi guy's.

i have a index.php page. and inside i have a list from a DB.

Every link specified an article

so how can i do like ex.

www.mysite.com/index.php >
www.mysite.com/article.php?id=2
www.mysite.com/article.php?id=3
www.mysite.com/article.php?id=4
www.mysite.com/article.php?id=5
etc...

how does this issue calls in PHP ?

TNX! 🙂

bradgrafelman

I don't quite understand your question... are you trying to generate links to articles from your index.php based on a DB query?

tron00

If someone clicks on lets say www.mysite.com/article.php?id=2 then on the article.php page, you use $_GET['id'].

so in this instance on the article.php page:

echo $_GET['id'];

would print the value 2

foyer

Indeed it would

visualed

tron00;10897744 wrote:
If someone clicks on lets say www.mysite.com/article.php?id=2 then on the article.php page, you use $_GET['id'].

so in this instance on the article.php page:
echo $_GET['id'];
would print the value 2

i still didnt get what to do in index.php

and how to recive the $_GET to article.php page (with the ID of the article) :[

Weedpacket

We're not psychic. We don't know anything about your database. But at a guess you have a table that has a column that has article IDs in it. So you'd query for those IDs, and put them in the links. Which bit are you having trouble with?

visualed

ill say it again from the beginning.

i have a DB. in the DB i have id.
i showing the ID's in the index.php page.
when someone click on ID i want to send him to article.php page.
when he gets to the article.php page he will see the article.

its very simple, everyone is using it..i just dont know how they call it..

laserlight

Right. So you have listed out the steps:

i showing the ID's in the index.php page.
when someone click on ID i want to send him to article.php page.
when he gets to the article.php page he will see the article.

The middle step is more of a user action, so we can ignore that. Now, which of the other two steps are you having problems with, and what exactly is the problem?

visualed

i dont have any problem.

i just dont know how to do that.

djjjozsi

i call it details page:

<?php

if ( !empty( $_GET["id"] ) ) {
/* if you set an article variable*/

			include_once( "connect.php" );
/* Lets select from the articles table that article where the id is $_GET["id"]  */
				$sql = "SELECT * FROM articles WHERE id=" . (int)$_GET["id"];
				$result = mysql_query( $sql );
				if ( mysql_num_rows( $result ) > 0 ) {

							$rows = mysql_fetch_assoc( $result );
/* These field names just for example!  */
								print "Article_Category:" .  $rows["Article_Category"]  . "<br>\r";
								print "article_title:" . $rows["article_title"]  . "<br>\r";
								print "Article_body:" .  $rows["Article_body"]  . "<br>\r";
				}else
								print "No article found";  /* You did not find that article*/
}

?>

laserlight

visualed wrote:
i dont have any problem.

i just dont know how to do that.

Oh, so the problem is that you are at a complete loss as to how to get started 🙂

You need to give us more information on what you already know. For example, do you know how to retrieve the IDs from the database? Do you have any idea how to get the data submitted from a form? (E.g., did tron00's post make any sense to you?)

visualed

laserlight;10897917 wrote:
Oh, so the problem is that you are at a complete loss as to how to get started 🙂

You need to give us more information on what you already know. For example, do you know how to retrieve the IDs from the database? Do you have any idea how to get the data submitted from a form? (E.g., did tron00's post make any sense to you?)

i know the basic. i know how to INSERT and get info from a DB.
i just donk know how to do ex:

<a href="articles.php?id=" .$bla. "></a>";

how does this system works. ive search in Google and find nothing
because i dont know how its named. 😕

laserlight

visualed wrote:
how does this system works.

Read the PHP manual concerning Variables From External Sources and PHP and HTML.

coldwerturkey

so in index.php you want an output of

http://yoursite.com/articles.php?id=1
http://yoursite.com/articles.php?id=2
...etc
http://yoursite.com/articles.php?id=34

if so, it would look something like this:

$query = "SELECT id FROM articles ORDER BY id ASC";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
	echo "<a href='articles.php?id=".$row['id']."'>http://yoursite.com/articles.php?id=".$row['id']."</a><br />\n";
}

from there you have to use something like djjjozsi showed to display the article in articles.php

visualed

I got it

thanks to you all!!!