php shopping cart?

[Scrumpy]

Anyone have a suggestion on a good php based shopping cart system? Credit card processing included? Total idiot about shopping cart/ selling online. Thanks for any info.

Scrumpy

[eric418]

i'm using The Exchange in PHP/MySQL, i can't say if it's good or not. But just a sugguestion.

For it, it's so far so good.

[Scrumpy]

Thanks Eric I'll take a look at it.

Scrumpy

[DCE]

Check out hotscripts http://www.hotscripts.com/PHP/Scripts_and_Programs/E-Commerce/Shopping_Carts/
there's lots there

[Scrumpy]

Yes there are a lot of shopping cart scripts at hotscripts, thanks.

I guess I'll just have to download a couple and see how they work. Im a total php beginner but I'll try anything once or twice....or until I get it right or give up. : )


Thanks for the info.

Scrumpy

[DarkWizard]

I agree with eric418, The Exchange Project (http://theexchangeproject.org/) is the better one out there and the developement team is working on a new version. I have written a couple of hacks for it as well and one being an option to accept checks....

[Scrumpy]

ok, I've tried getting exchange (and others) running on a site but stumble when its time to import the data into the database. I follow the directions - using putty to ssh - but Im doing something wrong. Is there a trick or something you can tell me about the installation that might help. Thanks

Scrumpy

[eric418]

DarkWizard:

Really, this is what i'm hoping for Exchange to accept check. When will the newer version be released? Looking forward for it.

Scrumpy:

I just follow exactly what the instruction states and I got it running without a problem in Hostrocket.

1. insert the sql
2. Adjust the application_top, Application_bottom, header, footer etc.
3. Upload both catalog and admin
4. chmod the image directory.

Basically thatz all what i did to make it running, and of course u'll have to customize it after it's running.

[Scrumpy]

I will try again today and see what happens. I think the area giving me trouble is insterting the sql. Thanks for the advice.


Scrumpy

[eric418]

Oh. This is the point.

DO NOT insert the sql in phpMyAdmin.


1. just upload the *.sql file.
2. telnet to server.
3. type "mysql catalog < ./filename.sql"

p.s. I think you'll need to drop all tables first before you do this. As you did once with phpMyAdmin.

[Scrumpy]

This might be a stupid question but... where exactly do I upload the sql file? public_html folder or someplace else?

Thanks for the help

Scrumpy

[DarkWizard]

Originally posted by Scrumpy
This might be a stupid question but... where exactly do I upload the sql file? public_html folder or someplace else?

Thanks for the help

Scrumpy

Upload it to your WEB root and run this command:

mysql -uUSERNAME -pPASSWORD dbname < catalog.sql

[Scrumpy]

I finally got the db data imported, now Im just trying to stop all the error messages while I test everything.

Thanks for all the help.

Scrumpy

[waipahunet]

I've followed the previous messages and when I go to http://www.mydomain/catalog to try and view the shopping cart, all I see is a directory listing of the files containted within the directory. Can someone help?

[eric418]

DirectoryIndex default.php

add this in .htaccess

becos default.php is not set as the index name.

[waipahunet]

Thanks eric418! I at least knew that it should've been the file default.php that should automatically load when view the directory but adding the .htaccess did the trick!

I wish there were more detailed help...now I keep getting "Unable to connect to database server!" when viewing the catalog directory and "Warning: Supplied argument is not a valid MySQL result resource in /home/waipahu/public_html/admin/includes/functions/database.php on line 39" when viewing the admin directory. Where should I start first?

[waipahunet]

I think my problem resides in the

//define our database connection
define('DB_SERVER', $HTTP_ENV_VARS['HOSTNAME']);
define('DB_SERVER_USERNAME', 'mysql');
define('DB_SERVER_PASSWORD', '');
define('DB_DATABASE', 'waipahu_catalog');
define('USE_PCONNECT', 1);

is this the correction configuration?

[eric418]

i don't think your user name is "mysql"

this seems better.

define('DB_SERVER_USERNAME', 'waipahu');

[waipahunet]

I don't know why but I tried installing it on another web host company and it works like a charm but it doesn't seem to work right here on hostrocket. I keep getting the following error.

Warning: Supplied argument is not a valid MySQL result resource in /home/waipahu/public_html/admin/includes/functions/database.php on line 39

anyone got anymore suggestions or ideas?

[waipahunet]

I finally got "the Exchange" up and running! yehey!

[Sinmedia]

Okay, I ftp'd the "Mysql_catalog.sql" file to my "public_htm" folder.

Then I went to SSH, and typed:

mysql -uMYUSERNAME -pMYPASSWORD create catalog

Then I got the whole help index listing..

then I typed:

mysql -uMYUSERNAME -pMYPASSWORD catalog < ./mysql_catalog.sql

I get an error message: "access denied for user: 'sinmedia@localhost' (using passwd: YES)

Any advice would be appreciated. What am I doing wrong?

Thanks all.

[DCE]

Shouldn't it be.....
mysql -uMYUSERNAME -pMYPASSWORD username_catalog < ./mysql_catalog.sql

[Sinmedia]

DCE,

tried that. Still get the same error.. :(

Help from someone who successfully installed and is running The Exchange Project would be greatly appreciated. I'm totally a newbie at PHP/MySQL...

[DCE]

Hope you get it sorted, but......

You still must use *username_dbname*
because there might be 10 other people who have a db named *catalog* so when you create it, the username is tagged on to it to identify it as your db

The username refers to the db username not your account username

[DCE]

Have you tried using PHPMyAdmin to create and load the db?

If not try this (please excuse the simplistic instructions)


Login to PHPMyAdmin
http://www.yourdomain.com/phpMyAdmin/index.php

Look down the left hand column, you should see your db (username_catalog) if not you'll see a text box inviting you to *create new database* type in catalog and hit enter

If you can see your *username_catalog* db (or you've just created it) click on it
You will then see a textbox with the wording *or Location of textfile* above it
click the browse button and navigate to the .sql file on your local machine
then click go

If everything goes OK you should get a success message

[Sinmedia]

DCE, appreciate your help.

On an earlier post, Eric418 wrote: (beginquote)


DO NOT insert the sql in phpMyAdmin.


1. just upload the *.sql file.
2. telnet to server.
3. type "mysql catalog < ./filename.sql"

p.s. I think you'll need to drop all tables first before you do this. As you did once with phpMyAdmin.

(endquote)

Why does he say not to use phpMyAdmin?

When I go to phpMyAdmin, I can't find the sinmedia_catalog database. I'm guessing that means it never got created, right?

I will check out your suggestion and see if it will work through phpMyAdmin.. did you get TheExchangeProject installed and working this way?

Thanks

[DCE]

No I've never installed it
But it seems your problem is a db create, so it shouldn't be too difficult to sort out

[Sinmedia]

wow, that was an ordeal. Finally got the database inserted, tables seem fine... now trying to configure the thing.

can anyone point me to the next step after inserting the database?


Actually, you know what would be really helpful, is if someone could email me their application_top.php, application_bottom.php, and database.php file code for their catalog and admin folders.. marking out any sensitive info of course. I just want to see the proper way to set the directory paths and the things that need to be configured for the server..etc. please?

Also, after I ftp'd and messed with my admin directory, I can access the default.php, but none of the images show up?? As far as I know, the image directory is set correctly... I have no idea what to do about the chown thing.. any pointers would be appreciated.

Thanks.

[Sinmedia]

Please? :)

also, what is the 'chown' setting for the 'images' folder for the catalog?

example:

cd catalog
chown -R username.usergroup images

Thanks!

[dennispaulbaker]

How did you finally get it working? I'm on the "final step" -- configuring the myphp part in The Exchange. I'm not sure what to put as the username, etc. Everything I enter fails.

I find this odd as I setup PHP Nuke with no problems at all...

hmmmmmmmmmmm

[Sinmedia]

your username should be the username you set up when you created the catalog database from PHPmyadmin.

For instance, my catalog's name is "sinmedia_catalog" (see previous posts by DCE), and I created a user (let's say "joe", which the system would recognize as "sinmedia_joe") and set a unique password for "joe".

All this is done in PHPmyadmin.

Unfortunately, I'm still stuck, because I still get "cannot connect to database server" errors (although I think this might have something to do with the network, not what I did, because it worked fine for a while)

I also get other errors.... arrgh.

[dennispaulbaker]

Here's how I got it working -- totally different than what I did for PHP Nuke...


// define our database connection
define('DB_SERVER', 'localhost');
define('DB_SERVER_USERNAME', 'MYCPANELNAME');
define('DB_SERVER_PASSWORD', 'MYCPANELPASS');
define('DB_DATABASE', 'MYCPANELNAME_catalog');
define('USE_PCONNECT', 1);

[Sinmedia]

Hey, that's fantastic! :)

That solved my "cannot connect to database" problem, as well as the other error message.

For some reason though, none of my images in the admin section are showing up. do you have the same problem?

Also, do you know how to set the "chown" for the catalog images directory in SSH, as instructed by the admin install doc?

Thanks for sharing your info.


Josh

[Sinmedia]

For some reason, the images are pointed to incorrect directories...

example (image properties):

http://www.sinmedia.net/admin/catalog/images/category_hardware.gif

When it should be:

http://www.sinmedia.net/catalog/images/category_hardware.gif

But the directory variables in account_top.php is set correctly, to my knowledge...

define('HTTP_SERVER', 'http://www.sinmedia.net/');
define('DIR_FS_DOCUMENT_ROOT', '/home/sinmedia/public_html/'); // where your pages are located on the server.. needed to delete images.. (eg, /usr/local/apache/htdocs)
define('DIR_FS_LOGS', '/home/sinmedia/public_html/exchange_logs/');
define('DIR_WS_ADMIN', 'admin/');
define('DIR_WS_CATALOG', 'catalog/');
define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG);
define('DIR_WS_IMAGES', DIR_WS_ADMIN . 'images/');
define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/');
define('DIR_WS_INCLUDES', 'includes/');
define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/');
define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/');

I'm not sure why the program is messing up the directory addresses...

[Sinmedia]

Figured out the image problem. really dumb mistake on my part.

Now, all that's left is the 'chown' command on the catalog images directory!

[Damian]

Okay I have a question. After you setup the shopping cart and all that and you get somebody to buy something -- where is the credit card number stored (security concerns) and how do you get it to the bank for payment?

Any help on this will be greatly appreciated as I'm looking to launch a basic e-commerce site very shortly.

W

[Sinmedia]

I'm guessing the cc info will be in the payment processing provider's dbase? (secure server), or If you have a secure server, you can implement it through PHP (This is advanced stuff... I have no clue).

As far as I can tell, TEP is ideal for mid-large size stores. If you're setting up a 'basic' store, all the PHP and code might be overkill. There are far easier cart programs to use out there for small stores. Much less headache.

My 2 cents.

[DomeTasking]

Thanks guys! Without this thread i could have not found OSC. I thinks it's great! It has opened new doors to me thanks!