PHP - Two Variables, One Node!

Hi All,

I've been struggling to get the following code to work. I have an API feed that looks like this:

 

<Jobs>
        <Job>
            <ID>1805</ID>
            <Name>House Additions/Alterations </Name>
            <Description>House</Description>
            <Client>
                <ID>16178470</ID>
                <Name>client name 1</Name>
            </Client>
            <ClientOrderNumber></ClientOrderNumber>
            <State>In Construction</State>
            <StartDate>2018-03-26T00:00:00</StartDate>
            <DueDate>2020-03-31T00:00:00</DueDate>
            <Contact>
                <ID>10195532</ID>
                <Name>Clent Name1</Name>
            </Contact>
            <InternalID>25026686</InternalID>
            <Manager>
                <ID>610781</ID>
                <Name>Manager Name 1</Name>
            </Manager>
            <Partner>
                <ID>610781</ID>
                <Name>patner name</Name>
            </Partner>
            <Assigned>
                <Staff>
                    <ID>610781</ID>
                    <Name>Staff 1</Name>
                </Staff>
              .........
              

I'm trying to work out how to show all the job ID, Job Name, Client Name, Start Date etc that are specific to the assigned staff member by selecting a specific staff member. $Staff is populated by a dropdown earlier in the code.

here's my code so far:

if ($err) {
  echo "cURL Error #:" . $err;
} else {
        $xml=simplexml_load_string($response) or die("Error: Cannot create object"); 
    $jobs = $xml->xpath("Jobs/Job/Assigned/Staff[Name= '$Staff']");
    foreach($jobs as $item) {
    //foreach($xml->Jobs->Job as $item) {
        $item1 = $item->Client->Name;
        $job_no = "$item->ID";
        $job_name = "$item->Name";
        $job_client = "$item1";
        $job_start = "$item->StartDate";
        $job_due = "$item->DueDate";
        $job_status = "$item->State";
            
    echo "<tr><td>$job_no</td><td><a href='activecp/managejob.php?job_id=$job_no'>$job_name</a></td><td>$job_client</td><td>$job_status</td><td>$job_start</td><td>$job_due</td></tr>";
     } 
}

This currently shows the ID and name of the selected staff member but not the info i need. All of the data I want to show is before the Assigned/Staff . 

Any help would be much appreciated. 

Thanks in advance.

Hi,

I have a RSS feed cached as an XML file. I need to pull some info out of it so I can then print it to the page.

Currently I am using this code to extract the data:

$doc = new DOMDocument();
  $doc->load('inthenews.xml');
  $inthenews = array();
  foreach ($doc->getElementsByTagName('item') as $node) {
    $itemRSS = array ( 
      'title' => $node->getElementsByTagName('title')->item(0)->nodeValue,
      'link' => $node->getElementsByTagName('link')->item(0)->nodeValue,
      'desc' => $node->getElementsByTagName('description')->item(0)->nodeValue,
      );
    array_push($inthenews, $itemRSS);
  }

However, the Description node contains more than I want. I need to remove everything except for the image ( <img../> ) it contains.

Is there some way of running preg or similar on the nodeValue as it is extracted? Or an alternative to "getElementsByTagName" that allows searching for strings?

If not, does anyone have a suggestion for doing this? I tried running preg_replace on the array, but it doesn't seem to do anything?? An example of the Array created by my code above is shown below:


Code: [Select]
[0] => Array
        (
            [title] => BBC radio Cambridge 7.20am
            [link] => images/news/Matthew_Freeman_Radio_Cambridgeshire_21-10-10.mp3
            [desc] => <img alt="BBC-logo" src="http://www2.mrc-lmb.cam.ac.uk/images/news/BBC-logo.jpg" height="54" width="127" /><br/>BBC radio Cambridge 7.20am 21.10.10: Dr Matthew Freeman"<br/> 21 October 2010
        )


Thanks in advance for any advice 

Phil

I would like to adding a node to a tree. I want it to be a balanced b-tree. The logic/algorithm i can think of is

Code: [Select]
<?php
function add_node($root, $node) // Where $root is the parent to which node should be added and $node is the node that is to be added.
{
     Traverse the tree level wise, level 1 being the lchild and rchild of $root and calculate the number of node in that level
     if(number of nodes in a level < 2[sup]$level[/sup])  // Since number of nodes a level can accommodate  = 2[sup]$level[/sup] 
     {
          Add node in that level where ever it gets an empty spot.
     }
}
?>

Tree table:-
Code: [Select]
CREATE TABLE IF NOT EXISTS `tree` (
  `parent` int(7) NOT NULL,
  `rchild` int(7) NOT NULL,
  `lchild` int(7) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Is their any better logic to do so ?

Hi, I am new to xml parsing and I just want to know how to check whether a node has attributes:

Here is my xml file to use:
=================
Code: [Select]
<?xml version="1.0" encoding="ISO-8859-1"?>
<email>
<message>
<to>
<toFirstName>Tove</toFirstName>
<toLastName toType="common" style="swag">Smith</toLastName>
</to>
<from>
<fromFirstName>Jani</fromFirstName>
<fromLastName fromType="unique">Dravison</fromLastName>
</from>
<heading>Reminder</heading>
<body>
<prologue>Tis the night before Xmas...</prologue>
<paragraph1>Don't forget me this weekend!</paragraph1>
<paragraph2>Jump the gun!</paragraph2>
<epilogue>The end of the world.</epilogue>
</body>
</message>

<message>
<to>employees</to>
<from>CEO</from>
<heading>Power Lunch</heading>
<body>
<prologue></prologue>
<paragraph1>Year over year data</paragraph1>
<paragraph2>Downsizing</paragraph2>
<epilogue>The end.</epilogue>
</body>
</message>
</email>

Here the simple script that I cannot get to work:
==================================
Code: [Select]
<?php
$simpleXMLObj=simplexml_load_file("email.xml");

if($simpleXMLObj->to[0]->toLastName[0]->attributes()->getName)
print "YES: this node has attributes!";
else
        print "NO:";
?>

Please I really need help, it is simple I know but I am new to xml parsing and mixed up.

I am creating a football predictor game and have a table in the database to hod all my users i have written a query to pull all out the users that have made a prediction that day with their predictions made i have put this into an array so my array will hold all the user details 1 being their userId I have set the order by on the query to userId so I get all the same users predictions in 1 block. I now want to extract all the predictions for each user and put these into their own array but I don't know which users the array will hold, how many users their will be, or how many predictions each user would have made so i'm not sure how to create this array i'm quite new to php can anyone help me with this

How can I print the attributes of a child node?
I have been trying and looking and cant get it.
I need the attributes of subfield printed after datafield
so a line would look like
datafield plus attributes plus subfield attributes plus subfield

=906 __$a0$bcbc$corignew etc...

<?php
//child nodes http://www.w3schools.com/php/php_xml_dom.asp
//http://books.google.com/books?id=ygQRKDEsLecC&pg=PA196&lpg=PA196&dq=print+php+xml+child+node+attributes&source=bl&ots=TCAhH4kpCt&sig=yJUPXesIkRUrNXdNE9Yr5ul7Wdw&hl=en&ei=U51kTeKQKsL48AbN4MDTBg&sa=X&oi=book_result&ct=result&resnum=10&ved=0CF4Q6AEwCQ#v=onepage&q=print%20php%20xml%20child%20node%20attributes&f=false
//http://stackoverflow.com/questions/4598409/printing-content-of-a-xml-file-using-xml-dom

$doc = new DOMDocument();
$doc->preserveWhiteSpace = FALSE;

$doc->load( 'loc.xml' );
$root = $doc->documentElement;
$type = $root->nodeType;
//print $doc->nodeName."\n";
//print $root->nodeName."\n";
//print $doc->nodeValue."\n";
//print $root->nodeValue."\n";


$librecords = $doc->getElementsByTagName( "record" );

foreach( $librecords as $record ){

   $leader = $record->getElementsByTagName( "leader" );
   $controlfields = $record->getElementsByTagName( "controlfield" ); 
   $datafields = $record->getElementsByTagName( "datafield" ); 
   $subfields = $record->getElementsByTagName( "subfield" );

   $leader = $leader->item(0)->nodeValue;  
   echo '=LDR '.$leader.'<BR>';

   foreach( $controlfields as $controlfield ){
      $tag = $controlfield->getAttribute('tag');  
      $cf_value = $controlfield->firstChild->nodeValue;
      echo "=".$tag." ".$cf_value.'<BR>';  }

   foreach( $datafields as $datafield ){
      $tag = $datafield->getAttribute('tag');  
      $ind1 = $datafield->getAttribute('ind1'); 
      $ind2 = $datafield->getAttribute('ind2'); 
      if ($ind1 ==" ") {$ind1 = "_";}
      if ($ind2 ==" ") {$ind2 = "_";}
      echo "=".$tag." ".$ind1.$ind2; 

      //if($datafield->hasChildNodes()){echo 'This node has children!<br />';}
      foreach ($datafield->childNodes AS $item)  {  
      //  $arr = $item->attributes; 
        print $arr;
      print 'nodeName '.$item->nodeName . " = " . $item->nodeValue." | " ;} //. "<br />";  }
  
  //   foreach ($datafield->children() as $node) {
  //      $arr = $node->attributes();   // returns an array
  //      print ("code=".$arr["code"]);     // get the value of this attribute
 //       print ("  Company=".$node->subfield);
//        print ("<p><hr>");
//}
 //     foreach( $subfields as $subfield){
      
 //     foreach($subfield->attributes as $attr){

     // $attributes = $subfield->attributes;

     
  //      print $attr->nodeName;
    //    print $attr->nodeValue;
   //     //print $attributes->nodeName;
        //print $attributes->nodeValue;

   //    print $subfield->nodeName;
    //   print $subfield->nodeValue;

//}}
    
   // print $item->nodeValue  ;  
 //       print $item->attributes("code");
   //       $valueID = $item->getAttribute('code'); 
   //      print $item->nodeName->attributes("code");
//          echo $item->nodeValue.getAttribute("code");
      //      print $item->getAttribute('code')
//http://www.devshed.com/c/a/PHP/Accessing-Attributes-and-Cloning-Nodes-with-the-DOM-XML-Extension-in-PHP-5/1/
 
      echo '<BR>'; 
     
     }





   foreach( $subfields as $subfield ){
      $code = $subfield->getAttribute('code');  
      $sf_value = $subfield->firstChild->nodeValue;
      echo '$'.$code.$sf_value.'<BR>'; }

echo '<BR>';

}
?>

   

Code: [Select]
  <leader>01026ngm a22002773a 4500</leader>
  <controlfield tag="001">16429180</controlfield>
  <controlfield tag="005">20100823131409.0</controlfield>
  <controlfield tag="007">vffcjaho|</controlfield>
  <controlfield tag="008">100823s2010    xxu060            mleng  </controlfield>
  <datafield tag="906" ind1=" " ind2=" ">
    <subfield code="a">0</subfield>
    <subfield code="b">cbc</subfield>
    <subfield code="c">orignew</subfield>
    <subfield code="d">u</subfield>
    <subfield code="e">ncip</subfield>
    <subfield code="f">20</subfield>
    <subfield code="g">y-movingim</subfield>
  </datafield>
  <datafield tag="955" ind1=" " ind2=" ">
    <subfield code="b">qm12 2010-08-23</subfield>
  </datafield>

Hi, I need to build my own xml validator and was wondering, what are some possible purposes of having multiple text nodes for a given parent node, I ask b/c while I was playing around with W3schools XML validator, I noticed it successfully validated the following:


<?xml version="1.0" encoding="utf-8" ?>
<note>
 <to>Joh</to>
 <from>Frank</from>
 <body>Hello world</body>
  Extra text node that is validated!
</note>

Hey guys. I just recently started learning php and I like to learn hands on. So, my first project involves the Google Calendar. I found a script on github that is basically a Google calendar feed and I've been manipulating it to meet my personal needs and expectations, but the only thing I am struggling with is the xml part. All I want to do in this case is get the value from ###TITLE###   (after it is sorted by newest date which is done automatically in the script) and store it in a new variable but no matter what I try or do and after reading a bunch of material on xml and php, I still cannot get it to work. If anyone knows how to do this and provide an explanation so I can actually learn I would really really appreciate it. Here is the github script   https://github.com/m...ter/gcalphp.php   Thank you and I am looking forward to any suggestions or anything.

I am trying to use php to loop through an xml file and reorganize the data.  For example, if I have a xml file about books and the first xml sub tag under the <book> tag is "<type>" .  I would like to make the following tags (nodes?) as child nodes under the type tag.  For example, instead of this:
Code: [Select]
   <book>
        <type>nonFiction</type>
        <title>Advanced PHP Programming</title>
        <author>George Schlossnagle</author>
        <publisher>Developer Library</publisher>
        <category>1</category>
        <category>3</category>
   </book>
   <book>
        <type>Fiction</type>
        <title>My Novel</title>
        <author>Same Nagle</author>
        <publisher>Developer Library</publisher>
        <category>1</category>
        <category>3</category>
   </book>
I want to make the xml look like this:
Code: [Select]
   <book>
        <type>nonFiction
                <title>Advanced PHP Programming</title>
                <author>George Schlossnagle</author>
                <publisher>Developer Library</publisher>
                <category>1</category>
                <category>3</category>
        </type>
   </book>
   <book>
        <type>Fiction
             <title>My Novel</title>
             <author>Same Nagle</author>
             <publisher>Developer Library</publisher>
             <category>1</category>
             <category>3</category>
        </type>
   </book>


[attachment deleted by admin]

does anyone know how to decode this XML variable value into string values? I also need to know the oposite way: creating variable values into xml. I've tried several code examples but they did filter the requested data.

Code: [Select]
$xml='<?xml version="1.0" encoding="utf-8"?>
<elements>
<text identifier="ed9cdd4c-ae8b-4ecb-bca7-e12a5153bc02">
  <value/>
</text>
<textarea identifier="a77f06fc-1561-453c-a429-8dd05cdc29f5">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>]]></value>
</textarea>
<textarea identifier="1a85a7a6-2aba-4480-925b-6b97d311ee6c">
  <value><![CDATA[<p style="text-align: justify;">Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy  eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed  diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.  Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor  sit amet.</p>]]></value>
</textarea>
<image identifier="ffcc1c50-8dbd-4115-b463-b43bdcd44a57">
  <file><![CDATA[images/stories/red/cars/autobedrijf.png]]></file>
  <title/>
  <link/>
  <target/>
  <rel/>
  <lightbox_image/>
  <width><![CDATA[250]]></width>
  <height><![CDATA[187]]></height>
</image>
<text identifier="4339a108-f907-4661-9aab-d6f3f00e736e">
  <value><![CDATA[Kramer 5]]></value>
</text>
<text identifier="ea0666d7-51e3-4e52-8617-25e3ad61f8b8">
  <value><![CDATA[6000 RS]]></value>
</text>
<text identifier="90a18889-884b-4d53-a302-4e6e4595efa0">
  <value><![CDATA[Eindhoven]]></value>
</text>
<text identifier="410d72e0-29b3-4a92-b7d7-f01e828b1586">
  <value><![CDATA[APK Pick up and return]]></value>
</text>
<text identifier="45b86f23-e656-4a81-bb8f-84e5ea76f71f">
  <value><![CDATA[15% korting op grote beurt]]></value>
</text>
<text identifier="3dbbe1c6-15d6-4375-9f2f-f0e7287e29f3">
  <value><![CDATA[Gratis opslag zomerbanden]]></value>
</text>
<text identifier="2e878db0-605d-4d58-9806-8e75bced67a4">
  <value><![CDATA[Gratis abonnement of grote beurt]]></value>
</text>
<text identifier="94e3e08f-e008-487b-9cbd-25d108a9705e">
  <value/>
</text>
<text identifier="73e74b73-f509-4de7-91cf-e919d14bdb0b">
  <value/>
</text>
<text identifier="b870164b-fe78-45b0-b840-8ebceb9b9cb6">
  <value><![CDATA[040 123 45 67]]></value>
</text>
<text identifier="8a91aab2-7862-4a04-bd28-07f1ff4acce5">
  <value/>
</text>
<email identifier="3f15b5e4-0dea-4114-a870-1106b85248de">
  <value/>
  <text/>
  <subject/>
  <body/>
</email>
<link identifier="0b3d983e-b2fa-4728-afa0-a0b640fa34dc">
  <value/>
  <text/>
  <target/>
  <custom_title/>
  <rel/>
</link>
<relateditems identifier="7056f1d2-5253-40b6-8efd-d289b10a8c69"/>
<rating identifier="cf6dd846-5774-47aa-8ca7-c1623c06e130">
  <votes><![CDATA[1]]></votes>
  <value><![CDATA[1.0000]]></value>
</rating>
<googlemaps identifier="160bd40a-3e0e-48de-b6cd-56cdcc9db892">
  <location><![CDATA[50.895711,5.955427]]></location>
</googlemaps>
</elements>';

Hi. I have some code which needs to return a single variable from the function and stored as a variable within this page, so it can be echoed later on in the page. I couldn't get it to return as a variable, so i used "return compact();" to return the variable and "extract (myFunction());" to extract it to variables. However, when I turned on php's display errors and error reporting function, I got an error message saying "Warning: extract() [function.extract]: First argument should be an array in /my/web/site/index.php on line 6" (which is where my extract function is). This works fine with passing more than one variables through, is there another way pass one variable from a function to be stored as a variable on the page which called the function?

Here is the function:
Code: [Select]
<?php
//This is a list of numeric error codes against their text. this will return the error code as the variable $issue
function checkLoginIssue() {

//If there is an error code
if (isset($_GET["issue"])) {
 
  //cycle through the list until the code is reached, return the text and break the switch
    switch ($_GET["issue"]) {

      case "1":
              $issue = '<p class="warning">Please log in to view this page</p>';
              break;
  
      case "2":
              $issue = '<p class="warning">Wrong Username or Password</p>';
              break;

        case "3":
              $issue = '<p class="warning">No user found with those details</p>';
              break;

    }
 
 //return the variable in an array with a single value
 return compact('issue');
 
}
 
}
?>
And here is the code which calls the function:
Code: [Select]
<?php
extract(checkLoginIssue());
?>

Hello

I am stuck at a point where I need to call multiple numbers for a given API

 

This is the  code provided by the API company

// Send Message
$my_apikey = "APIKEY";
$destination = "NUMBER";
$message = "hellotest";
$api_url = "http://blahblah.com/send_message.php";
$api_url .= "?apikey=". urlencode ($my_apikey);
$api_url .= "&number=". urlencode ($destination);
$api_url .= "&text=". urlencode ($message);
$my_result_object = json_decode(file_get_contents($api_url, false));

 

Now My html code would be

 

<div class="card-header ch-alt">
        <h2>Test API</h2>
    </div>

    <div class="card-body card-padding">
        API Key: * <br>

         <option value='APIKEY'>APIKEY Value </option>            </select><br>
        
        Destination Number: * <br>
        <input class="form-control" type="text" id="test_number" required><br>

        <br><br>

        Text: * <br>
        <textarea class="form-control" id="test_text" required rows=5></textarea><br>
            </div>

 

 

Now how do I insert multiple numbers on the Destination number...when i give commas, it gives errors but the message goes with single number

 

Need hlp

I've got a select statement that looks like this in php.
Code: [Select]
$sql = "Select * from inventory where ".$fields."".$operator."".$criteria;
Everything posts correctly, everything is dereferenced correctly.    My only question is how do I get $criteria have single quotes around it?

So that when I actually run the query it says

select * from inventory where field = 'value';


I've tried
Code: [Select]
$sql = "Select * from inventory where ".$fields."".$operator.""'.$criteria';

$sql = "Select * from inventory where ".$fields."".$operator.""'$criteria';
and a bunch of variations like that. 

Thanks for you help.

Hi guys,

I've a developer for a pretty large website and forum, the database is exploding in size and we are now seeing a grow in the slow log. We want to be able to fix this by optimizing query's but the site is so big, we can't locate the query's themselfs as they are dynamically generated.

I want to be able to tail onto the end of the query a comment containing where a function was last called. In the example below, I want the file name and line-number of where add_together() was called.

Here is an example for index.php:

Code: [Select]
$a = 1;
$b = 2;

$c = add_together($a, $b);

function add_together($a, $b)
{
    return $a + $b;
}

Look forward to your assistance with this!

Joe

Hi guys

I have two variables but
$no1=$row[no1];
$no2=$row[no2];

I need to have another variable where i can merge these two as i need to insert them to database with sapce in between each variable like:

$numbers= $no1 $no2;

by doing this i get syntax error, do u know whats the best way to do this?