Should i use Mysql and php with phpmyadmin?

[birtles]

Hi. Im a total noob. I Have no clue about php or mysql. I know a little HTML but thats it.

I have a project in mind, that could help my familys buisness, and i was wondering if php and sql is the way to go or not?

I have heard lots of good things about php, and i would infact like to learn it, but i am also a little crunched on time. So would it be better to buy some readymade software?

 

The plan is this; We run two magazines, they both contain a lot of images, and graphic elements (backgrounds/ icons/ andsoforth) usually in raw and tiff.

Over time the amount of images get harder to organize and remember what is where.  (And raw can not be previewed, makes it even harder to organise)

I would like to set up a database on our private server where metadata from the files can be searched, (most likely through an xml) and thumbnails can be previewed.

Metadata should also be able to be changed from the browser. This system would have to work both on Mac's and PC's.

This is one of the reasons I believe the php-sql way is the best way to go, as ready made software seldom does both mac's OS and windows.

Se my thought workplan-graph. Its in german, but hope you get the gist of it.

 

But am I mistaken? Is there something i should know before i sit down and learn php?

 

[attachment deleted by admin]

[kickstart]

Hi

 

Php is designed for systems based on a server (OK there are client php frameworks), as as such you could access them from any computer that can have a web connection to that server.

 

You should be able to extract meta data from normal images (although RAW images might well be a problem), store that on a database and search it, and also store the images (although images are large and storing full size ones might well result in you using a massive amount of storage).

 

All the best

 

Keith

[manwhoeatsrats]

I highly recommend mysql and php.  Phpmyadmin is a great utility.  I use it quite a bit.  if you are willing to spend a bit of money though for your SQL I like "SQL Maestro for MYSQL" it is roughly 200 bucks.  though there are numerous other free programs out there that will do the same thing.

if you are wanting a simple install of mysql, php, and phpmyadmin.  try googling Xammpp

[birtles]

Thanks for the replies. My server (qnap) comes with preinstalled php5 mysql and phpmyadmin, so that is what i would use to get the job done. My plan was to create thumbnails of all images, and give them same metadata as their "bit brothers." Then create 2 folders on my server, one for big images and one for small. The metadata between theese folders would be syncronised on command. The database would then only deal with tiny images. You mention that there is software that allready does theese kinds of things? Do you have any names?