[RESOLVED] Output integer from SubStr

[dcjones]

Hi all,

I have a variable which hold content like "EDB6.4452" and I need to extract only integer part of the string into another variable.

This is what I am working with:

foreach( $parts as $key=> $value){
	$rate = $value;
	$countryname =  substr($rate,1,3);
	$countryratesell =  (substr($rate,6,8));
}

$countryname extracts the first three charaters which is waht I need but I am having issues with extracting just the integer.

Can anyone help please..

[anakadote]

Wouldn't this be the first 3 characters: substr($rate,0,3);

And the the number after the decimal would be substr($rate,5,4);

Or you could split it by the decimal and take the second half that way:

$parts = explode('.', $rate);
$countryratesell = $parts[1];

[dcjones]

Hi anakadote,

Many thanks for your reply.

Not working as expected.

The variable can contain either:

EDBBuy6.4452 or EDBSell5.1002 and I need to get the first three character into:

$countryname and the remaining number including the decimal point into to $countryratesell .

foreach( $parts as $key=> $value){
    $rate = $value;
    $countryname =  substr($rate,1,3); // needs to be EDB
    $countryratesell =  (substr($rate,6,8)); // needs to be either 6.4452 or 5.1002 
} 

Thank, many thanks for your help.

[bradgrafelman]

One way to do it might be using regular expressions:

preg_match('/^(.{3})[^\d.]*([\d.]+)/', $rate, $matches);
list($countryname, $countryratesell) = array($matches[1], $matches[2]);

Note that the last line doesn't include any error checking to make sure that the data actually matched the pattern given.

[dcjones]

Hi Brad and thank you for your reply,

My problem is bigger than I thought. I have a text file which contain data in the following format:

AEDBuy=6.4452&AEDSell=5.1002&ANGBuy=3.164&ANGSell=2.298&ARSBuy=6.8626&ARSSell=5.3583

Knowing you are exceptionally good at "preg_match" can I pick your brains and ask if the following is possible.

Read my data array and have a result which would place parts of the data into individual variables like:

$country = ANG
$sRate = 6.4452
$bRate = 5.1002

$country = AED
$sRate = 3.164
$bRate = 2.298

$country = ARS
$sRate = 6.8626
$bRate = 5.3583

and loop through the ARRAY so I can insert the results in to a table.

The country part of the data will always be three characters.

The numeric part of the data can have a varying length depending on currency exchange rates.

I know I am asking a lot.

Many thanks for any help you can provide.

[bradgrafelman]

[man]parse_str/man:

$str= 'AEDBuy=6.4452&AEDSell=5.1002&ANGBuy=3.164&ANGSell=2.298&ARSBuy=6.8626&ARSSell=5.3583';
parse_str($str, $arr);

print_r($arr);

output:
[pre]Array
(
[AEDBuy] => 6.4452
[AEDSell] => 5.1002
[ANGBuy] => 3.164
[ANGSell] => 2.298
[ARSBuy] => 6.8626
[ARSSell] => 5.3583
)[/pre]

EDIT: To get the first three letters and the corresponding numeric value, use a [man]foreach/man loop with the "$key => $value" syntax so you can use [man]substring/man on the array key.

[laserlight]

You can try something along these lines:

<?php
$str = 'AEDBuy=6.4452&AEDSell=5.1002&ANGBuy=3.164&ANGSell=2.298&ARSBuy=6.8626&ARSSell=5.3583';

if (preg_match_all('/([A-Z]{3})(Buy|Sell)=(\d+\.\d+)/', $str, $matches, PREG_SET_ORDER)) {
    $data = array();
    foreach ($matches as $match) {
        $data[$match[1]][$match[2]] = $match[3];
    }
    print_r($data);
}

It is not exactly what you want, but then what you are asking for does not quite make sense since it would involve overwriting variables that you do not want to overwrite. Thus, my idea here is to create an associative array with the country codes as keys, and an associative array as the value.

[dcjones]

Hi all,

So near, I think.

Just one error, can anyone see why I should be getting this error;

Notice: Undefined index: id in /var/www/vhosts/mydomain/httpdocs/moneycorp/test.php on line 59

session_start();
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    

    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}


mysql_select_db($database_flightq, $flightq);
$query_flights = "TRUNCATE moneyCorpRates";
$flights = mysql_query($query_flights, $flightq) or die(mysql_error());



$file_handle = fopen("DATA/lgwrates.txt", "rb");

while (!feof($file_handle) ) {

$line_of_text = fgets($file_handle);
$str= $line_of_text;
parse_str($str, $arr);



if (preg_match_all('/([A-Z]{3})(Buy|Sell)=(\d+\.\d+)/', $str, $matches, PREG_SET_ORDER)) {
    $data = array();
    foreach ($matches as $match) {
        $data[$match[1]][$match[2]] = $match[3];

	$country  = $match[1];
	$sellRate = $match[2];
	$buyRate  = $match[3];
}
$insertSQL = sprintf("INSERT INTO moneyCorpRates (id, country, sellRate, buyRate) VALUES (%s, %s, %s, %s)",
                   GetSQLValueString($_POST['id'], "int"),
                   GetSQLValueString($_POST['country'] = $country  , "text"),
                   GetSQLValueString($_POST['sellRate'] = $sellRate , "text"),
                   GetSQLValueString($_POST['buyRate'] = $buyRate , "text"));


  mysql_select_db($database_flightq, $flightq);
  $Result1 = mysql_query($insertSQL, $flightq) or die(mysql_error());
}

}  


fclose($file_handle);

Thank you all for your help, I learn with each day.

[bradgrafelman]

dcjones wrote:

can anyone see why I should be getting this error

Well if 'id' is an undefined index of the $_POST array, then you apparently didn't submit any form element with a name of 'id'.

EDIT: You might also want to use print_r() to take a look at the array structure that laserlight's example generates, because this code:

        $country  = $match[1]; 
        $sellRate = $match[2]; 
        $buyRate  = $match[3]; 

is wrong.

[dcjones]

Hi Brad,

Your right, Laserlight has missing the mark. But she is so near.

I have gone back to your code:

$str= 'AEDBuy=6.4452&AEDSell=5.1002&ANGBuy=3.164&ANGSell=2.298&ARSBuy=6.8626&ARSSell=5.3583';
parse_str($str, $arr);

When I run your code I do see the data I want to process but do I get each element in to three variables:

$country
$sellRate
$buyRate

I am now working with:

$file_handle = fopen("DATA/lgwrates.txt", "rb");

while (!feof($file_handle) ) {

$line_of_text = fgets($file_handle);
$str= $line_of_text;
parse_str($str, $arr);

foreach( $arr as $key=> $value){
	$sellRate  = $value;


$insertSQL = sprintf("INSERT INTO moneyCorpRates ( country, sellRate, buyRate) VALUES ( %s, %s, %s)",

                   GetSQLValueString($_POST['country'] = $country  , "text"),
                   GetSQLValueString($_POST['sellRate'] = $sellRate , "text"),
                   GetSQLValueString($_POST['buyRate'] = $buyRate , "text"));


  mysql_select_db($database_flightq, $flightq);
  $Result1 = mysql_query($insertSQL, $flightq) or die(mysql_error());
  } 
}

Sorry to be a pain in the neck.

[bradgrafelman]

dcjones;10951207 wrote:

Your right, Laserlight has missing the mark. But she is so near.

It wasn't his (:p) code that was wrong, it was your implementation.

If you go with laserlight's approach, you don't need to modify his foreach() loop at all.. you just need to understand the array structure that it creates and use it accordingly.

That's why I suggested you do a [man]print_r/man (which, incidentally, laserlight even included in his code snippet) to look at the resulting array.

[dcjones]

Hi Brad,

Firstly I apologise for referring to LaserLight as female.

LaserLight, I apologise.

With regard to Laserlights code, having taken another look I do understand it and the results are what I am looking for.

Many, many thanks for the help and your time the both of you have given.