SitePoint Sponsor

User Tag List

Results 1 to 7 of 7

Hybrid View

  1. #1
    SitePoint Member
    Join Date
    Apr 2012
    Location
    Newcastle upon Tyne
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Implementing MYSQL online

    Hi All,

    I have always been practicing web development on my local host, yes I have a couple of websites out there, on a .com domain but I am fairly new and still learning how to develop and fully implement a complete website, with a database.

    I am currently using PHP5.2 and MySql. I always have been using PHPMyAdmin and I am quite confident with it. Now I want to implement my website online, but I am not sure what to do when it comes to the database side of it; I am ok uploading the html, php files online etc. but what should I do to have the database functionality online?

  2. #2
    SitePoint Enthusiast
    Join Date
    Oct 2009
    Location
    A city equidistant from two coasts of India.
    Posts
    47
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Your hosting space provider will give you a control panel where you can easily find option to create a new database. You will also find phpMyAdmin.

  3. #3
    SitePoint Addict MikesBarto2002's Avatar
    Join Date
    May 2006
    Location
    New York City
    Posts
    317
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by rpk2006 View Post
    Your hosting space provider will give you a control panel where you can easily find option to create a new database. You will also find phpMyAdmin.
    Along with this, it's always a good idea to learn how to implement database commands without using phpmyadmin. There might be times when you won't have access to phpmyadmin, and then you will have to write your scripts to access the database without it.

    Check out Simply SQL for more information.
    James Web Development | New York, NY
    Design, Develop, Deliver

  4. #4
    SitePoint Member
    Join Date
    Apr 2012
    Location
    Newcastle upon Tyne
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by MikesBarto2002 View Post
    Along with this, it's always a good idea to learn how to implement database commands without using phpmyadmin. There might be times when you won't have access to phpmyadmin, and then you will have to write your scripts to access the database without it.

    Check out Simply SQL for more information.
    Thanks a lot for your help! I am actually ok doing SQL queries, it's literally just the implementation I was wondering about...

  5. #5
    SitePoint Addict
    Join Date
    Apr 2009
    Posts
    357
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    If you have a host that gives you shell access you should get familiar with the mysql command line programs.
    Doug G
    =====
    "If you ain't the lead dog, the view is always the same - Anon

  6. #6
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,263
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    Quote Originally Posted by Doug G View Post
    If you have a host that gives you shell access you should get familiar with the mysql command line programs.
    you could also try giving yourself a root canal, it's just about as painful

    there's really no good reason not to use a good front-end program... and yes, you should know how to write sql, but they all have an sql window where you can do that
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  7. #7
    SitePoint Addict
    Join Date
    Apr 2009
    Posts
    357
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    there's really no good reason not to use a good front-end program... and yes, you should know how to write sql, but they all have an sql window where you can do that
    Obviously you don't do a lot of work on remote servers where ssh is your main lifeline and getting a gui is "difficult".
    Doug G
    =====
    "If you ain't the lead dog, the view is always the same - Anon


Tags for this Thread

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
  •