error

i am trying to store the values in the database but its showing the error ''Object of class PDOStatement could not be converted to int in C:\xampp\htdocs\payment\thankyou.php on line 51'' below is my code

try {
    $response = $api->paymentRequestStatus($payid);


    $payment_ID = $response['payments'][0]['payment_id'];
    $status =$response['status'];
    $Type =$response['payments'][0]['status'];

    $query = $connect->query("SELECT * FROM payment_done where payment_ID = '$payment_ID' ");

    //echo "RowCount:".mysql_num_rows($query);
    if($query  == 0){

    $result = $connect->query("INSERT INTO `payment_done`(`payment_ID`, `status`, `Type`) VALUES('$payment_ID ', '$status', '$Type')");
   

    if($result){
       
        echo 1;
        } else{
       
        echo "Something went wrong. Try again";
    }
  }
ram sAsked:
Who is Participating?
 
NerdsOfTechConnect With a Mentor Technology ScientistCommented:
try {
    $response = $api->paymentRequestStatus($payid);


    $payment_ID = $response['payments'][0]['payment_id'];
    $status =$response['status'];
    $Type =$response['payments'][0]['status'];

    $query = $connect->query("SELECT * FROM payment_done where payment_ID = '$payment_ID' ");

    //echo "RowCount:".mysql_num_rows($query);
    if(mysql_num_rows($query)  == 0){ // this was the problem //

    $result = $connect->query("INSERT INTO `payment_done`(`payment_ID`, `status`, `Type`) VALUES('$payment_ID ', '$status', '$Type')");
    

    if($result){
        
        echo 1;
        } else{
        
        echo "Something went wrong. Try again";
    }
  }

Open in new window

0
 
Hasin Ahmed ChoudharyExchange AdministratorCommented:
I have modified the topics, that will widen the audience. Hope someone assist you on it.
0
 
ram sAuthor Commented:
thank you
0
 
NerdsOfTechTechnology ScientistCommented:
Corrected logic error.
0
All Courses

From novice to tech pro — start learning today.