I’m trying grab and insert into a mysql database table some users info when they sign up using ccbill. here’s what i’m using…can someone direct me to some sources or help fix this. I’m willing to pay someone who can write one that works.
basically…i’m trying to do a postback with ccbill.
<?php
### LISTING OF ipn.php
define ("DBHOST", "localhost");
define ("DBNAME", "mydb");
define ("DBUSER", "myuser");
define ("DBPASS", "mypass");
### CONNECT TO THE DATABASE
function DatabaseConnect() {
if (!($mylink = mysql_connect(DBHOST, DBUSER, DBPASS))) {
echo mysql_error();
exit;
} //fi
mysql_select_db(DBNAME) or die(mysql_error());
} // end function
DatabaseConnect(); // this will automatically connect us
// below supported vals that CC Bill posts to us, this list is exhaustive.. but
// without notify_version and verify_sign NOTE: if in is not in this array, it
// is not going in the database.
$ccbill_vals = array("customer_fname", "customer_lname", "email",
"username", "password", "price", "start_date", "phone_number"
);
// build insert statement
while (list ($key, $value) = each ($HTTP_POST_VARS)) {
if (in_array ($key, $ccbill_vals)) {
if (is_numeric($value)) {
$addtosql .= " $key=$value,";
} else {
$newval = urlencode($value);
$topost .= "&$key=$newval"; //used later in reposting
$value = addslashes($value);
$addtosql .= " $key='$value',";
} //fi
} //fi
$entirepost .= "[$key]='$value',";
} //wend
$entirepost = addslashes($entirepost); // just in case..
$addtosql = substr("$addtosql", 0, -1).";"; //chop trailing "," replace with ";"
$sql1 = "
INSERT INTO users
SET date=now(), entirepost='$entirepost',". $addtosql;
mysql_db_query(DBNAME, $sql1) or die($sql1);
} //fi
### END LISTING OF ipn.php
?>- Admin > wacked it in a
tagg for you <!-- s:) --><img src="{SMILIES_PATH}/icon_smile.gif" alt=":)" title="" /><!-- s:) -->