This was buried in another post so not many people saw it... - WarmGlass.com

This was buried in another post so not many people saw it...

This is the main board for discussing general techniques, tools, and processes for fusing, slumping, and related kiln-forming activities.

Moderators: Tony Smith, Brad Walker

Post Reply
Pam Hrycyk
Posts: 36
Joined: Mon Mar 10, 2003 9:17 pm
Location: Toronto, Ontario Canada

This was buried in another post so not many people saw it...

Postby Pam Hrycyk » Sat Apr 17, 2004 9:12 am

Brad Walker wrote:The good news, I guess, is that I want to update things to create the kind of database we'd all like to see. I just am not sure I have the programming ability (or the time) to do it. Anyone out there know php and is willing to donate some hours?


Brad seldom (if ever!) asks for help and I'm not sure enough people saw this request so I'm copying it and reposting it. If I knew anything about php I would certainly donate some time, unfortunately, I don't even know what it is. Anyone else willing to help?

Pam

Susan B
Posts: 6
Joined: Sun Mar 28, 2004 1:34 pm
Location: Royal Oaks, CA
Contact:

Postby Susan B » Sat Apr 17, 2004 9:43 am

What kind of data base are you talking about?

Brad Walker
Site Admin
Posts: 1349
Joined: Fri Mar 07, 2003 9:33 pm
Location: North Carolina, USA
Contact:

Postby Brad Walker » Sat Apr 17, 2004 9:47 am

IamSundancer wrote:What kind of data base are you talking about?


MySQL.

The original comment that Pam quoted was made in response to a request that we be able to search the memberlist by various criteria. Right now it's only accessible sequentially and can't be searched.

In addition to the ability to search the memberlist (by location, for example, as well as name), I'd like to be able to search studios that are offering courses to find one in your area. The first would be an application that builds on the database I already use, the second would be a totally new application.

These wouldn't have to be written in php, but that language is commonly used with MySQL. I could probably figure out how to do it, but don't really have the time.

dee
Posts: 302
Joined: Tue Mar 11, 2003 5:20 pm
Location: Atlanta GA
Contact:

Postby dee » Sat Apr 17, 2004 10:16 am

Brad Walker wrote:
IamSundancer wrote:What kind of data base are you talking about?


MySQL.

The original comment that Pam quoted was made in response to a request that we be able to search the memberlist by various criteria. Right now it's only accessible sequentially and can't be searched.

In addition to the ability to search the memberlist (by location, for example, as well as name), I'd like to be able to search studios that are offering courses to find one in your area. The first would be an application that builds on the database I already use, the second would be a totally new application.

These wouldn't have to be written in php, but that language is commonly used with MySQL. I could probably figure out how to do it, but don't really have the time.


brad - is this info currently in a mysql db? if you have the db structure handy, i could write the sql statements needed to pull the data but i don't know php, only coldfusion so someone would have to build the interface to use the sql statements and output the data.....
D
Dee Janssen
Unicorn's Creations Studio
http://ucjewelry.com
dee@ucjewelry.com

Brad Walker
Site Admin
Posts: 1349
Joined: Fri Mar 07, 2003 9:33 pm
Location: North Carolina, USA
Contact:

Postby Brad Walker » Sat Apr 17, 2004 3:20 pm

dee wrote:brad - is this info currently in a mysql db? if you have the db structure handy, i could write the sql statements needed to pull the data but i don't know php, only coldfusion so someone would have to build the interface to use the sql statements and output the data.....
D


Yes, it's current in a MySQL db, but there would need to be some tinkering (splitting location field, for example). I could probably write the sql statements to do all this (that's not too difficult or time-consuming), but I just don't have the time to write the interface.

Dani
Posts: 493
Joined: Mon Mar 10, 2003 3:17 pm
Contact:

Postby Dani » Sat Apr 17, 2004 5:27 pm

But, since I asked the original question, I might suggest strong consideration as to whether it is worth the effort to begin with..... Is searching the member base going to be an important enough thing to justify the time and effort? How many times has the issue come up?

Brad Walker
Site Admin
Posts: 1349
Joined: Fri Mar 07, 2003 9:33 pm
Location: North Carolina, USA
Contact:

Postby Brad Walker » Sat Apr 17, 2004 5:50 pm

Dani wrote:But, since I asked the original question, I might suggest strong consideration as to whether it is worth the effort to begin with..... Is searching the member base going to be an important enough thing to justify the time and effort? How many times has the issue come up?


Somebody asks me about it around once a month, maybe more. I don't know how many people wonder but don't ask.

To me, the real value is to be able to have a database of kiln-forming artists so that people could find out who's in their area, etc.


Post Reply

Return to “Techniques and Tools”

Who is online

Users browsing this forum: No registered users and 48 guests

Warm Glass

2575 Old Glory Road, Suite 700
Suite 700
Clemmons, NC 27012
Phone: (336) 712 8003
Email: wg@warmglass.com

cron