SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Hybrid View

  1. #1
    Addicted to the Source of Life PowerBit's Avatar
    Join Date
    Feb 2004
    Location
    Loveland Co
    Posts
    548
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Questions: Just began "Database Driven Websites - using PHP and MySQL"

    Hello to the well knowledgable out there,

    I have just began the book from Sitepoint "Database Driven Websites - using PHP and MySQL" and have a few questions (I would like to add that I am not sure if I am accurately asking these questions -- please bear with me):

    The situation:
    I am instructed to access MySQL and use PHP script; the options pointed out in the book is:
    1.) If my host offers MySQL and PHP then I can access what I need from the host.
    2.) If they are not offered then download them to my machine.

    The situation I face is that my host offers an empty database for my use at a cost to me. Of course I wanna go free!

    The questions:
    1.) Concerning the needs of the book: Is a database just a part of what I will need to access from my host; in other words can I access other needed parts of MySQL from my host, apart from the database (thus creating my own database down the road)?
    2.) If the database is integral to the requirements of the book and essential to have, what are my options? a.) partial use of MySQL from the host and create my own database? b.) download everything I need from My SQL's site and run from my computer? c.) other options d.) do you understand my question?

    Note: I am just a beginning and I know only what the first few chapters speak about.

  2. #2
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hello Onebit
    if i do understand you clearly.

    Let me first explain that a database is a hierachy of objects, the database being the top level object.

    Question1;
    Whatever database your host gives you, should be empty, you would have to create tables own your own and other database objects. And you can name them whatever you want.

    So you would be creating your own database structure.

    However if you are given a dedicated server which allows you full control, you could create multiple databases. But since you are just starting off, i guess one database would be ok.

    2.
    (a) create your own database structure. I guess a database would be given to you.
    (b) you could create a mirror database on your local computer and upload to the server
    (c) what other options ?

  3. #3
    Afrika
    Join Date
    Jul 2004
    Location
    Nigeria
    Posts
    1,737
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I would advice you get a good understanding about

    1. Databases, SQL statements and databse objects
    2. Server side scripts e.g php
    3. Database connections e.g. ODBC, connection strings

    and generally about Client server communications. Ie
    client - your web browser
    server - webserver Architecture e.g Apache and backend database MySQL


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
  •