Creating a URL from the ID.

[urbandog]

Hello.

I'm trying to use php as a template for my portfolio site. Currently, I am hardcoding links. What I would like to do instead is display a particular item (title, date, description, etc) have the viewer click the link of the title (the id) and bring up a new page with the items full description & pictures.

I would like all this information to be displayed within the template that I created. Without having to create a new html page every time. I rather have this done dynamically.

Here is my url: http://www.urbandog.net you can have a better understanding of what I'm trying to do. If you could also tell me the "term/naming" of what I'm trying to do that would be great as well. All advice is appreciated. Thank you.😃

[Kudose]

Here is a rough schematic of what you could do:

functions.inc.php

function contact(){
echo "Contact Information Here";
}

function resume(){
echo "Resume Here";
}

function home(){
echo "Default page here";
}

//I think you get the idea.  

//You can use any code just like you would normally
//as long as it is inside the brackets

index.php

include('functions.inc.php');
//header stuff here
echo "I'm a banner.  See me dance.";

//now for the important stuff
//all your links must be in this format below
//without the forward slashes

//<a href='index.php?page=function'>Click Me!</a>

//the link above tells me what info I am going to
//load in the dynamic page
//I will get the page now
$page = $_GET['page'];
if($page == "contact"){ contact(); }
elseif($page == "resume"){ resume(); }
else { home(); }

//footer here
echo "I am a footer.  I rock.";

Hope that gets you on a good start. 🙂

[urbandog]

That def. is a good start. Yet, that isn't exactly what I'm hoping for.

What I'd like to do is this. Have the main template. There is a middle section for the content (sides have the links). When I put a new item into my database, it has these fields (id, title, description, image).

On the mainpage you can view the title, and breif description. I'd like to have it set up, where you click on a link that bring up the template, and places into the content all the fields for the item. Picture/Description etc.... without having to make a page that states, item1.php or item2.php. How do I create the links for this, and the page?

Again, a document/article that you can point me to would be great. Thanxs in advance.

Marie

[tude-marie]

So what your saying is you have some sort of index page, where you link to a page that is supposed to show more detailed information?

What you want to do is in every link on the index page, include i the id of the "thing". fx.

http://www.mypage.com/details.php?produkt_id=123

When the user presses the link the produkt_id is sent with the user to the details.php page.

Here you can use something like this, supposing you are using a MySQL database.

$conn = mysql_connect(database_connection_info);

mysql_select_db("database_name", $conn);

// This selects the information from the database
$data = mysql_query("SELECT titel, description, image FROM table_name WHERE id = '".$_GET['product_id']."'");

// And throws it into an array
$rs = mysql_fetch_array($data);

// Now you just echo the different information from the array
echo "<strong>".$rs['titel']."</strong><br />";
echo $rs['description']."<br />";
echo "<img src=\"".$rs['image']."\" border=\"0\" />";

You might recognize some HTML in there, which is fine as long as it is kept in quotationmarks "" or ''.

I would suggest you use the same method to create an index with all the different products. Only difference is:

while($rs = mysql_fetch_array($data))
{
   // Now you just echo the different information from the array
   echo "<strong>".$rs['titel']."</strong><br />";
   echo $rs['description']."<br />";
   echo "<img src=\"".$rs['image']."\" border=\"0\" />";
}

And of course without the WHERE clause in the SQL query which only makes sure you output the right information, which is not needed when trying to list all the content of the table.

Hope this makes sence... 😉

[urbandog]

yes- that is def. more of what I'm looking for. Thank you.

Marie

[buzzby]

i have a problem and wondered of you could help. I am going loopy at the moment because of it.

I have a site that is dynamically created using templates, php/mysql. There are records that include pictures (well I need them to because each record/row contains a jpg. The jpg itself has to be a link to a larger jpg. )

Can you point me in the right direction: do I need to store the image in the database or the link in the database? How do I go about designing for whichever is chosen?

Any help you can give in this area will be most appreciated

[urbandog]

I personally link to the images. In your table, you have the id/description/date etc and a field which i call url (name however you'd like) which holds the url to the image desired. The url is contained in the database, which links to an image folder in your directory. You can put the image itself in the database, but that is a personal preferene.

[buzzby]

create table image_index (
id int not null auto_increment primary key,
url varchar(255),
);

insert into image_index values (1,'services_01.jpg');
insert into image_index values (2,'services_02.jpg');
insert into image_index values (3,'services_03.jpg');

this did nothing. it just displayed the text in a table