Read data from mysql php jquery ajax

Question

I need to read data from my web page with jquery + ajax

This is my function:

public function getvalueshahr()
{
if($_POST['ostan']!=0){
$db=  JFactory::getDbo();
$query=$db->getQuery(TRUE);
$query->select('id,title')->from('#__categories')->
where($db->quoteName('parent_id').'='.$db->quote($_POST['ostan']));
$db->setQuery($query);
$res=$db->loadObjectList();
echo $db->getErrorMsg();
echo json_encode($res);}
}

I can read data with c# like this:

But my ajax method is not working. Here is the method:

 $.ajax({
   type: "POST",
   url: "www.mysite.net/index.php?task=shahrestan.getvalueshahr",
  data: "{ostan=77}",
  dataType: "json",
  success: function (result)
  {
    var d = $.parseJSON(result);
    $.each(d, function (i, field)
  {
    $("#output").append("id: " + field.id + " title: " +  
    field.title+"br/>"); 
  });
  },
    error: function (e)
  {
    alert("error:" + e.responseText);
  }
 });

The method returns nothing.

You should really learn how to write good code, your code looks very messy and is hard to read. — Black
– Black, Commented Apr 21, 2016 at 6:48

M. Eriksson · Accepted Answer · 2016-04-21 06:20:36Z

2

You're sending a string instead of an object in your ajax-request. Try changing :

data: "{ostan=77}"

to

data: { ostan: 77 }

And you should set the content type before echoing the results in PHP:

header('Content-Type: application/json');
echo json_encode($res);

Now you don't need $.parseJSON in the JS-code. You will get a json-object straight away.

answered Apr 21, 2016 at 6:20

M. Eriksson

13.7k4 gold badges31 silver badges42 bronze badges

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

2 Comments

Mr Alemi Over a year ago

thanks, it returns an error message and e.responseText is empty how can i get error details

M. Eriksson Over a year ago

Have you tried console.log(e) instead of alert(e.responteText) when catching the error? Use your browsers console to see the output. Here's how to open it in different browsers: webmasters.stackexchange.com/questions/8525/…

Elshad Aghazade · Accepted Answer · 2016-04-21 06:23:47Z

0

First of all you send a wrong data to the server. You have to rewrite part of your code like this:

data: {ostan: 77},

or

data: "ostan=77",

The second problem is you get a result as a json object on the success method, but you try to parse it again to the json object. So remove this line from your code:

var d = $.parseJSON(result);

Finally your ajax function should looks like this:

$.ajax({
   type: "POST",
   url: "www.mysite.net/index.php?task=shahrestan.getvalueshahr",
  data: {ostan: 77},
  dataType: "json",
  success: function (result)
  {
    $.each(result, function (i, field)
  {
    $("#output").append("id: " + field.id + " title: " +  
    field.title+"br/>"); 
  });
  },
    error: function (e)
  {
    alert("error:" + e.responseText);
  }
 });

answered Apr 21, 2016 at 6:23

Elshad Aghazade

764 bronze badges

2 Comments

Mr Alemi Over a year ago

thanks, it returns an error message and e.responseText is empty how can i get error details

Elshad Aghazade Over a year ago

Add a "complete" method to your ajax to get all data about server error. You have to write like this example: complete: function (res) { console.log(res); } Run your codes on the chrome browser, than from the console copy and paste the output result please

flohdieter · Accepted Answer · 2016-04-21 06:34:47Z

0

If you are loading data from you mysql-database you eventually have to convert these data because it is not stored as utf-8 converted. This piece of code convert given object to UTF-8: mb_convert_encoding(database-entry,'UTF-8');

answered Apr 21, 2016 at 6:34

flohdieter

1304 silver badges15 bronze badges

Collectives™ on Stack Overflow

Read data from mysql php jquery ajax

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related