Member Avatar for <M/>

I am creating a site and I am trying to put all the posts within a mysql database (phpmyadmin). How do i put articles/posts in the DB?

  • 4 Contributors
  • 6 Replies
  • 180 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by <M/>
Member Avatar for pritaeas

INSERT queries. If you can be a little more specific about what exactly you're looking for, I can give a more specific answer.

Member Avatar for JorgeM

Yes more info is needed but at a high level you'll track the posts by a unique identifier in your DC table, such as postId.

We really need to know what information do you want to store about the post? The post itself, when it was posted, what is its category, is it solved, view count, what category does it belong to, etc... Just to name a few...

Member Avatar for <M/>

Lets say I was to store an article that i wrote, it contains maybe 1000+ words in the body, how would i store that kind of data in a database?

Member Avatar for pritaeas

Use a TEXT column.

Member Avatar for rch1231

Why don't you simply use wordpress or drupal they are both free and manage the web site and handle postings also. Why re-invent the code when someone has already written it and it is easy to use....

Member Avatar for <M/>

Why re-invent the code when someone has already written it and it is easy to use....

I was planning on doing that for learning purposes.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.