Upload errors in PHP

Question

I used the variables you gave me regarding... previous question

 $praBanco .=" '".$file_destination."', ";

 for ($x = 1; $x <=$quantColunas; $x++) {
    $colunas.=" ads_image_".$x." = ";
 } 

 $praBanco = substr($praBanco,0,-1); 
 $colunas = substr($colunas,0,-1);

$colunas and $praBanco

The problem is... It does not update because I think something is wrong regarding the update entry.

 $smtp_process = "UPDATE public_ads SET ads_title = '$ads_title', ads_content = '$ads_content', ads_price = '$ads_price', edit_attempts = edit_attempts + 1, $colunas = '$praBanco' WHERE ads_id = '$editor_id'"; 
 $smtp_request_query = $con->query($smtp_process);

But... it does not update or show errors...

I think it’s about this: $colunas = '$praBanco'

The goal is that it add in the Database the path of the uploaded images. As was done in INSERT, click now UPLOAD.

Answer 1

As you already have $colunas and $praBanco can loop and concatenate the values respectively of the elements of the arrays returned by the function explode of PHP

$explodeColunas = explode(',', $colunas);

$explodePraBanco = explode(',', $praBanco);

for($i = 0; $i<count($explodeColunas); $i++){

    $paraUpadate .= $explodeColunas[$i]."=".$explodePraBanco[$i].",";

}

//para retirar os 3 caracteres do final da string  ,=, ( virgula sinal de igual virgula )
$paraUpadate = substr($paraUpadate,0,-3);

//agora é só colocar esse resultado na declaração UPDATE

$smtp_process = "UPDATE public_ads SET ads_title = '$ads_title', ads_content = '$ads_content', ads_price = '$ads_price', edit_attempts = edit_attempts + 1, $paraUpadate WHERE ads_id = '$editor_id'"; 

See the above code working on ideone