PHP - Variable Delivery Amounts

Quote

#adf #234432 #fwerfw

I have this as a result of a form that has been completed.  It might be twice that, it might be much much more.

But what I want to do is render it on a page inside Divs.  So each one is in a kind of shaded box.

The CSS side of it is easy, but how do I extract each one of these into a variable useful means to surround each one by <div>$variable</div>?

I thought it might be "explode", but you appear to have to state the [3] number of the variable to show.  In this case, it's totally random.

We won't be using these as Variables to trigger anything else, it's purely "for display" purposes.

Day

I'm using Codeigniter and inside the framework I create a file with PHP code
(Codeigniter doesn't provide means to create files) by copying from a template
file, set the permissions to 0775 and the ownership is ruled by sticky bits on the
directory hosting the file. The ownership is set to the Apache settings (http:http),
just to be 'sure'...

If I try to point to it, the web-server doesn't deliver due to permission issues.

All this is done in a 'register function' where I create some fields in a SQL
database to save user credentials. As of now the application should be
obvious.

If I put the user credentials into the database 'by hand' and likewise when I
create a file in the above mentioned directory (http:http) 'by hand' and point
the web-server on it, it gets delivered. Even if I keep the original ownership
conditions 'user:http'.

I'm pretty sure this issue has been existed before and I'd appreciate any help.
I'm also sure it has in some way to do with either file creation permissions
or/and the user running PHP. I was going far from that PHP (more precise
mod_php) is running as the same user as Apache?

 

Thanks for your help in forward.

Gee

Edited August 17, 2020 by bogus

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}}';

 

I'm currently working on a browser based mmorpg. First things first, here is an example of my battle.php

<?php
include_once 'connect.php';
session_start();

include_once 'logo.php';
?>
<link href="style.css" rel="stylesheet" type="text/css" />
<div id="login2" div align="center">


<?php




if (isset($_SESSION['player']))
{
  $player=$_SESSION['player'];
}
else
{
  echo "Not Logged in <br><br> <A href='login.php'>Login</a>";
  exit;
}
?>
</div>
<?php
$playerinfo="SELECT * from players where name='$player'";
$playerinfo2=mysql_query($playerinfo) or die("could not get player stats!");
$playerinfo3=mysql_fetch_array($playerinfo2);

include_once 'statpanel.php';

$pid = $playerinfo3['id'];
$name = $playerinfo3['name'];
$playerhp = $playerinfo3['hpoints'];
$playerattack = $playerinfo3['attack'];
$playerdefense = $playerinfo3['defense'];

if ($playerhp < 1)
{
  echo "You are dead!" ;
  echo "<br><a href='inn.php>Heal at the lake";
  exit;
}
?>
<div id="table">

<?php

if (isset($_GET['randid']))
{
   $randid=$_GET['randid'];
   $iteminfo="SELECT * from inventory where randid='$randid' AND id ='$pid'";
$iteminfo2=mysql_query($iteminfo) or die("could not get item stats!");
$iteminfo3=mysql_fetch_array($iteminfo2);

if (!$iteminfo3['name'])
{
}
else
{

$iname = $iteminfo3['name'];
$stats = $iteminfo3['stats'];
$statadd = $iteminfo3['statadd'];
$type = $iteminfo3['type'];

if ($type == "healing")
{
   $newhp = $statadd + $playerhp;
   if ($newhp > $playerinfo3['maxhp'])
   {
    $newhp = $playerinfo3['maxhp'];
   }
    $updateplayer="update players set hpoints='$newhp' where id='$pid'";
  mysql_query($updateplayer) or die("Could not update player");

    $updateitem="DELETE from inventory where id='$pid' AND randid='$randid' limit 1";
  mysql_query($updateitem) or die("Could not delete item");
   
   $playerhp = $newhp;
 
  echo "Used " . $iname . " and recovered " . $statadd . ".<br>";
}

}}





$creature = $playerinfo3['creature'];
if ($creature != 0)
{
$creatureinfo="SELECT * from creatures where id='$creature'";
$creatureinfo2=mysql_query($creatureinfo) or die("could not get the creature you were fighting!");
$creatureinfo3=mysql_fetch_array($creatureinfo2);

}
else
{
  $creatureinfo="SELECT * from creatures order by rand() limit 1";
$creatureinfo2=mysql_query($creatureinfo) or die("could get a creature!");
$creatureinfo3=mysql_fetch_array($creatureinfo2);
$cid = $creatureinfo3['id'];
$updateplayer="update players set creature='$cid' where name='$name'";
  mysql_query($updateplayer) or die("Could not update player");
}

$creature = $creatureinfo3['name'];
$creaturehp = $creatureinfo3['hpoints'];
$creatureattack = $creatureinfo3['attack'];
$creaturedefense = $creatureinfo3['defense'];



?>
</div>
<div id="player">
<?php
/////player info
echo "<u> " . $playerinfo3['name'] . "</u><br>";
echo "Hit points = " . $playerhp . "<br>";
echo "Attack = " . $playerattack . "<br>";
echo "Defense = " . $playerdefense . "<br><br><br>";
?>
</div>
<div id="creature">
<img src="images/<?php echo $creatureinfo3['imgurl'];?>" <br>
<?php
///////creature info

echo "<u> " . $creatureinfo3['name'] . "</u><br>";
echo "Hit points = " . $creaturehp . "<br>";
echo "Attack = " . $creatureattack . "<br>";
echo "Defense = " . $creaturedefense . "<br><br><br>";
 ?>
 </div>

<div id="options">
<?php
echo "<a href='attack.php'>Attack</a>";
echo "<br><a href='usemagic.php'>Use Magic</a>";
echo "<br><a href='useitem.php'>Use Item</a>";
echo "<br><a href='index.php'>Exit Arena</a>";


?>
</div>

<div id="logout">
<?php
echo "<br><a href='logout.php'><img src='images/logout.gif'>";
?>
</div>


Particular functions I'm interested in for zone creation.

-Pay to get in & have the initial icon switch to a now usable adventure zone. (done)

-When 'adventuring' in this link. Battle php randomizes encounters between 'combat encounters' and 'non-combat' encounters.  (can't get this right, and removed my utter failures from the code above as to not clutter it. Pulls randomly from the Creature DB just fine but when I try to add in the 2nd,non-combat,db..it pulls nothing.)

-NonCombat encounters dish our reward. (currently my non combats do not give reward. Unlike a standard creature encounter where a players gold and exper get updated on a victory...I dont know how to immediately trigger the change on encounter & I'm epically unsure how to craft the $updateplayer= to be so broad as to include all possibilities of improvement but only to utilize the one being called upon in the encounter)

-I'm also interested in updating my battle.php to include a dropdown list of usable spells/items instead of the current method of Attacking/going back/selecting magic or items/going back/...repeat. It works, sure, but its nasty..Any ideas on how to call on the database for user specific data to fill in a drop down menu?

i have a form that has a price field, but if anything other than a decimal (0.00) a zero is entered into the database. There is the problem of people trying to add a dollar sign before their amount. What is the best way to validate a price amount to be entered into the database. The column in the database type is decimal(6,2). Any suggestions?