Posted By

johnschneider on 04/12/15

Tagged

Versions (?)

Last Edited at 04/12/15 01:40am

Statistics

Viewed 809 times

Favorited by 0 user(s)

Related snippets

php code example

/ Published in: PHP

example of php code I worked on

Highlighted TextExpand

<!DOCTYPE html>

<?php

// set error reporting
error_reporting(-1);
error_reporting(E_ALL);

// start session
session_start();

$servername = "";
$username = "";
$password = "";
$dbname = "";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} else {

//echo "Connected successfully";

}

// figure out contect of call based on passed in category or product
$category = $_REQUEST['category'] ;
//$product_id = $_REQUEST['product_id'] ;
$product = $_REQUEST['product'] ;

if ( $product != '' ) {
// this has to change to select * from site_partnerproducts with a join

//$query= "SELECT * FROM  `site_partnerproducts` AS a, `site_partners` AS b WHERE a.partner_id = b.partner_id AND a.Product = '$product' 
    //ORDER BY b.PartnerCategory ASC, b.logo_sortorder ASC,b.category_sortorder ASC, b.Partner ASC";

$query = "SELECT * FROM  `site_partnerproducts` AS a, `site_partners` AS b";
$query .= " WHERE a.partner_id = b.partner_id AND a.Product = '$product'";
$query .= " ORDER BY b.category_sortorder ASC, b.logo_sortorder ASC";

//$query .= " ORDER BY b.PartnerCategory, b.logo_sortorder ASC, b.Partner ASC";

//echo $query;

} else {

$query = "SELECT * FROM site_partners";

}

//echo $query;

$result = mysqli_query($conn, $query);

if (mysqli_num_rows($result) > 0) {

// output data of each row

while($row = mysqli_fetch_assoc($result)) {

echo "<br>".$row["Partner"]."<br>".$row["Description"]."<br>".$row["Logo_Large"]."<br>".$row["Logo_Small"]."<br>".$row["PartnerURL"]."<br>"
        .$row["partner_id"]."<br>".$row["PartnerCategory"]."<br>";

}

} else {

//echo "<br />0 results";

}

<title>Partners and Integrations | NRGShip</title>

<link href="http://www.nrgsoft.com/new2/css/preload.css" rel="stylesheet" media="screen">
    <link href="http://www.nrgsoft.com/new2/css/bootstrap.min.css" rel="stylesheet" media="screen">
    <link href="http://www.nrgsoft.com/new2/css/yamm.css" rel="stylesheet" media="screen">
    <link href="http://www.nrgsoft.com/new2/css/bootstrap-switch.min.css" rel="stylesheet" media="screen">
    <link href="http://www.nrgsoft.com/new2/css/font-awesome.min.css" rel="stylesheet" media="screen">
    <link href="http://www.nrgsoft.com/new2/css/animate.min.css" rel="stylesheet" media="screen">
    <link href="http://www.nrgsoft.com/new2/css/slidebars.css" rel="stylesheet" media="screen">
    <link href="http://www.nrgsoft.com/new2/css/lightbox.css" rel="stylesheet" media="screen">
    <link href="http://www.nrgsoft.com/new2/css/jquery.bxslider.css" rel="stylesheet">
    <link href="http://www.nrgsoft.com/new2/css/syntaxhighlighter/shCore.css" rel="stylesheet" media="screen">

</head>

<style>

</style>

<div id="preloader">
    <div id="status">&nbsp;</div>
</div>

<body>

<?php include ("http://www.nrgsoft.com/new2/navbar.php"); ?>

<?php

if ( $product == 'all') {

echo '  <h1 class="page-title">Shipping Partners and Integrations</h1>';

} elseif ($product == 'mac') {

echo '  <h1 class="page-title">Mac Partners and Integrations</h1>';

} elseif ($product == 'filemaker') {

echo '  <h1 class="page-title">FileMaker Partners and Integrations</h1>';

} elseif ($product == 'nrgship_upsfm') {

echo '

<h1 class="page-title">UPS for FileMaker Integrations</h1>

<ol class="breadcrumb pull-right">
                    <li><a href="http://www.nrgsoft.com/new2/shipping/filemaker/ups/ups_filemaker.php">Features</a></li>
                    <li><a href="http://www.nrgsoft.com/new2/shipping/common//partners_integrations.php?product=nrgship_upsfm">Integrations</a></li>
                    <li><a href="#">FAQs</a></li>
                    <li><a href="#">Pricing</a></li>
                </ol>

} elseif ($product == 'nrgship_ups') {

echo '  <h1 class="page-title">NRGship for UPS Integrations</h1>

<ol class="breadcrumb pull-right">
                        <li><a href="http://www.nrgsoft.com/new2/shipping/mac/ups/nrgship_ups.php">Features</a></li>
                        <li><a href="http://www.nrgsoft.com/new2/shipping/common//partners_integrations.php?product=nrgship_ups">Integrations</a></li>
                    <li><a href="#">FAQs</a></li>
                    <li><a href="#">Pricing</a></li>
                    </ol>

} elseif ($product == 'nrgship_upspro') {

echo '  <h1 class="page-title">NRGship Pro for UPS Integrations</h1>

<ol class="breadcrumb pull-right">
                        <li><a href="http://www.nrgsoft.com/new2/shipping/mac/ups/nrgship_pro_ups.php">Features</a></li>
                        <li><a href="http://www.nrgsoft.com/new2/shipping/common//partners_integrations.php?product=nrgship_upspro">Integrations</a></li>
                    <li><a href="#">FAQs</a></li>
                    <li><a href="#">Pricing</a></li>
                    </ol>

} elseif ($product == 'nrgship_fedexpro') {

echo '  <h1 class="page-title">NRGship Pro for FedEx Integrations</h1>

<ol class="breadcrumb pull-right">
                        <li><a href="http://www.nrgsoft.com/new2/shipping/mac/fedex/nrgship_pro_fedex.php">Features</a></li>
                        <li><a href="http://www.nrgsoft.com/new2/shipping/common//partners_integrations.php?product=nrgship_fedexpro">Integrations</a></li>
                    <li><a href="#">FAQs</a></li>
                    <li><a href="#">Pricing</a></li>
                    </ol>

} elseif ($product == 'nrgship_fedexfm') {

echo '  <h1 class="page-title">FedEx for FileMaker Integrations</h1>

<ol class="breadcrumb pull-right">
                        <li><a href="http://www.nrgsoft.com/new2/shipping/filemaker/fedex/fedex_filemaker.php">Features</a></li>
                        <li><a href="http://www.nrgsoft.com/new2/shipping/common//partners_integrations.php?product=nrgship_fedexfm">Integrations</a></li>
                    <li><a href="#">FAQs</a></li>
                    <li><a href="#">Pricing</a></li>
                    </ol>

} elseif ($product == 'nrg_shipconnect') {

echo '  <h1 class="page-title">NRG Ship Connect Integrations</h1>

<ol class="breadcrumb pull-right">
                        <li><a href="http://www.nrgsoft.com/new2/shipping/filemaker/shipconnect/shipconnect.php">Features</a></li>
                        <li><a href="http://www.nrgsoft.com/new2/shipping/common//partners_integrations.php?product=nrg_shipconnect">Integrations</a></li>
                    <li><a href="#">FAQs</a></li>
                    <li><a href="#">Pricing</a></li>
                    </ol>

}

</div>

</header>

<div class="container">
    <div class="portfolio-topbar hidden-sm hidden-xs">
        <div class="row">
            <div class="col-md-8">
               
                <ul class="portfolio-topbar-cats">

<?php

if ($product == 'all') {

// below adjust category value to be whatever the value is for the category in db
                    if ($category == '' || $category == 'all' ) {
                   echo ' <li><span class="filter" data-filter="all">All</span></li>';
                   }
                    if ($category == '' || $category == 'shopping_carts' ) {
                 echo '    <li><span class="filter" data-filter=".shopping_carts">Shopping Carts</span></li>';
                 }
                    if ($category == '' || $category == 'marketplaces' ) {
                     echo '    <li><span class="filter" data-filter=".marketplaces">Marketplaces</span></li>';
                 }
                      if ($category == '' || $category == 'mac_software' ) {
                 echo '    <li><span class="filter" data-filter=".mac_software">Mac Software</span></li>';
                 }               
                    if ($category == '' || $category == 'filemaker_solutions' ) {
                    echo '     <li><span class="filter active" data-filter=".filemaker_solutions">FileMaker Solutions</span></li>';
                 
                }
                    if ($category == '' || $category == 'shipping_partners' ) {
                    echo '     <li><span class="filter" data-filter=".shipping_partners">Shipping Partners</span></li>';
                 }

} elseif ($product == 'filemaker') {

// below adjust category value to be whatever the value is for the category in db
                    if ($category == '' || $category == 'all' ) {
                   echo ' <li><span class="filter" data-filter="all">All</span></li>';
                   }
                    if ($category == '' || $category == 'shopping_carts' ) {
                 echo '    <li><span class="filter" data-filter=".shopping_carts">Shopping Carts</span></li>';
                 }
                    if ($category == '' || $category == 'marketplaces' ) {
                     echo '    <li><span class="filter" data-filter=".marketplaces">Marketplaces</span></li>';
                 }
                    if ($category == '' || $category == 'mac_software' ) {
                 echo '    <li><span class="filter" data-filter=".mac_software">Mac Software</span></li>';
                 }               
                    if ($category == '' || $category == 'filemaker_solutions' ) {
                    echo '     <li><span class="filter active" data-filter=".filemaker_solutions">FileMaker Solutions</span></li>';
                  }
                    if ($category == '' || $category == 'shipping_partners' ) {
                    echo '     <li><span class="filter" data-filter=".shipping_partners">Shipping Partners</span></li>';
                 }

} elseif ($product == 'mac') {

} elseif ($product == 'nrgship_fedexfm') {

} elseif ($product == 'nrg_shipconnect') {

// below adjust category value to be whatever the value is for the category in db
                    if ($category == '' || $category == 'all' ) {
                   echo ' <li><span class="filter" data-filter="all">All</span></li>';
                   }
                    if ($category == '' || $category == 'shopping_carts' ) {
                 echo '    <li><span class="filter" data-filter=".shopping_carts">Shopping Carts</span></li>';
                 }
                    if ($category == '' || $category == 'marketplaces' ) {
                     echo '    <li><span class="filter" data-filter=".marketplaces">Marketplaces</span></li>';
                 }
                    if ($category == '' || $category == 'mac_software' ) {
                 echo '    <li><span class="filter" data-filter=".mac_software">Mac Software</span></li>';
                 }               
                    if ($category == '' || $category == 'filemaker_solutions' ) {
                    echo '     <li><span class="filter active" data-filter=".filemaker_solutions">FileMaker Solutions</span></li>';
                  }
                    if ($category == '' || $category == 'shipping_partners' ) {
                    echo '     <li><span class="filter" data-filter=".shipping_partners">Shipping Partners</span></li>';
                 }

} elseif ($product == 'nrgship_upsfm') {

// below adjust category value to be whatever the value is for the category in db
                    if ($category == '' || $category == 'all' ) {
                   echo ' <li><span class="filter" data-filter="all">All</span></li>';
                   }
                    if ($category == '' || $category == 'shopping_carts' ) {
                 echo '    <li><span class="filter" data-filter=".shopping_carts">Shopping Carts</span></li>';
                 }
                    if ($category == '' || $category == 'marketplaces' ) {
                     echo '    <li><span class="filter" data-filter=".marketplaces">Marketplaces</span></li>';
                 }
                    if ($category == '' || $category == 'mac_software' ) {
                 echo '    <li><span class="filter" data-filter=".mac_software">Mac Software</span></li>';
                 }                 
                    if ($category == '' || $category == 'filemaker_solutions' ) {
                    echo '     <li><span class="filter active" data-filter=".filemaker_solutions">FileMaker Solutions</span></li>';
                  }

} elseif ($product == 'nrgship_ups') {

if ($category == '' || $category == 'shopping_carts' ) {
                 echo '    <li><span class="filter" data-filter=".shopping_carts">Shopping Carts</span></li>';
                 }
                    if ($category == '' || $category == 'marketplaces' ) {
                     echo '    <li><span class="filter" data-filter=".marketplaces">Marketplaces</span></li>';
                 }
                    if ($category == '' || $category == 'mac_software' ) {
                 echo '    <li><span class="filter" data-filter=".mac_software">Mac Software</span></li>';
                 }

} elseif ($product == 'nrgship_upspro') {

} elseif ($product == 'nrgship_fedexpro') {

}

</ul>

</div>

</div>

</div>
    <div class="row">
        <div class="col-md-12">
            <div class="row" id="Container">

<?php
/*
                <a data-toggle="modal" class="btn btn-info" href="<?php echo ''.$row["Partner"].''; ?>" data-target="<?php echo ''.$row["partner_id"].''; ?>"></a>  */

//http://www.nrgsoft.com/new2/shipping/common/partners_detail.php?partner_id='.$row["partner_id"].'&product_id='.$product.'

//<a href="http://www.nrgsoft.com/new2/shipping/common/partners_detail.php?partner_id='.$row["partner_id"].'&product_id='.$product.'" class="thumbnail">

while($row = mysqli_fetch_assoc($result)) {

//echo "<br>".$row["Partner"]."<br>".$row["Description"]."<br>".$row["Logo_Large"]."<br>".$row["Logo_Small"]."<br>".$row["PartnerURL"]."<br>"
                    //.$row["partner_id"]."<br>".$row["PartnerCategory"]."<br>";

if ($product == 'all') {

echo '
   
                                <div class="mix '.$row["PartnerCategory"].' col-md-3 col-sm-6 col-xs-12">

<h4 class="caption-title">'.$row["Partner"].'</h4>

</div>
                                        </div>
                                </div>

} elseif ($product == 'mac') {

echo '
   
                                <div class="mix '.$row["PartnerCategory"].' col-md-3 col-sm-6 col-xs-12">

<h4 class="caption-title">'.$row["Partner"].'</h4>

</div>
                                        </div>
                                </div>

} elseif ($product == 'filemaker') {

echo '
   
                                <div class="mix '.$row["PartnerCategory"].' col-md-3 col-sm-6 col-xs-12">

<h4 class="caption-title">'.$row["Partner"].'</h4>

</div>
                                        </div>
                                </div>

} else {

echo '

<h4 class="caption-title">'.$row["Partner"].'</h4>

</div>
                                        </div>
                                </div>

}
                }

<div class="modal-header">
                                                <button type="button" class="close" data-dismiss="modal" aria-hidden="true">&times</button>

</div>

<p></p>

</div>

<div class="modal-footer">
                                                <button type="button" class="btn btn-ar btn-primary" data-dismiss="modal">Close</button>
                                            </div>

</div>

</div>
                                </div>

</div>

</div>
        </div> 
    </div>
</div>

<?php include ("http://www.nrgsoft.com/new2/footer.php"); ?>

</div> 
</div>

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js"></script>

</script>

<script src="http://www.nrgsoft.com/new2/js/syntaxhighlighter/shCore.js"></script>
<script src="http://www.nrgsoft.com/new2/js/syntaxhighlighter/shBrushXml.js"></script>
<script src="http://www.nrgsoft.com/new2/js/syntaxhighlighter/shBrushJScript.js"></script>

</body>

</html>

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.

Posted By

Tagged

Versions (?)

Statistics

Related snippets

php code example

Comments

Choose a language for easy browsing: