how to return a individual rows using ajax

how to return a individual rows using ajax

Hi,

I am using jquery ajax with PHP and I would like to return individual rows instead of html. here is my code:

  1. $('#btnShowDetails').click(function(){
  2.     $.ajax({
  3.         url : "get_company_details.php",
  4.         data : 'id=ed23e767-539f-11e3-aef0-74de2b9a31a4',
  5.         type : "post",
  6.         success : function(data)
  7.         {
  8.             $('#lblCompanyName').text(company name from data result);
  9.             $('#lblCompanyWebsite').text(company website from data result);
  10.         }
  11.     });
  12. });

and here is my ger_company_details.php:

  1. <?php
  2.     include('../includes/php_header.php');
  3.     include($_SESSION["absolute_path"] . '/includes/connect2db.php');
  4.     
  5.     if (!isset($_SESSION["member_loggedOn"])) { exit(header("Location: ../signin")); }
  6.     
  7.     $mysql_query = $mysql_connection->prepare("CALL sp_get_company_details(:param_company_guid)");
  8.     $mysql_query->bindParam(':param_company_guid', $_GET["id"], PDO::PARAM_STR);
  9.     $mysql_query->execute();

  10.     $mysql_row_count = $mysql_query->rowCount();

  11.     if ($mysql_row_count <= 0) { exit(header("Location: " . $_SESSION["domain_name"] . "home")); }

  12.     while ($mysql_row = $mysql_query->fetch())
  13.     {
  14.         $company_id = $mysql_row["company_id"];
  15.         $company_guid = $mysql_row["company_guid"];
  16.         $company_name = $mysql_row["company_name"];
  17.         $company_industry = $mysql_row["industry_name"];
  18.         $company_country = $mysql_row["country_name"];
  19.         $company_region = $mysql_row["region_name"];
  20.         $company_telephone = $mysql_row["company_telephone"];
  21.         $company_fax = $mysql_row["company_fax"];
  22.         $company_website = $mysql_row["company_website"];
  23.         $company_email = $mysql_row["company_email"];
  24.         $about_company = $mysql_row["about_company"];
  25.         $hide_email = $mysql_row["hide_email"];
  26.     }
  27. ?>