Question about the php?category_id=

[Tomcat13]

OK I'm doing this:

div class='nav_cat' onMouseOver='open_nav_child(48);' onMouseOut='close_nav_child(48);'>
<a href='index.php?category_id=48'>Area Rugs</a>
</div>
<div class='nav_sect' id='nav_cat_48_child'>
<a href='index.php?category_id=48&section_id=794'>Large</a><br>
<a href='Runners.php?category_id=48&section_id=796'>Runners</a><br>
<a href='index.php?category_id=48&section_id=795'>Small</a><br>
</div>
It works ok but

My question is,
How do I make my link (child) Pages, to connect? In other words, what whould be the title of my link page in order to correspond to "?category_id=48'"?, or category_id=48&section_id=794'" etc., so when you click on that link would get you to the link page...

Thank you in advance

[rincewind456]

The title of your link page is entirely up to you, your hyperlinks point to index.php, except for runners, which I think may be a mistake.

In index.php you process the information coming from the $GET variables that you have passed with the hyperlink, I would do something like this

<?
if (isset($_GET['category_id'])) {


switch ($_GET['category_id']){
	case 48:

	if (isset($_GET['section_id'])) {

		switch ($_GET['section_id']){
			case 794:
			echo 794;
			break;
			case 795:
			echo 795;
			break;
			case 796:
			echo 796;
			break;
			default:
			echo "no choice";
		} //section_id switch
		break;
	} //section_id IF
	case 49:
	// you can add as many category ids as you want in the same format as above

	default:
	echo "no choice";
}//cat_id switch
}
?>

to send me to where ever I wanted to go by I would use the [man]header/man function in place of the echoes in the code.

[Tomcat13]

Thanks for your reply partner, but I'm kinda lost here...

Where does the above code go? In which page?

I 'm doing articles and I want each one of them to have their own id.

Do I add my own id number for those article pages?
or, are the id numbers auto-generated?

How does that work?

Can you give me a simple example, with one "id" link from, say, the index page to the article page, with the "id" number or code or whatever it takes...

Thanks again

[Tomcat13]

I am using this code:

<!--
<div class='nav_cat' onMouseOver='open_nav_child(48);' onMouseOut='close_nav_child(48);'> -->
<a href='index.php?category_id=48'>photos</a>
</div>
<div class='nav_sect' id='nav_cat_48_child'>
<a href='index.php?category_id=48&section_id=799'>799</a><br>
<a href='index.php?category_id=48&section_id=800'>800</a><br>
<a href='index.php?category_id=48&section_id=801'>801</a><br>
</div>

The above show the same page.
Here are the actual links and the outcome when you click on the links: You see tha same page, even though the id is different.

Here are the links:
http://www.greencyberfans.com/documents/index.php?category_id=48
http://www.greencyberfans.com/documents/index.php?category_id=48&section_id=799
http://www.greencyberfans.com/documents/index.php?category_id=48&section_id=800
http://www.greencyberfans.com/documents/index.php?category_id=48&section_id=801

Below, you'll see the difference. Same category, "cat", different "id", they show a different page. The way it's suppose to be.

http://www.greengate.gr/cat/new.php?NewID=529
http://www.greengate.gr/cat/new.php?NewID=530
http://www.greengate.gr/cat/new.php?NewID=531

How do I do that?
What is the code for the above, so a same category and a different id show a different page like above?

I would really appreciate your help

[Tomcat13]

Is this "id" a MySQL thing, with news articles, that nobody knows about? 😕

[bpat1434]

yes, the id is a "mySQL thing". It represents the row ID which mySQL gave it.

You're asking a question that can be summed up like this: you want to pass article ID information to a page using links. you've got the links down. now you need to go and grab the info from the $_GET array, and run a query on the database to pull the information and display it accordingly.

There are plenty of tutorials on this (including on this site). I suggest you google it.

[Tomcat13]

I googled it with not much success.

However you said it all partner!..

A couple of links would really help me if someone can provide them. Don't forget I am kinda new to this, and I would need a simple and detailed tutorial about this "id" thing.
I think I am almost there. I just need to "click" and put it all together.

thank you in advance

[bpat1434]

the id references the mySQL row id (which you need to set up)....
You create a query based upon the input id (or a default if none given)....
You display the results from the query....

CREATE TABLE example(
  `id`  INT(11) NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(32) NOT NULL,
  `age`  INT(11) NOT NULL
) ENGINE=MYISAM

A link like:
domain.com/index.php?id=42

would run a query like:

SELECT * FROM example WHERE id='42'

Then you'd run that query in PHP, and loop through the results accordingly.

[Tomcat13]

OK, now what I need to do, is create a couple of articles and put them in the database, cause right now there is no tables with articles to retrieve.
I have the code to retrieve stuff.
But I need to create the text tables

I've tried to create a table with text in MySQL but I was getting errors.

So I need to make a couple of articles (tables) with title, date, some text, and id and upload them to the database.
Or create them in the MySQL.

Can you help? I think that would do it.

Please be specific if you can

Thanks so much

[bpat1434]

CREATE TABLE articles(
  `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  `title` VARCHAR(100) NOT NULL ,
  `date` INT(11) NOT NULL ,
  `body` LONGTEXT NOT NULL
) ENGINE=MYISAM;

Something like that.....
Notes:
-- The date column would be a UNIX timestamp either created by mySQL using UNIX_TIMESTAMP(NOW()) or in php.
-- The id field will automatically generate your ids
-- The INSERT statement would not have the id field accounted for (so that mySQL auto increments it, and there aren't duplicates)

[Tomcat13]

Go to this url:
http://www.greencyberfans.com/about2/newdoc.php

Click on the links, you'll see that I get a different ID number with each one of them. In other words, I'm pulling out the "title" and the "id" out of the db. Fine. Looks like I'm on the right track here, or am I?

The thing is that the links are not pulling any articles out of the database, apparently because there are no articles to retrieve.
I did tables the way you told me, but I don't know how to insert the articles, or the text or the HTML into the tables, so I can have articles to retrieve along with the ID numbers.
How do I do that?

Thanks again

p.s: It 's most likely very simple, but when you don't know how to do it, it's hard.
To anybody that can help me to go ahead with this I 'll be grateful.

[bpat1434]

in the body column put the stuff you want to display... then when you click a link, run this:

<?php
$query = sprintf("SELECT body FROM articles WHERE id='%d' LIMIT 1",
                   mysql_real_escape_string($_GET['id'])
                );
$result = mysql_query($query);

$body = mysql_result($result, 0, 'body');

echo $body;
?>

Easy as pie....

[Tomcat13]

bpat1434 wrote:

in the body column put the stuff you want to display... then when you click a link, run this:

<?php
$query = sprintf("SELECT body FROM articles WHERE id='%d' LIMIT 1",
                   mysql_real_escape_string($_GET['id'])
                );
$result = mysql_query($query);

$body = mysql_result($result, 0, 'body');

echo $body;
?>

Easy as pie....

Easy as pie...? For you maybe! 🙂
Before I couldn't get anything out of the db, now I get two pages at a time!! He..he..

http://www.greencyberfans.com/about2/newdoc.php
scroll down and you'll see..
Check the links on the top left hand corner of the page., "cars' and "trucks". The id changes when you click on them.
I made a table with two rows, that I put the text in, two different pages, and now both show on the same page!!! 😕

BTW, I think I've got the first part..

How do you "run" the above script? 😕

thanks for you time n' effort to help me.

Tom

[bpat1434]

umm.. the two pages thing is your own problem: it's a hard-coded thing. Notice how it never changes after following links?

How do you "run" the above script?

Put it on your webserver, call the page, make sure ?id=## is in the url. You're good to go.

How do you add it to your site, well that's for you to figure out. Of course, it's the same way any PHP goes into a website.

Perhaps a short "PHP for Beginners" book is for you 😉

[Tomcat13]

I have a table with three rows (three different articles).
The problem is the code I use, pulls out all three rows at the same time.
So, instead of having three different pages, I have one page with the three articles all in one page!!!
In the URL, if I change, "articles" to "title", I get the three titles all in one page!!
What is wrong here? I want the pages, (or the titles) to show individually.

Here is the code I use:

<?php 

// Connect to the database and select which database we want to use first. 

$db = mysql_connect("server", "username", "password") or die(mysql_error()); 
mysql_select_db("dbname", $db) or die(mysql_error()); 

// Now we're going to make a query to the database to retrieve all the information we need. 

$get = mysql_query("SELECT * FROM tbl_name") or die(mysql_error()); 

// Now we're going to create a loop that will display all the articles for you to choose from. 
while($row = mysql_fetch_array($get)) 
{ 
    // Declare your variables in here 
    $id = $row['ID']; 
    $title = $row['title']; 
    $date = $row['date'];
    $article = $row['article']; 

echo("<a href='http://www.yoursite.com/articles.php?articleid=$id'>$title</a>"); 
} 

if($_GET['articleid'] == $id) 
{ 
     echo("<b>$title</b><br />"); 
     echo($article); 
} 
?>  

[bpat1434]

Well, nothing's wrong. But I think what you want is to have a sort of "index" of articles, and then links to read them. Then if they're reading it, don't show the index? If that's true, do this:

<?php 

// Connect to the database and select which database we want to use first. 

$db = mysql_connect("server", "username", "password") or die(mysql_error()); 
mysql_select_db("dbname", $db) or die(mysql_error()); 

if(!isset($_GET['articleid']) || empty($_GET['articleid']))
{ 

  $get = mysql_query("SELECT * FROM tbl_name") or die(mysql_error()); 

  while($row = mysql_fetch_array($get)) 
  { 
      // Declare your variables in here 
      $id = $row['ID']; 
      $title = $row['title']; 
      $date = $row['date'];
      $article = $row['article']; 

  echo("<a href='http://www.yoursite.com/articles.php?articleid=$id'>$title</a>"); 
  } 
}
else
{
  $get = mysql_query("SELECT * FROM tbl_name WHERE ID='".$_GET['articleid']."' LIMIT 1");

  $info = mysql_fetch_array($get);

  // Display a link to the article index :)
  echo '<a href="'.$_SERVER['PHP_SELF'].'">Back to Article Index</a><hr>';

  echo("<b>$info['title']</b><br />"); 
  echo $info['article']; 
}  

?>  

[Tomcat13]

bpat1434,

<?php 

// Connect to the database and select which database we want to use first. 

 $db = mysql_connect("server", "username", "password") or die(mysql_error());  

mysql_select_db("dbname", $db) or die(mysql_error());

if(!isset($_GET['articleid']) || empty($_GET['articleid'])) 
{ 

  $get = mysql_query("SELECT * FROM tbl_name") or die(mysql_error()); 

  while($row = mysql_fetch_array($get)) 
  { 
      // Declare your variables in here 
      $id = $row['ID']; 
      $title = $row['title']; 
      $date = $row['date']; 
      $article = $row['article']; 

  echo("<a href='http://mydomain.com./about2/news.php?articleid=3'>$title</a><br>");


  } 
} 
else 
{ 
  $get = mysql_query("SELECT * FROM article_news WHERE ID='".$_GET['articleid']."' LIMIT 1"); 

  $info = mysql_fetch_array($get); 

  // Display a link to the article index :) 
   echo '<a href="'.$_SERVER['PHP_SELF'].'">Back to Article Index</a><hr>';

  echo $info['article']; 

}   

?> 

The only thing I've changed in your code,
I ommited the,
echo("<b>$info['title']</b><br />");
in the line before last, in the code that you gave me, 'cause it was giving me a parse error.

Well, it's starting to work partially.

Now, check this out:
http://www.greencyberfans.com./about2/news.php

As you'll see here we have three different links.
Actually there are three different rows (articles) in the table in the db, with different id's: "3" for "roots" "6" for "history" and "9" for "photos".
These are the id numbers in the db.
BTW, the "back to Articles" link, works right. It takes you back to the link page.

When you click on "roots", you get the correct response.
When you click on "history" and "photos" not only you don't get the correct articles which in this case would be "history"(6) and "photos"(9), but you get the same article: "roots", on all three links.
You also get the same "id", which in this case is "3", for all three links or articles ('cause that's what they are, articles or rows on the table in the db).
This is what I can't figure out. How to get these links to retrieve the correct articles. SE-PE-RA-TE-LY AND WITH THE CORRECT ID.
What do I have to do to achieve that?
If you wanna help, please be specific.

One more thing I've changed in your code besides, server username and ps,
is the id number on the echo. I put number "3":
echo("<a href='http://mydomain.com./about2/news.php?articleid=3'>$title</a><br>");

Thank you in advance, partner!

[bpat1434]

DOH!!
You have the id hard-coded into the link!!!

echo("<a href='http://mydomain.com./about2/news.php?articleid=3'>$title</a><br>");

Change it to this:

echo("<a href='http://mydomain.com./about2/news.php?articleid=$id'>$title</a><br>");

[Tomcat13]

bpat1434 wrote:

DOH!!
You have the id hard-coded into the link!!!

echo("<a href='http://mydomain.com./about2/news.php?articleid=3'>$title</a><br>");

Change it to this:

echo("<a href='http://mydomain.com./about2/news.php?articleid=$id'>$title</a><br>");

It's getting better all the time!
Now I get the right pages and the right id numbers when I enter the URL in the address bar:

http://www.greencyberfans.com./about2/news.php?articleid=3
http://www.greencyberfans.com./about2/news.php?articleid=6
http://www.greencyberfans.com./about2/news.php?articleid=9

And that's GREAT! I'm so EXCITED!!!

When you click on "back to articles Index" from any of those pages it takes you to,
http://www.greencyberfans.com./about2/news.php

There you've got the three links:

roots
history
photos

When you click on those it just gives me a URL with no page or id.

http://www.greencyberfans.com./about2/news.php?articleid=

How do u work around that?

Thanks partner!!
Almost there!!!!