{"id":1478,"date":"2017-11-30T15:22:51","date_gmt":"2017-11-30T15:22:51","guid":{"rendered":"https:\/\/buyblueridgefood.com\/?page_id=1478"},"modified":"2017-11-30T15:22:51","modified_gmt":"2017-11-30T15:22:51","slug":"database-print-out","status":"publish","type":"page","link":"https:\/\/blueridgefood.com\/index.php\/database-print-out\/","title":{"rendered":"Database Print Out"},"content":{"rendered":"

[insert_php]<\/p>\n

$servername = “localhost”;
\n $username = “blueridg_bridge”;
\n $password = “kr~COSJQ7DP5”;
\n $dbname = “blueridg_bridge”;<\/p>\n

$priceType = “regular_price”;<\/p>\n

\/\/ Create connection
\n $conn = mysqli_connect($servername, $username, $password, $dbname);
\n if( mysqli_connect_errno() ){
\n echo “Database Error: “.mysqli_connect_errno();
\n }else{
\n $sql = “SELECT name, packaging, “.$priceType.” AS price, promoting, category FROM bridge_products ORDER BY category, name ASC”;<\/p>\n

if($result = mysqli_query($conn, $sql)){
\n while($row = mysqli_fetch_assoc($result)){
\n if($category){
\n if($category != $row[‘category’]){
\n $category = $row[‘category’];
\n echo ‘<\/table>\n

‘.ucfirst($category).’<\/h3>\n\n\n
Item<\/td>\nPackaging<\/td>\nPrice<\/td>\n<\/tr>\n

‘;
\n }
\n }else{
\n $category = $row[‘category’];
\n echo ‘<\/p>\n

‘.ucfirst($category).’<\/h3>\n\n\n\n
Item<\/td>\nPackaging<\/td>\nPrice<\/td>\n<\/tr>\n

‘;
\n }
\n echo ‘<\/p>\n

‘.$row[‘name’].’<\/td>\n‘.$row[‘packaging’].’<\/td>\n‘;
\n if( $row[‘price’] ){
\n echo ‘$’.money_format(‘%i’, doubleval($row[‘price’]));
\n }else{
\n echo $row[‘price’];
\n }
\n echo ‘<\/td>\n<\/tr>\n

‘;
\n }
\n echo ‘<\/table>\n

‘;
\n }
\n }<\/p>\n

[\/insert_php]<\/p>\n","protected":false},"excerpt":{"rendered":"

[insert_php] $servername = “localhost”; $username = “blueridg_bridge”; $password = “kr~COSJQ7DP5”; $dbname = “blueridg_bridge”; $priceType = “regular_price”; \/\/ Create connection $conn = mysqli_connect($servername, $username, $password, $dbname); if( mysqli_connect_errno() ){ echo “Database Error: “.mysqli_connect_errno(); }else{ $sql = “SELECT name, packaging, “.$priceType.” AS price, promoting, category FROM bridge_products ORDER BY category, name ASC”; if($result = mysqli_query($conn, $sql)){ while($row…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1478","page","type-page","status-publish","hentry","no-sidebar"],"_links":{"self":[{"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/pages\/1478","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/comments?post=1478"}],"version-history":[{"count":0,"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/pages\/1478\/revisions"}],"wp:attachment":[{"href":"https:\/\/blueridgefood.com\/index.php\/wp-json\/wp\/v2\/media?parent=1478"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}