I have been searching around this forum, and while I have found similar questions that have already been answered, I am still struggling to figure this out (as always, I'm a complete newbie and need clear explanations).
In my database, I have tables users.db (userId, mmbrship, mmbrship_date) with a few more values but the ones I need to update are mentioned above.
Additionally, there is a payments.db ( id, txnid, payment_amount, payment_status, itemid, createdtime )
Within my functions.php file, I have the following code:
function updatePayments($data){
global $link;
if(is_array($data)){
$sql = mysql_query("INSERT INTO `payments` (txnid, payment_amount, payment_status, itemid, createdtime) VALUES (
'".$data['txn_id']."' ,
'".$data['payment_amount']."' ,
'".$data['payment_status']."' ,
'".$data['item_number']."' ,
'".date("Y-m-d H:i:s")."'
)", $link);
return mysql_insert_id($link);
}
}
My goal is to insert the values 'itemid' and 'createdtime' from payments.db into users.db in the columns 'mmbrship' and 'mmbrship_date'
Furthermore, I also need to add the 'userId' from users.db to payments.db (in order to link the user to their purchase).
This will allow me to check the users.db for information on whether a member has paid their membership fee. Currently, the payments.db inserts its own id, so connecting these two tables with the userId seems like a step in the right direction...
? Any assistance would be greatly appreciated :)