I would like the current value in database in column mass_reach to be added with the new value under variable name $newmass (a constant figure). I created a double barrel loop below to extract what value is current then add it and update the value in second loop but cant seem to get this going.
if(isset($_POST['mass_reach'])){
$massreach = $_POST['mass_reach'];
foreach ($massreach as $massreach_id) {
$query4 = "SELECT mass_reach FROM coaches WHERE id='{$massreach_id}'";
$result4 = mysqli_query($con, $query4);
$query2 = "UPDATE coaches SET mass_reach='{$newmass}'+'{$result4}' WHERE id='{$massreach_id}'";
$result = mysqli_query($con, $query2);
}
}
I am getting the error: I get the error: Catchable fatal error: Object of class mysqli_result could not be converted to string in line 8 ie
$query2 = "UPDATE coaches SET mass_reach='{$mass}'+'{$result4}' WHERE id='{$massreach_id}'";
function get_string_between($string, $start, $end){
$string = " ".$string;
$ini = strpos($string,$start);
if ($ini == 0) return "";
$ini += strlen($start);
$len = strpos($string,$end,$ini) - $ini;
return substr($string,$ini,$len);}
foreach ($mass_reach as $string) {
$c_id = get_string_between($string,"[","]");
$c_mass = get_string_between($string,"(",")");
$query2 = "UPDATE coaches SET mass_reach='{$mass}' + '{$c_mass}' WHERE id='{$c_id}'";
$result2 = mysqli_query($con, $query2);
}