PHP - Parse Out Values In String Separated By Periods

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=342695.0

So I'm trying to create an Array from a comma separated string containing array{s}. How can I take a string full of comma separated hex values such as : 

<?php
    $myStr = (
        "00ffff", "00cccc", "009999", 
        "007777", "004444", "001111", 
        "01ffff", "01cccc", "019999"
    );
?>

& turn it into 3 separated arrays like : 

<?php
    $myNewArrs = [
        Array1 ( 3 ), 
        Array2 ( 3 ), 
        Array3 ( 3 ), 
    ];
?>

which REALLY looks like : 

<?php
    $myNewArrs = [
        Array ( "00ffff", "00cccc", "009999" ), 
        Array ( "007777", "004444", "001111" ), 
        Array ( "01ffff", "01cccc", "019999" ), 
    ];
?>

?

Any assistance is most-definitely appreciated!

Thank you & have a great afternoon!

 

 

Edited May 27 by AquariaXI

Hello to everyone

Can someone help me on how to parse this CSV string? I do not know how to parse string using PHP..

#1# "4","+447980123456","+447781484145","","2009-07-08","10:38:15","hello "","" world","Orange" "5","+447980123456","+447781484146","","2009-07-08","10:38:55","hello world","Orange"


This string can contain a much bigger data. I would like the result to be

Originator : +447781484145, Date : 2009-07-07, Time : 10:38:15, Message : hello world
Originator : +447781484146, Date : 2009-07-08, Time : 10:38:55, Message : hello world


Please guys if anyone of you knows how to parse this string it will be much appreciated. Im nearing my deadline for my work and this thing is keeping me from finishing it..

Thanks in advance

I have a $string with this structure "word-word2 something-SECONDPART". I want to divide it to $string1 and $string2 by separating with the last "-".

The point is that "-" exists in the first part, and I just want to make the second string after the last "-"

I have a list of pictures and I want to control the order.


Here is the picture format:
$pic = http://www.picture.biz/incoming/w_2GTEK13T961240561_1.jpg
$pic = http://www.picture.biz/incoming/w_2GTEK13T961240561_2.jpg
$pic = http://www.picture.biz/incoming/w_2GTEK13T961240561_3.jpg
$pic = http://www.picture.biz/incoming/w_2GTEK13T961240561_4.jpg
$pic = http://www.picture.biz/incoming/w_2GTEK13T961240561_5.jpg

Notice the order 1.jpg, 2.jpg, etc..

Here is where I'm stuck...

// begin stuck :)
$orderPic = explode("_", $pic);

foreach($orderPic as $rank){
     echo "$rank"; // I need $rank to equal 1 then 2 then 3 ...
}


It would be nice actually if I could start the insert with number 2 because number one is always a screwy picture.

I hope this makes sense /  Thank for the help!

I'm trying the fetch some geocode data from mapquest. Google doesn't like me right now. I keep running into the query_limit. So I want to set a back up that will go into production when I get that error from the big G.

I have my api key and I can put the string in a var.
Code: [Select]
$geocode = file_get_contents($url)

I selected json as the output and when I echo $geocode... here is the first portion of the string....(I want lat & lng)

Code: [Select]
renderOptions({"results":[{"locations":[{"latLng":{"lng":-112.35984,"lat":34.58752},.....
Now for the life of me, I can't do anything with it.
I've tried json_decode() with the true argument there and not.
Code: [Select]
$output = json_decode($geocode, true);
$output = json_decode($geocode);
vardump($output) is NULL.

So, I thought, well maybe I don't need to decode it, but I can't figure out how to parse it.

I'm lost. This admittedly is my first attempt as trying to work with a jason object, but jeesh, it doesn't seem like it should be that hard.
Can someone start me in the right direction?

I need parse the JSON string below into an associative array, sort it by the 'age' field and output the sorted array as an HTML table. Here is what I have done so far but it just returns me 'Array':

Code: [Select]
<?php
$json='[{"name": "John","age": 23},{"name": "jim","age": 19},{"name": "jason","age": 34}]';
$array = json_decode( $json, true); 
 
function cmp( $a, $b){ 
  if( !isset( $a['age']) && !isset( $b['age'])){ 
    return 0; 
  } 
 
  if( !isset( $a['age'])){ 
    return -1; 
  } 
 
  if( !isset( $b['age'])){ 
    return 1; 
  } 
 
  if( $a['age'] == $b['age']){ 
    return 0; 
  } 
 
  return (($a['age'] > $b['age']) ? 1 : -1); 
} 

usort( $array, 'cmp');
foreach ($array as $key => $value) {
    echo $key.":".$value."\n";
}
?>

I call a web service and it retuens the values in the following format

$response = $client->submitRequest($requestParams);

Which returns

stdClass Object
(
    [return] => stdClass Object
        (
            [result_code] => 0
            [result_data] => City[0]=Chicago
            [message_text] => 
        )

)

what I want is just the value for

[result_data] => City[0]=Chicago

assigned to a variable     Psedo Code

$city = [result_data] => City[0]=Chicago;

so that $city = Chicago;  

Hello All,   Being a newbie at PHP coding I'm at my wits end trying to figure out:      a) how to pull-in values from a delimeted text field (in a MySQL table) and check/select the appropriate checkboxes, based on the values that were stored in the text field,      b) how to write any changes (made by the user) back to the tables' text field.   Note that this is for an "update.php" file/process.   My "create.php" file/process uses the following HTML to display and accept the checkbox values:

                <div class="control-group">
                    <label class="control-label">Limited Time Sale Days:</label>
                    <div class="lts-checkboxes-container">
                        <label class="indent-to-the-left">
                               <input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='F'><span class='no-highlight'>Fri</span>
                        </label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='Sa'><span class='no-highlight'>Sat</span></label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='Su'><span class='no-highlight'>Sun</span></label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='M'><span class='no-highlight'>Mon</span></label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='Tu'><span class='no-highlight'>Tue</span></label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='W'><span class='no-highlight'>Wed</span></label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='Th'><span class='no-highlight'>Thu</span></label>
                    </div>
                </div>

And the code (certainly not the best code in the world, but it works) to collect, delemit/concatenate, and save to DB is as follows:

        if(empty($_POST['limited_time_sale']))
            {
                // echo("You didn't select any weekday.");
                $selected_lts = '';
                $limited_time_sale = '';
            }
        else
            {
                $limited_time_sale = $_POST['limited_time_sale'];    
                $N = count($limited_time_sale);
                $selected_lts = '';
                 // echo("You selected $N DoW(s): ");
                for($i=0; $i < $N; $i++)
                    {
                        // echo($limited_time_sale[$i] . " ");
                        if ($i < ($N - 1))
                            {
                                $selected_lts .= $limited_time_sale[$i] . "-";
                            }
                        else
                            {
                                $selected_lts .= $limited_time_sale[$i];
                            }
                    }
            }
 
        if(!empty($selected_lts)) { $limited_time_sale = $selected_lts; }

Now, I've figured out how to bring-in, and separate the stored values using the following code, however I have no idea what to do next...in order to have only the approprite boxes checked/selected (in the event that all boxes were not selected during the create stage).

                $limited_time_sale = isset($values['limited_time_sale']) ? $values['limited_time_sale'] : '';                
                $checked_lts = explode("-", $limited_time_sale);

In my "update.php" file, the HTML for the forms' checkboxes is as follows:  

                <div class="control-group">
                    <label class="control-label">Limited Time Sale Days:</label>
                    <div class="lts-checkboxes-container">
                        <label class="indent-to-the-left">
                               <input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='F' <?php echo $lts1; ?>><span class='no-highlight'>Fri</span>
                        </label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='Sa' <?php echo $lts2; ?>><span class='no-highlight'>Sat</span></label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='Su' <?php echo $lts3; ?>><span class='no-highlight'>Sun</span></label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='M' <?php echo $lts4; ?>><span class='no-highlight'>Mon</span></label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='Tu' <?php echo $lts5; ?>><span class='no-highlight'>Tue</span></label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='W' <?php echo $lts6; ?>><span class='no-highlight'>Wed</span></label>
                        <label><input class='lts-checkbox' type='checkbox' name='limited_time_sale[]' value ='Th' <?php echo $lts7; ?>><span class='no-highlight'>Thu</span></label>
                    </div>
                </div>

    Attached picture shows that selected checkboxes are saved to the text field as/in the format of "F-Sa-Su-M-Tu-W-Th" - if all checkboxes/weekdays were selected....or as "Sa-M-W-Th" - if only Sat, Mon, Wed, and Thu checkboxes were selected   Thanks.   Attached Files  checkbox-Question.png   403.99KB   0 downloads

I have a table with Territory Representative Sales.  It has columns that go back 26 months.  The columns are SALES_OLDEST_PD_1, SALES_PD_2, SALES_PD_3, ..... SALES_PD_25, SALES_LAST_PD_26, & SALES_CURR_PD_27.   SALES_CURR_PD_27 is the current month.

I want to build a table with "Last Year To Date Sales" (LYTD), "Current Year To Date Sales" (CYTD), (May 2011), and (May 2010).  I know that (May 2011) will be SALES_CURR_PD_27 and (May 2010) will be SALES_PD_15.

The trick is that the sales year starts in November.  So, I need to figure out a way to match the table columns with "Nov. 09 - May. 10 TOTAL" for (LYTD) and "Nov. 10 - May. 2011 TOTAL" for (CYTD). I am familiar with using mktime() to subtract months.  But, I am not sure where to start yet on this project.

Jake
Code: [Select]
while (odbc_fetch_row($rs))
  {
$M1 += odbc_result($rs,"SALES_OLDEST_PD1");
$M2 += odbc_result($rs,"SALES_PD2");
$M3 += odbc_result($rs,"SALES_PD3");
$M4 += odbc_result($rs,"SALES_PD4");
$M5 += odbc_result($rs,"SALES_PD5");
$M6 += odbc_result($rs,"SALES_PD6");
$M7 += odbc_result($rs,"SALES_PD7");
$mate += odbc_result($rs,"SALES_PD8");
$M9 += odbc_result($rs,"SALES_PD9");
$M10 += odbc_result($rs,"SALES_PD10");
$M11 += odbc_result($rs,"SALES_PD11");
$M12 += odbc_result($rs,"SALES_PD12");
$M13 += odbc_result($rs,"SALES_PD13");
$M14 += odbc_result($rs,"SALES_PD14");
$M15 += odbc_result($rs,"SALES_PD15");
$M16 += odbc_result($rs,"SALES_PD16");
$M17 += odbc_result($rs,"SALES_PD17");
$M18 += odbc_result($rs,"SALES_PD18");
$M19 += odbc_result($rs,"SALES_PD19");
$M20 += odbc_result($rs,"SALES_PD20");
$M21 += odbc_result($rs,"SALES_PD21");
$M22 += odbc_result($rs,"SALES_PD22");
$M23 += odbc_result($rs,"SALES_PD23");
$M24 += odbc_result($rs,"SALES_PD24");
$M25 += odbc_result($rs,"SALES_PD25");
$M26 += odbc_result($rs,"SALES_LAST_PD26");
$M27 += odbc_result($rs,"SALES_CURR_PD27");
  }
Note: By the way SMF is changing $M"8" to $M"ate". lol

I am trying to wrap my head around the best approach to accomplish this.   I am trying to come up with a random schedule for a full 24 hour day with random time periods ranges including breaks. The only constants will be the minimum time and maximum time of the events and the minimum and maximum time of the breaks between each event.   for example There are three teams Team A Team B Team C   Each event will last either a minimum of 7 minutes to a maximum of 38 minutes The breaks will last a minimum of 30 seconds to a maximum of 5 minutes.   so the events need to be generated randomly with a break period following each event and the timelines are different for each team with the current event time left going to  a timer on the page   I think I have the part to generate the random blocks figured out by using 

<!DOCTYPE html>
<html>
<body>
<?php
function eventRange($min, $max, $blocks) {
    $events = range($min, $max);
    shuffle($events);    
    return array_slice($events, 0, $blocks);
    
}

function breakRange($min, $max, $blocks) {
    $breaks = range($min, $max, 0.1);
    shuffle($breaks);    
    return array_slice($breaks, 0, $blocks);
    
}
echo"<pre>";
print_r( eventRange(7,38,32) );
echo"</pre>";

echo"<pre>";
print_r( breakRange(.5,5,32) );
echo"</pre>";

?>
</body>
</html>

bur is there a way to make it fill a full 24 hour period and then a way to determine which block to display based on the current time when either team is viewing the page.   Sounds totally confusing to me as I try to explain it so I hope what Im asking makes sense. Thanks for any guidance..          

Hi,

I have a string with the value of

{ "success": true, "delivered": true, "contactDetailsRequired": false, "message": "Signed For by: D ANDERSON ", "signature": "https://webservices.thedx.co.uk/PodImage/ImageHandler.ashx?tn=906732192165", "date": "21-07-2020", "serviceLevelName": "Consigned", "time": "13:33:19", "trackedProductName": "DataExchange" }

How do i go about placing the values into variables so for example:

$success = "true";
$delivered = "true";
$message = "Signed for by: D ANDERSON";
etc....

My mind has gone blank and im having one of those days, any help would be greatly appreciated. Thanks

Hi,

I currently have a string with some values in it:

$a_random_string="some random text, goes here - $123<br>some more random text goes here - $53 (text 123 )<br>ANother line of text - $126";

Now I want to add all the values that have a '$' before the value eg; $123.

So in this case I would end up with: 302

How would I do this?

Thanks,

mme

okay all i need is a way to make 4 <OPTION> values into a string which i can compare to a row in my db.

 This is my form.
Code: [Select]
<select name='n1'>
        <option value='0'>0</option>
        <option value='1'>1</option>
        <option value='2'>2</option>
        <option value='3'>3</option>
        <option value='4'>4</option>
        <option value='5'>5</option>
        <option value='6'>6</option>
        <option value='7'>7</option>
        <option value='8'>8</option>
        <option value='9'>9</option>
    </select>
    <select name='n2'>
        <option value='0'>0</option>
        <option value='1'>1</option>
        <option value='2'>2</option>
        <option value='3'>3</option>
        <option value='4'>4</option>
        <option value='5'>5</option>
        <option value='6'>6</option>
        <option value='7'>7</option>
        <option value='8'>8</option>
        <option value='9'>9</option>
    </select>
    <select name='n3'>
        <option value='0'>0</option>
        <option value='1'>1</option>
        <option value='2'>2</option>
        <option value='3'>3</option>
        <option value='4'>4</option>
        <option value='5'>5</option>
        <option value='6'>6</option>
        <option value='7'>7</option>
        <option value='8'>8</option>
        <option value='9'>9</option>
    </select>
    <select name='n4'>
        <option value='0'>0</option>
        <option value='1'>1</option>
        <option value='2'>2</option>
        <option value='3'>3</option>
        <option value='4'>4</option>
        <option value='5'>5</option>
        <option value='6'>6</option>
        <option value='7'>7</option>
        <option value='8'>8</option>
        <option value='9'>9</option>
    </select>

here is the php code which i tried but doesnt seem to work.
Code: [Select]
       $n1 = $_POST['n1'];
       $n2 = $_POST['n2'];
       $n3 = $_POST['n3'];
       $n4 = $_POST['n4'];
       
       $string = ("" . $n1 . "" . $n2 . "" . $n3 . "" . $n4 . "");

echoing $string does give to correct numbers.. but when i try and compare it to my database it doesnt match.


all help would be great.

I have a DB of data: article-id, section-id, subsection-id, article-text. When a row is fetched I am displaying article, section, subsection as <h3>, <h4>, <h5> and then text in a <p>. Before outputting the text I want to scan it for other articles, sections, or subsections it may reference then turn that reference into a hyperlink. I read the PHP documentation but I can't find anything that translates to the basic commands of instring, indexof, and left/mid/right. 

Example:

1. Article Name

100. Article 1, section 1

100.a article 1, section 1, subsection a

Text blah blah blah 105.f blah blah blah

 

I want to find that 105.f and turn it into a link. All my articles, sections, and subsections are in the DB so I know I can use an array of the number values as my items to look for, but I can't figure out how to look.