Problem with query and php / ajax

0

I wanted to ask for help with a problem that I have and I have not been able to find the error, in reality there are 2 problems:

Problem 1: I have an error with the query, I have a syntax error (I do not know how to get there but before it did not work either)

Problem 2: This problem I can not know what is due, what happens is that I have a value in a field (of the variables that I receive with post) that is F ++ but when I receive the value and print it in console only shows me the F without the ++, in fact no value sent by the post with + is received and for this I think I can not do the query normally, if someone could help I would appreciate it a lot.

<?php

$especiee = $_POST["especiee"];
$generoo = $_POST["generoo"];
$familiaa = $_POST["familiaa"];
$calidadd = $_POST["calidadd"];
$tamañoo = $_POST["tamañoo"];
$ciudadd = $_POST["ciudadd"];
$comentarioo = $_POST["comentarioo"];
$precioo = $_POST["precioo"];
$especie = $_POST["especie"];
$genero = $_POST["genero"];
$familia = $_POST["familia"];
$calidad = $_POST["calidad"];
$tamaño = $_POST["tamaño"];
$ciudad = $_POST["ciudad"];
$comentario = $_POST["comentario"];
$precio = $_POST["precio"];


$conexion=mysqli_connect('localhost','root','','shells');


$consulta="update shell set especie='$especiee', 
genero='$generoo',familia='$familiaa',calidad='$calidadd',tamano='$tamañoo',
ciudad='$ciudadd',comentario='$comentarioo',precio='$precioo' where especie='$especie' 
and genero=$'$genero'and familia='$familia'and calidad='$calidad'and tamano='$tamaño'and 
ciudad='$ciudad'and comentario='$comentario'and precio='$precio' "

$request=mysqli_query($conexion,$consulta); 

if($request) echo "funciona";
else echo "error";  

?>
    
asked by Javier Russell Richards Valenz 01.02.2017 в 01:21
source

0 answers