Installing on Windows Web Server

PHP-eSeller and PHP-KeyCodes can both be installed on a Windows Web Server which runs PHP and has a mySQL database.  This is quite a common arrangement now, and many hosting companies provide this, enabling PHP applications to be installed on Windows Web Servers. 

Both of the applications work fine on Windows servers and normally work straight out of the box installation.

The only possible issue is sending emails.  Both applications need to send out emails from the server and this can be done by configuring PHP-eSeller and PHP-KeyCodes to use SMTP if the standard PHP email has not been set up.  This requires minor configuration changes to the config file which means entering the SMTP host, username, password.  All of these details should be available from your web site host if you donot know them.

You do not have to use the web server SMTP details, you can use an external SMTP mail service such as http://www.authsmtp.com.  Sometimes, these provide a better mail service than your host and may be more reliable.

Can different applications use the one PayPal IPN account

Can I use the same PayPal account for different PayPal applications.

Yes you can. The way you do it is to pass the url of the IPN script in the purchase button using the notify_url field.  PHP-eSeller, PHP-SecureArea and PHP-KeyCodes are all able to operate on the same PayPal account because they all send the IPN confirm url within the button.  This means that if you an application that uses your IPN PayPal account, you can still use withinweb.com applications on your site. 

In fact, withinweb.com applications create the and post the data to PayPal dynamically.  The relevant information is extracted from the database and, collected together and then posted to PayPal.  This method means that you can control the data centrally using the admin panel.

Extracting data from myPHPAdmin

A question I am often asked is how can I create better reports from the data that is in the mySQL database for transactions processed by PHPeSeller or by PHPSecureArea.  Both of these have sales history displays but you may wish to process the data in another application such as MS Excel or MS Access.

One approach is to extract the data from mySQL using your web server control panel.  Login into the control panel of your server and find the section that deals with mySQL.  You should have a link to myPHPAdmin or a similar database tool.

Navigate to the correct database in myPHPAdmin.  Navigate to the table that you want to export and at the top of the page you should see an EXPORT tab.  Click on this.  You will need to select a particular format for the export. This is normally CSV for Excel or CSV.  CSV stands for Comma Separted Values and is a very common method of transfering data to and from different application.  That should then allow you to download the file which can then be opened in your required application.

Using other flash mp3 clip players in PHP-eSeller

PHP-eSeller comes with a number of flash mp3 preview buttons.  You can use other mp3 preview buttons if you want, but the integration does depend on how the other flash mp3 buttons are configured.

We have documented a number of mp3 buttons with the required code to enable them to be intergrated into the template system.

http://www.withinweb.com/phpeseller/flash_mp3_buttons.php

Embedding Google News into Your Layout

Google is always coming out with some great web site enhancements.  One new tool they are providing for free, for any webmaster out there to use is the NewsShow Wizard.  It allows you to embed your own Google News widget into your web site on any topic you might have in mind.

All you need to do is step through the wizard, customizing your news as you want it to be seen on your web site.  You can pick from a 728×90 leader board or a 300×250 medium square to display the news from. 

So take a look at this if you need something to replace that white space in your web site’s side bar or if you just want a little more interactivity on your web site.

Posted in SOE

How do I change the language code for PayPal?

The language code for the PayPal site is defined in the button using a hidden field.

So for English language use
<input type=’hidden’ name=’lc’ value=’US’ />

Possible values are France(FR), Spain (ES), Italy (IT), Germany (DE), China (CN), English (US).

The customer should hopefully see the login page in the defined language.

To change the language code, go to the file ipnfunction.php open in a text editor and you should see the default language code of
<input type=’hidden’ name=’lc’ value=’US’ />

Change the value to what ever code you require and upload the file back to your server.

Creating a mySQL Database in cPanel (new style)

Log in to your Cpanel

Log into cPanel and click on the mySQL database link.

Create A New Database

Scroll down to where it says ‘new database’ and enter your choosen database name in the field and click on ‘Create Database’

MySql Account Maintenance Page 

Each step in the process will take you back and forth to the mySQL Maintenace page to verify that you have set up the process correctly and you will be able to see the information you have created.

Here you will see you have added the database.

Click on the Go Back button.

Enter Username and Password

Scroll down to username and password and enter your information.  Click on create user.

Back to MySql Account Maintenance Page 

The username and password have been created for you database.  Click on the Go Back button to return.

Add username to database

Scroll down to add users to your databases.

If there are no users or databases previously created you will only see one in each selection.

Choose the username that you want to add.  Note that the username previously created “myusername” has been shortened to “myusern”  This is the name that you need to use in the config.php file. 

Example: “vonnamia_myusern” not “vonnamia_myusername”

Select the Database you created from the list.

Select the Checkbox “All Privileges”.

Click Add User To Database

MySql Account Maintenance 

This will take you back to the MySql Account Maintenance page for verification, you will see the shortened Username there.

Click on the Go Back button and you will see the contents of your finished Database.

Running the install.php file

At this point you have created the database, created a user and allocated the user to the database.

You can now create the tables using the install.php script supplied with the zip file.

You will need to have the following information available :

database name
database username
database password
database host (usually local host but refer to your host documentation if you are not sure)

When you run the install.php file in your browser you will be presented with boxes as follows :

Create a mySQL database with GoDaddy hosting

This describes creating a database with GoDaddy hosting

First, start by logging into your GoDaddy account:

Click on my hosting account (dropdown under “hosting”)

Click on “manage account” under the correct hosting account domain

Once you’re in the “hosting control center” click on “mysql” from the “databases” dropdown menu

Click the “create database” button

Choose MySQL version 4 or 5, and then enter a description (can be anything), database/user name (must be very unique, or you’ll have to try again), and password (must use at least one capital letter and a number)

(NOTE: you may have to wait 5-10 minutes while the database is setup )

Click the little pencil icon to edit/view database details

Write down or copy the “Host Name:” this will go in the wp-config.php file in place of “localhost”

In your web browser, go to the installation script install.php and fill in the details: