main.php?id=123456734522134534...

spstieng

I'm a bit confused.
When viewing a lot of PHP sites, I see a typical URL like: http://www.pcbutikken.com/showitems2.asp?id=1&kategori=1942&dept_type=1&dept_id=8512

OK, so this is ASP, but the same goes for PHP. When calling other pages, they are called by numbers instead of logical names like memmory, motherboards etc.

Why do programers use number IDs instead of logical names?😕

kevinsequeira

so when the url is main.php?id=1 the id value is captured and corresponding name is got

reg
kevin

bad76

Hi,
the biggest number are ID SESSION self-generated from php when a session start.

If in the URL is present this number the php know this user as already logged, and reopen the same session. Else you can redirect the user to login page.

It's just one mode to use session. May be usefull for much other thing...

see you

spstieng

I don't think it has anything to do with sessions.

kevinsequeira is on to something.
I'm gonna develop a hierarchical menustructure for computer components (e-commerse). This menu will be created dynamically with calls to a DB.
A script then retrieves relevant inforamtion (from D😎, writes it to a file.

A javascript will be showing and hiding menues.
A working example can be found here: http://www.psdata.no/

Yes, I've allready ripped the javacode - but I still need a system for the component tree.
How can I make it logical. Let's try (so I can udnerstand).

1|HDD 
	1|IDE
		1|5400rpm
		2|7200rpm
	2|SCSI
	3|SATA
2|processor
	1|Socket 370
		1|Celeron
		2|Pentium
	2|Socket 478
	3|Socket A
3|memory
4|motherboards

Now, If I click HDD, the id=1. If I click IDE, the id=11 and if I click 7200rpm the id=112?
Am I on to something?

How would I know what data to fetch from the DB though? I have to de-siffer what 112 means. Do I hardcode the structure somewhere? Or can this be done dynamically?
How would I create my DB for this? One table for HDD, one for CPU and so on? So the table for HDD would maybe look like:

001 | 1 | 1 | 1 | ->(5400rpm IDE HDD)
001 | 1 | 1 | 2 |
001 | 1 | 2 | 1 |
001 | 1 | 2 | 2 | ->(socket 370, celeron CPU)

But what if there is no level three?

It's late and I'm just a bit confused on how to create a LOGICAL database - whuch may require PHP calls like main.php?id=121.

kevinsequeira

u do something like this

ID|PARENT_ID|NAME
1|0|HDD
2|1|IDE
3|1|SCSI
4|1|SATA
5|2|5200RPM
6|2|7200RPM
7|0|PROCESSOR
8|7|SOCKET370
9|7|SOCKET478
10|7|SOCKETA
11|8|CELERON
12|8|PENTIUM
.
.
.
.

then once u have an id,
1. check it its parentid=0, if it is then its the base,
2. then check for ids, whose parentids are the id to get the next level in the tree and so on
reg
kevin