Put single quotes to store in mysql

Question

Put single quotes to store in mysql

Navigation

#1 by (0 votes)

0

I have to store an array and that each of the data has a single quote and I'm not sure how to do it.

I'm trying like this:

$Butacas = implode(",", addslashes ('.$_POST["Prot_asientos"].'.));

But I get an error.

Would the syntax be like this?

this is the complete code without the quotation marks:

if (isset($_POST["Prot_asientos"])) { $Butacas = implode(",", $_POST["Prot_asientos"]); } else { $Butacas=""; } 

    $InuevoProt = Insertar_Datos("Protocolo" , "'idcontacto', 'confirmado', 'fechacontacto', 'plazas', 'asientos', 'entrega', 'aviso', 'fechaaviso', 'asistentes', 'evento', 'observaciones'", "
    '".mysqli_real_escape_string($Conectar, $IdContacto)."',
    '".mysqli_real_escape_string($Conectar, $_POST['Prot_Confirmado'])."',
    '".mysqli_real_escape_string($Conectar, $fecha)."',
    '".mysqli_real_escape_string($Conectar, $_POST['Prot_plazas'])."',
    '".mysqli_real_escape_string($Conectar, $Butacas)."',
    '".mysqli_real_escape_string($Conectar, $_POST['Prot_entregadas'])."',
    '".mysqli_real_escape_string($Conectar, $_POST['Prot_recordar'])."',
    '".mysqli_real_escape_string($Conectar, $fechaviso)."',
    '".mysqli_real_escape_string($Conectar, $_POST['Prot_asistentes'])."',
    '".mysqli_real_escape_string($Conectar, $_POST['Proyecto_Id'])."',
    '".mysqli_real_escape_string($Conectar, $_POST['Prot_observaciones'])."'
    ");

php

asked by Killpe 05.03.2018 в 20:28

source

1 answer

Perform query of totals between two tables without duplicating the values Android - How to draw with different styles?

score 0 · Answer 1

The correct thing would be:

Add the single quotes as part of the implode separator.
Add single quotes before and after the implode .

Solution:

$Butacas = "'" . implode("','", $_POST["Prot_asientos"]) . "'";