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"
}
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);
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);
$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);
}
output
Top comments (0)