SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Enthusiast
    Join Date
    Mar 2012
    Posts
    49
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to create MySQL database with php for visitor comments, registration, profile pg

    What's best/quickest/easiest way to accomplish this? Site is static & unlaunched yet, built in Dreamweaver (html/css code viewer). Anyone know of the code or a website to specifically help with this?

  2. #2
    #titanic {float:none} silver trophy
    molona's Avatar
    Join Date
    Feb 2005
    Location
    from Madrid to Heaven
    Posts
    8,268
    Mentioned
    249 Post(s)
    Tagged
    1 Thread(s)
    I feel that the easiest and quickest way to achieve this is using a already built solution such as WordPress... but of course that doesn't allow for much learning, does it?

    Still, your question is really wide. It involves:

    - Creating the table and structure for the profile and user's data
    - Using PHP code to open a connection to the database
    - Creating specific forms (login, profile details or comments, depending on which are of the website you are)
    - SQL queries to insert data, retrieve or modify it (like the profile, in case that they want to change something)

    I'll use the example of the log in page. In this thread you'll find some interesting information as well as code examples. Do read it as there's a bit on discussion on best practices.

    http://www.sitepoint.com/forums/show...in-page-in-php

    For the rest, I find that if you understand what it is said here, at least in general, you'll be able to code the other pages. The concepts are similar.

    Now, if you don't know any PHP and you only want the code... this will be useless and even if you search the web for the code you need, you'll find yourself in trouble if you want to implement it (not imposible if the structure of your database matches the example but hard work)

    In that case, I'd certainly advise you to use something like WordPress and the plugíns that you may need to create that functionality that you need... and then that you start to learn PHP

  3. #3
    SitePoint Enthusiast
    Join Date
    Mar 2012
    Posts
    49
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Wow, you are really rude - your arrogance simply means ignorance. Good luck with that

  4. #4
    #titanic {float:none} silver trophy
    molona's Avatar
    Join Date
    Feb 2005
    Location
    from Madrid to Heaven
    Posts
    8,268
    Mentioned
    249 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by hiya View Post
    Wow, you are really rude - your arrogance simply means ignorance. Good luck with that
    I truly sorry but I do not understand this attitude... and definately I don't know what you mean when you say that I'm being rude. You asked a question, and tried to help you. I have no knowledge of what you know or what you don't.

    Do be aware that people around here do help each other but we do not do homework. We get paid for that

  5. #5
    SitePoint Wizard
    Join Date
    Feb 2007
    Location
    Southern California
    Posts
    1,388
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    If you have no MySQL or PHP experience, then the best and easiest way to get up and running to accomplish the tasks you want is to get the Sitepoint book, PHP & MySQL: Novice to Ninja. I've finished reading it today it and it covers how to create such tasks as you mentioned.
    Steve Husting

  6. #6
    Programming Since 1978 silver trophybronze trophy felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, NSW, Australia
    Posts
    16,871
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)
    Quote Originally Posted by hiya View Post
    What's best/quickest/easiest way to accomplish this? Site is static & unlaunched yet, built in Dreamweaver (html/css code viewer). Anyone know of the code or a website to specifically help with this?
    See http://www.commentics.org/ for a PHP script to add commenting functionality to otherwise static web pages.
    Stephen J Chapman

    javascriptexample.net, Book Reviews, follow me on Twitter
    HTML Help, CSS Help, JavaScript Help, PHP/mySQL Help, blog
    <input name="html5" type="text" required pattern="^$">


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •