[Resolved] Internal linking

cybertrip

Ok here is the deal i have a page that im making for a online gaming clan. i got it to display the main page how i want it to, but i need it to link to another place inside the same page that will display the rest of the info in a table here is my code for displaying it....

<html>
<body>
<body bgcolor="#696969">
<font color="#ffffff">
<?php
$conn=odbc_connect('members','',''); 
if (!$conn)
{
exit("Connection Failed: " . $conn); 
} 
$sql="SELECT * FROM members"; 
$rs=odbc_exec($conn,$sql); 
if (!$rs)
{ 
exit("Error in SQL");
} 
echo "<table><tr>";
echo "<th><u>Handle</u></th></tr>";

while (odbc_fetch_row($rs))
{
$handle=odbc_result($rs,"Handle");
$name=odbc_result($rs,"FName");
$age=odbc_result($rs,"Age");
$local=odbc_result($rs,"Location");
$maps=odbc_result($rs,"Fav Maps");
$id=odbc_result($rs,"ID");
$guns=odbc_result($rs,"Fav Guns");
echo "<tr><td><a href='detailpage.php?id=$id'>$handle</a></td></tr>";

}
odbc_close($conn);
echo "</table>";
?>
</body>
</html>

Drakla

Do you mean something like a HTML named anchor that will just let you jump down / up the page to the table when you click on a link?

If I'm not messing up what you're saying then above the table put something like

Above the table, then a link elsewhere like

<a href="#infotable">go to info table</a>

cybertrip

no thats not what i ment i can do that, i mean like ok i have the page when i open that code up that i have it displays a Table Header called Handles then underthat a bunch of names and thats all thats on the page i want it to have a link from those names and go to a new page displaying all that one persons info like you always see using the .php?id= type thing in the url

Drakla

Yeah, thought that seemed too simple as you look like you know what you're doing.

Well you have the line that prints their handles with the id linked, do you want to display the detailed info under the main link table, or above it or something?

If so it's just a case of checking if id is set in the $_GET array, then creating a SELECT query based on that.

if (isset($_GET['id']))
{
    $id = (int)$_GET['id'];
    show_detail_table($id);
}

...

function show_detail_table($id)
{
    $q = 'SELECT * FROM details WHERE id = '. $id;

   blahh blahhh
}

Or have I missed the point again?

cybertrip

i want it to open like if it was a completly new page... i know exactly how to do it in asp but i dont know how in php. like u click the name and it open a page that will have the one users info as if it where a whole new page, but all done with in one file

bradgrafelman

So yeah, just like Drakla said.

You have a page.... "info.php", and when they initially open it, they have an option for searching for a user, jumping to a user by name/id, etc. They are redirected either via POST or GET (as in Drakla's method) to "info.php?uid=3235" and your script runs the query, gets the info for uid# 3235, etc. etc.

cybertrip

i guess im just not understanding how to put that into my code.

Drakla

Okey doke, let's knock up a rough version - we'll say for the sake of it that that the main table you've produced is in a function called show_members()

When you click on one of the links then the variable $GET['id'] will be defined in the script - when you first get to the script that won't be in the url, so $GET['id'] will be undefined, you check for that with [MAN]isset[/MAN], or if it's set but you don't want to allow zero then you can also use [MAN]empty[/MAN]

So your basic framework for the script becomes

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Today is: Generic Title Day</title>
</head>

<body>
<?php
if (isset($_GET['id']))
{
	$id = (int)$_GET['id']);

show_user_detail($id);

	// create a link to this page without ?id=xxx to show the members again

echo '<a href="', $_SERVER['SCRIPT_NAME'], '">Show Users</a>';
}
else
{
		// show links to the member guff
	show_members();
}
?>
</body>
</html>

cybertrip

i still cant get this to work, im a complete noob at php i am good with asp but my host doesnt use it i got it to display the members names with the links but i cant get it to open the details.

Drakla

You aren't running some really ancient install of PHP before $GET and $POST are you?

Put phpinfo(); in a script and see what version it springs.

It might also be time for you to go DAFT

cybertrip

im running version 5.0.4, and i have tried tuts but i cant find one that works for me.

thorpe

it is EXACTLY the same as doing it in asp. you pass the required id via the querystring in your link to your details page. then retrieve that id ($_GET['id']), then use that id in your query.

cybertrip

not asp vbscript which is a whole lot different becuase i can get it to work in vbscript but my host only supports one or the other and i need php for my forums so i need this to work in php

bradgrafelman

Post your code here.

cybertrip

<?php
$conn=odbc_connect('members','',''); 
if (!$conn)
{
exit("Connection Failed: " . $conn); 
} 
$sql="SELECT * FROM members"; 
$rs=odbc_exec($conn,$sql); 
if (!$rs)
{ 
exit("Error in SQL");
} 
echo "<table><tr>";
echo "<th><u>Handle</u></th></tr>";

while (odbc_fetch_row($rs))
{
$handle=odbc_result($rs,"Handle");
$name=odbc_result($rs,"FName");
$age=odbc_result($rs,"Age");
$local=odbc_result($rs,"Location");
$maps=odbc_result($rs,"Fav Maps");
$id=odbc_result($rs,"ID");
$guns=odbc_result($rs,"Fav Guns");
echo "<tr><td><a href='members.php?id=$id'>$handle</a></td></tr>";

}
odbc_close($conn);
echo "</table>";
?>

bradgrafelman

Is that all of it? Didn't you try implementing the code suggested by Drakla, me, etc.?

<?php 
if (isset($_GET['id'])) 
{ 
    $id = (int)$_GET['id']); 

show_user_detail($id);  // define this function / replace with your functions

    // create a link to this page without ?id=xxx to show the members again 

echo '<a href="', $_SERVER['SCRIPT_NAME'], '">Show Users</a>'; 
} 
else 
{ 
        // your sql statements here
} 
?>

Replace the show_user_detail with your own functions/whatever.

cybertrip

i tried but i had no clue where to put it and what to replace so i removed it as i need it to be able to display still. and im complete noob to this this is my first php page ever.

bradgrafelman

So copy your script to a test script, and start messing with it, posting links for us to see, etc. etc.

The above code is a great place to start, however, as it's pretty much all you need, with the exception of the user-specific MySQL queries/format, which I'm assuming/hoping you've already taken care of, seeing as how I have no clue what the steup of your MySQL table looks like and how you want it formatted, etc.

bretticus

I can translate ASP to PHP 😃. Post your ASP code.

bradgrafelman

<%
Response.Write "I need a better scripting language"
%>

==>

<?PHP

phpinfo();

?>