Parse error: syntax error, unexpected 'Y' (T_STRING)

Question

this is my first queston i ask, its about this code:

<?php
date_default_timezone_set('America/Santiago);
$fecha=date('Y-m-d');
$hora=date('H:i:s');
$link=mysqli_connect('localhost','root','','evaluacion2');
$sql="INSERT INTO sensores SET temperatura=".$_GET['celsius'].",distancia=".
$_GET['distancia'].",fecha='".$fecha."',hora='".$hora."'";
mysqli_query($link,$sql);
?>

i try to insert from the URL

http://localhost/sensores/capturadatos.php?temperatura=3&distancia=12

but i get this message

Parse error: syntax error, unexpected 'Y' (T_STRING) in D:\wamp64\www\sensores\capturadatos.php on line 3

You're missing a ' on the first line - it should be like this: `date_default_timezone_set('America/Santiago');` — Luke Briggs, Nov 07 '17 at 23:07
stackoverflow codeblock shows you your error. I suggest you use a good ide for php — Mark, Nov 07 '17 at 23:09
aside from the error your code is vulnerable to sql injection - research and implement `stored procedures` — Professor Abronsius, Nov 07 '17 at 23:21
@RamRaider its for a local arduino mini project im working on so security is not a problem, but thanks anyway for the tip! — Rigo_158, Nov 07 '17 at 23:25

score 1 · Accepted Answer · answered Nov 07 '17 at 23:07

1

Replace date_default_timezone_set('America/Santiago);

to date_default_timezone_set('America/Santiago');

answered Nov 07 '17 at 23:07

cn007b

15,878
6
57
69

Add this `$_GET['celsius'] = isset($_GET['celsius']) ? $_GET['celsius'] : 'default';` before line 7. – cn007b Nov 07 '17 at 23:21
i did not get that quite well, so i should look like this? `` – Rigo_158 Nov 07 '17 at 23:28

Parse error: syntax error, unexpected 'Y' (T_STRING)

1 Answers1