Posted by leader on 02/01/07 06:52

On Wed, 31 Jan 2007 17:13:39 -0800, "Angelic Kodaijin"
<odinzed@gmx.co.uk> wrote:

>
><bob.chatman@gmail.com> wrote in message
>news:1170276282.993482.197340@j27g2000cwj.googlegroups.com...
>> On Jan 31, 5:17 am, "Angelic Kodaijin" <odin...@gmx.co.uk> wrote:
>>> Ok here is what I'm trying to find out and do.
>>>
>>> I'm working on this website and we are converting it from HTML to PHP.
>>> With
>>> that we are using MySQL to be able to automatically incorporate new media
>>> content into the website.
>>>
>>> Here is the problem.
>>>
>>> There are over 70k items that need an entry into a table(s) for the URL
>>> of
>>> the content (for example an image). My question is: Are there any
>>> programs
>>> out there that will simplify the process of adding this data into a table
>>> or
>>> data base with out having to hand enter tens of thousands lines of
>>> code/queries? or perhaps some kind of php sample code that will help with
>>> this?
>>
>> if you could get me some more detailed information about what it is
>> you are actually trying to do i could probably help you, but from
>> your description there really doesn't look to be anything that can be
>> suggested.
>>
>> Bob
>>
>
>OK not a problem. Basically I'm trying to build a dynamic site that will
>allow for easy incorporation of new images or data. It's an art web site,
>don't think I mentioned it before. Anyway, what people are doing right now
>are just uploading images to the ftp server on their own little space and
>then using that (when they sign up) to make a HTML page that allows them to
>have a bio page and all the art they have done and put it up for sell. Over
>the last few months there have been soooooo many hacks to the site because
>of the ftp and the freedom I've allowed with making their own pages. Now I'm
>getting people putting advertisements up and its bogging down the server and
>eating up my bandwidth like a moth @%#@&. So in light of that happening, I'm
>redesigning the site from the group up.
>
>But as I said, there are a lot of images that need to be entered into the
>data base. What I'm aiming for is to be able, and I know its passable, is to
>have PHP and MySQL to have people upload their images and input information
>about it and link it to their page/bio/artist info, what ever, so when a
>person goes to that page or pages the new content will be automatically
>displayed to the user with out the need to continually make new HTML, and
>provide additional security. The way I thought I could do this was to have a
>table or tables that will have all the info about a set (witch right now is
>in their own folder), and an entry for that set/image that will be pulled up
>by PHP when I query the database array to have the URL to pull up the new or
>old images.
>
>Right now I have a good system in the works, but there is a lot of old
>images that need to be imputed into the database. I'm trying to find out if
>there will be a way to do this with out having to hand enter all these
>entries, being there are about 70,000 that would need to be entered.
>
>Is there any more info you need?
>

What you are describing is what is done by a CMS, a Content Management
System. You might be able to tweak one of the existing ones (stick
CMS +free
into any search engine) but sometimes these try to be all things to
all men and can fall down between all sorts of stools, I've read that
some of them can be less than simple to configure, and for some
purposes they can be *too* powerful. It could be you would be better
suited by having a smaller set of scripts written especially for you.
e-mail me and I'll see what I can contribute.
As for importing your existing data easily, whatever system you use,
such data must be in a regular, set format. Once you have that,
importing it is a one-step procedure.

[Remove _your_clothes_ to reply.]

[Back to original message]