Easy way to add Clickbank products to website?

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
nparekh
Forum Commoner
Posts: 31
Joined: Fri Aug 05, 2005 2:35 am

Easy way to add Clickbank products to website?

Post by nparekh »

Hi guys,

I am trying to work out whether theres a way to create a php script that would reside on my site so that I can maximise my earnings (in the event people don't purchase my product)

For example - I have my own software which I use to assist people increase their value of their homes. If the person doesn't buy my particular product I would like to be able to promote an affiliate product from clickbank or other affiliate programs.

What I was thinking of was some type of MySQL database with

1) products
2) pictures(if any)
3) category/keywords

Then based on the particular topic (foreclosure, or no money down strategies for real estate etc) the site will display the picture and product with my affiliate id?

With clickbank the user id is the same so is there any way I could automate this?

Thanks in advance

Nikhil
User avatar
William
Forum Contributor
Posts: 332
Joined: Sat Oct 25, 2003 4:03 am
Location: New York City

Post by William »

So if somone uses your product without paying for it you want it to show a affiliates product on your software from a database on your site?
nparekh
Forum Commoner
Posts: 31
Joined: Fri Aug 05, 2005 2:35 am

Post by nparekh »

Hi William

Thanks for your help so far!! Its really appreciated.

What I am looking for is something to create another stream of income for my website. If the visitor doesn't buy my product, I'd still like to get them to click on an affiliate link of a product -that way I still might get a sale even though its not my product.

What I was hoping for was a way to have a database created with affiliate programs with product names, pictures and a default keyword category.

In my case I would like it to pull "real estate" keyword products onto my site dynamically. If I had 5 real estate products in the database then it would rotate when visitors arrived at my site, alternating between the affiliate products for different visitors. Eg. visitor 1 would see affiliate product "real estate" 3, visitor 2 would see affiliate product "real estate" 5 etc

Hope you can shed some light.

Thanks so much

Nikhil
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

you can pull the information you want displayed out of your database and throw it into an array, then use array_rand() to display them randomly.

after you have them displayed, you can use those links to send to an intermediate page on your site that captures the "hit" and saves it into your database, then redirects the user to the appropriate page.

I will warn you however, there are a lot of very reputable affilate programs already out there which most saavy customers should consider before "trusting" your system to catch and count hits to their site. I'm certainly not saying you're not trustworthy, but if I have to pay for clicks, I'd want to make sure I'm paying for legitimate clicks.
nparekh
Forum Commoner
Posts: 31
Joined: Fri Aug 05, 2005 2:35 am

Post by nparekh »

Hi Burrito

I appreciate your post and I understand your point of view.

I do not get paid for clicks so its not an issue as I only get paid for leads or sales. I was looking to maximise leads/revenue from my site as I only convert about 0.5-1% of visitors to actual sales. I do feel however that if I can get them to visit a related affiliate program then I can get a further sale (potentially). Maximise efforts rather than only hope for the one off sale.

Could you possibly point me in the direction of how I would get database data out into an array - I will investigate the array_rand() code.

Also coud you advise how I would get the "hit" saved into a database?

Any ideas would really be welcomed.

Regards,

Nikhil
josh
DevNet Master
Posts: 4872
Joined: Wed Feb 11, 2004 3:23 pm
Location: Palm beach, Florida

Post by josh »

How to get an array:
first use mysql_query() to get a result set in $result, then do something like:

Code: Select all

$array=array();
while( $row = mysql_fetch_array($result, MYSQL_ASSOC) ) {
      $array[]=$row;
}
Post Reply