Unable to retrieve value from MySQL database

Question

I am using the following PHP code to retrieve the "Location" field from the database in my server, but am getting the error shown below when I run the PHP.

My PHP file:

<?php 
$con=mysqli_connect("localhost","naveen","naveen123","naveen_z");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }
$result = mysqli_query($con,"SELECT 'Location' FROM `map_details` ");
print_r($result);
mysqli_close($con);
?>

My database structure:

Database structure

I am getting the following error:

Parse error: syntax error, unexpected $end in location.php on line 12

Now, I'm receiving this:

{"current_field":null,"field_count":null,"lengths":null,"num_rows":null,"type":n‌ull} –

Observation: Don't mix and match identifier quotes. Use ` consistently (or, better, only quote when required). ' should not be used for identifiers because it's actually an ANSI SQL string quote :( — user2864740
– user2864740, Commented Nov 16, 2013 at 7:03
can u make that php in correct format becoz am getting following null values now it showing all values as null {"current_field":null,"field_count":null,"lengths":null,"num_rows":null,"type":n‌ull} – — Bangalore
– Bangalore, Commented Nov 16, 2013 at 7:10
$result refers to the entire result, not a specific row. It says "there were no rows" ("num_rows":null) so the map_details table is most likely empty. Anyway, that's a different (and unrelated) problem - post a new question as appropriate (but first validate or disprove my previous assertion). — user2864740
– user2864740, Commented Nov 16, 2013 at 7:27

Mihai · Accepted Answer · 2014-01-28 20:53:17Z

1

You are using quotes instead of backticks,so you are selecting a string.If its not a reserved word you can remove them altogether.

mysqli_query($con,"SELECT Location FROM `map_details`")

answered Jan 28, 2014 at 20:53

Mihai

26.8k8 gold badges71 silver badges87 bronze badges

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

Comments

Andrew · Accepted Answer · 2014-02-24 20:27:52Z

1

Make sure to use msqli_fetch_array() on the results of the query.

EG: return mysqli_fetch_array($result);

answered Feb 24, 2014 at 20:27

Andrew

20.4k13 gold badges110 silver badges122 bronze badges

Comments

Zack Newsham · Accepted Answer · 2013-11-16 06:44:31Z

0

You are missing closing quotes on your query:

mysqli_query($con,"SELECT 'Location' FROM `map_details`");

what's funny is that stackoverflows syntax highlighting caught it!

Also, unless you are trying to select the literal value 'Location' from your table, you want different quotes (either backticks or remove them altogether)

answered Nov 16, 2013 at 6:44

Zack Newsham

3,0022 gold badges27 silver badges45 bronze badges

3 Comments

Bangalore Over a year ago

oooops..my mistake,...now its working but the $result printing like "mysqli_result Object ( [current_field] => 0 [field_count] => 1 [lengths] => [num_rows] => 9 [type] => 0 ) "how do i get the reults in JSON

Zack Newsham Over a year ago

well, your result is an object, you can call json_encode on the object, and that will convert all public variables into json format.

Bangalore Over a year ago

it showing all values as null {"current_field":null,"field_count":null,"lengths":null,"num_rows":null,"type":null}

Collectives™ on Stack Overflow

Unable to retrieve value from MySQL database

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related