mySQL database Tutorial???

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
  • c.mclean
    First Sergeant

    • Sep 2006
    • 75

    mySQL database Tutorial???

    Hi...

    Is there anywhere that I could get a MySQL Tutorial, so that I could learn how to use it effectively?

    Please reply...

    Chris
  • VodaHost
    General & Forum Administrator

    • Mar 2005
    • 12356

    #2
    Re: mySQL database Tutorial???

    MySQL is such very large topic, click the below to learn how to create a database....


    VodaHost

    Your Website People!
    1-302-283-3777 North America / International
    02036089024 / United Kingdom
    291916438 / Australia

    ------------------------

    Top 3 Best Sellers

    Web Hosting - Unlimited disk space & bandwidth.

    Reseller Hosting - Start your own web hosting business.

    Search Engine & Directory Submission - 300 directories + (Google,Yahoo,Bing)


    Comment

    • c.mclean
      First Sergeant

      • Sep 2006
      • 75

      #3
      Re: mySQL database Tutorial???

      Hi again,

      Thanks for your help... Could you explain - or give me a link that explains - how to use the database in BV?
      Say you want to easily update and add new information to your webpage, and the information always has the same fields. Like Address, Practise, Country, Phone Number and Name for example. All the information has to be displayed on the webpage. How could you use a database to do this?

      Thank you,
      Chris

      Comment

      • navaldesign
        General & Forum Moderator

        • Oct 2005
        • 12080

        #4
        Re: mySQL database Tutorial???

        BV has nothing to do with the database. The database administration is made through your CP and the phpAdmin that comes with it.
        What you are looking for, is a web based interface script that would allow DB searching, and displaying the querry results. This is usually done with php in joint with a visual part (which can, if you have the knowledge to combine the two, be built in BV)

        This is not a standard BV feature (i beleive it is not a feature of ANY sitebuilder) , but is one of the future projects i have. Building a BV intreface for administrating a DB. The project is a very complicated one, as it has to be completely parametric, in order to allow users to define what they want to visualize, how to do it, etc.

        For the moment i beleive you can only look if someone (or you) can build a custom made script for your purposes.
        Navaldesign
        Logger Lite: Low Cost, Customizable, multifeatured Login script
        Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
        DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
        Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

        Comment

        • c.mclean
          First Sergeant

          • Sep 2006
          • 75

          #5
          Re: mySQL database Tutorial???

          Thanks Naval,

          I understand what you are saying... thanks for your help.

          Chris

          Comment

          • kenhansen
            First Sergeant

            • Jun 2006
            • 80

            #6
            Re: mySQL database Tutorial???

            I have been trying for hours to get this to work. All I want to do is create an opt in form. I am using php form generator. Seemed very easy until I tried to add the info to mySQL database. Obviously I need to maintain the opt in list, but cannot get the databse to work correctly. I have been to php forum, looked everywhere and this post was the closest I could find for an answer. When I fill out the final page in the form maker, I receive this: reply:

            phpFormGenerator
            [ home ] [update] [support] [contact] quick links - project web
            - sourceforge
            - linux.com
            - php.net
            - mysql.com
            - apache.org

            powered by h4x0rs.us

            wise words What is the difference between genius and stupidity? Genius has limits. - Albert Einstein. Step 5: generation status v2.09 thats it! now we're ready to generate your form. if you encounter any errors, please make sure that you provided the correct database information (if any), and please maintain that everything is case sensitive. also remember to give read+write permissions to the forms directory (located under the phpformgen directory). thank you.

            Now creating table 'optinnres' ...


            Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'zoyxtaw'@'ns15.vodahost.com' (using password: YES) in /home2/zoyxtaw/public_html/optinform/process3.php on line 288


            Could not establish connection to MySQL database with the information provided.I am wit's end trying to do what should be simple. ANy suggestions, or a different approach, Please let me kkkknnnow.

            THank you

            Comment

            • navaldesign
              General & Forum Moderator

              • Oct 2005
              • 12080

              #7
              Re: mySQL database Tutorial???

              The DB login details must be wrong. Connect to your CP, Databases, and chech the database login details and the database name. Usually, the username and database name, will have "zoyxtaw_" infront of the name and the username given
              Navaldesign
              Logger Lite: Low Cost, Customizable, multifeatured Login script
              Instant Download Cart: a Powerfull, Customized, in site, DB driven, e-products Cart
              DBTechnosystems.com Forms, Databases, Shopping Carts, Instant Download Carts, Loggin Systems and more....
              Advanced BlueVoda Form Processor : No coding form processor! Just install and use! Now with built in CAPTCHA!

              Comment

              • jamestcs
                Private

                • Dec 2006
                • 4

                #8
                Re: mySQL database Tutorial???

                i came accross the same problem before , and Navaldesign is right, the DB login details is wrong. Once i corrected it , running smooth now. :)
                James
                FLV converter
                Roller shutters manufacturer

                Comment

                Working...
                X