[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{

echo get_current_user_id();

$sql = “SELECT id, name, packaging, “.$priceType.” AS price, promoting, category FROM bridge_products ORDER BY id”;
if($result = mysqli_query($conn, $sql)){
$rowCount = mysqli_num_rows($result);
$i = 0;
echo ‘‘;
}

$sql = “SELECT id, name, packaging, “.$priceType.” AS price, promoting, category FROM bridge_products ORDER BY category, name ASC”;

if($result = mysqli_query($conn, $sql)){
while($row = mysqli_fetch_assoc($result)){

if($category){
if($category != $row[‘category’]){
echo ‘