PHP Throws 500 Error

Question

I am attempting to query a SQL Server Database and return the results onscreen. My page loads as it should, but when I push the button to query SQL Server if I look at the console it shows a 500 error.

What do I need to alter so that the valid results are returned on screen as I need?

<select name="peopleinfo[]" multiple style="min-width: 200px;" id="peopleinfo">
  <option value="red">Red</option>
  <option value="blue">Blue</option>
</select>
<div><input type="submit" value="Submit" id="ajaxButton" onclick="ReturnIt()"></div>
    <div id="result_data"></div>
<script>
  function ReturnIt(){
  var peopleinfo = $('#peopleinfo').val();
    jQuery.ajax({            
              url: "",
              type: 'POST',
              dataType: "html",
              data: { peopleinfo: peopleinfo },
              success : function(result) {
                    $('#result_data').empty();
                    $('#result_data').append(result);
              } ,
              error: function(){

              }
        });
  }
  </script>
    $peopleinfo = implode(',',$_REQUEST['peopleinfo']);
    $option = array(); //prevent problems

    $option['driver']   = 'mssql';            // Database driver name
    $option['host']     = 'Lockwood';    // Database host name
    $option['user']     = 'root';       // User for database authentication
    $option['password'] = 'sa';   // Password for database authentication
    $option['database'] = 'test';      // Database name
    $option['prefix']   = '';             // Database prefix (may be empty)

    $db = JDatabase::getInstance( $option );
    $result = $db->getQuery(true);
    $result->select($db->quoteName(array(".$peopleinfo.")));
    $result->from($db->quoteName('[redheadstepchild]')); 
    $db->setQuery($result); 
    $row = $db->loadRowList();
    print_r($row);

EDIT
This is what the dev console shows
an error on this line jquery-1.12.4.js:10254

And this is the actual syntax when I click that

// Do send the request
// This may raise an exception which is actually
// handled in jQuery.ajax (so no try/catch here)
xhr.send( ( options.hasContent && options.data ) || null );

The cause for the error should be shown in your HTTP server's error log — Phil, Mar 14 '17 at 02:25
Is this code running inside Joomla environment or outside Joomla environment. If running inside Joomla env then why give database details again. Why dont use `$db = JFactory::getDbo();` instead. And from where did you get this `[redheadstepchild]`. — Amit Ray, Mar 14 '17 at 03:58
it is running in the Joomla environment, directly inside an article. [redheadstepchild] is the table name, does it not require the brackets? — IcyPopTarts, Mar 14 '17 at 13:19

score 0 · Answer 1 · answered Mar 14 '17 at 02:43

I have added a try and catch exception, this will return the issue with your query

$peopleinfo = implode(',',$_REQUEST['peopleinfo']);
$option = array(); //prevent problems

$option['driver']   = 'mssql';            // Database driver name
$option['host']     = 'Lockwood';    // Database host name
$option['user']     = 'root';       // User for database authentication
$option['password'] = 'sa';   // Password for database authentication
$option['database'] = 'test';      // Database name
$option['prefix']   = '';             // Database prefix (may be empty)

try{
$db = JDatabase::getInstance( $option );
$result = $db->getQuery(true);
$result->select($db->quoteName(array(".$peopleinfo.")));
$result->from($db->quoteName('[redheadstepchild]')); 
$db->setQuery($result); 
}catch(Exception $e){
 echo $e->getMessage();
}
$row = $db->loadRowList();
print_r($row);

There is no error echo on the screen. If I open the dev console it only shows a 500 error. — IcyPopTarts, Mar 14 '17 at 13:35

score 0 · Accepted Answer · answered Mar 24 '17 at 12:02

Hello I made a module to accomplish what you are doing and it worked well. I'll put the example here might help you.

Module:

<?php
defined('_JEXEC') or die;

include_once __DIR__ . '/helper.php';

// Instantiate global document object
$doc = JFactory::getDocument();

$js = <<<JS
(function ($) {
    $(document).on('click', 'input[type=submit]', function () {
        var value   = $('input[name=data]').val(),
            request = {
                    'option' : 'com_ajax',
                    'module' : 'ajax_search',
                    'data'   : value,
                    'format' : 'raw'
                };
        $.ajax({
            type   : 'POST',
            data   : request,
            success: function (response) {
                $('.search-results').html(response);
            }
        });
        return false;
    });
})(jQuery)
JS;

$doc->addScriptDeclaration($js);

require JModuleHelper::getLayoutPath('mod_ajax_search');
?>

Helper:

<?php
defined('_JEXEC') or die;

class modAjaxSearchHelper
{
    public static function getAjax()
    {
        include_once JPATH_ROOT . '/components/com_content/helpers/route.php';

        $input = JFactory::getApplication()->input;
        $data  = $input->get('data', '', 'string');

$db = JFactory::getDbo();
        $query = $db->getQuery(true);


        // Build the query
        $query
            ->select($db->quoteName(array('id','name','email')))
            ->from($db->quoteName('#__banner_clients'))
            ->where($db->quoteName('name') . ' LIKE '. $db->quote('%' . $data . '%'));
            //->order('id ASC');


        $db->setQuery($query);
        $results = $db->loadObjectList();


        // Get output
        $output = null;

        foreach($results as $result){
            $output .= '<h4><a href="' . ContentHelperRoute::getArticleRoute($result->id,  $result->email) . '">' . $result->name . '</a></h4>';
        }

        if($output == null or empty($data))
        {
            $output = 'Sorry! No results for your search.';
        }

        return $output;
    }
}
?>

PHP Throws 500 Error

2 Answers2