|
|
|
|
|
Home
| Forum
Archives | Past Discussion
How to enter content?
NOTE: You are currently
viewing an archived discussion from the Online Marketing
Today, website promotion forums. As such, you can no longer participate in
this discussion. If you would like to discuss similar issues, or any
issue related to website promotion & marketing in general,
then please feel free to visit the active
discussion forums & post a message in the most appropriate
forum.
|
|
|
|
|
Duncan Carver's
- Link Management Assistant - $197 Yours FREE! |
|
|
|
Put your website promotion,
marketing, & search engine positioning on autopilot
with my all new Link Management Assistant. The
"Link Management Assistant" totally automates
your reciprocal link partner management, allowing you to
focus entirely on securing more strategic link partners
to increase your websites link popularity & search
engine rankings...
|
|
Read
More & Download |
|
|
|
|
How to enter content? -- Posted by Trent L on 01-18-04 09:59
Hello everyone,
I'm planning the design for a personal blog website. I will write the
whole site by hand (see my post "Q about hand coding" for further
details if you're curious). I have a lot of the details planned out,
but there is something that I'm still fuzzy about:
How do I enter the content?
By content, I mean articles and blog entries. I don't want to hardcode
the articles into my HTML. Rather, I think my HTML files will look
something like:
I think a good way is to store each article/entry as a row in a mySQL
database. That's easy to say, but it's the details of actually *doing*
it that I'm confused about.
Chances are, the dbms will be on my webhost's machine. I don't want to
telnet in and do something like:
insert into table ARTICLES values ('Today's headlineGood
morning blah blah blah ', date, etc....)
My question boils down to this: if you have a site that frequently
updates with new content, how do you enter the content? What tools do
you use to connect to your webhost's SQL database over the web?
Any practical advice is welcomed. I'm getting close to the point where
the rubber hits the road, so sorry if this post was long-winded. Thanks!
Re: How to enter content? -- Posted by Bill Logan on 01-18-04 14:32
"Trent L" wrote in message
news:TPudnaPOd8nLApfdRVn-hQ@comcast.com...
> Hello everyone,
>
> I'm planning the design for a personal blog website. I will write the
> whole site by hand (see my post "Q about hand coding" for further
> details if you're curious). I have a lot of the details planned out,
> but there is something that I'm still fuzzy about:
>
> How do I enter the content?
>
> By content, I mean articles and blog entries. I don't want to hardcode
> the articles into my HTML. Rather, I think my HTML files will look
> something like:
>
>
>
>
>
> I think a good way is to store each article/entry as a row in a mySQL
> database. That's easy to say, but it's the details of actually *doing*
> it that I'm confused about.
>
> Chances are, the dbms will be on my webhost's machine. I don't want to
> telnet in and do something like:
>
> insert into table ARTICLES values ('Today's headlineGood
> morning blah blah blah ', date, etc....)
>
> My question boils down to this: if you have a site that frequently
> updates with new content, how do you enter the content? What tools do
> you use to connect to your webhost's SQL database over the web?
>
> Any practical advice is welcomed. I'm getting close to the point where
> the rubber hits the road, so sorry if this post was long-winded. Thanks!
Any basic cms will do the trick - free ones available at hotscripts and the
like.
Alternatively, it is a simple matter to write one yourself in php to accept
your data from a web page form and enter it into the database.
Re: How to enter content? -- Posted by Trent L on 01-18-04 15:07
Bill Logan wrote:
> "Trent L" wrote in message
> news:TPudnaPOd8nLApfdRVn-hQ@comcast.com...
>
>>Hello everyone,
>>
>>I'm planning the design for a personal blog website. I will write the
>>whole site by hand (see my post "Q about hand coding" for further
>>details if you're curious). I have a lot of the details planned out,
>>but there is something that I'm still fuzzy about:
>>
>>How do I enter the content?
>>
>>By content, I mean articles and blog entries. I don't want to hardcode
>>the articles into my HTML. Rather, I think my HTML files will look
>>something like:
>>
>>
>>
>>
>>
>>I think a good way is to store each article/entry as a row in a mySQL
>>database. That's easy to say, but it's the details of actually *doing*
>>it that I'm confused about.
>>
>>Chances are, the dbms will be on my webhost's machine. I don't want to
>>telnet in and do something like:
>>
>>insert into table ARTICLES values ('Today's headlineGood
>>morning blah blah blah ', date, etc....)
>>
>>My question boils down to this: if you have a site that frequently
>>updates with new content, how do you enter the content? What tools do
>>you use to connect to your webhost's SQL database over the web?
>>
>>Any practical advice is welcomed. I'm getting close to the point where
>>the rubber hits the road, so sorry if this post was long-winded. Thanks!
>
>
> Any basic cms will do the trick - free ones available at hotscripts and the
> like.
> Alternatively, it is a simple matter to write one yourself in php to accept
> your data from a web page form and enter it into the database.
Thanks for the tip. I considering building my own web interface to an
SQL database (I've done that before), but then I wondered about the
security issues. I'll look into it some more.
Re: How to enter content? -- Posted by David VB on 01-18-04 22:52
Trent L wrote:
> Bill Logan wrote:
>
>> "Trent L" wrote in message
>> news:TPudnaPOd8nLApfdRVn-hQ@comcast.com...
>>
>>> Hello everyone,
>>>
>>> I'm planning the design for a personal blog website. I will write the
>>> whole site by hand (see my post "Q about hand coding" for further
>>> details if you're curious). I have a lot of the details planned out,
>>> but there is something that I'm still fuzzy about:
>>>
>>> How do I enter the content?
>>>
>>> By content, I mean articles and blog entries. I don't want to hardcode
>>> the articles into my HTML. Rather, I think my HTML files will look
>>> something like:
>>>
>>>
>>>
>>>
>>>
>>> I think a good way is to store each article/entry as a row in a mySQL
>>> database. That's easy to say, but it's the details of actually *doing*
>>> it that I'm confused about.
>>>
>>> Chances are, the dbms will be on my webhost's machine. I don't want to
>>> telnet in and do something like:
>>>
>>> insert into table ARTICLES values ('Today's headlineGood
>>> morning blah blah blah ', date, etc....)
>>>
>>> My question boils down to this: if you have a site that frequently
>>> updates with new content, how do you enter the content? What tools do
>>> you use to connect to your webhost's SQL database over the web?
>>>
>>> Any practical advice is welcomed. I'm getting close to the point where
>>> the rubber hits the road, so sorry if this post was long-winded.
>>> Thanks!
>>
>>
>>
>> Any basic cms will do the trick - free ones available at hotscripts
>> and the
>> like.
>> Alternatively, it is a simple matter to write one yourself in php to
>> accept
>> your data from a web page form and enter it into the database.
>
>
> Thanks for the tip. I considering building my own web interface to an
> SQL database (I've done that before), but then I wondered about the
> security issues. I'll look into it some more.
A really simple cms and a mysql interface is phpmyadmin ;-)
No, seriously, it is good enough just to add simple entries, but if you
want the input to be a little more user friendly/intuitive, it would be
simple to write your own php script.
Discuss this issue in the live
discussion
forums now.
|
|
|
|
|
| Popular
Website Promotion & Marketing Articles... |
|
|
Xin Net Files Annual Report
Business Wire - April 5, 2001
Business Editors
VANCOUVER, B.C.--(BUSINESS WIRE)--April 5, 2001
Xin Net Corp. (OTCBB:XNET)
The Board of Directors of Xin Net Corp. announces that the Company has today filed its 10K Annual Report with the Securities and Exchange Commission.... (Read More)
Legal Club of America, Corp. Launches Einstein Computer Corporation Offering Computers/Free Internet Services through Payroll Deduction
Business Wire - April 25, 2000
Business/Technology Editors
SUNRISE, Fla.--(BUSINESS WIRE)--April 25, 2000
Legal Club of America, Corp. (OTC BB: LEGL), announced the launch of its wholly-owned subsidiary, Einstein Computer Corporation (ECC), to market affordable, all-inclusi... (Read More)
NetComISP, Inc. Announces Joint Development Agreement with Springboard
Business Wire - June 12, 2000
Business Editors
DALLAS--(BUSINESS WIRE)--June 8, 2000
NetComISP, Inc. (http://www.netcomisp.com), (a wholly owned subsidiary of NetCommerce, Inc., (OTCBB:NEET) (http://www.neetstock.com) today announced the signing of a letter of intent to ma... (Read More)
|
|
|
