Register free!

The Green Industry's Resource Center



Reply
 
Thread Tools   Display Modes
  #11  
Old 05-20-2005, 11:32 AM
1BadHawk 1BadHawk is offline
LawnSite Member
 
Join Date: Feb 2005
Location: Baltimore, Maryland
Posts: 127
Yes they do use phpMyAdmin to manage MYsql database.
Reply With Quote
  #12  
Old 05-20-2005, 01:55 PM
partstree's Avatar
partstree partstree is offline
LawnSite Member
 
Join Date: Mar 2005
Location: Austin, Texas
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.
Reply With Quote
  #13  
Old 05-20-2005, 01:56 PM
partstree's Avatar
partstree partstree is offline
LawnSite Member
 
Join Date: Mar 2005
Location: Austin, Texas
Posts: 79
Quote:
Originally Posted by 1BadHawk
Ill ask the host about mysql manager.

Meanwhile, another option that might work for now, is using a form type feature.
Let the user input their ID or name, and then load the appropriate page which will have the same name as the user id.

This way, Jane Smith, enters her name, and then page "Jane Smith.html" loads. Since the info doesnt provide anything confidential other than their estimate info, privacy isnt of the utmost importance.

Their will be one seperate .html page of each customer, in my case thats less 30 right now.
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.
Reply With Quote
  #14  
Old 05-22-2005, 08:55 AM
1BadHawk 1BadHawk is offline
LawnSite Member
 
Join Date: Feb 2005
Location: Baltimore, Maryland
Posts: 127
seems to be working so far. thanks.
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump





Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright ©1998 - 2012, LawnSite.comô - Moose River Media
All times are GMT -4. The time now is 07:29 PM.

Page generated in 0.07327 seconds with 9 queries