[SOLVED] Db::getInstance()->execute($sql) return no value

[sphway]

class GetVal{
        public function value(){
            $sql = new DbQuery();
            $sql->from('ps_table');
            $sql->select('id_name');
            $sql->where('id_addr = some street 10');
            return Db::getInstance()->execute($sql); // return ONE name
        }
    }

 

I try to get the result in other class,but get nothing

 

$ddb = new GetVal();
$result = $ddb->value();

 

Edited August 19, 2022 by sphway
SOLVED (see edit history)

[ps8modules]

Hi.

execute = INSERT, UPDATE, DELETE, ALTER (not return)

executeS = SELECT (return rows and all lines)

GetValue = SELECT (return one)

getRow = SELECT (return all rows and one line)

Edited August 19, 2022 by 4you.software (see edit history)

[ps8modules]

return Db::getInstance()->executeS($sql);

[sphway]

30 minutes ago, 4you.software said:

return Db::getInstance()->executeS($sql);

thanks,but still not working,should i import the class GetVal ?

[ps8modules]

classes: GetValClass.php

if (!defined('_PS_VERSION_')) {
    exit;
}
 
class GetVal
{
    protected $module = false;
    protected $name_of_class;
    protected $context;

    public function __construct(Module $module = null)
    {
        $this->name_of_class = get_class($this);
        $this->module = $module;
        $this->context = Context::getContext();
    }

    public function value($filter)
    {        
        if (!$filter) {return;}		
        $sql = new DbQuery();
        $sql->from('ps_table');
        $sql->select('id_name');
        $sql->where('id_addr = '.$filter);
        return Db::getInstance()->executeS($sql);
    }
}
    

 

your module:

if (!defined('_PS_VERSION_')) {
    exit;
}

require_once(dirname(__FILE__).'/classes/GetValClass.php');
class myModule extends Module
{
    public function __construct()
    {
        ....
    }    
    

    public function getValueInMyClass()
    {
        $ddb = new GetVal($this);
        $filter = addslashes("'some street 10'");
        $result = $ddb->value($filter );
        $idsName = array();
		
        if ($result) {
            foreach ($result as $data){
                $idsName[] = $data['id_name'];
            }

            if ($idsName){
                echo implode(', ',$idsName); 
            }
         }
     }

}

 

Edited August 19, 2022 by 4you.software (see edit history)

[sphway]

7 hours ago, 4you.software said:

classes: GetValClass.php

if (!defined('_PS_VERSION_')) {
    exit;
}
 
class GetVal
{
    protected $module = false;
    protected $name_of_class;
    protected $context;

    public function __construct(Module $module = null)
    {
        $this->name_of_class = get_class($this);
        $this->module = $module;
        $this->context = Context::getContext();
    }

    public function value($filter)
    {        
        if (!$filter) {return;}		
        $sql = new DbQuery();
        $sql->from('ps_table');
        $sql->select('id_name');
        $sql->where('id_addr = '.$filter);
        return Db::getInstance()->executeS($sql);
    }
}
    

 

your module:

if (!defined('_PS_VERSION_')) {
    exit;
}

require_once(dirname(__FILE__).'/classes/GetValClass.php');
class myModule extends Module
{
    public function __construct()
    {
        ....
    }    
    

    public function getValueInMyClass()
    {
        $ddb = new GetVal($this);
        $filter = addslashes("'some street 10'");
        $result = $ddb->value($filter );
        $idsName = array();
		
        if ($result) {
            foreach ($result as $data){
                $idsName[] = $data['id_name'];
            }

            if ($idsName){
                echo implode(', ',$idsName); 
            }
         }
     }

}

 

Thanks,The issue is solved

[ps8modules]

I gladly helped.
You can like posts.
Just click on the gray heart under the posts.
Please remember to include SOLVED in the subject title.