/ Published in: PHP
example of php code I worked on
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
<!DOCTYPE html> <?php // set error reporting // start session $servername = ""; $username = ""; $password = ""; $dbname = ""; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($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; // 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"; } ?> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no"> <title>Partners and Integrations | NRGShip</title> <link rel="shortcut icon" href="img/favicon.png"> <meta name="description" content=""> <script type="text/javascript" src="http://www.nrgsoft.com/new2/js/jquery.min.js"></script> <!-- CSS --> <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"> <link href="http://www.nrgsoft.com/new2/css/style-orange.css" rel="stylesheet" media="screen" title="default"> <link href="http://www.nrgsoft.com/new2/css/width-full.css" rel="stylesheet" media="screen" title="default"> <link href="http://www.nrgsoft.com/new2/css/buttons.css" rel="stylesheet" media="screen"> <!-- HTML5 shim and Respond.js IE8 support of HTML5 elements and media queries --> <!--[if lt IE 9]> <script src="http://www.nrgsoft.com/new2/js/html5shiv.min.js"></script> <script src="http://www.nrgsoft.com/new2/js/respond.min.js"></script> <![endif]--> </head> <style> </style> <!-- Preloader --> <div id="preloader"> <div id="status"> </div> </div> <body> <div id="sb-site"> <div class="boxed"> <?php include ("http://www.nrgsoft.com/new2/navbar.php"); ?> <header class="main-header"> <div class="container"> <!-- Collect the nav links, forms, and other content for toggling --> <!-- <div class="pull-right"> <a href="javascript:void(0);" class="sb-icon-navbar sb-toggle-right"><i class="fa fa-bars"></i></a> </div> --> <?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"> <!-- <h4>Categories</h4> --> <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') { // 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>'; } } elseif ($product == 'nrgship_fedexfm') { // 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>'; } } 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') { // 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>'; } } elseif ($product == 'nrgship_upspro') { // 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>'; } } elseif ($product == 'nrgship_fedexpro') { // 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>'; } } ?> </ul> </div> <!-- <div class="col-md-4"> <ul class="portfolio-topbar-desc"> <li id="showDetails"><a href="javascript:void(0);" id="port-show">Show Details</a></li> <li id="hideDetails"><a href="javascript:void(0);" id="port-hide">Hide Details</a></li> </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"> //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"> <a href="#" class="thumbnail"> <img src = "'.$row["Logo_Large"].'" ></a> <div class="caption-ar"> <div class="caption-content"> <a data-toggle="modal" class="btn btn-primary btn-lg btn-ar" href="products.php?partner_id='.$row["partner_id"].'" data-target="#myModal2"> More Info </a> <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"> <a href="#" class="thumbnail"> <img src = "'.$row["Logo_Large"].'" ></a> <div class="caption-ar"> <div class="caption-content"> <a data-toggle="modal" class="btn btn-primary btn-lg btn-ar" href="'.$row["Partner"].'" data-target="#myModal2"> More Info </a> <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"> <a href="#" class="thumbnail"> <img src = "'.$row["Logo_Large"].'" ></a> <div class="caption-ar"> <div class="caption-content"> <a data-toggle="modal" class="btn btn-primary btn-lg btn-ar" href="'.$row["Partner"].'" data-target="#myModal2"> More Info </a> <h4 class="caption-title">'.$row["Partner"].'</h4> </div> </div> </div> '; } else { echo ' <div class="mix '.$row["PartnerCategory"].' col-md-3 col-sm-6 col-xs-12"> <a href="#" class="thumbnail"> <img src = "'.$row["Logo_Large"].'" ></a> <div class="caption-ar"> <div class="caption-content"> <a data-toggle="modal" class="btn btn-primary btn-lg btn-ar" href="#" data-target="#"> More Info </a> <h4 class="caption-title">'.$row["Partner"].'</h4> </div> </div> </div> '; } } ?> <div class="modal" id="myModal2" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true"> <div class="modal-dialog modal-sm"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button> <h4></h4> </div> <div class="modal-body"> <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> <!-- col-md-9 --> </div> </div> <!-- container --> <?php include ("http://www.nrgsoft.com/new2/footer.php"); ?> </div> <!-- boxed --> </div> <!-- sb-site --> <div id="back-top"> <a href="#header"><i class="glyphicon glyphicon-arrow-up"></i></a> </div> <!-- Scripts --> <!-- Include jQuery --> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js"></script> <script type="text/javascript"> </script> <script src="http://www.nrgsoft.com/new2/js/jquery.min.js"></script> <script src="http://www.nrgsoft.com/new2/js/jquery.cookie.js"></script> <script src="http://www.nrgsoft.com/new2/js/bootstrap.min.js"></script> <script src="http://www.nrgsoft.com/new2/js/bootstrap-switch.min.js"></script> <script src="http://www.nrgsoft.com/new2/js/wow.min.js"></script> <script src="http://www.nrgsoft.com/new2/js/slidebars.js"></script> <script src="http://www.nrgsoft.com/new2/js/jquery.bxslider.min.js"></script> <script src="http://www.nrgsoft.com/new2/js/holder.js"></script> <script src="http://www.nrgsoft.com/new2/js/buttons.js"></script> <script src="http://www.nrgsoft.com/new2/js/styleswitcher.js"></script> <script src="http://www.nrgsoft.com/new2/js/jquery.mixitup.min.js"></script> <script src="http://www.nrgsoft.com/new2/js/circles.min.js"></script> <script src="http://www.nrgsoft.com/new2/js/lightbox.min.js"></script> <!-- Syntaxhighlighter --> <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> <script src="http://www.nrgsoft.com/new2/js/app.js"></script> <script src="http://www.nrgsoft.com/new2/js/portfolio.js"></script> </body> </html>