Parse error: syntax error, unexpected end of file in line 25 [duplicate]

Question

I am building a function and there is an error please help me to resolve this.

The error line is this:-

Parse error:syntax error, unexpected end of file in /home/u854338141/public_html/login/register.php on line 25

My Code:-

<?php
//Recieve username and password from android device or GET request
$user = $_GET['username'];
$pass = $_GET['password'];

//Database connection information
$dbhost = "mysql.hostinger.in";
$dbuser = "u854338141_root";
$dbpass = "1234567";
$dbname = "u854338141_demo";

//Create a connection to databse
$con = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

//Define sql statement for you business logic: registration
$sql = "INSERT into login(username, password) VALUES('" . $user . "', '" . 
$pass . "');

//Execute sql statement
$result = $con->query($sql);

if($result){
echo json_encode(array("Result"=>true));
}else{
echo json_encode(array("Result"=>false));
}

Tigran Babajanyan · Accepted Answer · 2017-07-27 06:20:31Z

5

change

//Define sql statement for you business logic: registration
$sql = "INSERT into login(username, password) VALUES('" . $user . "', '" . 
$pass . "')";

add double quote after last bracket

answered Jul 27, 2017 at 6:20

Tigran Babajanyan

2,0451 gold badge26 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Fabrice Kabongo · Accepted Answer · 2017-07-27 07:41:22Z

2

$sql = "INSERT into login(username, password) VALUES('" . $user . "', '" . 
$pass . "')";

You didn't close the query. There is a missing double quote " at the end of the query just after the closing bracket.

edited Jul 27, 2017 at 7:41

Fabrice Kabongo

66810 silver badges24 bronze badges

answered Jul 27, 2017 at 6:28

parkway

2762 silver badges15 bronze badges

7 Comments

Artsrun Hakobyan Over a year ago

Please don't duplicate answers , be more attentive .....

parkway Over a year ago

the only query that he gave. i cannot modified the statement, or the query or the attribute from the original post. The only things that i can do is fixing the missing value, symbol or etc.. It is same when u trying to fixing a words.. Let say someone miss spelled the word airplane, he wrote airplant.. and hes asking whats wrong with the words.. even 10 people answer it, 100% sure they definitely answer AIRPLANE as their answer. And you you come over to those people who answered AIRPLANE and asking them not t duplicate since the only answer is only AIRPLANE..

Artsrun Hakobyan Over a year ago

Dear @parkway It's not about this specific case, it's generally

parkway Over a year ago

what else did you can change in the query instead of replacing or adding a missing symbol? since the only problem that clearly

Artsrun Hakobyan Over a year ago

I upvoted your answer , means I agree with your answer , I'm just saying when you see someone already answers don't post same answer that's it , something remains unclear ?

|

Prabhu Nandan Kumar · Accepted Answer · 2017-07-27 06:31:42Z

You code is right just add double qoute in the Insert query and your problem solved. Right code is as follows :

<?php
//Recieve username and password from android device or GET request
$user = $_GET['username'];
$pass = $_GET['password'];

//Database connection information
$dbhost = "mysql.hostinger.in";
$dbuser = "u854338141_root";
$dbpass = "1234567";
$dbname = "u854338141_demo";

//Create a connection to databse
$con = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

//Define sql statement for you business logic: registration
$sql = "INSERT into login(username, password) VALUES('" . $user . "', '" . 
$pass . "')"; // This line you missed double quote ' " ' 

//Execute sql statement
$result = $con->query($sql);

if($result){
echo json_encode(array("Result"=>true));
}else{
echo json_encode(array("Result"=>false));
}

?>

If still you have issue please let us know.

Collectives™ on Stack Overflow

Parse error: syntax error, unexpected end of file in line 25 [duplicate]

3 Answers 3

Comments

7 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

7 Comments

Comments

Linked

Related