PHP DB query in Code Block

Using the page builder, is it possible to a table query using PHP in the Code Block? I have a table with products and want to use an Ajax form to query and display them on a page. I tried a code sample:
global $wpdb;
$wp_products = $wpdb->get_results(“SELECT * FROM catalog;”);
echo “<table>”;
foreach($catalog as $catalog){
echo "<tr>";
echo "<td>".$wp_products->ITEM."</td>";
echo "<td>".$wp_products->DESCRIPTION."</td>";
echo "<td>".$wp_products->COLOR."</td>";
echo "<td>".$wp_products->TYPE."</td>";
echo "</tr>";
}
echo "</table>";

Is this possible? Any recommendations on how to implement this on a page? - I did try putting the <?php> tags, but no go.

• This topic was modified 11 years, 3 months ago by jlarmen.