PHP දන්න අයගෙන් උදව්වක් ඕනේ

[geeko]

PHP දන්න අයගෙන් උදව්වක් ඕනේ

මේ code එකේ " ParseError: syntax error, unexpected \'$sql\' (T_VARIABLE) " error එක එනවා ප්‍රශ්නේ මොකක්ද?

$conn = new mysqli(localhost, motivesweb, motivesweb, motivesweb);

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT destination FROM phpfox_photos";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {
echo $row["destination"]. "<br>";
}
} else {
echo "0 results";
}
$conn->close();

 

[D_Mad]

B U M P

 

[Bobby_Axlerod]

මේ code එකේ " ParseError: syntax error, unexpected \'$sql\' (T_VARIABLE) " error එක එනවා ප්‍රශ්නේ මොකක්ද?

$conn = new mysqli(localhost, motivesweb, motivesweb, motivesweb);

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT destination FROM phpfox_photos";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {
echo $row["destination"]. "<br>";
}
} else {
echo "0 results";
}
$conn->close();

//TRY THIS
<?php

$servername="localhost";
$username="root";
$password="";
$dbname = "ict";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT destination FROM phpfox_photos";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo echo $row["destination"]. "<br>"; // you should use HTML table //here
}
} else {
echo "0 results";
}
$conn->close();
?>

 

[geeko]

//TRY THIS
<?php

$servername="localhost";
$username="root";
$password="";
$dbname = "ict";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT destination FROM phpfox_photos";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo echo $row["destination"]. "<br>"; // you should use HTML table //here
}
} else {
echo "0 results";
}
$conn->close();
?>

ඒත් ඒ error එකම එනවා

 

[pramix2011]

Help akak dennam teamviewer walin balala,,pw ake PM karanne

 

[geeko]

Help akak dennam teamviewer walin balala,,pw ake PM karanne

cpanel details evannada

 

[Helo1]

bump saho

 

[Lakshan-Seram]

$conn = new mysqli('localhost', 'motivesweb', 'motivesweb', 'motivesweb');

if ($conn->connect_error) {
   die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT `destination` FROM `phpfox_photos`";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

   while($row = $result->fetch_assoc()) {
     echo $row["destination"]. "<br>";
   }
} else {
   echo "0 results";
}
$conn->close();

 

[pramix2011]

ok ewanne

 

[The_Killer]

Simple stuff can make your life miserable;

i managed to solve it and just want to share my answer with you guys.

hopefully this post will serves as a lesson to others as well.

what actually happened was there are "invisible" spaces between the codes, most probably when i copied from somewhere. "invisible codes" means something you get like [alt]+255 on numeric keyboard. these invisible characters was read by the php codes, thus returning the error.

the point is, ALWAYS CHECK FOR EMPTY SPACES OR UNUSED SPACES, delete all the unnecessary spaces. it might fix your (mine) problem.

thanks guys... took me 2 days... long days.

thanks stackoverflow.com

ps: hope moderator will keep this post open, as the answer might be helpful to others.

https://stackoverflow.com/questions/13341057/parse-error-syntax-error-unexpected-result-t-variable

https://stackoverflow.com/questions/20733995/syntax-error-unexpected-stmt-t-variable

https://stackoverflow.com/questions/34858009/parse-error-syntax-error-unexpected-sql-t-variable

 

[wolvoring]

$conn = new mysqli(localhost, root, password, db_name);

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT destination FROM phpfox_photos";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {
echo $row["destination"]. "<br>";
}
} else {
echo "0 results";
}
$conn->close();

password= password eka ban samanyen hiss thiyanne
ex -apema pc ekaka dagena karanawanam api root ekata password danne naha dammoth e password eka danawa

localhost/phpmyadmin log wena koata pass word ekak denawanam eka methana dapan



db_name- ube data base eke nama dala balapan

 

[geeko]

$conn = new mysqli('localhost', 'motivesweb', 'motivesweb', 'motivesweb');

if ($conn->connect_error) {
   die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT `destination` FROM `phpfox_photos`";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

   while($row = $result->fetch_assoc()) {
     echo $row["destination"]. "<br>";
   }
} else {
   echo "0 results";
}
$conn->close();

ඒත් හරියන්නෙ නෑ

 

[geeko]

Simple stuff can make your life miserable;



https://stackoverflow.com/questions/13341057/parse-error-syntax-error-unexpected-result-t-variable

https://stackoverflow.com/questions/20733995/syntax-error-unexpected-stmt-t-variable

https://stackoverflow.com/questions/34858009/parse-error-syntax-error-unexpected-sql-t-variable

meka matha dakka ban stackoverflow eke.

 

[geeko]

$conn = new mysqli(localhost, root, password, db_name);

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT destination FROM phpfox_photos";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {
echo $row["destination"]. "<br>";
}

} else {
echo "0 results";
}
$conn->close();

password= password eka ban samanyen hiss thiyanne
ex -apema pc ekaka dagena karanawanam api root ekata password danne naha dammoth e password eka danawa

localhost/phpmyadmin log wena koata pass word ekak denawanam eka methana dapan



db_name- ube data base eke nama dala balapan

localhost neme ban karanne. password,db name,username okkoma hariyatama deela thiyenawa. othana issue eka thiyenne

$sql = "SELECT destination FROM phpfox_photos";

line eke.

 

[Lakshan-Seram]

$sql = "SELECT `destination` FROM `phpfox_photos`";

hariyanne nettam ithin

$sql = mysqli_query( "SELECT `destination` FROM `phpfox_photos`" );

use karala ithuru tikat a widihata gepalenna karanna

 

[geeko]

$sql = "SELECT `destination` FROM `phpfox_photos`";

hariyanne nettam ithin

$sql = mysqli_query( "SELECT `destination` FROM `phpfox_photos`" );

use karala ithuru tikat a widihata gepalenna karanna

maara scene eka. kisima deyak hariyanne na

 

[Lakshan-Seram]

$conn = new mysqli('localhost', 'root', '', 'test');

if ($conn->connect_error) {
   die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT `destination` FROM `phpfox_photos`";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

   while($row = $result->fetch_assoc()) {
     echo $row["destination"]. "<br>";
   }
} else {
   echo "0 results";
}
$conn->close();

weda na kiwwe uba..

 

[geeko]

$conn = new mysqli('localhost', 'root', '', 'test');

if ($conn->connect_error) {
   die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT `destination` FROM `phpfox_photos`";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

   while($row = $result->fetch_assoc()) {
     echo $row["destination"]. "<br>";
   }
} else {
   echo "0 results";
}
$conn->close();

weda na kiwwe uba..

man php script ekak customize karanne phpfox (social media site ekakata) kiyala. script eke mokak hari aulakda danne na.

 

[shenic_v2.0.0]

$conn = new mysqli('host', 'user', 'password', 'db');

	if ($conn->connect_errno) # <= CHECK this line!
	{
		die("Connection failed: " . $conn->connect_error);
	}
	else
	{
		$sql = "SELECT id, destination FROM phpfox_photos";

		if($conn->query($sql))
		{
			$des_data = $conn->query($sql);

			if($des_data->num_rows > 1)
			{
				$destination_data = array();

				while($row = $des_data->fetch_assoc())
				{
					$destination_data[] = $row;
				}	

				foreach ($destination_data as $k => $v)
				{
					echo "{$v['id']} : {$v['destination']} <br>";
				}
			}
			else
			{
				echo "0 Results!";
			}
		}
		else
		{
			echo "Query Error!";
		}			
	}

$conn->close();

machan ubata answers hambela thiyenne danatamath!
ewa wada karanna ona.

wena monawa hari aulak athi balanna.

PHP version eka check karala balanna.

Onna mamath mage local eke test karala balapu code ekak damma.
mee code eka test karala balanna.
"CHECK this line" kiyana line eka balanna. ($conn->connect_errno)

 

[geeko]

$conn = new mysqli('host', 'user', 'password', 'db');

	if ($conn->connect_errno) # <= CHECK this line!
	{
		die("Connection failed: " . $conn->connect_error);
	}
	else
	{
		$sql = "SELECT id, destination FROM phpfox_photos";

		if($conn->query($sql))
		{
			$des_data = $conn->query($sql);

			if($des_data->num_rows > 1)
			{
				$destination_data = array();

				while($row = $des_data->fetch_assoc())
				{
					$destination_data[] = $row;
				}	

				foreach ($destination_data as $k => $v)
				{
					echo "{$v['id']} : {$v['destination']} <br>";
				}
			}
			else
			{
				echo "0 Results!";
			}
		}
		else
		{
			echo "Query Error!";
		}			
	}

$conn->close();

machan ubata answers hambela thiyenne danatamath!
ewa wada karanna ona.

wena monawa hari aulak athi balanna.

PHP version eka check karala balanna.

Onna mamath mage local eke test karala balapu code ekak damma.
mee code eka test karala balanna.
"CHECK this line" kiyana line eka balanna. ($conn->connect_errno)

hariyanne na ban. man hithanne me script ekata oya code eka vada karanne na.