Database - CPanel

Thread Solved

Join Date: Jul 2006
Posts: 790
Reputation: pritaeas is on a distinguished road 
Solved Threads: 128
Sponsor
pritaeas's Avatar
pritaeas pritaeas is offline Offline
Master Poster

Re: Database - CPanel

 
0
  #21
Jul 7th, 2009
As far as i can tell wowhead has one large item list on a single page, where at the top they jump down to a specific part (http://ptr.wowhead.com/?new-items=3.2). Everything here is already loaded from the start. Is this what you mean. The links jumping down is controlled by in-page links (e.g. href='mypage.php#bookmark')

Just to show you what one php page can do, have a look at one of my sites, just to get an idea. I know you can't read the contents, but everything is controlled by one php page. www.onderwaterwereld.org
Last edited by pritaeas; Jul 7th, 2009 at 5:57 pm.
"If it is NOT source, it is NOT software."
-- NASA
Reply With Quote Quick reply to this message  
Join Date: Jun 2009
Posts: 34
Reputation: Spunky is an unknown quantity at this point 
Solved Threads: 0
Spunky Spunky is offline Offline
Light Poster

Re: Database - CPanel

 
0
  #22
Jul 10th, 2009
Yea I guess that is what I need to do too then. Have all the content loaded and controlled by one php page and only have what is clicked on to be shown. That's probably some difficult php coding though lol. But that's alright, I'll just need to learn. This is exactly what I am talking about with learning hands on.

But actually. The link you pasted for wowhead isn't what I am talking about. That page in particular yes is using anchor points, which you will find here: http://www.wowtah.com/transportation.html that I am incorporation this as well, having links jump down to another part of the page.

An example I am talking about on wowhead is this: say you click on one of those items on the page you linked to. How is the page it brings you to created? Surly the developer didn't create an individual page for every item; yet, on that page when you click the item is its info as well as its own unique quick facts about it off to the right hand side. All data from a database put into a page that I am not sure is created..thats what I want to know. Where did this page come from? And even when someone does a search with filters; how is the data changed on one page?

This is all stuff I need to learn and understand. First I want to understand the concept, then I want to learn the php it takes to do it. Will you help me?
Last edited by Spunky; Jul 10th, 2009 at 3:33 pm.
Reply With Quote Quick reply to this message  
Join Date: Jul 2006
Posts: 790
Reputation: pritaeas is on a distinguished road 
Solved Threads: 128
Sponsor
pritaeas's Avatar
pritaeas pritaeas is offline Offline
Master Poster

Re: Database - CPanel

 
0
  #23
Jul 10th, 2009
I can help you with php, but as far as i can tell, the hover information and some other stuff is javascript. I don't know much about that, as I always try to avoid using it.

The detail page in the middle will probably a template page, which can be easily filled with database info. I use smarty for that, it could be useful to look into. (smarty.net)
"If it is NOT source, it is NOT software."
-- NASA
Reply With Quote Quick reply to this message  
Join Date: Jun 2009
Posts: 34
Reputation: Spunky is an unknown quantity at this point 
Solved Threads: 0
Spunky Spunky is offline Offline
Light Poster

Re: Database - CPanel

 
0
  #24
Jul 12th, 2009
Well. Ill need to know what I am trying to accomplish before I know what to learn in php. As for the hover info, yea thats javascript, I can figure out how to do that easy. Learning javascript as well and have more knowledge in it.

As for the detail in the middle. I know how to make a template page. My entire website is created with a template. The top header and navigation as well as the bottom info is all the same on each page due to a template I created. But, how do I get the info in the middle to change depending on what is selected/what the user is searching for? That I don't understand.
Reply With Quote Quick reply to this message  
Join Date: Jul 2006
Posts: 790
Reputation: pritaeas is on a distinguished road 
Solved Threads: 128
Sponsor
pritaeas's Avatar
pritaeas pritaeas is offline Offline
Master Poster

Re: Database - CPanel

 
0
  #25
Jul 13th, 2009
Most common method would be to use mypage?id=X on an item click. The page will use id to retrieve the data from the database and display it in your template. If you have spread your data over multiple tables/categories than you can just extend this, e.g. mypage.php?category=goblin&id=324 You can retrieve the id by using $_GET['id']
"If it is NOT source, it is NOT software."
-- NASA
Reply With Quote Quick reply to this message  
Join Date: Jun 2009
Posts: 34
Reputation: Spunky is an unknown quantity at this point 
Solved Threads: 0
Spunky Spunky is offline Offline
Light Poster

Re: Database - CPanel

 
0
  #26
Jul 14th, 2009
Ok because I don't expect you to give me a full lesson on how to do this I went to w3schools.com to look for help and I found:This but it seems to be directed more towards frames. And yes, my data is spread over multiple tables.

Im finding it difficult to find anything of use to me to learn this. Then, both with PHP and Javascript I find it difficult to learn because like, you learn the functions but what makes you smart in using it is HOW you use what you learn. Gives me a headache. That's why what I know in Javascript is what I've used on my site derived from tutorials for doing what it is I want to accomplish..I suppose in time I will know a lot...

Ok, do you think you could point me in the right direction to learning what I need to know? Not just a tutorial website but the actual useful tutorial on it or something, or you could help me yourself that'd be useful too lol.
Last edited by Spunky; Jul 14th, 2009 at 1:09 am.
Reply With Quote Quick reply to this message  
Join Date: Jul 2006
Posts: 790
Reputation: pritaeas is on a distinguished road 
Solved Threads: 128
Sponsor
pritaeas's Avatar
pritaeas pritaeas is offline Offline
Master Poster

Re: Database - CPanel

 
0
  #27
Jul 14th, 2009
I have just written code for someone, that implements an account administration panel. It has a search tab, a detail view, a notes tab and a mass e-mail tab. The detail tab is a template which gets filled with data from the database. I could modify this to give you an idea. I'll strip out the notes and email, and change the database a bit.
"If it is NOT source, it is NOT software."
-- NASA
Reply With Quote Quick reply to this message  
Join Date: Jul 2006
Posts: 790
Reputation: pritaeas is on a distinguished road 
Solved Threads: 128
Sponsor
pritaeas's Avatar
pritaeas pritaeas is offline Offline
Master Poster

Re: Database - CPanel

 
0
  #28
Jul 14th, 2009
Last edited by pritaeas; Jul 14th, 2009 at 5:30 pm.
"If it is NOT source, it is NOT software."
-- NASA
Reply With Quote Quick reply to this message  
Join Date: Jun 2009
Posts: 34
Reputation: Spunky is an unknown quantity at this point 
Solved Threads: 0
Spunky Spunky is offline Offline
Light Poster

Re: Database - CPanel

 
0
  #29
Jul 14th, 2009
Omg thank you so much, you are ever so helpful. When I get a chance to take a look at this I will get back to you for any additional questions. =)
Reply With Quote Quick reply to this message  
Join Date: Jun 2009
Posts: 34
Reputation: Spunky is an unknown quantity at this point 
Solved Threads: 0
Spunky Spunky is offline Offline
Light Poster

Re: Database - CPanel

 
0
  #30
Jul 29th, 2009
Alright I know it's been like two weeks since my last response but things have been pretty busy for me. I've got work and then school is starting for me soon, bf coming home from Afghanistan soon, friend just moved up from Texas.......anyways..

Ok, well, I've tried to take a look at what you made. Um, but I could get the php to work using my host, I just wanted to be able to view it and how it works cuz that is the best way to learn how the code that I can see works, you know? Unfortunately I couldn't get it working and I am not sure why.

What are the .tpl files and what is that code written in? I am guessing the index.php calls those .tpl files to function certain things, I just wish I could see how. Hands on you know? Otherwise all this confusing code doesn't really help.

Ah well, Im sure in time I will learn all I need to know to do this kind of stuff.
Reply With Quote Quick reply to this message  
Reply

This thread has been marked solved.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC