Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 21-11-2008
Member
 
Join Date: Oct 2008
Posts: 27
Tag system with mysql and php

I have tagged a nice little site for myself and my friends, where I can upload some pictures, and then they can see them when they are logged.
But I would like to "tag" them. Like the face book. My question is now how this is done smartest. The whole page is coded in php and mysql.
I've messed around with two ideas in their heads. One saves you who are at each image in each frame. But I think will make the search on the tags a bit cumbersome.
The second idea save by users of the album and pictures they have on.
I would also like to make it such that when all members album is displayed as shown in a small box below, who are involved in the album (like this must be subtracted from the roof-system).
I worked properly with two databases. One of the photos are broken down by album, and one which uses the info.
It really does not itself coding I must have help with, but more how it's smartest to put up.

Hope you can help.
Reply With Quote
  #2  
Old 21-11-2008
Member
 
Join Date: May 2008
Posts: 2,008
Re: Tag system with mysql and php

Hmmm, I would make a many to many relationship.

So like this

[Image table] -> [Ref to the tags] <- [Tags to Table]

So it is just about how to set up code tags, and put them in the picture
Reply With Quote
  #3  
Old 21-11-2008
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: Tag system with mysql and php

Select tag from tags where imageid = <imageid>

Something in the style, is a few years since I last messed with php
Reply With Quote
  #4  
Old 21-11-2008
Member
 
Join Date: Apr 2008
Posts: 1,948
Re: Tag system with mysql and php

Quote:
Originally Posted by MindSpace View Post
Select tag from tags where imageid = <imageid>

Something in the style, is a few years since I last messed with php
There is not much of the php there.

As Katty says it is a many-to-many relationship you need time in. I will recommend to read this page:
How to handle a Many-to-Many relationship with PHP and MySQL

[Image table]
-> Billed_id
-> Billed_url

[Tags]
-> Tag_id
-> Billede_id
-> Person_id
-> Y_num
-> X_num

[Profiles]
-> Profil_id
-> Profil_tekst

(... Look only now the date of issue.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Tag system with mysql and php"
Thread Thread Starter Forum Replies Last Post
Unable to install MySQL and MySQL Workbench on Linux mint 10 Zared Windows Software 4 13-01-2011 01:08 AM
mysql config file in MySQL Netorious Software Development 4 18-03-2010 09:43 PM
Can I use MySQL API for C++? Rob Dizzle Software Development 5 23-01-2010 07:58 PM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM
MySQL with PHP Gyan Guru Guides & Tutorials 2 18-11-2008 04:53 PM


All times are GMT +5.5. The time now is 07:11 PM.