I'm new here so I have some question. I'm developing a web site, but there is some problem. I have map with tags, that onclick invokes a function "getObject(this.alt)".
function getObjects(object){
console.log(object);
$.get("/sites/map/objects.php?t="+object, function(data) {
$('#answer').html(data);
});
It executes script object.php were t= area tags alt attribute, the objects.php connects to MySql and returns objects row, but I get this kind of error:
GET http://some-site.com/sites/map/objects.php?t=some_object 500 (Internal Server Error) jquery-latest.js:8706
Can you please help me? :)
This is the PHP code. Object is alt atribute from area tag in HTML file. It gets this alt and from that returns DB row with this alt name.
<?php
$object = $_GET['t'];
echo $object;
$con=mysqli_connect("server_adr","username","password","db_name");
// Check connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$con->set_charset("utf8");
if($object!='all'){
$result = mysqli_query($con,"SELECT * FROM map WHERE `city`='$object' ORDER BY tips");
}
else{
$result = mysqli_query($con,"SELECT * FROM map ORDER BY tips");
}
$old_tips = '';
$old_city = '';
while($row = mysqli_fetch_array($result))
{
$tips = $row['tips'];
$city = $row['city'];
if($old_tips!=$tips){
echo '<strong>'.$tips.'</strong><br>';
}
if($old_city!=$city){
echo $row['city'] . '<br>';
}
echo $row['title'] . ' - <a href="'.$row['web'].'">' . $row['web']. '</a>';
echo "<br>";
$old_tips = $row['tips'];
$old_city = $row['city'];
}
?>
And the WEB server info:
- Apache/2.2.21 (FreeBSD) mod_ssl/2.2.21 OpenSSL/0.9.8q DAV/2 PHP/5.3.8 with Suhosin-Patch SVN/1.7.1
- MySQL client version: 5.1.59
- PHP extension: mysql