1. Commentics Forum
  2. Customization
  3. Code
This is the community forum. For a developer response use the Client Area.
Follow us on Facebook, Twitter and YouTube!

Displaying price from MySQL
Tim
Member
**
Posts: 21
Threads: 5
Joined: Oct 2019
#1

24-Dec-2019, 10:13 PM
Hello,

I've manually added 'price' field in MySQL table.
http://joxi.net/LmGMEZ8UwyR0PA

How to display the information from this 'price' field with Extractor?
For example, interesting in "public function pageRating($cmtx_identifier)".
I want to display rating and price from pageRating function.

Thanks for future help.
Find
Reply
Steven
Administrator
*****
Posts: 2,895
Threads: 59
Joined: Jun 2010
#2

25-Dec-2019, 02:01 PM
Hi Tim,

Change this:
PHP Code:
<?php 

"SELECT `id`

To this:
PHP Code:
<?php 

"SELECT `id`, `price`

Change this:
PHP Code:
<?php 

return $average;

To this:
PHP Code:
<?php 

return array('average' => $average, 'price' => $page['price']);

Change this:
PHP Code:
<?php 

echo $extractor->pageRating('1');

To this:
PHP Code:
<?php 

$rating = $extractor->pageRating('1');

if (is_array($rating)) {

echo $rating['average'];

echo $rating['price'];

} else {

echo $rating;

}
Have you completed the interview?
Find
Reply
Tim
Member
**
Posts: 21
Threads: 5
Joined: Oct 2019
#3

25-Dec-2019, 07:03 PM
Cool...!
Working.
Thanks a lot.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 2 Guest(s)
  1. Commentics Forum
  2. Customization
  3. Code