PHP - Select Box Attributes

Hi,

Im trying to grab some data from a XML generated by an external server.
I know how to grab from XML without attributes, but I cant seem to wrap my head around the structure of this file.
What would be easiest way to get the value of  the "dbnr" field?

Part of the XML file:

Code: [Select]
<data>
 <location>
   <field name="id" format="Long">xxxxxx</field>
   <field name="dbnr" format="Long">xxxxxx</field>
   <field name="jobnr" format="Long">xxxxxx</field>
   <field name="job_type" format="String" maxlen="50">xxxxxx</field>
   <field name="job_category" format="String" maxlen="50">xxxxxx</field>
 </location>
</data>

I have the following code below:

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 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.

The following script came from using-custom-paths.  It appears that these are PHP 8's new attributes, correct?

<?php
// api/src/Entity/Question.php

#[ApiResource(
    subresourceOperations: [
        'api_questions_answer_get_subresource' => [
            'method' => 'GET',
            'path' => '/questions/{id}/all-answers',
        ],
    ],
)]
class Question
{
}

I currently am using PHP7 and will need to convert them.  Does the following look correct?  Thanks
 

/**
 * @ApiResource(
 *     subresourceOperations = {
 *      "api_questions_answer_get_subresource" = {
 *          "method" = "GET",
 *          "path" = "/questions/{id}/all-answers"
 *     }
 *  }
 * )
 */

 

<league name="italy" id="1">
     <match name="AC Milan v Palermo" time="15/02/2011 20:45">
          <bettype name="Versus (with Draw)">
          <bet outcome_name="AC Milan"      odd="1.87">
               <bet outcome_name="X"                 odd="3.40">
               <bet outcome_name="Palermo"  odd="4.00">
          </bettype>
    </match>

    <match name="Juventus v Torino"  time="15/02/2011 20:45">
         <bettype name="Versus (with Draw)">
                <bet outcome_name="Juventus"   odd="2.00">
              <bet outcome_name="X"          odd="3.00">
              <bet outcome_name="Torino"  odd="2.00">
         </bettype>
   <bettype name="Half Time">
               <bet outcome_name="1"  odd="2.40">
               <bet outcome_name="X"  odd="3.40">
               <bet outcome_name="2"  odd="1.40">
          </bettype>
     </match>
</league>

<league name="Spain" id="2">
     <match name="Barcelona v Real Madrid" time="15/03/2011 21:45">
          <bettype name="Versus (with Draw)">
          <bet outcome_name="Barcelona"    odd="1.87">
               <bet outcome_name="X"            odd="3.40">
               <bet outcome_name="Real Madrid"  odd="4.00">
         </bettype>
     </match>
</league>


im trying to parse attributes of above xml  with using xpath functions. what i want to output is this:
(  <bettype name="Half Time"> this will be ignored   )


Italy
AC Milan v Palermo
1.87 3.40 4.00
Juventus v Torino
2.00 3.00 2.00

spain
Barcelona v Real Madrid
1.87 3.40 4.00



im trying do this with below xpath codes



$xml=simplexml_load_file('http://xml.gamebookers.com/sports/football.xml_attr.xml');
$league=$xml->xpath("//league");          
$matches=$xml->xpath('//bettype[@name="Versus (with Draw)"]/..'); 
$odds=$xml->xpath('//match/bettype[@name="Versus (with Draw)"]/bet'); 



i searched and tried lots of tutorials. i need help in writing the correct code
thanks

I am trying to write a more elegant solution to be able to check an object, find only the properties in an object that have values, and update those values in a database with a matching ID.

I am extending a class from a generic user class here is an example of my code


Code: [Select]
<?php
require_once('User.php');

require_once('Database.php');



class Vendor extends User {


protected static $vendor_attributes = array('id', 'nothing' , 'tagline' , 'bio');
protected static $table_name = "user_vendors";

public $tagline;




















}//close class


?>

Hi,
I have been trying to improve my PHP programming skills by following the Lynda.com Beyond the basics tutorial and they came to a section where they were building common database methods inside a database class.

Since they did not have PHP 5.3 (Where late static bindings is introduced) they had to place code referring to self:: inside of each class that needs this functionality. It seems that not having late static binding was binding self to the database class and not to other classes that call it statically. I will insert some code to explain this better.

Long story short, I was really interesting in getting an attributes function working and as I do not have late static bindg either, I cannot figure out how to call it from inside a class to make it function correctly.

Here is some code. Below is the attribute class they wrote. Each class declared an array of attributes for each of the classes that want to call this method like

protected static $db_fields = array('id', 'email', 'password', 'etc');

Code: [Select]

        protected function attributes() {
        // return an array of attribute names and their values
  $attributes = array();
  foreach(self::$db_fields as $field) {
    if(property_exists($this, $field)) {
      $attributes[$field] = $this->$field;
    }
  }
  return $attributes;
}
They planned on moving this code to a DatabaseObject class after they get LSB but until then, have to include it in every class that wants use this.

Is there any way to write this as a function, include it in a class, and call the method without late static binding.. or even place this inside a database class and call it from another class without LSB?

Forgive me if I am not explaining this correctly, again, I am still learning.

My version of PHP is 5.2.6.

hirealimo.com.au/code1.php

this works as i want it:
Quote

SELECT * FROM price INNER JOIN vehicle USING (vehicleID) WHERE vehicle.passengers >= 1 AND price.townID = 1 AND price.eventID = 1



but apparelty selecting * is not a good thing????

but if I do this:
Quote

SELECT priceID, price FROM price INNER JOIN vehicle....etc


it works but i lose the info from the vehicle table.

but how do i make this work:
Quote

SELECT priceID, price, type, description, passengers FROM price INNER JOIN vehicle....etc


so that i am specifiying which colums from which tables to query??

thanks

Okay, the title may sound a little confusing but it's the best way I could explain it.

I think it's better to understand what I'm doing by looking at my function below:

<?
function refresh($name,$num,$time)
{?>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript">
  update<?=$num?>();
  function update<?=$num?>() {
    num = Math.random();
    $('span.<?=$name?>').load('refresh.php?a=<?=$name?>');   
    setTimeout('update<?=$num?>()', <?=$time?>/1000);       
  }
</script>
}<?
//refresh('name of span tag','JS update#', 'refresh time');
refresh('spantag1','1', '5');
refresh('spantag2,'2', '5');
refresh('spantag3','3', '5');
?>

As you can see this would output 3 javascript codes on the page. I'd then use the span tag to allow this to refresh every 5 seconds like below:

<span class=spantag1>This contains the contents that will refresh in span tag one</span>

to refresh every 5 seconds.


This is a huge problem because I have about 50 tags that need to be refreshed every 'x' seconds.
Because of using all these 50 refreshes my page size is 1.36MB large

Without all this javascript my page size is only 38KB.

I'm wanting to use one javascript code but allow up to 50+ raw data that is inside the span tag to be refreshed.



<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript">
  update<?=$num?>();
  function update<?=$num?>() {
    num = Math.random();
    $('span.<?=$name?>').load('refresh.php?a=<?=json_encode($arr)?><?=$name?>');   
    setTimeout('update<?=$num?>()', <?=$time?>);       
  }
</script>




Sorry if it didn't make sense, tried my best lol.

Thanks and all help is much appreciated.

I have 2 queries that I want to join together to make one row  

Dear All,

I wish to have 2 drop down boxes, Country Select Box and Locality Select Box. The locality select box will be affected by the value chosen in the country select box.

All is working fine except that the locality select box is not being populated.
I know that the problem is in the sql statement

WHERE country_id='$co'

because i am having an error that $co is an undefined variable.

All the rest works fine because i have replaced the $co variable directly with a number (say 98) for a particular country id and it worked fine. In what way can i define this variable $co so that it is accepted by my sql statement?

Thank you for your help in advance.

MySQL Tables indicated below:

CREATE TABLE countries(
country_id INT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
country_name VARCHAR(30) NOT NULL,
PRIMARY KEY(country_id),
UNIQUE KEY(country_name),
INDEX(country_id),
INDEX(country_name))
ENGINE=MyISAM;

CREATE TABLE localities(
locality_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
country_id INT(3) UNSIGNED NOT NULL,
locality_name VARCHAR(50),
PRIMARY KEY (locality_id),
INDEX (country_id),
INDEX (locality_name))
ENGINE=MyISAM;

Extract PHP script included below:

// connect to database
require_once(MYSQL);

if(isset($_POST['submitted']))

{

// trim the incoming data

/* this line runs every element in $_POST through the trim() function, and assigns the returned result to the new $trimmed array */
$trimmed=array_map('trim',$_POST);

// clean the data

$co=mysqli_real_escape_string($dbc,$trimmed['country']);

$lc=mysqli_real_escape_string($dbc,$trimmed['locality']);

}

?>

<form action="form.php" method="post">

<p>Country
<select name="country">
<option>Select Country</option>

<?php

$q="SELECT country_id, country_name
FROM countries";

$r=mysqli_query($dbc,$q) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($r))

{

$country_id=$row[0];
$country_name=$row[1];
echo '<option value="' . $country_id . '"';
if(isset($trimmed['country']) && ($trimmed['country']==$country_id))
echo 'selected="selected"';
echo '>' . $country_name . '</option>\n';

}

?>

</select>
</p>

<p>Locality
<select name="locality">
<option>Select Locality</option>

<?php

$ql="SELECT locality_id, country_id, locality_name
FROM localities
WHERE country_id='$co'
ORDER BY locality_name";

$rl=mysqli_query($dbc,$ql) or
trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

while($row=mysqli_fetch_array($rl))

{

$locality_id=$row[0];
$country_id=$row[1];
$locality_name=$row[2];
echo '<option value="' . $locality_id . '"';
if(isset($trimmed['locality']) && ($trimmed['locality']==$locality_id))
echo 'selected="selected"';
echo '>' . $locality_name . '</option>\n';

}

// close database connection
mysqli_close($dbc);

?>

</select>
</p>

<p><input type="submit" name="submit" value="Submit" /></p>

<input type="hidden" name="submitted" value="TRUE" />

</form>

Hi all,
Im trying to get the requested genre and compare it with the <SELECT> list to add the word SELECTED on the option.
So if the requested genre is the same as the option name them make that the SELECTED option.

Cheers.

Here's a bit of code I made that does not work
Code: [Select]
<?
function selected(){
if ($_REQUEST['genre'] = $name){
echo"SELECTED";
}}
?>

Gen
<SELECT class="sort" align="right" onChange="window.location.href=this.options[this.selectedIndex].value;">
<option value="<?=$_SERVER['PHP_SELF'];?>" <?$name = ''; selected(); ?>>Any</option>
<option value="<?=$_SERVER['PHP_SELF'];?>?genre=Action" <?$name = 'Action'; selected(); ?>>Action</option>
<option value="<?=$_SERVER['PHP_SELF'];?>?genre=Adventure" <?$name = 'Adventure'; selected(); ?>>Adventure</option>
<option value="<?=$_SERVER['PHP_SELF'];?>?genre=Animation" <?$name = 'Animation'; selected(); ?>>Animation</option>
</SELECT>

Hello,   i am starting to freak out ... i am trying to make a select but it dont want to work.   So what do i have:   i have 2 Tables   table 1: customer (contains the name) (fieldname: name) table 2: bookings (contains the name from customer) (fieldname: belegung)   in table 2 there are multiple lines with lets say 10 customer xyz and 3 customer xxx in table 1 every customer is only once and it includes 5 customer   my output i want to have now is a group by where i have the customer in column 1 and the count(*) in column 2   so in my case   customer xyz - 10 customer xxx - 3 customer 3     - 0 customer 4 - 0 customer 5 - 0   i only manage to group them, so i can see it like customer xyz - 10 customer xxx - 3 customer 3     - 1 customer 4 - 1 customer 5 - 1   as it goes on the count(*) from table 1   please if someone could help me i would be pleased

Hi Guys   I have a table which in it's shortened form has the following columns:   id  |  postID  |  title  |  content  |  version   The column for postID has a number that can be shared by multiple rows - differentiated by version number.   I want to run a query to select all records that are like a given keyword (i.e. %LIKE%) but where results share the same postID I only want to return the highest version number for that record.     The difficulty is some records may have multiple version numbers that match the like statement and some may have only one. So this variance with the LIKE search is causing me some confusion.   I've tried this in a few ways using a sub-query but for the life of me I cannot work out how to do it.   Any help would be appreciated,   Drongo