Hi, Unregistered. | Today's Posts

T-Shirt Forums
User Name
Password

Need to Register?

Forgot Your Password?


Site Navigation







+   T-Shirt Forums > T-Shirt Selling > Ecommerce Site Design
Discuss website design for ecommerce sites, useability, navigation and other development considerations. To get feedback on your t-shirt design(s) or website, please post a request in our Site Reviews and Design Reviews section here.

Works Database convert to php ?



 
Share This Thread Thread Tools Search this Thread
Old August 28th, 2006 Aug 28, 2006 9:28:03 PM -   #1 (permalink)
TSF Veteran
Certified T-Shirt Junkie

T-BOT's Avatar
 
You can call me: Lucy
Member Since: Jul 2006
Location: Canada
Posts: 3,800
Thanks: 9
Thanked 37 Times in 31 Posts
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)


Default Works Database convert to php ?

hey, I have a database in microsoft works format with about 5,000 entries (products/attributes etc.), how can I convert this base to a php type thing i can use on a website.

any ideas ?
__________________
www.T-BOT.net - Happy Holidays Bruno.
 
Digg this Post!Add Post to del.icio.us Tweet about this Post!
Old August 29th, 2006 Aug 29, 2006 2:22:45 PM -   #2 (permalink)
Administrator
Certified T-Shirt Junkie

Rodney's Avatar
 
You can call me: Rodney
Member Since: Nov 2004
Location: Sacramento, CA
Posts: 25,838
Thanks: 5,083
Thanked 4,273 Times in 2,522 Posts
Blog Entries: 8
Mentioned: 18 Post(s)
Tagged: 0 Thread(s)


Default Re: Works Database convert to php ?

Couldn't you export it as an csv or other delimited file and then upload that file to a mysql database?

It definitely sounds "possible", so if it's not something you could do yourself, I bet it could be done in about an hour or so by someone at rentacoder.com
__________________
Rodney Blackwell - We're selling our 100% Natural Extravaganza T-Shirt For Charity!
PrinterListings.com: a place find, rate, and review custom t-shirt printing businesses


 
Digg this Post!Add Post to del.icio.us Tweet about this Post!
Old August 29th, 2006 Aug 29, 2006 6:23:41 PM -   #3 (permalink)
T-Shirt Lover
T-Shirt Wizard

Vtec44's Avatar
 
You can call me: James
Member Since: Apr 2006
Location: So Cal
Posts: 690
Thanks: 0
Thanked 10 Times in 4 Posts
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)


Default Re: Works Database convert to php ?

PHP is just a standard scripting language to access backend databases, typically mySQL/Oracle/Access/etc. For you to be able to import your existing data into another type of database, you will need to know the database structure to put what in where. With that knowledge, then you can either write a script or do a manual cut and paste. Different script will generate different database structure. For example, OSCommerce mySQL database structure is probably slitely different than CubeCart's mySQL database structure.
__________________
vMatches.com - Social networking and dating site.
 
Digg this Post!Add Post to del.icio.us Tweet about this Post!
Old August 29th, 2006 Aug 29, 2006 6:48:57 PM -   #4 (permalink)
TSF Veteran
Certified T-Shirt Junkie
Thread Starter

T-BOT's Avatar
 
You can call me: Lucy
Member Since: Jul 2006
Location: Canada
Posts: 3,800
Thanks: 9
Thanked 37 Times in 31 Posts
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)


Default Re: Works Database convert to php ?

thanks guys,
I just was not sure.

So, import the db into mySQL database.

With the Microsoft Works db, on my box I go to edit/find and i can search for " AC/DC " and it pulls up the AC/DC design.

how woud i do this on a site/web page ?

thanks in advance.
__________________
www.T-BOT.net - Happy Holidays Bruno.
 
Digg this Post!Add Post to del.icio.us Tweet about this Post!
Old August 29th, 2006 Aug 29, 2006 7:26:10 PM -   #5 (permalink)
T-Shirt Lover
T-Shirt Wizard

Vtec44's Avatar
 
You can call me: James
Member Since: Apr 2006
Location: So Cal
Posts: 690
Thanks: 0
Thanked 10 Times in 4 Posts
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)


Default Re: Works Database convert to php ?

There are many types of mySQL database. Which one are you planning to import the data to?

A mySQL database stores data. A php script will access the data, depending on the request, and output it as an HTML page. So, for something as simple as a "search" function to work, a php script will have 2 parts, 1. The front end where the users will see a search box and input a search request 2. The back end where it uses the entered value and go search a particular part of the database. So, if a user wants to search just item name field, the front end will have to allow that user to limit the request to item name field, then capture that request, search the designated portion of the database listed as the "item name field". It's not something you can simply do without extensive understanding of database, database structure, and scripting. A typical ecommerce script will have this feature built-in.
__________________
vMatches.com - Social networking and dating site.
 
Digg this Post!Add Post to del.icio.us Tweet about this Post!
Old August 29th, 2006 Aug 29, 2006 7:30:08 PM -   #6 (permalink)
TSF Veteran
Certified T-Shirt Junkie
Thread Starter

T-BOT's Avatar
 
You can call me: Lucy
Member Since: Jul 2006
Location: Canada
Posts: 3,800
Thanks: 9
Thanked 37 Times in 31 Posts
Mentioned: 0 Post(s)
Tagged: 0 Thread(s)


Default Re: Works Database convert to php ?

thanks James.

That helped ? will start on it.
__________________
www.T-BOT.net - Happy Holidays Bruno.
 
Digg this Post!Add Post to del.icio.us Tweet about this Post!

Tags: , , ,







This is a discussion about Works Database convert to php ? that was posted in the Ecommerce Site Design section of the forums.

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


All times are GMT -8. The time now is 11:25 AM.


Copyright 2004-2012 T-ShirtForums.com. All rights reserved.