What is the best way to do this web page updater
rock
area to update the products,text and images on the pages.
The products are initially in an Excel file on a XP desktop so we need
option to upload from that as well as change categories, products,images
online through browser and Admin area.
The db is small with only a few fields.
Site is on Linux 5.3 with mySQL 5.0.89
My preference is some code which can be inserted in areas of these pages
however I realise most will go the way of a dynamic page.
Anyone have any thoughts on the best way to do this?
I will not be doing it as my php skills aren't up to it, however I will
seek a coder from RAC etc., so it is within budget.
Thanks
rock
Jerry Stuckle
Normally admin pages should be separate from the rest of the site. It's
more secure and easier to do it that way than to have to keep testing
for admin privileges several times on a page.
And one caution - when you go for a cheap price, you typically get a
cheap result. I've made some good money from straightening up code
written by cheap programmers - more than if they had just done it right
in the first place.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstu...@attglobal.net
==================
J.O. Aho
> I have a static html website framework for which I need to add an Admin
> area to update the products,text and images on the pages.
>
> The products are initially in an Excel file on a XP desktop so we need
> option to upload from that as well as change categories, products,images
> online through browser and Admin area.
There are classes for handling excel, but as microsoft is famous to change how
their document "standards" works, I do recommend you use something more
standardised document format, csv should be quite okey.
It's important that the data is verified before stored in the database, this
will save you from sql injections and wrongly formatted in-data.
I agree with Jerry on a separated admin section, but the check should be more
than see if you have a session to see if the user is logged into the admin
section (one day you may want to have different user profiles with different
privileges).
> The db is small with only a few fields.
> Site is on Linux 5.3 with mySQL 5.0.89
Just a bit off topic, there is no Linux 5.3, latest stable Linux is 2.6.34.1.
The 5.3 is the version of the distribution of GNU/Linux you are using and
those you should use the name of the distribution, for example "RedHat
Enterprise Linux 5.3" or "CentOS 5.3".
--
//Aho
Geoff Berrow
<jstu...@attglobal.net> wrote:
>> I will not be doing it as my php skills aren't up to it, however I will
>> seek a coder from RAC etc., so it is within budget.
...
>
>And one caution - when you go for a cheap price, you typically get a
>cheap result. I've made some good money from straightening up code
>written by cheap programmers - more than if they had just done it right
>in the first place.
What's RAC?
--
Geoff Berrow (Put thecat out to email)
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs www.4theweb.co.uk/rfdmaker
Geoff Berrow
>I have a static html website framework for which I need to add an Admin
>area to update the products,text and images on the pages.
>
>The products are initially in an Excel file on a XP desktop so we need
>option to upload from that as well as change categories, products,images
>online through browser and Admin area.
That's fine as long as the online changes do not affect the Excel/CSV
file or you'll need to consider how to keep them in sync
>
>The db is small with only a few fields.
The db needs to be designed to do what you want it to do. This is
crucial.
>
>
>My preference is some code which can be inserted in areas of these pages
>however I realise most will go the way of a dynamic page.
Not sure what you mean here. With PHP it's easy to insert code into
your HTML so that the page becomes a template.
Jerry Stuckle
> On Tue, 20 Jul 2010 23:28:35 -0400, Jerry Stuckle
> <jstu...@attglobal.net> wrote:
>
>>> I will not be doing it as my php skills aren't up to it, however I will
>>> seek a coder from RAC etc., so it is within budget.
> ...
>> And one caution - when you go for a cheap price, you typically get a
>> cheap result. I've made some good money from straightening up code
>> written by cheap programmers - more than if they had just done it right
>> in the first place.
>
>
> What's RAC?
Rent-A-Coder - a good place to get poor code done cheaply.
Allodoxaphobia
>
> And one caution - when you go for a cheap price, you typically get a
> cheap result. I've made some good money from straightening up code
> written by cheap programmers - more than if they had just done it right
> in the first place.
<snicker>
I made a good living there for a while, cleaning up
the "cheap results" rolled out for the Y2K Hysteria.
Jonesy
--
Marvin L Jones | jonz | W3DHJ | linux
38.24N 104.55W | @ config.com | Jonesy | OS/2
* Killfiling google & XXXXbanter.com: jonz.net/ng.htm
rock
> On Wed, 21 Jul 2010 11:48:56 +1000, rock<19...@pobox.com> wrote:
>
>> I have a static html website framework for which I need to add an Admin
>> area to update the products,text and images on the pages.
>>
>> The products are initially in an Excel file on a XP desktop so we need
>> option to upload from that as well as change categories, products,images
>> online through browser and Admin area.
>
> That's fine as long as the online changes do not affect the Excel/CSV
> file or you'll need to consider how to keep them in sync
>>
>> The db is small with only a few fields.
>
> The db needs to be designed to do what you want it to do. This is
> crucial.
>>
>>
>> My preference is some code which can be inserted in areas of these pages
>> however I realise most will go the way of a dynamic page.
>
> Not sure what you mean here. With PHP it's easy to insert code into
> your HTML so that the page becomes a template.
Thank you all for your input.
Oops...I meant php 5.3 not Linux
I agree with all that was said and as far as RAC is concerned I have had
some bad experiences however I must say I have had many more good ones
over the years.
I must also say that more expensive does not mean better, same as
cheaper does not always mean okay. As I said I have been burnt on both ends.
I am quite amazed I have not come across some standard script/program
where one can change db fields etc through an admin and which generates
code for inclusion into the html page. Maybe it is there but haven't
seen it in my very extensive searching.
Thanks again guys your time is appreciated.
rock
Geoff Berrow
>I am quite amazed I have not come across some standard script/program
>where one can change db fields etc through an admin and which generates
>code for inclusion into the html page. Maybe it is there but haven't
>seen it in my very extensive searching.
It's called a content management system (CMS) and there are lots of
them. However the problem is that most will be more complicated than
you need.
Most would use some kind of templating system but there is no reason
why a system such as you suggest could not be created using simple
includes or echoed variables from a database query at the top of the
page.