Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

EasyPHP and Oscommerce


JoeKool

Recommended Posts

Posted

I have just installed easyphp, and my first question is when I start it a screen comes up with language.txt with a check box next to it, and under that easyphp.exe with a check box next to it, and there is by default a ckeck in the box next to easyphp, and I just press ok, and it gives me a error, and then the screen is gone, and I get the blinking red light in the lower left like I should be?? My other question is how and where to put my oscommerce files, I have read some stuff saying to put certain files in certain places although Im still not fully clear. From the very start I have a zipped file, and should I extract it to the "ww" folder, or do I just extract it, then move certain files and folders to this "www" folder???

Posted

Not sure about the problem you are having. I don't think I have seen that screen but as for where to put the files it is in the www folder under easyphp in your programs directory.

 

How you do it is up to you but you need to end up with everything that is inside the catalog folder in the osCommerce zip inside the www folder in the same way it is in the catalog folder.

There are extra things inside the zip you do not need to put in the www folder.

Wendy James

 

Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Posted

Ok I have got that far now. I read a post of yours that says to create a database using easyphp. How do I do that, when I start easyphp I get the error I told you about then a screen that shows that Apache and MySQL are started, and thats it.

Posted

Ok I created a database with php admin and now how/where do I setup a user name and password, right after I setup the database name, it says there are no tables and asks for name and fields

Posted

Ok I think what you posted before meant that I dont need to setup another user because there is one already there called root. So from there you say to start the install, well I open "www" and in there is the folder oscommerce... and in that is the catalog folder and so on, is this an ok way for thoose files to be stored? Becides the folders inside oscommerce.. folder, there are files like readme and others, and all of them have that icon look to them that means they dont know what program to open with, if you could please tell me what Im doing right and worng here thankx.

Posted

I've never been impressed with Easy PHP. You may not want to hear this but my advice is to uninstall it and install XAMPP instead - it's much more up to date and has a wider array of features. The install is dead easy - it doesn't get any easier.

 

After the install, go to http://localhost and you'll have the option by clicking one button, of setting up your security features. It also comes equipped with FileZilla (FTP Client), and its own Mail Client.

 

The address:

 

http://www.apachefriends.org/en

 

Vger

Posted

Ok saying I go with this program you are talking about, does it have included the same programs that easyphp does, because so far it seems like I need php to do modifications to oscommerce. Also could you answer the rest of my last post which talks about where my fils are and why they dont know what program to open with. So after I install the program you are tlaking about how do I finish the install? Thankx for everyones help so far on this

Posted

XAMPP has absolutely everything you need, and even has two versions of PHP - 4.3.11 and 5.0.3 - which you can switch between via the XAMPP control panel.

 

Once you've installed it load the osCommerce 'catalog' folder into the c:/apachefriends/xampp/htdocs folder.

 

Then go to http://localhost/phpmyadmin and create a blank database.

 

Then go to http://localhost/catalog/install and begin the install procedure.

 

Further info on the install can be found by reading the 'Quick Install Guide' link below my name.

 

Vger

Posted

Looks like you are switching to xampp so for anyone else that reads this and wants to know

 

you put the contents of the catalog folder in your www folder, not the whole oscommerce... although you can. Just easier if you put just what you need.

 

To install osCommerce you just have to get to the install. If you have the contents of the catelog folder in your www you just put

http://localhost/install although it sometimes opens right to it without typing the install if you haven't previously installed.

 

User for the database when entering the information during install.

Server is Localhost

user is root

no password

Wendy James

 

Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Posted

Thankx again both of you for all your help, Im sure I will build some more questions in the coming days as I put all this together.

Posted

Ok I went through all the XAMPP setup, and created a blank database, and set up my securities. Now I was reading this quick install by Vger and I dont understand how to do step 4, do I use phpmy admin for this???

 

4. Make sure that the permissions on all of the folders are set to 755, and if that does not work then set them to 777. Make sure that the includes/configure.php file and the admin/includes/configure.php file are set to 777 for the duration of the install. Once the install is complete reset to 644, 444, or 400 depending on your server setup.

Posted

I thought mabey I suppose to go to //localhost/catalog/admin/includes/configure.php

when I do that it says access forbidden

when I go to //localhost/catalog/includes/configure.php

it just gives me a blank screen and says nothing at all. Could someone please tell me what I might be doing wrong, all I want to do is to be able to change permissions for files and folders.

Posted

Wish I could help but I know nothing about xampp.

Wendy James

 

Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Posted

Does anyone know what I did wrong????????

 

 

Warning: fopen(D:/Chris\\\'s Program files/xampp-win32-1.4.15/xampp/htdocs/catalog/includes/configure.php) [function.fopen]: failed to open stream: No such file or directory in D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\catalog\install\templates\pages\install_7.php on line 209

 

Warning: fputs(): supplied argument is not a valid stream resource in D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\catalog\install\templates\pages\install_7.php on line 210

 

Warning: fclose(): supplied argument is not a valid stream resource in D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\catalog\install\templates\pages\install_7.php on line 211

 

Warning: fopen(D:/Chris\\\'s Program files/xampp-win32-1.4.15/xampp/htdocs/catalog/admin/includes/configure.php) [function.fopen]: failed to open stream: No such file or directory in D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\catalog\install\templates\pages\install_7.php on line 259

 

Warning: fputs(): supplied argument is not a valid stream resource in D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\catalog\install\templates\pages\install_7.php on line 260

 

Warning: fclose(): supplied argument is not a valid stream resource in D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\catalog\install\templates\pages\install_7.php on line 261

The configuration was successful!

 

 

 

Or does this mean I did it right????

then when I go to..../catalog/admin/index.php

it gives me this message

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mysql'@'localhost' (using password: NO) in D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\catalog\admin\includes\functions\database.php on line 19

Unable to connect to database server!

 

And when I go to the catalog, it takes me back to the first page of the install again..Any help here would be great thankx

Posted

That error message means that the configure.php files were not writeable at the time of the install, and this leads to another error with the mysql. The default mysql User Name is root, plus whatever password you set up for mysql access via security settings.

 

I don't know why you are getting this pathway:

D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\

 

It would normally be c:\apachefriends\xampp\htdocs\ - and the auto-install would set it up this way, unless you altered it.

 

The fact that the configure.php files were not writeable means you will have to edit them manually.

 

http_server = http://localhost

http_cookie_domain = localhost

http_catalog = /catalog/

DIR_FS_ROOT = D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\

 

I would look into how it (XAMPP) got installed in that way, because I think you'll make problems for yourself in the future if it's not installed correctly.

 

Vger

Posted

I thought mabey Im suppose to go to //localhost/catalog/admin/includes/configure.php

when I do that it says access forbidden

when I go to //localhost/catalog/includes/configure.php

it just gives me a blank screen and says nothing at all. Could someone please tell me what I might be doing wrong. I just need to know how to be able to edit these files.

Posted

You do not go directly to those pages, You have to edit them in some type of text editer.

Wendy James

 

Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Posted

Ok I edited both my configure files, and tried going to .../catalog/admin/index.php

and its looking alot better now, the only problem now is this message.

 

Parse error: parse error in D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\catalog\admin\includes\configure.php on line 20

 

Could anyone tell me what this means, and perhaps tell me how to count lines to fine where this is. Getting closer thankx again for everyones help, when this thread is done it should serve to be a good one for people to find alot of beginner info.

Posted

Counting lines...

Open up the file in any editer and count down.

Many editers come with line numbers on the side so you don't have to do this.

 

If you post your code here without the database information I am sure someone could point out the problem for you. Don't just post line 20 as the error could be above it. Making line 20 have a problem.

Wendy James

 

Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.

Posted

Well I made the sugessted changes, and now my error is this.

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mysql'@'localhost' (using password: NO) in D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\catalog\admin\includes\functions\database.php on line 19

Unable to connect to database server!

 

<?php

/*

$Id: database.php,v 1.23 2003/06/20 00:18:30 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

Copyright © 2003 osCommerce

Released under the GNU General Public License

*/

function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') {

global $$link;

if (USE_PCONNECT == 'true') {

$$link = mysql_pconnect($server, $username, $password);

} else {

$$link = mysql_connect($server, $username, $password);

}

if ($$link) mysql_select_db($database);

return $$link;

}

function tep_db_close($link = 'db_link') {

global $$link;

return mysql_close($$link);

}

function tep_db_error($query, $errno, $error) {

die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>');

}

function tep_db_query($query, $link = 'db_link') {

global $$link, $logger;

if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) {

if (!is_object($logger)) $logger = new logger;

$logger->write($query, 'QUERY');

}

$result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error());

if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) {

if (mysql_error()) $logger->write(mysql_error(), 'ERROR');

}

return $result;

}

function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') {

reset($data);

if ($action == 'insert') {

$query = 'insert into ' . $table . ' (';

while (list($columns, ) = each($data)) {

$query .= $columns . ', ';

}

$query = substr($query, 0, -2) . ') values (';

reset($data);

while (list(, $value) = each($data)) {

switch ((string)$value) {

case 'now()':

$query .= 'now(), ';

break;

case 'null':

$query .= 'null, ';

break;

default:

$query .= '\'' . tep_db_input($value) . '\', ';

break;

}

}

$query = substr($query, 0, -2) . ')';

} elseif ($action == 'update') {

$query = 'update ' . $table . ' set ';

while (list($columns, $value) = each($data)) {

switch ((string)$value) {

case 'now()':

$query .= $columns . ' = now(), ';

break;

case 'null':

$query .= $columns .= ' = null, ';

break;

default:

$query .= $columns . ' = \'' . tep_db_input($value) . '\', ';

break;

}

}

$query = substr($query, 0, -2) . ' where ' . $parameters;

}

return tep_db_query($query, $link);

}

function tep_db_fetch_array($db_query) {

return mysql_fetch_array($db_query, MYSQL_ASSOC);

}

function tep_db_result($result, $row, $field = '') {

return mysql_result($result, $row, $field);

}

function tep_db_num_rows($db_query) {

return mysql_num_rows($db_query);

}

function tep_db_data_seek($db_query, $row_number) {

return mysql_data_seek($db_query, $row_number);

}

function tep_db_insert_id() {

return mysql_insert_id();

}

function tep_db_free_result($db_query) {

return mysql_free_result($db_query);

}

function tep_db_fetch_fields($db_query) {

return mysql_fetch_field($db_query);

}

function tep_db_output($string) {

return htmlspecialchars($string);

}

function tep_db_input($string) {

return addslashes($string);

}

function tep_db_prepare_input($string) {

if (is_string($string)) {

return trim(stripslashes($string));

} elseif (is_array($string)) {

reset($string);

while (list($key, $value) = each($string)) {

$string[$key] = tep_db_prepare_input($value);

}

return $string;

} else {

return $string;

}

}

?>

 

 

Any ideas???

Posted

Hi,

 

I have the same problem,

resolve you your problem?

 

Please I ned urgent help

 

Thank you

from Spain

 

 

 

Well I made the sugessted changes, and now my error is this.

 

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'mysql'@'localhost' (using password: NO) in D:\Chris's Program files\xampp-win32-1.4.15\xampp\htdocs\catalog\admin\includes\functions\database.php on line 19

Unable to connect to database server!

 

<?php

/*

  $Id: database.php,v 1.23 2003/06/20 00:18:30 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions

  http://www.oscommerce.com

  Copyright ? 2003 osCommerce

  Released under the GNU General Public License

*/

  function tep_db_connect($server = DB_SERVER, $username = DB_SERVER_USERNAME, $password = DB_SERVER_PASSWORD, $database = DB_DATABASE, $link = 'db_link') {

    global $$link;

    if (USE_PCONNECT == 'true') {

      $$link = mysql_pconnect($server, $username, $password);

    } else {

      $$link = mysql_connect($server, $username, $password);

    }

    if ($$link) mysql_select_db($database);

    return $$link;

  }

  function tep_db_close($link = 'db_link') {

    global $$link;

    return mysql_close($$link);

  }

  function tep_db_error($query, $errno, $error) {

    die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>');

  }

  function tep_db_query($query, $link = 'db_link') {

    global $$link, $logger;

    if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) {

      if (!is_object($logger)) $logger = new logger;

      $logger->write($query, 'QUERY');

    }

    $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error());

    if (defined('STORE_DB_TRANSACTIONS') && (STORE_DB_TRANSACTIONS == 'true')) {

      if (mysql_error()) $logger->write(mysql_error(), 'ERROR');

    }

    return $result;

  }

  function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') {

    reset($data);

    if ($action == 'insert') {

      $query = 'insert into ' . $table . ' (';

      while (list($columns, ) = each($data)) {

        $query .= $columns . ', ';

      }

      $query = substr($query, 0, -2) . ') values (';

      reset($data);

      while (list(, $value) = each($data)) {

        switch ((string)$value) {

          case 'now()':

            $query .= 'now(), ';

            break;

          case 'null':

            $query .= 'null, ';

            break;

          default:

            $query .= '\'' . tep_db_input($value) . '\', ';

            break;

        }

      }

      $query = substr($query, 0, -2) . ')';

    } elseif ($action == 'update') {

      $query = 'update ' . $table . ' set ';

      while (list($columns, $value) = each($data)) {

        switch ((string)$value) {

          case 'now()':

            $query .= $columns . ' = now(), ';

            break;

          case 'null':

            $query .= $columns .= ' = null, ';

            break;

          default:

            $query .= $columns . ' = \'' . tep_db_input($value) . '\', ';

            break;

        }

      }

      $query = substr($query, 0, -2) . ' where ' . $parameters;

    }

    return tep_db_query($query, $link);

  }

  function tep_db_fetch_array($db_query) {

    return mysql_fetch_array($db_query, MYSQL_ASSOC);

  }

  function tep_db_result($result, $row, $field = '') {

    return mysql_result($result, $row, $field);

  }

  function tep_db_num_rows($db_query) {

    return mysql_num_rows($db_query);

  }

  function tep_db_data_seek($db_query, $row_number) {

    return mysql_data_seek($db_query, $row_number);

  }

  function tep_db_insert_id() {

    return mysql_insert_id();

  }

  function tep_db_free_result($db_query) {

    return mysql_free_result($db_query);

  }

  function tep_db_fetch_fields($db_query) {

    return mysql_fetch_field($db_query);

  }

  function tep_db_output($string) {

    return htmlspecialchars($string);

  }

  function tep_db_input($string) {

    return addslashes($string);

  }

  function tep_db_prepare_input($string) {

    if (is_string($string)) {

      return trim(stripslashes($string));

    } elseif (is_array($string)) {

      reset($string);

      while (list($key, $value) = each($string)) {

        $string[$key] = tep_db_prepare_input($value);

      }

      return $string;

    } else {

      return $string;

    }

  }

?>

Any ideas???

Posted

Yes, I didnt have this bottom portion of both my configure.php files filled in.

 

 

define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', '*****');

define('DB_SERVER_PASSWORD', '*******');

define('DB_DATABASE', '*****')

Posted

Dear Friend:

 

Thank you, thank you very much

 

I have this lines, but the password and user are changed, and I don?t now

 

I resolve whit the user and password

 

Thank you again.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...