1. Missed the live Ask the Expert event?
    Not to worry. Check out the archived thread of the Q&A with Ken Hutcheson, President of U.S. Lawns, and the LawnSite community on the Franchising Forum.

    Dismiss Notice

Help with customer login

Discussion in 'Digital Marketing' started by 1BadHawk, Apr 30, 2005.

  1. 1BadHawk

    1BadHawk LawnSite Member
    Posts: 127

    Yes they do use phpMyAdmin to manage MYsql database.
     
  2. partstree

    partstree Sponsor
    Posts: 79

    then in that case you'll want to create a new database and a user account to access that database. this is outside the scope of phpmyadmin, so you'll need to ask your host how to do that. once it's setup, you can login to phpmyadmin and select the database you have just setup.

    phpmyadmin is a method of maintaining your database - think of a mysql database as a folder full of excel spreadsheets. each of the excel files are called "tables" in mysql, each table has fields (which are columns in excel) and as many entries (or rows in excel) as you want.

    if you plan on starting off with just a few customers (less than 1000) you'll want to store all of your customer data in one table (if your site grows you may want to re-plan your database architecture, but for now we'll discuss how to setup your site for a small customer database) create your table by typing in "customers" where it says "create new table on database ..." (this may vary on what version phpmyadmin you're using, but will be something similar) you can call the table whatever you want, but customers very easily identifies what the table holds. then enter the number of fields you want (that is, you'll probably want the customer first name, last name, email address, phone number, etc... one field for every column you would have in an excel spreadsheet. you can add and delete fields later if you decide to make changes) click go to create the table.

    next you'll want to define the fields. the only three properties you really need to worry about are field , type and length/values. in field goes the name of the field (name, email address, phone number etc...), in type goes the data type (this depends on what you'll be holding in this field. when in doubt, just go with varchar - with the small size of your database this will not be an issue), and finally in length/values input the maximum size that any particular value can be input (that is, if the longest last name you expect to have is 13 letters long, put in 13. be careful when considering this, i've had cases where i didn't plan ahead and put too small of a number, and the rest got cut off. you can put a big number in, as you'll have enough space if your database is relatively small) after you've done this for all of your fields, hit go to create the table.

    after this you can begin adding records to the table. you can do this under the insert tab (just put in whatever value you want under the value and hit go to insert)

    so those are the basics of phpmyadmin. now you can setup your customer database. the next step is to use one of the scripts that have been mentioned previously in this thread to create a user interface for your customers to utilize your database to login. you can create your database to store customer invoices and estimates, which is your first step. next step is to create a user interface for your customers to view the information. this is about as easy as it's going to get if you want to do it yourself.
     
  3. partstree

    partstree Sponsor
    Posts: 79

    this is a good method for a small user set (in fact what you're describing is very much how a database works) if you want to do this i can throw together a simple script to do so.
     
  4. 1BadHawk

    1BadHawk LawnSite Member
    Posts: 127

    seems to be working so far. thanks.
     

Share This Page