Get data from database into variable

[dreampho]

Hi. I am new to PHP, and am testing a few things in a Expression Engine module.

 

I have a database called 'currency', and I want to retrieve some data from it and place the data into variables. How can I do this?

 

Here is what I currently have.

 

public function convert() {

 $price = $this->EE->TMPL->fetch_param('price');
 if( $price === FALSE ) {
	 return "";
 }

 $tagdata = $this->EE->TMPL->tagdata;

 $this->EE->db->select( "usd, eur, gbp" );
 $query = $this->EE->db->get( "currency" );

 $usd = '';
 $eur = '';
 $gbp = '';

 $usd_convert = $price * $usd;
 $eur_convert = $price * $eur;
 $gbp_convert = $price * $gbp;

 return $usd;
}

[Jessica]

This sounds like a third-party question, so I'm moving it there. Check "Expression Engine"'s website and documentation as well.

[albertdiones]

If you got a currency table, with columns usd, eur, gbp:

public function convert() {

 $price = $this->EE->TMPL->fetch_param('price');
 if( $price === FALSE ) {
	 return array();
 }

   $query = $this->EE->db->select( "usd, eur, gbp" )->get( "currency" );

   $currency_values = $query->num_rows() ? array_shift($query->result()) : false; // Only if there are results

   if (!$currency_values) {
      throw new Exception("No currency row found in the database");
   }

   foreach ($currencies as $currency => $currency_values) {
      if (!$currency_values) {
         throw new Exception("$currency currency has blank value");
      }
   }

   $return = array(   
          'usd' => $price * $currency_values['usd'],
          'eur' => $price * $currency_values['eur'],
          'gbp' => $price * $currency_values['gbp']
       );

 return $return;
}

 

I got no idea actually about "EE" but I made that based on the documentation hoping it'll help or give you idea at least.

 

Btw. having a currency table with only one row doesn't seem to make sense to me, I could have understood it wrong though, but if I didn't, I suggest having a currency row with ( currency varchar, usd_value decimal ) table instead