I am new to php and mysql and I would like to learn. If there is someone that would not mind teaching me the basics if it is not too much to ask then that would be greatly appreciated. The reason being is that I am starting a company and I need to do a db for it because I cannot find someone that will take care of it. None of my guys know how.

Thank you in advance

    hello, when you say you need a db for your company: do u mean u need a website or a database?? what exactly do you need it for?

    the reason being: their are already plenty of scripts around you can install without knowledge of php and run a successfull business (OScommerce for instance)

    if you need a database (not a website) you could use microsft access for instance.

      There are MANY things you need to consider... such as: How much data are you storing in it, how many users are going to access it, is it for the internet or just local use.

      Microsoft Access is very good for new database users on a small system with very few simultaneous users. You can create forms in the program and use VBA (Visual Basic for Application) to make some VERY INTUITIVE forms and applications.

      MySQL is better for online applications and larger databases, but you need PHP or ASP to display your data.

      So you need to be sure to fully understand the scope of your project before 'leaping in with both feet'.

        Thank you for the informations. What I need the db for is so for my clients page, after they sign up I need the script to store their names in an array with other contact information for billing purposes.

        My server is already equiped to handle the php and mysql, but I do not know how to write the coding. I went to the php tutorial that you gave me bretticus, but call me dense because I still have no clue on how to start the script for it.

          I would never call anyone dense. However, if you are going to learn this, you need to get your toes wet sometime. Dig in! If you get stuck on something specific, post for help here. We love the "easy" questions! Perhaps the tutorial I linked to is a bit too brief or assumes you have some Web programming background. May I suggest this one instead.

            I don't know where you start either. You at least need an html page with a form for signing up (the form handling part of my tutorial should have explained that one generically enough to get started.) You need a php page to send the form contents to (think <form action="handler.php">...) You need to learn how to take form input values and insert them into a database (which means you need to know something of SQL queries.)

              Try this one.... http://www.w3schools.com/php/default.asp

              You'll need a form to retrieve the information that includes a SQL (Sequel) statement that inserts the date into the tables.

              1. Create a database
              2. Create a table (to store the date)
              3. Create the necessary Fields in the table (with appropriate data types)
              4. Create the form to retrieve the data from the user and insert into the table.

              Hope that helps,
              Chas

                I have completed a multiplayer board game for internet play and would like the game connected to a multiserver engine. I can have the database and codes available upon request. I need to maintain administrative control and code protection of course. If you cannot help will you recommend someone who can? Upon connection to a multiplayer server I will be ready for internet play.

                egroeg

                  Hi, this is my first post here at phpbuilder.com. I'm impressed at the information already given. The mysql manual is very well written and it is an excellent source. I will further recommend you the book that got me started with php it is called Spring into php 5, this book is a light read and it is straight to the point. I will also suggest you get a database modeling tool (there are plenty free ones such as Maestro and commercials like Toad), they are great when you are new to database design. For best practices look into database normalization. Best of luck.

                    Write a Reply...