PHP - Randomizing Encounters & Data Delivery Help Please.

Hi All, Long long long time lurker here! 

A little background to understand how this fits in

So I am building a local directory for my local area as part of a community project. Part of this there is the ability for local stores to sell online locally for people to have delivered or collect. So in the UK we have postcodes in the formats:

AB12 3CD,

A1 2BC

A12 3CD,

A1B 2CD

Most delivery pricing solutions only care about the full postcode as they are all about national delivery or at best only care about the first half. Due to the local nature we need more granularity to it so we have some rules: 

Delivery Available

EH => Price

EH3 => Price

EH3 1 => Price

EH3 1-4 => Price

Exceptions - No Delivery allowed

EH => null

EH3 => null

EH3 1 => null

EH3 1-4 => null

Can mix and match for example:

EH3 = £2.00

EH3 2 => £2.25

EH3 5 => null

This means that ALL EH3 address the delivery cost is £2 BUT If they are in EH3 2 then its £2.25 or if the are in EH3 5 then no delivery is possible.

I have came up with this monstrosity of code that for the most part works but also can throw the wrong delivery prices out due to bugs and issues that I can't seem to work out!  

Main Function:

function isDeliverable($postcode, $rules){
		
		$canDeliver = false;
		$deliveryValue = 0.00;
		$found = false;
			
		list($outward, $inward) = explode(' ', $postcode);
		$area = substr($outward, 0, 2);
		$district = substr($outward, 2);
		$sector = substr($inward, 0, 1);
		$unit = substr($inward, 1,1);
		
		$rulez = json_decode($rules, true);
		
		
		//RULE START - EH10 9RJ
		$pcFound = inRule($rulez, $postcode);
		
		if($pcFound){
			return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];
		}
		//RULE END - EH10 9RJ
		
		
		
		
		
		
		//RULE START - EH10 9R
		$pcFound = inRule($rulez, $area.$district.' '.$sector.$unit);
		
		if($pcFound && !strpos($pcFound['postcode'], "-")){
			return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];
		}
		//RULE END - EH10 9R
		
		
		
		
		
		
		//RULE START - EH10 9A-F
		$pcFound = inRule($rulez, $area.$district.' '.$sector.$unit, 1);
				
		if($pcFound){
			
			$postArray = postcodeExploder($pcFound, 1);
			
			$pcFound = inRule($postArray, $area.$district.' '.$sector.$unit);
		
			if($pcFound){
				return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];
			}			
		}
		//RULE END - EH10 9A-F
		
		
		
		
		
		
		//RULE START - EH10 9
		$pcFound = inRule($rulez, $area.$district.' '.$sector);
				
		if($pcFound && !strpos($pcFound['postcode'], "-")){
			return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];			
		}
		//RULE END - EH10 9
		
		
		
		
		
		//RULE START - EH10 1-4
		$pcFound = inRule($rulez, $area.$district.' '.$sector, 2);

		if($pcFound){
			$postArray = postcodeExploder($pcFound, 2);

			$pcFound = inRule($postArray, $area.$district.' '.$sector);
			
			if($pcFound){
				return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];
			}			
		}
		//RULE END - EH10 1-4
		
		
		
		
		
		//RULE START - EH10
		$pcFound = inRule($rulez, $area.$district);

		if($pcFound && !strpos($pcFound['postcode'], "-")){
			return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];			
		}
		//RULE END - EH20
		
		
		
		
		
		//RULE START - EH1-20
		$pcFound = inRule($rulez, $area.$district, 3);
		
		if($pcFound){

			$postArray = postcodeExploder($pcFound, 3);

			$pcFound = inRule($postArray, $area.$district);
		
			if($pcFound){
				return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];
			}			
		}
		//RULE END - EH1-20
		
		
		
		
		
		//RULE START - EH
		$pcFound = inRule($rulez, $area);
		
		if($pcFound && !strpos($pcFound['postcode'], "-")){
			return ['canDeliver' => $pcFound['deliverable'], 'deliveryValue' => $pcFound['price']];			
		}
		//RULE END - EH
		
	
		return ['canDeliver' => $canDeliver, 'deliveryValue' => $deliveryValue]; 
	}

Helper Functions:

function inRule($rules, $postcode, $type = null){
		
		foreach($rules as $key => $rule){
			
			if(substr_count($rule['postcode'], '-') !== 0 && strlen($postcode) > 2){
				$pEX = postcodeExploder($rule, $type);

				foreach($pEX as $r){
					
					if($r['postcode'] == $postcode){
						return $rules[$key];
					}
					//$rule['postcode'] = trim(substr($rule['postcode'], 0, strpos($rule['postcode'], "-")-1));
				}
			}		
			
		   
			if ( $rule['postcode'] == $postcode )
		    	return $rules[$key];
		}
		
		return false;
	}
	
	function postcodeExploder($rule, $type){
		$out = [];
		
		$r = explode(' ', $rule['postcode']);
    	$count = count($r);
    					    	
    	//It must be in the form AB1 1C
    	//$first = AB1
    	//$last = 1C-G
    	if($count == 2){
    		list($first, $last) = $r;
    	} else {
	    	$last = $r[0];
    	}
		
		list($left, $right) = explode('-', $last);
			   	
	    $sec = $left[0];

    	$leftInward = substr($last, strpos($last, '-')-1,1);
    	$rightInward = substr($last, strpos($last, '-')+1,1);
    	
		$range = range($leftInward, $rightInward);	

		foreach($range as $key => $ra){
			
			if($type == 1){
			
				$out['a'.$key] = [
					'postcode' => $first.' '.$sec.$ra,
					'deliverable' => $rule['deliverable'],
					'price' => $rule['price']
				];
				
			} else if($type == 2){
				
				$out['a'.$key] = [
					'postcode' => $first.' '.$ra,
					'deliverable' => $rule['deliverable'],
					'price' => $rule['price']
				];
				
			} else {
				
				$out['a'.$key] = [
					'postcode' => preg_replace('/\PL/u', '', $left).$ra,
					'deliverable' => $rule['deliverable'],
					'price' => $rule['price']
				];
				
			}
		}
		
		return $out;
		
	}

Stores Rules:

	$rules = '{"a1":{"postcode":"EH9","deliverable":true,"price":"1.50"},"a2":{"postcode":"EH9 7","deliverable":true,"price":"1.60"},"a3":{"postcode":"EH9 7A","deliverable":true,"price":"1.70"},"a4":{"postcode":"EH9 7AY","deliverable":true,"price":"1.80"},"a5":{"postcode":"EH1-2","deliverable":true,"price":"1.90"},"a6":{"postcode":"EH1 2-3","deliverable":true,"price":"2.00"},"a7":{"postcode":"EH4 5A-N","deliverable":true,"price":"2.10"},"a8":{"postcode":"EH","deliverable":true,"price":"1.40"},"a9":{"postcode":"TD14","deliverable":true,"price":"2.00"},"a10":{"postcode":"TD14 5DC","deliverable":false,"price":null}}';

Hello to all,

I have problem figuring out how to properly display data fetched from MySQL database in a HTML table.

In the below example I am using two while loops, where the second one is nested inside first one, that check two different expressions fetching data from tables found in a MySQL database. The second expression compares the two tables IDs and after their match it displays the email of the account holder in each column in the HTML table.

The main problem is that the 'email' row is displayed properly while its while expression is not nested and alone(meaning the other data is omitted or commented out), but either nested or neighbored to the first while loop, it is displayed horizontally and the other data ('validity', 'valid_from', 'valid_to') is not displayed.'

Can someone help me on this, I guess the problem lies in the while loop?
Here is part of the HTML code:

<thead>
 <tr>
 <th data-column-id="id" data-type="numeric">ID</th>
 <th data-column-id="email">Subscriber's Email</th>
 <th data-column-id="validity">Validity</th>
<th data-column-id="valid_from">Valid From</th>
 <th data-column-id="valid_to">Valid To</th>
</tr>
</thead>

Here is part of the PHP code:

    <?php
    while($row = $stmt->fetch(PDO::FETCH_ASSOC))
    {
        echo '
            <tr>
                <td>'.$row["id"].'</td>
        ';
        while ($row1 = $stmt1->fetch(PDO::FETCH_ASSOC)) {
        echo '
                <td>'.$row1["email"].'</td>
        ';
        }
        if($row["validity"] == 1) {
            echo '<td>'.$row["validity"].' month</td>';
        }else{
            echo '<td>'.$row["validity"].' months</td>';
        }
        echo '  <td>'.$row["valid_from"].'</td>
                <td>'.$row["valid_to"].'</td>
        </tr>';
    }
    ?>

P.S. Please know that I have purposely omitted the connection part and the methods in the class that are used in this code to keep the spot of the problem as clean as possible. If you need me to rephrase the question, please ask.

Thank you.

<?php 
session_start(); 
if(!isset($_SESSION['Logged_in'])){
header("Location: /page.php?page=login");
}
?>
<!DOCTYPE Html>
<html>
<head>
<!--Connections made and head included-->
<?php require_once("../INC/head.php"); ?>
<?php require_once("../Scripts/DB/connect.php"); ?>
<!--Asynchronously Return User Names-->
<script>
$(document).ready(function(){
function search(){
        var textboxvalue = $('input[name=search]').val();
        $.ajax(
        {
            type: "GET",
            url: 'search.php',
            data: {Search: textboxvalue},
            success: function(result)
            {
                $("#results").html(result);
            }
        });
};​
</script>
</head>
<body>
<div id="header-wrapper">
<?php include_once("../INC/nav2.php"); ?>
</div>
<div id="content">
<h1 style="color: red; text-align: center;">Member Directory</h1>
<form onsubmit="search()">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<label for="search">Search for User:</label>
<input type="text" size="70px" id="search" name="search">
</form>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="index.php?do=">Show All Users</a>|<a href="index.php?do=ONLINE">Show All Online Users</a>
<div id="results">
<!--Results will be returned HERE!-->
</div>

<?php
//testing if data is sent ok
echo "<h1>Hello</h1><br>" . $_GET['search'];
?>

<?
include("admin_code_header.php");


if ($_POST["DeletePost"]) {
    $id = $_POST['id'];
    $query = "DELETE FROM ".$dbTable." WHERE id='".$id."'"; 
    mysql_query($query);
    echo "ID removed from system: ".$id;
  }


if ($_POST["BanIP"]) {
    $IP_To_Add = $_POST["ip"];
    
      $sql = "INSERT INTO ".$IPBanTable." (ip) VALUES (\"$IP_To_Add\")";
      $result = mysql_query($sql);
  }
$result = mysql_query("SELECT * FROM ".$dbTable." WHERE id='".$id."'",$db);

  while ($myrow = mysql_fetch_array($result)) {
    $msg = $myrow["StringyChat_message"];
$idm = $myrow["id"];



?>
<html>
<form name="form<? echo $myrow["id"];?>" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">

<input name="DeletePost" type="submit" id="DeletePost" value="Delete">

<input name="BanIP" type="submit" id="BanIP" value="Ban <? echo $myrow["StringyChat_ip"];?>">
    </form>
</html>
<?
}
?>

Hi,

I want to pull data from db, where sometimes all rows and sometimes rows matching given "username".

Here is my code:

	//Grab Username of who's Browsing History needs to be searched. 
	if (isset($_GET['followee_username']) && !empty($_GET['followee_username'])) 
{ 
    $followee_username = $_GET['followee_username']; 
    
    if($followee_username != "followee_all" OR "Followee_All") 
    { 
        $query = "SELECT * FROM browsing_histories WHERE username = \"$followee_username\""; 
        $query_type = "followee_username"; 
        $followed_word = "$followee_username"; 
        $follower_username = "$user"; 
        echo "$followee_username"; 
    } 
    else 
    { 
        $query = "SELECT * FROM browsing_histories"; 
        $query_type = "followee_all"; 
        $followed_word = "followee_all"; 
        $follower_username = "$user"; 
        echo "all"; 
    } 
} 
	

When I specify a "username" in the query via the url:

browsing_histories_v1.php?followee_username=requinix&page_number=1

I see result as I should. So far so good.

Now, when I specify "all" as username then I see no results. Why ? All records from the tbl should be pulled!

browsing_histories_v1.php?followee_username=all&page_number=1

This query shouldv'e worked:

	$query = "SELECT * FROM browsing_histories";