Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: SQL Database Creation

  1. #1
    Join Date
    Aug 2006
    Location
    Southern California
    Posts
    83

    Default SQL Database Creation

    I'm relatively new to BH having recently moved our domain from elsewhere.
    I would like to set up a database on our site, but I'm not familiar with the process of working with an SQL database. Most of my experience has been with MS Access (sorry about that).

    I've checked the help files and managed to create a database, but I have no idea as to how to get data into the database nor how to link it into our web, which is created and published using Frontpage (don't knock it - it works).

    I could use some basic guidance with the above. Any help would be appreciated.

    Techgy

  2. #2
    Join Date
    Jul 2006
    Location
    Portland, OR
    Posts
    285

    Default

    There are articles in the knowledgebase that illustrate how to import data into a database. Of course, to do that you either have to create the SQL queries that add the records or export from an existing SQL database.

    Also, there are many good books out there on SQL in general and MySQL and other SQL databases in particular.

  3. #3
    Join Date
    Aug 2006
    Location
    Southern California
    Posts
    83

    Smile SQL Creation

    Thanks for the response. However, I've already been through the information in the Knowledgebase. As for purchasing a book, that's a last resort, but a possibility.

    What I'd really like to find is an on-line example of setting up an SQL database and connecting it into a FrontPage web site. Anything simple would be fine, I'm just looking for something that would "turn the lights on".

    Thanks

  4. #4
    Join Date
    Jul 2006
    Location
    Portland, OR
    Posts
    285

    Default

    Quote Originally Posted by techgy
    What I'd really like to find is an on-line example of setting up an SQL database and connecting it into a FrontPage web site.
    To create a data driven web page you need to use a server-side scripting langauge. HTML by itself cannot do the job. PHP is a commonly used server-side scripting language as are Perl and Python but there are others as well.

    You need to learn all about LAMP (Linux, Apache, MySQL and Perl/Python/PHP). This technology is, I would guess, the basis of most of the data driven websites hosted here. There are tutorials in various places on the web that explain how to get started, see the tucows page.

  5. #5
    Join Date
    Sep 2006
    Posts
    1

    Default Forget HTML

    You need a CMS like Joomla. It uses lamp. HTML and Frontpage are dead, dead dead.

  6. #6
    Join Date
    Jul 2006
    Location
    Portland, OR
    Posts
    285

    Default

    Quote Originally Posted by boppinbob
    HTML [is] dead, dead dead.
    Not so. HTML is essential to web pages. Perhaps you meant that coding web pages solely in HTML is obsolete. That is closer to the truth, perhaps, but if you don't know any HTML you'll have a difficult time creating sophisticated, data-centric web pages no matter what server-side scripting language or CMS you choose.

  7. #7
    Join Date
    Feb 2006
    Location
    Fresno, CA
    Posts
    629

    Default

    Quote Originally Posted by boppinbob
    HTML and Frontpage are dead, dead, dead.
    For all you Star Trek fans, that was a famous quote from a show, "Trilane."

    Don't chuck that html editor just jet, I still write in html, and it is quite effective.

    But FrontPage is indeed dead, Dead, DEAD.

    Perhaps you could give us some examples of the data you need to manage?

  8. #8
    Join Date
    Feb 2006
    Location
    Florida, USA
    Posts
    1,498

    Default

    Quote Originally Posted by boppinbob
    You need a CMS like Joomla. It uses lamp. HTML and Frontpage are dead, dead dead.
    content management lol

  9. #9
    Join Date
    Aug 2006
    Location
    Southern California
    Posts
    83

    Smile Reply to BobDog

    The date is VERY simple. In fact, it's basically a flat-file database.
    In any event it would be good experience to setting up a db on BH.

    The data format is;

    Name
    Address
    City
    State
    Zip
    Phone
    Email


    All fields can be text format. Data is indexed (sorted) on the name field.

    If I can get the basics going, then I can probably take it from there.
    I've been dealing with MS servers for years and switching to BH is, well, different.

  10. #10
    Join Date
    Feb 2006
    Location
    Fresno, CA
    Posts
    629

    Default

    That should be pretty easy. First make a new database. In cPanel, click on SQL databases. Create a new database, add a user and password to that database. Now, click on the phpMyAdmin link on the bottom. Select your database. Click on the SQL tab. Run this SQL query in the window:

    CREATE TABLE `clients` (
    `Name` varchar(100) NOT NULL default '',
    `Email` varchar(100) NOT NULL default '',
    `Address` varchar(255) NOT NULL default '',
    `City` varchar(50) NOT NULL default '',
    `State` varchar(50) NOT NULL default '',
    `Country` char(2) NOT NULL default '',
    `Phone` varchar(20) NOT NULL default '',
    `Zip` varchar(6) NOT NULL default '',
    ) TYPE=MyISAM;

Posting Permissions

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