Insert text with double quotation marks in mysql database

Question

Insert text with double quotation marks in mysql database

Navigation

#1 by (2 votes)

1

I am using the following code to insert text with double quotes in a mysql database:

mysqli_query($con, "insert into medicacaohistorico (data, unidadeori, unidadedes, itemdetalhe, qtd, solicitante, despachante) values ('".date("y-m-d")."', '".$nome = mysqli_real_escape_string($con, $usuario['unidade'])."', '".$unidadeDes."', '".substr($dados[$i], 1)."', '".$dados[$i + 1]."', '".$solicitante."', '".$despachante."')")

I learned to use mysqli_real_escape_string but it is not working.

The unsaved string is:

insert into medicacaohistorico (data, unidadeori, unidadedes, itemdetalhe, qtd, solicitante, despachante) values ('18-08-08', '5', '0', '12', '1', 'DAMIAO', 'MEDICO CAIXA D'AGUA')

mysql query select mysqli

asked by anonymous 08.08.2018 / 14:22

1 answer

How to call an Interstitial by clicking on an item in the list that goes through an Adapter? Incorrect jQuery Array

score 2 · Accepted Answer

The command should look like this (using single double quotes):

insert into medicacaohistorico (data, unidadeori, unidadedes, itemdetalhe, qtd, solicitante, despachante) values ('18-08-08', '5', '0', '12', '1', 'DAMIAO', 'MEDICO CAIXA D''AGUA')

or so (used backslash):

insert into medicacaohistorico (data, unidadeori, unidadedes, itemdetalhe, qtd, solicitante, despachante) values ('18-08-08', '5', '0', '12', '1', 'DAMIAO', 'MEDICO CAIXA D\'AGUA')