Hi there!
Could someone please explain how image libraries work It’s my opinion the images are connected to a database, a free of charge search on that database is finished via a search form which pulls the images up. Is this best done with Entry or MYSQL I’d like to create something fairly simple however am struggling a little with exactly how it really is done.
Thanks
Brian SOME SORT OF.
My organization is not sure just what exactly you mean by means of image library.
However how i describe it looks like you mean which the image filenames are stored within a database table.
And these are then extracted and utilized to generate < img> rule.
What you will have to do is
1: create a database along with a table. That table really should have a field for that image filename, plus an id area. Also maybe a field for 2 row was included, of type timestamp.
In which case you would need a technology for example PHP or ASP in order to extract the values from your database table, and output the end result.
Thanks for the! Sorry for your confusion – I am talking about an on-line share image library where the interested party can enter a keyword and yes it comes up using the images requested eg enter London and all the images of London created.
Will it be best to generate the table throughout MYSQL or Admittance
If you wish to do a free search to the database – and had fields labelled ID, type, country, location, description including a field for this image – what you place into the " query" to look on these fields but just show the image
Bless you & Regds
We would say MySQL.
And in such a situation, you tend to be searching a column, both the description, or even the image filename.
The description is better.
Do you know any server aspect languages
You will have to create a HTML form that blows the description they are seeking, get that benefit (set a changing to it) along with your query would possibly be something like
select img_filename coming from table where outline LIKE '%what-they-entered%'
That which means if what they entered is in the description column that filename could well be extracted.
Until we find out what language you want to use we cannot really help further.
I can create a type in Dreamweaver as well as I guess PHP will be the companion to MYSQL.
Where you type ‘%what-they-entered%’ – usually what you actually set up the query this kind of that if state Ireland was typed into your form the ‘%what-they-entered%’ would certainly understand that
select img_filename from table – possibly the table it is fair to be defined such as IMAGE DATABASE
Regds
It’s much more likely that searches are built against metadata instead of the actual filename. One example is, each image can be a user-defined number of keywords and the optimization matches against that.
If Let me use Photoshop CS – the right way to I attach keywords towards thumbnail or could it be done via the second database
You would have a field for any image filename and also a field full associated with keywords.
Your current PHP code would look something like
< php
if($_POST'submit')
// connect to db here
$search = $_POST'search';
$query = "SELECT * FROM table_name WHERE description = '%$search%'";
$result = mysql_query($query) or die("error in select - " . mysql_error();
Assuming your column names in addition to table names complement.
Thanks! Feel the light can be gradually beginning in order to dawn…
Just went straight into photoshop and found that commencing " file info" means that you can attach keywords for you to an image – now I guess if the search works for the database field when the path to that image is stored and you search on that field it’ll pick up your keywords and display the image.
Don’t confuse Photoshop’s keywords when using the ones you have to store in this database. The keywords throughout Photoshop are stored directly while in the image, and thus difficult to get into (and slow). Keywords stored in a very database, on another hand, are stored while in the database and are searched very very quickly. They’re separate, and you won’t be associating keywords within the database through Photoshop; you’ll have to complete it some some other way.
BTW, when you’ve got an uploading script, or even upload the pics yourself, you should know that there are various data accompanying any camera photo.
You may extract that facts through some ‘EXIF’ manipulations with your script. The info contains generic data just like " date, solution, camera type, universal image name, data compresion, thumbnail, etc".
However, this is not directly based on your question.
If you ever however, wanted your graphics beeing searchable through other types of figures, there are many meta-data hidden around any digital photography.
(a thumbnail would in fact be considered relevant for almost any DB storage)
Thanks Rosland – unfortunately My organization is a traditionalist plus am scanning transparencies inside – h