<?php

global $wpdb;

$table_name = $wpdb->prefix . 'siab_customer_purchase_credits'; 

global $wpdb;

$purchase_id = $wpdb->get_col("SELECT id FROM $table_name WHERE gf_form_id=13 ");

if (!empty($purchase_id)) {
    foreach ($purchase_id as $id) {
        $credits = $wpdb->get_var("SELECT credits FROM $table_name WHERE id = 2");
        $start_credits = $wpdb->get_var("SELECT start_credits FROM $table_name WHERE id = 2");

        if ($credits !== null) {
			if($start_credits==1)
			{
				$new_credit = $credits + 1;
				$data = array('credits' => $new_credit);
				$where = array('id' => $id,'start_credits' => 1);
			}
			else if($start_credits==5)
			{
				$new_credit = $credits + 5;
				$data = array('credits' => $new_credit);
				$where = array('id' => $id,'start_credits' => 1);
			}
			else if($start_credits==10)
			{
				$new_credit = $credits + 10;
				$data = array('credits' => $new_credit);
				$where = array('id' => $id,'start_credits' => 10);
			}
           

            $updated = $wpdb->update($table_name, $data, $where);

            if ($updated !== false) {
                echo "updated successfully!<br>";
            } else {
                echo "Error updating <br>";
            }
        } else {
            echo "Not found.<br>";
        }
    }
} else {
    echo "False.";
}



?>