I need help super badly....it's been 2 months and I'm tired of watching sales go out the door...so if anyone can help if would be so much appreciated~ =)

I am trying to hook CCBill's Datalink up to work with my classified script so that I can charge per advertisement posting.

What is needed is for the communication between my database and ccbills so that the memeber login and password are updated after the sale.

I have had to create a cron job. That part is done.
I also had to create a datalink on ccbillls site. That part is done.

I NEED SO BADLY to know WHAT to ad in my .php script so that it gets the information from my Datalink URL and knows what to and how to add it to Mysql.

This is what I have so far in my script:

<?php
# host name:

$host_name="localhost";

# user's name:

$db_user="PRIVATEUSER";

# user's password:

$db_password="PRIVATEINFO";

# name of database table for ads:

$table_ads="PRIVATETABLENAME";

include_once "https://datalink.ccbill.com/data/main.cgi?startTime=20050115010305&endTime=20050115102334&transactionTypes=NEW&clientAccnum=PRIVATEINFO&username=PRIVATEINFO&password=PRIVATEINFO&testMode=1" 

?>

*I've subsituted "PRIVATE INFO" for my actual personal information.

Thanks for your time....so excited to hear suggesstions!

Bye for now,
glamorize

    What Am I Doing Wrong?

    My records are NOT updating/copying to MySQL

    Please help me. Thanks in advance.

    include('https://datalink.ccbill.com/data/main.cgi?startTime=20050115010305&endTime=20050115102334&transactionTypes=NEW&clientAccnum=PRIVATE&username=PRIVATE&password=PRIVATE&testMode=1'); 

$table_variables = array('customer_lname', 'customer_lname', 'email', 'username', 'password', 'price', 'start_date', 'phone_number'); 

$name = $_REQUEST ['customer_lname'];
$email = $_REQUEST ['email'];
$username = $_REQUEST ['username'];
$password = $_REQUEST ['password'];
$productDesc = $_REQUEST ["productDesc"];
$price = $_REQUEST ['price'];
$subscription_id = $_REQUEST ['subscription_id'];
$clientAccnum = $_REQUEST ['clientAccnum'];
$clientSubacc = $_REQUEST ['clientSubacc'];

$insert = "INSERT INTO almclmb8 ('customer_lname', 'email', 'username', 'password', 'price', 'start_date', 'phone_number')
VALUES ('".$name."','".$email."','".$username."','".$password."','".$productDesc."','".$price."','".$subscription_id."','".$clientAccnum."','".$clientSubacc."')";
      Write a Reply...