[SOLVED] Get a value from database using Javascript + PHP

[F.schettino]

I use Javascript on blur of an element to get a value from database using a function in user_ajax.php.

var elemento_Comune = Fabrik.getBlock('form_20').elements.get('fabrik_nominativi___Citta_Residenza');
var Codice_Comune = elemento_Comune.get('value');
var CAP_Comune='';
 
var url = "index.php?option=com_fabrik&format=raw&task=plugin.userAjax&method=CAP_da_Citta&Codice_Comune=" + Codice_Comune;
 
new Request(
  {url:url,
  method: 'get',
  onComplete: function(r) {alert(Codice_Comune); alert(r)}
}).send();

<?php
defined('_JEXEC') or die('Restricted access');
 
 
class UserAjax
{
    public function CAP_da_Citta()
    {
        $db = FabrikWorker::getDbo();
        $query = $db->getQuery(true);
        $CAP_Comune = ' ';
        $app = JFactory::getApplication();
        $input = $app->input;
        $cod_comune = $input->get('Codice_Comune', ' ');
        $query="SELECT CAP FROM fabrik_comuni WHERE Codice_Comune=" . $cod_comune;
        $db->setQuery($query, 1, 0);
        $CAP_Comune = $db->loadResult();
 
        echo $CAP_Comune;
    }
}

It doesn't work; alert(r) is blank.

If I modify last PHP statement from "echo $CAP_Comune;" to

"echo $cod_comune;"​

alert(r) displays:

undefined​

so, the query cannot work.


What is wrong? Why 'Codice_Comune' is not assigned to $cod_comune?

Can someone help me, please?

 

[jfquestiaux]

I think that 'codice_cimune' is a string, so try:
$query="SELECT CAP FROM fabrik_comuni WHERE Codice_Comune=" . $db->quote($cod_comune);

 

[F.schettino]

Thanks for your interest, jfquestiaux .

Probably I was not clear: the problem isn't the query but the input value.

If I try:

<?php
defined('_JEXEC') or die('Restricted access');
 
 
class UserAjax
{
    public function CAP_da_Citta()
    {
        $db = FabrikWorker::getDbo();
        $query = $db->getQuery(true);
        $CAP_Comune = ' ';
        $app = JFactory::getApplication();
        $input = $app->input;
        $cod_comune = $input->get('Codice_Comune', ' ');
 
        echo $cod_comune;
 
    }
}

alert(r) displays: undefined.

 

[troester]

Is it working with just

<?php
defined('_JEXEC') or die('Restricted access');
 
 
class UserAjax
{
    public function CAP_da_Citta()
    {
 
        echo 'abc';
 
    }
}

?

 

[F.schettino]

Thanks for your interest, troester .

Surely works; I tried something similar (you can see my #3 Reply).

My problem is pass the input value:

class UserAjax
{
    public function CAP_da_Citta()
    {
        $db = FabrikWorker::getDbo();
        $app = JFactory::getApplication();
        $input = $app->input;
        $cod_comune = $input->get('Codice_Comune', ' ');
 
        echo $cod_comune;
 
    }
}

As you see in #1 Replay and #3 Reply, alert(r) displays: undefined.
So $cod_comune is undefined in PHP, that means that Codice_Comune isn't passed to PHP function CAP_da_Citta().

 

[F.schettino]

Friendly bump.

 

[F.schettino]

No one wants to help me?

 

[F.schettino]

This code works well:

Javascript "on change" element

/* Recupero Codice Comune */
var elemento_Comune = Fabrik.getBlock('form_20').elements.get('fabrik_nominativi___Citta_Residenza');
var Codice_Comune = elemento_Comune.get('value');
var CAP_Comune='';
 
/* Interrogazione del database mediante Ajax per ottenere il CAP del Comune  */
var url = "index.php?option=com_fabrik&format=raw&task=plugin.userAjax&method=CAP_da_Citta&Codice_Comune=" + Codice_Comune;
 
new Request(
  {url:url,
  method: 'get',
  onComplete: function(r)
    {
      Fabrik.getBlock('form_20').elements.get('fabrik_nominativi___CAP_Residenza').update(r);
      posizione_xx=r.search("xx");
      if (posizione_xx!==-1) {alert("Precisare xx in CAP");}
    }
}).send();

user_ajax.php

<?php
defined('_JEXEC') or die('Restricted access');
 
 
class UserAjax
{
    function CAP_da_Citta()
    {
        $db = JFactory::getDBO();
        $cod_comune = JRequest::getVar('Codice_Comune', '');
 
        $query="SELECT CAP FROM fabrik_comuni WHERE Codice_Comune=" . $cod_comune;
        $db->setQuery($query);
        $result= $db->loadResult();
        echo $result;
    }
 
}

I hope that it can be useful for someone.

 

[cheesegrits]

Thanks for posting that.

-- hugh

 

[F.schettino]

I thank you, cheesegrits, for the appreciation, but you do not have to thank me; it is my duty.
I get lots of useful information and I am pleased to be able to return: this is the purpose of the forum.

Also, I have solved my problem by reading what is written in documentation.

I started reading

http://www.fabrikar.com/forums/index.php?wiki/elements/#options​

user_ajax_example.php​

but I had problems.
Then I red

http://fabrikar.com/help/tutorials/details/3/21​

and solved.

 

[mudshark79]

Thanks, this thread pointed me into some rigth directions and helped me master my first user ajax call !

 

[F.schettino]

I'm glad I helped you. This is the purpose of the Forum.
I also had a lot of help from others.