i'm getting this error from a '$_POST['phone']' unexpected '' ' (T_CONSTANT_ENCAPSED_STRING) for a insert on mysql

Asked Aug 26 '15 at 20:19

Active Aug 26 '15 at 20:19

Viewed 24 times

i'm new on stackfloww but allways i found solutions here. today is my first questions. the problem i have is this:

   Parse error: syntax error, unexpected '' ' (T_CONSTANT_ENCAPSED_STRING) in D:\XAMPP\htdocs\zupa\guardar.php on line 32

i read php documentation and is for my string is from a input with just acept numbers. i make it with the next function

   $(document).ready(function (){
   $('#2').keyup(function (){
   this.value = (this.value + '').replace(/[^0-9]/g, '');

now the problem is te sintaxis and iam on the line of craziness.

this is my code

<?php  




     //la funcion para conectarse cn la base de datos 




     //conectado con la base de datos

  include('conexion.php');
  $conexion=conectar();







     // agarro via post las variables y las conecto al mysql



             mysql_query('INSERT INTO mensajes(name,phone,comment,rate) VALUES('.$_POST['name']'
                                                                               '$_POST['phone']'
                                                                               '$_POST['comment']'
                                                                               '$_POST['rate']')') 
             or die(mysql_error());

             echo "dato guardado";

and the error is in the line 32 wich is

'$_POST['phone']'

thank for any help!

asked Aug 26 '15 at 20:19

Juan Luis Claure

definitely your quotes and SQL injection heaven – Funk Forty Niner Aug 26 '15 at 20:24
missing commas missing dots – Aug 26 '15 at 20:25
frightened him off just before I pressed the post button – RiggsFolly Aug 26 '15 at 20:26
@Dagon oh sure, make it look worse – Funk Forty Niner Aug 26 '15 at 20:26
@RiggsFolly sorry bro :-) – Aug 26 '15 at 20:27
@Dagon head of the Olympic comittee. So, not giving out flowers with those gold medals? – Funk Forty Niner Aug 26 '15 at 20:27
Oh a dup, should have checked first. Naughty me – RiggsFolly Aug 26 '15 at 20:27
@Fred-ii- no one mentioned the use of mysql_* – Aug 26 '15 at 20:27
some of us have a bookmark list of dupes :-) – Aug 26 '15 at 20:28
@Dagon You were to quick with the dup for anybody to get round to it. Hehe – RiggsFolly Aug 26 '15 at 20:28
This thing requires a master seamstress who doubles as a coder. It's "stitched" with holes. – Funk Forty Niner Aug 26 '15 at 20:29
@RiggsFolly yeah he takes all the fun out of us poor scabs who "search" for dupes. He's got "the list" tucked away in his lab. – Funk Forty Niner Aug 26 '15 at 20:30
@Dagon Nah, there are bigger problems with this. You said it yourself way back when. You can do just as well with `mysql_` if you know how to keep the snakes and roaches out of the pick-ah-nick basket. – Funk Forty Niner Aug 26 '15 at 20:33
Juan if you are still stuck: http://codepad.viper-7.com/05gxcP – Aug 26 '15 at 20:42

i'm getting this error from a '$_POST['phone']' unexpected '' ' (T_CONSTANT_ENCAPSED_STRING) for a insert on mysql

0 Answers0