[insert_php]
$connArr = explode(‘:’, DB_HOST);
$conn = new mysqli($connArr[0], DB_USER, DB_PASSWORD, DB_NAME);
mysqli_set_charset($conn, “utf8”);
$urlArr = explode(‘/’, $_SERVER[‘REQUEST_URI’]);
$page = $urlArr[count($urlArr) – 2];
$prodSql = “SELECT *
FROM products
WHERE slug = ‘$page'”;

$prodResult = $conn->query($prodSql);

if ($prodRow = $prodResult->fetch_assoc())
{
$prodName = $prodRow[‘menu_title’];

}
[/insert_php]

[insert_php]
echo $prodName;
[/insert_php]

Sign up and gain access to full vendor profiles and vendor reviews.

REGISTER TO GAIN FULL ACCESS

    [insert_php]
    $tabsSql = “SELECT
    (CASE WHEN post_name = ‘pricing-“.$page.”‘ THEN ‘yes’ ELSE ‘no’ END) as pricing,
    (CASE WHEN post_name = ‘what-are-“.$page.”‘ THEN ‘yes’ ELSE ‘no’ END) as what_are,
    (CASE WHEN post_name = ‘what-is-“.$page.”‘ THEN ‘yes’ ELSE ‘no’ END) as what_is
    FROM wp_posts
    WHERE post_name = ‘pricing-“.$page.”‘
    OR post_name = ‘what-are-“.$page.”‘
    OR post_name = ‘what-is-“.$page.”‘”;

    $tabResults = $conn->query($tabsSql);
    $hasWa = false;
    $hasWi = false;
    $hasPricing = false;
    if ($tabResults->num_rows > 0){
    $tabRows = mysqli_fetch_all($tabResults,MYSQLI_ASSOC);
    foreach ($tabRows as $tr1){
    if ($tr1[‘pricing’] == “yes”){
    $hasPricing = true;
    }
    if ($tr1[‘what_are’] == “yes”){
    $hasWa = true;
    }
    if ($tr1[‘what_is’] == “yes”){
    $hasWi = true;
    }
    }
    }

    if ($hasWa){
    echo ‘

  • What are…

    • ‘;
    }
    else{
    echo ‘

  •  

    • ‘;
    }
    echo ‘

  • Vendor Listing

    • ‘;
    echo ‘

  • Top Vendors

    • ‘;
    if ($hasPricing){
    echo ‘

  • Buyer\’s Guide

    • ‘;
    }
    else{
    echo ‘

  •  

    • ‘;
    }
    [/insert_php]

[insert_php]echo “[insert page=’pricing- $page’ display=’content’]”;[/insert_php]