PHP - Extracting Only The Last Array's Child Elemets

I have a multidimensional array for a calendar application as shown below.  The first level is an associative array for calendar dates, and the second is a numeric array for multiple events on each day.  The third level holds the events.  I know that I can extract a single event using the array indices, such as:

echo $events['2010-11-24'][0]['event_date'];

If I know the number of events for the date, I can extract them one-by-one by incrementing the array index.  However, I never know how many events will be stored for any one day.

I also know that I can extract all the data in the entire array using a foreach loop.  But how can I extract only the data in a subarray?


Array
(
    [2010-11-16] => Array
        (
            => Array
                (
                    [event_date] => 2010-11-16
                    [title] => Board Meeting
                )

            [1] => Array
                (
                    [event_date] => 2010-11-16
                    [title] => Second event
                )

        )

    [2010-11-24] => Array
        (
            => Array
                (
                    [event_date] => 2010-11-24
                    [title] => New meeting
                )

        )

)

Hi all,

I hope someone can help me out here as I think I am close but am not sure where to go from here.  The problem is:
I have a cms where a user can see a list of photos in the gallery.
I provide them the ability to select what photos they want to appear on a particular webpage.
The problem I have is that the user wants to be able to put the photos in whatever order they choose.

So, I have a form (see attached), the html code is:

          <table width="566px" cellspacing="0" border="0">              <tr>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' checked='checked' name='photos[][0]' value='119' />&nbsp;Bathroom Sin...
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value="0"/>                  </div>
                </td>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' checked='checked' name='photos[][0]' value='113' />&nbsp;Courtyard 1
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value="0"/>                  </div>
                </td>
                <td width="33%">
                  <div class="serviceCell">
<input type='checkbox' name='photos[][0]' value='114' />&nbsp;Courtyard 2
<img src="./images/help.gif" title="Enter an integer to signify the order in which this image will appear on the webpage." alt="Enter an integer to signify the order in which this image will appear on the webpage."/>&nbsp;<input type="text" size="2"  name="photos[][1]" value=""/>                  </div>
                </td>
              </tr>...

Now, lets assume that the user ticked the box next to 'Courtyard 2' and entered an integer '1' in the input box to signify that this image should be displayed 1st on the chosen webpage.  These 2 values go into the multidimensional array (photoid, ranking) and are submitted in the form to php in the photos[][] array.

But here is where I have the problem.  I am trying to extract the values from the array and then do an insert to a table in mysql.  My syntax must be wrong somewhere so I am asking anyone to please offer any advice:

  if (isset($_REQUEST['submitted'])){   
       $photos = $_REQUEST['photos'];
...

    if(!empty($photos)){
       foreach($photos as $photoID){
         $sql = "INSERT IGNORE INTO menuItemPhotos
                SET photoid='$photoID[0]', menuItemid='$id', ranking='$photoID[1]'";
        $ok = @mysql_query($sql); // execute the query
      } // End of foreach($photos as $photoID){
    } // End of if(!empty($photos)){

Thanks
Conor

[attachment deleted by admin]

What I'm trying to do is take two arrays and combine them using array_combine. After they are combined I want to take each key and value pair and use them in a string to build a MySQL query. See below for some pseudo-code  =D


<?php
$fields = array('first_name', 'last_name'); //the fields that will be set with an UPDATE query.
$newvals = array('Joe', 'Blow');//The values that will go into $fields

$arr = array_combine($fields, $newvals);//Each value now has a key of the field it will update.

/**
This is where I want to return my SET string with something like 'SET ' . $arr['first_name']  ' = ' . $arr['first_name_value'] ', etc etc.
*/


There it is, I suppose. Are there any easier ways of doing what I'm trying to accomplish, that is, am I on the right track or just making things harder for myself?
Both arrays will have dynamic values throughout my application, so I need to be able to get both each field and value for each query. Any links to some constructs, etc, etc? That's all I really need and I can post the solution when I've figured it out.

I need to set up a threaded comments system in a PHP project and I got this script shown below from http://www.jongales....#comment-436261

class Threaded_comments
{
    
    public $parents  = array();
    public $children = array();

    /**
     * @param array $comments 
     */
    function __construct($comments)
    {
        foreach ($comments as $comment)
        {
            if ($comment['parent_id'] === NULL)
            {
                $this->parents[$comment['id']][] = $comment;
            }
            else
            {
                $this->children[$comment['parent_id']][] = $comment;
            }
        }        
    }
   
    /**
     * @param array $comment
     * @param int $depth 
     */
    private function format_comment($comment, $depth)
    {   
        for ($depth; $depth > 0; $depth--)
        {
            echo "\t";
        }
        
        echo $comment['text'];
        echo "\n";
    }
    
    /**
     * @param array $comment
     * @param int $depth 
     */ 
    private function print_parent($comment, $depth = 0)
    {   
        foreach ($comment as $c)
        {
            $this->format_comment($c, $depth);

            if (isset($this->children[$c['id']]))
            {
                $this->print_parent($this->children[$c['id']], $depth + 1);
            }
        }
    }

    public function print_comments()
    {
        foreach ($this->parents as $c)
        {
            $this->print_parent($c);
        }
    }
  
}

Here’s the example usage with the data provided as an array:

$comments = array(  array('id'=>1, 'parent_id'=>NULL,   'text'=>'Parent'),
                    array('id'=>2, 'parent_id'=>1,      'text'=>'Child'),
                    array('id'=>3, 'parent_id'=>2,      'text'=>'Child Third level'),
                    array('id'=>4, 'parent_id'=>NULL,   'text'=>'Second Parent'),
                    array('id'=>5, 'parent_id'=>4,   'text'=>'Second Child')
                );

$threaded_comments = new Threaded_comments($comments);

$threaded_comments->print_comments();

I have a sample select query that pulls data from a database and stores the result in the $comments array as shown below. The $comments array is then passed as an argument to the $threaded_comments object:

$sql = 'SELECT * FROM test_comments';
// submit the query and capture the result
$result = $conn->query($sql);
$comments = array();
while ($row = $result->fetch_assoc()) {
    $comments[] = $row;
}

The challenge is that nothing is printed to the screen when I run the script. Inspection of the comments array with the var_dump function is shown below:

array (size=4)
  0 => 
    array (size=3)
      'id' => string '1' (length=1)
      'parent_id' => string '0' (length=1)
      'text' => string 'comment' (length=7)
  1 => 
    array (size=3)
      'id' => string '2' (length=1)
      'parent_id' => string '0' (length=1)
      'text' => string 'comment' (length=7)
  2 => 
    array (size=3)
      'id' => string '3' (length=1)
      'parent_id' => string '1' (length=1)
      'text' => string 'comment ' (length=8)
  3 => 
    array (size=3)
      'id' => string '4' (length=1)
      'parent_id' => string '3' (length=1)
      'text' => string 'comment ' (length=8)

I was wondering if the array format from my select query is the issue? Could anyone provide a clue as to how to fix this?   Thanks.
Edited by terungwa, 11 January 2015 - 05:07 PM.

I'm pulling a list of topics from my DB and they are structured hierarchally using the typical id | parent_id scheme
The array I end up with from the DB is one large one with keys representing the unique id of each data result...The problem is getting past the 2d scope of the array.  I know this will require a recursive function and I've been at it for hours but can't seem to wrap my hurting head around it!  How do I get my orignal array in this form:
Array
(
    [0] => Array
        (
            [1] => top parent
            [2] => top parent
            [3] => top parent
            [9] => top parent
        )

    [2] => Array
        (
            [4] => #1 child of 2
            [5] => #2 child of 2
        )

    [3] => Array
        (
            [6] => #1 child of 3
        )

    [4] => Array
        (
            [7] => #1 child(subsub) of 4
            [8] => #2 child(subsub) of 4
        )

)


To look something more like this? :
Array
(
    [1] => top parent
    [2] => Array
        (
            [4] => Array
                (
                    [7] => #1 child(subsub) of 4
                    [8] => #2 child(subsub) of 4
                )

            [5] => #2 child of 2
        )

    [3] => Array
        (
            [6] => #1 child of 3
        )

    [9] => top parent
)


notice how the 2nd array has all the proper dimensions according the the DB hierarchy.
Thank you

ps. or maybe I should work from a different array to start from...I'm open to suggestions

Hey guys!

I have the following strange problem:

Listing 1:

echo $n;   // Result is 20167 !

      if($child->id == $n){
      $image = array();
      $image[] = '"' . $child->id . '"';
      $image[] = '"' . $child->name . '"';
      $image[] = '"' . $misc->clean_path($child->file) . '"';
      $image[] = '"' . $child->file_name . '"';
      $image[] = '"' . $child->file_type . '"';
        $image[] = '"' . $path . '"';
      
      $images[] = implode("\t", $image);
      }

The if-statement is not true... so probably there's no $child->id with value 20167.... but watch this:

Listing 2:
if($child->id == 20167){
      $image = array();
      $image[] = '"' . $child->id . '"';
      $image[] = '"' . $child->name . '"';
      $image[] = '"' . $misc->clean_path($child->file) . '"';
      $image[] = '"' . $child->file_name . '"';
      $image[] = '"' . $child->file_type . '"';
        $image[] = '"' . $path . '"';
      
      $images[] = implode("\t", $image);
      }

Now with the hard coded value 20167 the statement is true and gives one result....

Strange, isn't it?

I placed the following three functions/test direct before the if-statement:
var_dump($n);    
Result: NULL


echo $n
Result: 20167 

echo "{$n}";
Result:


I tested one function at a time.


How can this happen?


Thanks to all! :-)

Folks,

I want to extract certain portion form URL.

Exmaple:
Quote

http://abc.com/this-is-test.html


Output should be
Quote

this-is-test


Another Example
Quote

http://abc.com/this-is-yet-another-test.html

Output should be
Quote

this-is-yet-another-test


I am not sure how it can be done with preg_match() and regex or something like that...

Can someone help me with this please?

Cheers
Natasha

Hi there

I need to extract data from some XML. I have found a few sites that explain that part to me, however there is a section of the data which I need to extract and am not sure how to go about it. Below is an extract of the XML, the section I am trying to extract is highlighted in red (it is essentially a text message being sent I am trying to get the contents of the sms/text message):

 <usa_smpp_host>THTTP</usa_smpp_host>
 <short_message>id:660352946 sub:001 dlvrd:001 submit date:1102081032 done date:1102081035 stat:DELIVRD err:000 text:Test SMS message</short_message>
 <dest_addr_npi>1</dest_addr_npi>

Any assistance would be appreciated. Have played around quite a bit but have not managed to figure it out yet.

thanks

I have an RSS feed, with alot of data of lottery numbers.

the feed itself is : http://www.alllotto.com/rss/NY/latest.rss

The item i am interested in is:

Quote

<item>
                   <title>Take 5</title>
                 <description>2011-08-27: 4, 10, 16, 17, 31</description>
                   <guid isPermaLink="false">USA-New-York-Take-5-2011-08-27</guid>
                 </item>



How could I output those to varibles?

thanks

Joe

hey guys i need to extract all the IP's of a string and loop them for more operations but for some reason i only get the first one

<?php

$string = '80.37.14.13 80.37.14.14 80.37.14.15';
preg_match("/\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}/", $string, $matches);

foreach ($matches as $ip){
    echo "$ip<br>";
}

?>

The string is not really seperated by spaces ... it can actualy be messy and have ips rapped arround a lot of code. The regex works because i do get the first one ...

What did i miss?

I usually only do design work, but a client wanted a log in system to his website, so I decided to do it.

I set everything up correctly, and users can sign up, login, and log out. However, he wants to be informed when a user logs into his site.

So say (user x) wants logs in, my client wants to receive an email with all of (user x)'s account information. How do I pull a row from mysql based on the login information provided?

My database is has 7 columns: user, pass, name, address, state, phone, email

$example "Q: Example? A:"

Let's assume that I'd like to display $example but exclude "Q:" and "A:", how would I do that?

I'm *attempting* to write a script that will take a paste of data from a user and when it's submitted it will drop certain parts of the data into databases and be available for recall later. I have the MySQL sorta out I think but I can't test until I get this part done.

Basically people will paste a copied paste (CTRL A, CTRL C and go to my form and just hit CTRL V). It will contain a bunch of data I want to drop in the database but in different areas, like the following example the items in bold are the items I want to grab.

First Name: Lincoln
Last Name: Coe
Address: 1234 Easy St, Perfectville, PV 00000
Telephone: 0000000000

HI guys,

I'm quite new to php, and I'm really struggling to get this right. I just cant get it to work properly.

Im trying to extract email from a list of URLS. I have currently got it to work with 1 URL at a time, but I am needing to as to how I can pass multiple URLS at once, either from a csv or just pasting them into the input.
any help would be much appriciated. here is my current code:

Quote

<?php



$the_url = isset($_REQUEST['url']) ? htmlspecialchars($_REQUEST['url']) : '';
?>

<form method="post">
  Please enter full URL of the page to parse (including http://):<br />
  <textarea name="url" cols="100" rows="10"><?php echo $the_url;  ?></textarea>
  <br />

  <input type="submit" value="Get Emails" />
</form>

<?php
if (isset($_REQUEST['url']) && !empty($_REQUEST['url'])) {
  // fetch data from specified url
  $text = file_get_contents($_REQUEST['url']);
}
elseif (isset($_REQUEST['text']) && !empty($_REQUEST['text'])) {
  // get text from text area
  $text = $_REQUEST['text'];
}

// parse emails
if (!empty($text)) {
  $res = preg_match_all(
    "/[a-z0-9]+([_\\.-][a-z0-9]+)*@([a-z0-9]+([\.-][a-z0-9]+)*)+\\.[a-z]{2,}/i",
    $text,
    $matches
  );

  if ($res) {
    foreach(array_unique($matches[0]) as $email) {
      echo $email . "<br />";
    }
  }
  else {
    echo "No emails found.";
  }
}

?>