Debug School

rakesh kumar
rakesh kumar

Posted on • Updated on

Error: array to string conversion in php

array to string conversion in php is solved by encode array to json string then store data

my code is

["influencer_name"] => array(4) {
[0] => string(4) "Amit"
[1] => string(6) "Roshan"
[2] => string(6) "Roshan"
[3] => string(16) "Roshan kumar jha"
}

Image description

when i store i got error

$sql = "INSERT INTO `payment_paytm`(payment_id,influencer_admin_id,amount,payment_status,admin_id,user_name,Pay_date,org_slug,admin_email,influencer_email,influencer_name) VALUES('$ORDER_ID','$influencer_admin_id','$TXN_AMOUNT','approved','$admin_id','$user_name', '$create_date','$org_slug','$EMAIL', '$influencer_email', '$name')";
    $result = $con->query($sql);
Enter fullscreen mode Exit fullscreen mode

Solution

   $influencer_email_json = $_POST['influencer_email'];
    $influencer_email = json_encode($influencer_email_json);
$influencer_admin_ids = $_POST["influencer_admin_id"];
$influencer_admin_id = json_encode($influencer_admin_ids);
Enter fullscreen mode Exit fullscreen mode 
$sql = "INSERT INTO `payment_paytm`(payment_id,influencer_admin_id,amount,payment_status,admin_id,user_name,Pay_date,org_slug,admin_email,influencer_email,influencer_name) VALUES('$ORDER_ID','$influencer_admin_id','$TXN_AMOUNT','approved','$admin_id','$user_name', '$create_date','$org_slug','$EMAIL', '$influencer_email', '$name')";
    $result = $con->query($sql);    
}
Enter fullscreen mode Exit fullscreen mode

output

Image description

Top comments (0)

Read next

suyash profile image

Resource utilization in Linux

Suyash Sambhare -

suyash profile image

Install PostgreSQL on OpenShift

Suyash Sambhare -