Learn VBA & Macros in 1 Week!

PHP - Simplexml Get Certain Value Based On A Field

Full Excel VBA Course - Beginner to Expert

Simplexml Get Certain Value Based On A Field	View Content

I'm trying to get the url of PRINT_POSITION_URL based on PRODUCT_NUMBER.

For product with product number 7375-06 i want to get PRINT_POSITION_URL color="06", for product with product number 7375-04 i want to get PRINT_POSITION_URL color="04" etc.

These two values are in different XML files which i am getting them from url and they are related with a field PRODUCT_PRINT_ID.

Here is my first XML file(products.xml):

<PRODUCTS>
  <PRODUCT>
    <PRODUCT_NUMBER>7375-06</PRODUCT_NUMBER>
    <PRODUCT_NAME>Soft ball</PRODUCT_NAME>
    <PRODUCT_PRINT_ID>40002010</PRODUCT_PRINT_ID>
  </PRODUCT>
</PRODUCTS>

And here is my second XML file(print-info.xml):

<PRINTINGINFORMATION>
  <PRODUCTS>
    <PRODUCT>
     <PRODUCT_PRINT_ID>40002010</PRODUCT_PRINT_ID>
      <PRINTING_POSITIONS>
        <PRINTING_POSITION>
          <PRINT_POSITION_URL color="04">https://thumb_7375_04.jpg</PRINT_POSITION_URL>
          <PRINT_POSITION_URL color="05">https://thumb_7375_05.jpg</PRINT_POSITION_URL>
          <PRINT_POSITION_URL color="06">https://thumb_7375_06.jpg</PRINT_POSITION_URL>
        </PRINTING_POSITION>
      </PRINTING_POSITIONS>
    </PRODUCT>
  </PRODUCTS>
</PRINTINGINFORMATION>

Here is what I've tried based on @Barand answer in another topic and i want to thank him for his help.

<?php
header ("Content-Type:text/xml");
$xmlA = simplexml_load_file('ftp://.../prodinfo_EN.xml');
$xmlB = simplexml_load_file('ftp://.../printinfo.xml');

// create empty output xml object
$final = new simpleXMLElement('<?xml version="1.0" encoding="utf-8"?><PRODUCTINFORMATION></PRODUCTINFORMATION>'); 
$products = $final->addChild("PRODUCTS");

  foreach ($xmlA->PRODUCTS->PRODUCT as $proda) {
    $prodbaseno = (string)$proda->PRODUCT_NUMBER;
    $prodname = (string)$proda->PRODUCT_NAME;
    $prodprintid = (string)$proda->PRODUCT_PRINT_ID;

    // build the output xml
    $prodnew = $products->addChild('PRODUCT');
    $prodnew->addChild('PRODUCT_NUMBER', $prodbaseno);
    $prodnew->addChild('PRODUCT_NAME', $prodname);
    $prodnew->addChild('PRODUCT_PRINT_ID', $prodprintid);

    // find related field from xml file B based on PRODUCT_PRINT_ID
    if ($prodarr = $xmlB->xpath("PRODUCTS/PRODUCT[PRODUCT_PRINT_ID='$prodprintid']")) {
        $prodb = $prodarr[0];

        $prtposns = $prodnew->addChild('PRINTING_POSITIONS');
        foreach ($prodb->PRINTING_POSITIONS->PRINTING_POSITION as $prtpos )   {
            $posnew = $prtposns->addChild('PRINTING_POSITION');
            $posnew->addChild('PRINT_POSITION_URL', $prtpos->PRINT_POSITION_URL);
        }
    }

  }

echo $final->saveXml();
?>

And here is the output:

<PRODUCTINFORMATION>
  <PRODUCTS>
    <PRODUCT>
      <PRODUCT_NUMBER>MO7375-06</PRODUCT_NUMBER>
      <PRODUCT_NAME>Soft ball</PRODUCT_NAME>
      <PRODUCT_PRINT_ID>40002010</PRODUCT_PRINT_ID>
        <PRINTING_POSITIONS>
          <PRINTING_POSITION>
            <PRINT_POSITION_URL color="04">https://thumb_7375_04.jpg</PRINT_POSITION_URL>
          </PRINTING_POSITION>
        </PRINTING_POSITIONS>
    </PRODUCT>
  </PRODUCTS>
</PRODUCTINFORMATION>

As you can see I'm getting the PRINT_POSITION_URL for color="04" but i want PRINT_POSITION_URL for color="06" based on PRODUCT_NUMBER.

I should probably use xpath with substring-after method but i can't get it work.

Any help would be greatly appreciated.

Full Excel VBA Course - Beginner to Expert

Problem Updating Mysql Field Based On User_email Field

Similar Tutorials

View Content

Hi:
I'm going crazy trying to do the following:
I'm making a job registration process where the user registers on one php page to the website, must acknowlege and email receipt using an activate php page, then is directed to upload their C.V. (resume) based on the email address they enter in the active page output. I then run an upload page to store the resume in teh MySQL db based on the users email address in the same record.

If I isolate the process of the user registering to the db, it works perfectly.
If I isolate the file upload process into the db, it works perfect.
I simply cannot upload teh file to the existing record based on teh email form field matching the user_email field in the db.
With the processes together, teh user is activated, but teh file is not uploaded.

Maybe I've simply been at this too long today, but am compeled to get through it by end day.
If anyone can help sugest a better way or help me fix this, I will soo greatly appreciate it.

My code is as follows for the 2 pages.

---------activate.php-------
<?php
session_start();
include ('reg_dbc.php');
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
$rsCode = mysql_query("SELECT activation_code from subscribers where user_email='$_GET[usr]'") or die(mysql_error());
list($acode) = mysql_fetch_array($rsCode);
if ($_GET['code'] == $acode)
{
mysql_query("update subscribers set user_activated=1 where user_email='$_GET[usr]'") or die(mysql_error());
echo "<h3><center>Thank You! This is step 2 of 3. </h3>Your email is confirmed. Please upload your C.V. now to complete step 3.</center>";
} else
{ echo "ERROR: Incorrect activation code... not valid"; }

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<title>Job application activation</title>
</head>
<body>
<center>
<br/><br/><br/>
<p align="center">
<form name="form1" method="post" action="upload.php" style="padding:5px;">
<p>Re-enter you Email : <input name="email" type="text" id="email"/></p></form>
<form enctype="multipart/form-data" action="upload.php" method="POST">
<input type="hidden" name="MAX_FILE_SIZE" value="4000000">
Upload your C.V.: <input name="userfile" type="file" id="userfile">
<input name="upload" type="submit" id="upload" value="Upload your C.V."/></form>
</p>
</center>
</body>

</html>
--------upload.php----------
<?php
session_start();
if (!isset($_GET['usr']) && !isset($_GET['code']) )
{
$msg = "ERROR: The code does not match..";
exit();
}
if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0)
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$email = $_POST['email']['user_email'];

$fp = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
}

include 'reg_dbc.php';

$query = "UPDATE subscribers WHERE $email = user_email (name, size, type, content ) ". "VALUES ('$fileName', '$fileSize', '$fileType', '$content')";

mysql_query($query) or die('Error, query failed');
mysql_close($dbname);
}
?>
<center>
<br/>
<br/>
<br/>
<br/>
Thank you for uploading your <?php echo "$fileName"; ?> file, completing your registration, and providing us your C.V. for this position.
<br/>
<br/>
<br/>
We will contact you if your canditature qualifies.
</center>

Update Based On Calculated Field

Similar Tutorials

View Content

Earlier I posted about how to best deal with a calculated field in MySQL and was advised not to store the value in the database. So, I took my calculated value out of the tables. I can select based on the calculated value

SELECT ... right_count, wrong_count, right_count + wrong_count AS Total_Count, 
right_count / (right_count + wrong_count) AS Right_Percent
...

but now I want to UPDATE based on Right_Percent. The old code was:

UPDATE leitner_vcard_boxes 
SET box=box+1 last_reboxed_date='$today' where box<7 
AND last_reboxed_date<'$cutoff_date' and right_percent<='$score'

The only way I can think of updating is something like:

UPDATE leitner_vcard_boxes SET box=box+1 last_reboxed_date='$today' 
WHERE box<7 and last_reboxed_date<'$cutoff_date' 
AND Right_Percent IN (SELECT right_count, wrong_count, right_count / (right_count + wrong_count) AS Right_Percent 
FROM leitner_vcard_boxes WHERE Right_Percent,='$score');

Will using a subquery even work? Is there a better way? To further complicate things, I loop through 5 score/cutoff date pairs (so that a lower score gets reboxed faster than a higher score). I imagine it would be more efficient to try to combine it all into a single query.

     $cutoff_scores=array(25=>7,50=>14,75=>28,90=>40);
    foreach ($cutoff_scores as $score => $rebox_interval){
        $today=date('Y-m-d');
        $interval=$rebox_interval.' days';
        $cutoff_date=date_sub($today, date_interval_create_from_date_string($interval));
        $query="UPDATE leitner_vcard_boxes SET box=box+1 last_reboxed_date='$today' where box<7 and last_reboxed_date<'$cutoff_date' and right_percent<='$score'";
        $result=  mysqli_query($link, $interval);
    }

Sum Of $row Based On Specific Time Field Rather Than Just Total

Similar Tutorials

View Content

This code works just fine to display a list of reservations for a given day and sums the guest and table counts just fine for the entire day. Sums all reservations returned. What I am trying to do or figure out is a way to get totals based on specific time intervals. For example how many guests and tables at 8:00, 9:00, 10:00, etc.... I can see where the sums are calculated, but need help adding a way to add a variable to look at the reservation_time and sum by hour rather than just daily total.

       $tablesum ++;
        $guestsum += $row->reservation_pax;
<?php echo $guestsum;?>&nbsp;&nbsp;<?php echo _guest_summary;?>

The full code that pulls in the data and then sums it up in total:

<!-- Begin reservation table data -->
<br/>
<table class="global resv-table-small" cellpadding="0" cellspacing="0">
	<tbody>
		<tr>
		
		<?php
		echo "<td class='noprint'> </td>";
		echo "<td>Time</td>";
		echo "<td>Guests/Type</td>";
		echo "<td>Name</td>";
		echo "<td>Special Instructions/Notes</td>";
		echo "<td class='noprint'>Table</td>";
		echo "<td class='noprint'>Status</td>";
		echo "<td class='noprint'>Created</td>";
		echo "<td class='noprint'>Details/Delete</td>";

	echo "</tr>";
		
		// Clear reservation variable
		$reservations ='';
		
		if ($_SESSION['page'] == 1) {
			$reservations =	querySQL('all_reservations');
		}else{
			$reservations =	querySQL('reservations');
		}
		
		// reset total counters
		$tablesum = 0;
		$guestsum = 0;
			
		if ($reservations) {
			
			//start printing out reservation grid
			foreach($reservations as $row) {
				// reservation ID
				$id = $row->reservation_id;
				$_SESSION['reservation_guest_name'] = $row->reservation_guest_name;
				// check if reservation is tautologous
				$tautologous = querySQL('tautologous');
				
			echo "<tr id='res-".$id."'>";
			echo "<td";
			// daylight coloring
			if ($row->reservation_time > $daylight_evening){
				echo " class='evening noprint'";
			}else if ($row->reservation_time > $daylight_noon){
				echo " class='afternoon noprint'";
			}else if ($row->reservation_time < $daylight_noon){
				echo " class='morning noprint'";
			}
			
			echo " style='width:10px !important; padding:0px;'>&nbsp;</td>";
			echo "<td id='tb_time'";
			// reservation after maitre message
			if ($row->reservation_timestamp > $maitre['maitre_timestamp'] && $maitre['maitre_comment_day']!='') {
				echo " class='tautologous' title='"._sentence_13."' ";
			}
			echo ">";
			echo "<strong>".formatTime($row->reservation_time,$general['timeformat'])."</strong></td>";
			echo "<td id='tb_pax'><strong class='big'>".$row->reservation_pax."</strong>&nbsp;&nbsp;<span class='noprint'>";
			printType($row->reservation_hotelguest_yn);
				//echo "<img src='images/icons/user-silhouette.png' class='middle'/>";
			echo "</span></td><td style='width:10%' id='tb_name'><span class='noprint'>".printTitle($row->reservation_title)."</span><strong> <a id='detlbuttontrigger' href='ajax/guest_detail.php?id=".$id."'"; 
			// color guest name if tautologous
			if($tautologous>1){echo" class='tautologous tipsy' title='"._tautologous_booking."'";}
			echo ">".$row->reservation_guest_name."</a></strong>";
			
			// old reservations symbol
			if( (strtotime($row->reservation_timestamp) + $general['old_days']*86400) <= time() ){
				echo "<img src='images/icons/clock-bolt.png' class='help tipsyold middle smicon' title='"._sentence_11."' />";
			}
			// recurring symbol
			if ($row->repeat_id !=0) {
	            echo "&nbsp;<img src='images/icons/loop-alt.png' alt='"._recurring.
					 "' title='"._recurring."' class='tipsy' border='0' >";
	        }
	
			echo"</td><td style='width:10%' id='tb_note'>";
				if ($_SESSION['page'] == 1) {
			 		echo $row->outlet_name;
			 	}else{
					echo $row->reservation_notes;
				}
			echo "</td>";
			
			if($_SESSION['wait'] == 0){
				echo "<td class='big tb_nr' style='width:85px;' id='tb_table'><img src='images/icons/table_II.png' class='tipsy leftside noprint' title='"._table."' /><div id='reservation_table-".$id."' class='inlineedit'>".$row->reservation_table."</div></td>";
			}
			echo "<td class='noprint'><div>";
				getStatusList($id, $row->reservation_status);
			echo "</div></td>";
			echo "<td class='noprint'>";
			echo "<small>".$row->reservation_booker_name." | ".humanize($row->reservation_timestamp)."</small>";
			echo "</td>";
			echo "<td class='noprint'>";
			// MOVE BUTTON
			//	echo "<a href=''><img src='images/icons/arrow.png' alt='move' class='help' title='"._move_reservation_to."'/></a>";
			
			// WAITLIST ALLOW BUTTON
			if($_SESSION['wait'] == 1){
				$leftspace = leftSpace(substr($row->reservation_time,0,5), $availability);
				if($leftspace >= $row->reservation_pax && $_SESSION['outlet_max_tables']-$tbl_availability[substr($row->reservation_time,0,5)] >= 1){	    
					echo"&nbsp;<a href='#' name='".$id."' class='alwbtn'><img src='images/icons/check-alt.png' name='".$id."' alt='"._allow."' class='help' title='"._allow."'/></a>&nbsp;&nbsp;";
				}
			}
			// EDIT/DETAIL BUTTON
			echo "<a href='?p=102&resID=".$id."'><img src='images/icons/pen-fill.png' alt='"._detail."' class='help' title='"._detail."'/></a>&nbsp;&nbsp;";
			// DELETE BUTTON
			if ( current_user_can( 'Reservation-Delete' ) && $q!=3 ){
		    	echo"<a href='#modalsecurity' name='".$row->repeat_id."' id='".$id."' class='delbtn'>
					<img src='images/icons/delete.png' alt='"._cancelled."' class='help' title='"._delete."'/></a>";
			}
		echo"</td></tr>";
		$tablesum ++;
		$guestsum += $row->reservation_pax;
			}
		}
		?>
	</tbody>
	<tfoot>

		<tr style="border:1px #000;">
			<td class=" noprint"></td><td></td>
			<td colspan="2" class="bold"><?php echo $guestsum;?>&nbsp;&nbsp;<?php echo _guest_summary;?></td>
			<td></td>
			<td colspan="2" class="bold"><?php echo $tablesum;?>&nbsp;&nbsp;<?php echo _tables_summary;?></td>
			<?php
			if($_SESSION['wait'] == 0){
				//echo "<td></td>";
			}
			?>
		</tr>
	</tfoot>
</table>
<!-- End reservation table data -->

Edited by mfandel, 26 October 2014 - 02:06 AM.

Add Extra Space Based On Remaining Max_length Field From Mysql

Similar Tutorials

View Content

I Have field in my table with max length (10).
My data is only (5) characters. ex: "apple"

I want to output "apple ". with extra (5) space.

Max Length: (10) - (5 characters: apple) = 5 extra white space to be added when outputting fruit.

I know can echo it as $row['fruit'] . " "; < == manually, but I want it to be automated based on the number of "max_length" from my field in my table/database.

Php Simplexml Help

Similar Tutorials

View Content

Help With Simplexml

Similar Tutorials

View Content

More Simplexml Help...

Similar Tutorials

View Content

so the code is

<?php

$xml1 = "
<outer>
  <xml>
    <more_info>
     <user>
        <id>200</id>
        <name>CLUEL3SS</name>
    </user>
    <user>
        <id>201</id>
        <name>CLUEL3SS2</name>
     </user>
    </more_info>
  </xml>
</outer>    ";

$cwb = simplexml_load_string($xml1);
foreach($cwb->xml->more_info->user as $stats)
  {
   echo $stats->id."\n";}

?>

output is

Code: [Select]
200
201

Now, how can I echo the name under <id>201</id> since there is more than one?

echo $stats->id."\n";

That echos both of the "ID" values, now how can I get it to only echo the second id 201 and the second name?

Thanks

Simplexml Help

Similar Tutorials

View Content

Ok so I have a url that is an XML doc, it says at the top

"This XML file does not appear to have any style information associated with it. The document tree is shown below."

and it has info like this

Code: [Select]

<outer>
<xml>
<viewer>
<user>
<id>1245789</id>
<name>CLueless</user>
<business>none</business>
</user>
</viewer>
</xml>
</outer>

How would I load the link and then assign everything to a variable like id, name and business

I usually use something like this but Im trying to get learn simple xml

$info = file_get_contents('url');
$id = explode('<id>', $info);
$id = explode('</', $id[1]);
$name = explode('<name>', $info);
$name = explode('</', $name[1]);
$biz = explode('<business>', $info);
$biz = explode('</', $biz);

Sorting Simplexml

Similar Tutorials

View Content

Hello,

Hope somebody can help me.
I have an XML file that is generated by active directory that dumps everything required for a telephone directory.
I currently present this using XSL but would like to move towards PHP.

I have some rudimentary code and it's working fine but I'd like to be able to sort by various values, such as First Name or telephone number.

My XML format looks like this:

Code: [Select]
<?xml version="1.0" encoding="UTF-8"?>
<telephonelist>
<employee>
<firstname>Jimmy</firstname>
<lastname>Jimmerson</lastname>
<email>jimbo@companyxyz.com</email>
<extensionnum>956</extensionnum>
<jobtitle>Security Officer</jobtitle>
<department>Security</department>
</employee>
<employee>
<firstname>David</firstname>
<lastname>Davidson</lastname>
<email>David.Davidson@companyxyz.com</email>
<extensionnum>968</extensionnum>
<jobtitle>Manager</jobtitle>
<department>Management</department>
</employee>
Any my current code looks like this:

Code: [Select]
<?
$myStaffMembers = new SimpleXMLElement("includes/telephonelist.xml", null, true);

echo <<<EOF
<table width="95%" border="0">
<tr>
<th><b>First Name</b></th>
<th><b>Last Name</b></th>
<th><b>Telephone Number</b></th>
<th><b>Position</b></th>
</tr>
EOF;

foreach($myStaffMembers as $myStaffMember)
{
echo "
<tr>
<td>{$myStaffMember->firstname}</td>
<td>{$myStaffMember->lastname}</td>
<td>{$myStaffMember->extensionnum}</td>
<td>{$myStaffMember->jobtitle}</td>
</tr>";
}
?>
Appreciate any help anybody could give.

Thanks,
LJ

Simplexml Warning

Similar Tutorials

View Content

Thanks in advance for your help.
I have the following code

Code: [Select]
function traverseXMLNodes($xml)
{
$xml = stripslashes($xml);
$xml =simplexml_load_string("<div>{$xml}</div>");//This the line that makes errors its line 70

echo 'Displaying contents of XML file...<br />';

print_r($xml);

}

Warning: simplexml_load_string() [function.simplexml-load-string]: Entity: line 1: parser error : xmlParseCharRef: invalid xmlChar value 0 in /home/wwwsend/public_html/postSample_Reply3.php on line 70 (Where i have written This the line that makes errors)

Warning: simplexml_load_string() [function.simplexml-load-string]: yid><eventid>60387073</eventid><numfrom>27826641429</numfrom><receiveddata> in /home/wwwsend/public_html/postSample_Reply3.php on line 70

Warning: simplexml_load_string() [function.simplexml-load-string]: ^ in /home/wwwsend/public_html/postSample_Reply3.php on line 70

Warning: simplexml_load_string() [function.simplexml-load-string]: Entity: line 1: parser error : xmlParseCharRef: invalid xmlChar value 0 in /home/wwwsend/public_html/postSample_Reply3.php on line 70

Warning: simplexml_load_string() [function.simplexml-load-string]: ventid>60387073</eventid><numfrom>27826641429</numfrom><receiveddata>O in /home/wwwsend/public_html/postSample_Reply3.php on line 70

Simplexml Problems

Similar Tutorials

View Content

I am trying to retrieve an attribute from a node and I keep getting the error:
Warning: main() [function.main]: Node no longer exists in /Users/dmonsewicz/Projects/noosemonsewicz/api_stuff/index.php on line 70

PHP Code
Code: [Select]
$xml = new SimpleXMLElement($result);
$arr = $xml->tickets->attributes();
echo $arr['count'];

XML
Code: [Select]
<tickets count="0" type="array"></tickets>

Any ideas on what I may be doing wrong?

Simplexml Error

Similar Tutorials

View Content

Hi

I am trying to use SimpleXML to populate some form fields from an XML file

This is the SimpleXML code that I am using
Code: [Select]
<?php
$vrm=strtoupper($_POST['veh_reg']);
$file="https://www.cdlvis.com/lookup/getxml?username=username&mode=test&key=key&vrm=".$vrm."";
$dom=new DOMdocument();
$dom->load($file);
$xml=simplexml_import_dom($dom);
var_dump($xml);
?>

The code for the display of the fields is:

Code: [Select]
<form name="vehicle_details" method="post" action="add_vehicle.php">
<table>
<tr>
<td>Registration Number:</td><td><input name="reg_num" type="text" value="<?php echo $xml->result[0]->vrm;?>" readonly="true" /></td></tr>
<tr>
<td>Make:</td><td><input name="make" type="text" value="<?php echo $xml->result[0]->make;?>" readonly="true" /></td></tr>
<tr>
<td>Model:</td><td><input name="model" type="text" value="<?php echo $xml->result[0]->model;?>" readonly="true" /></td></tr>
<tr>
<td>Date of Manufactu </td><td><input name="date_man" type="text" value="<?php echo $xml->result[0]->date_manufactured;?>" readonly="true" /></td></tr>
<tr>
<td>Date of First Registration:</td><td><input name="date_reg" type="text" value="<?php echo $xml->result[0]->first_registered;?>" readonly="true" /></td></tr>
<tr>
<td>Colour:</td><td><input name="colour" type="text" value="<?php echo $xml->result[0]->colour;?>" readonly="true" /></td></tr>
<tr>
<td>Body Style:</td><td><input name="body" type="text" value="<?php echo $xml->result[0]->body;?>" readonly="true" /></td></tr>
<tr>
<td>Number of Doors:</td><td><input name="doors" type="text" value="<?php echo $xml->result[0]->doors;?>" readonly="true" /></td></tr>
<tr>
<td>Engine Size:</td><td><input name="engine_size" type="text" value="<?php echo $xml->result[0]->engine_size;?>" readonly="true" /></td></tr>
<tr>
<td>Fuel Type:</td><td><input name="fuel_type" type="text" value="<?php echo $xml->result[0]->fuel;?>" readonly="true" /></td></tr>
<tr>
<td>Gearbox Type:</td><td><input name="gearbox" type="text" value="<?php echo $xml->result[0]->gearbox_type;?>" readonly="true" /></td></tr>
<tr>
<td>Previous Keepers:</td><td><input name="keepers" type="text" value="<?php echo $xml->result[0]->previous_keepers;?>" readonly="true" /></td></tr>
<tr>
<td>BHP:</td><td><input name="bhp" type="text" value="<?php echo $xml->result[0]->smmt_power_bhp;?>" readonly="true" /></td></tr>
<tr>
<td>Emissions:</td><td><input name="co2" type="text" value="<?php echo $xml->result[0]->smmt_co2;?>" readonly="true" /></td></tr>
<tr>
<td><input name="try_again" type="button" value="Try Again" /></td><td><input name="submit" type="submit" value="Next Stage" /></td></tr>
</table>
</form>

In each of the fields on the form when I run the code is the following error

Notice: Trying to get property of non-object in

I have also done a var_dump of the xml and I get the following

Code: [Select]
object(SimpleXMLElement)#2 (15) { ["@attributes"]=> array(4) { ["id"]=> string(6) "344571" ["generated"]=> string(10) "1300307651" ["mode"]=> string(4) "test" ["account_id"]=> string(3) "165" } ["vrm"]=> string(7) "DC70XSC" ["make"]=> string(7) "RENAULT" ["model"]=> string(23) "SCENIC EXPRESSION 16V A" ["date_manufactured"]=> string(10) "2004-02-20" ["first_registered"]=> string(10) "2004-02-20" ["colour"]=> string(5) "GREEN" ["body"]=> string(3) "MPV" ["doors"]=> string(7) "5 DOORS" ["engine_size"]=> string(4) "1598" ["fuel"]=> string(6) "PETROL" ["gearbox_type"]=> string(19) "TIPTRONIC AUTOMATIC" ["previous_keepers"]=> string(1) "1" ["smmt_power_bhp"]=> string(5) "115.1" ["smmt_co2"]=> object(SimpleXMLElement)#3 (0) { } }

What have I done wrong, any help will be much appreciated.

Simplexml Question

Similar Tutorials

View Content

Hello, I am sorry for this question in advance. I will try to explain it as detailed but, as short as possible so bare with me. I have a script that I did that parses an XML file and outputs the info in a table. The tables are created with each entry in XML file. Everything works great and as designed except for when there is no data. I know why it is doing this, I am just not sure how to approach fixing this. So here is what the data looks like where there is nothing and what the table shows. I am posting a screenshot of the XML file as I am not sure it will be empty if I post the link.

Simplexml Will Not Load

Similar Tutorials

View Content

I'm pretty new to php. But the below script should get news articles from google news rss. It is failing to load the simplexml and returns false. Any idea why?

Code: [Select]
$url = "http://news.google.com/news?geo=90210";
if ($xml = @simplexml_load_file($url))
{
for ($i=0; $i<4; $i++)
{
$item= $xml->channel->item[$i];

$link= '<a href = "'.(string) $item->link.'", target= "_blank">'.(string) substr($item->title, 0, 50).'...</a><br />';
$news[]= $link;
}
}

Using Curl And Simplexml Together ??

Similar Tutorials

View Content

Hello,

I am using curl with it's code like this:
Code: (php) [Select]
<?php
$urls = 'http://www.a-url.com';
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $urls);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_POSTFIELDS, "xml=".urlencode($xml_posts));
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Connection: close'));
$result=curl_exec($ch);
var_dump($result);

$data = XML_unserialize($result);
echo ($data);
?>
and using the XML Parse by:
Quote

# XML Library, by Keith Devens, version 1.2b
# http://keithdevens.com/software/phpxml

When i echo $data and $result i can see them on the front end and the xml in the source code once i view it.

How do i add a SimpleXML to this as i want to get some of the values from the xml file displayed in a array with a number of rows. Does this mean getting rid of the XMLParser function file and using a SimpleXML function file. Can i not use both?

When i try to use the SimpleXML functions, i'm clueless in how to get it's data from the xml $results. The XML is the source can be shown like this with me only showing one line:
Code: [Select]
<Result>
<Info>
<Details>
<Type>
<Who>
<Name key="1">This is Me</Name>
<Number1 key="2">18.93</Number1>
<Number2 key="2">20.01</Number2>
<Number3 key="2">15.21</Number3>
</Who>
</Type>
</Details>
</Info>
</Result>

Can somebody please help me with this ? I need to getthis sorted !!

Using Shuffle() With Simplexml

Similar Tutorials

View Content

I get strings via simplexml with this code
$xml = simplexml_load_file("test.xml");

foreach ($xml->title->case as $value){
$param1 = $value->param1;
$param2 = $value->param2;

Now I want to randomize the xml items (not in their original order); but I cannot use shuffle($value); because it does not consider $value as an array. How can I make a random order?

Simplexml And Htmlspecialchars?

Similar Tutorials

View Content

Hello and thanks in advance for any help.

Overview:
Im tyring to pull data from a XML api using simpleXML. I have ran into a problem with special characters and entities that simpleXML does not accept.
IE " " Ive tried all the solutions i could find to no avail.

SimpleXML gives me this error.

parser error : Entity 'nbsp' not defined in

Here is my code.

Code: [Select]
$feed = simplexml_load_file('URL TO API FEED');
$feed = html_entity_decode($feed);
$feed = str_ireplace(array('<','>','&','\'','"'),array('<','>','&',''','"'),$feed);

echo 'Game Title: ' .$feed->game. '</br>';
echo 'Ponts Earned: ' .$feed->gamerscore. '</br>';
echo 'Total Achievements: ' .$feed->totalachievements. '</br>';

foreach($feed->achievements->achievement as $ach) {

$output = htmlentities($feed->title, ENT_QUOTES, "UTF-8");
echo $output;
if( !empty($ach->unlockedartwork)){
echo '<img src=' .$ach->unlockedartwork. '></img></br>';
}else {
echo '<img src=' .$ach->artwork. '></img></br>';
}

}
Here is the code im trying to retrieve.
Code: [Select]
<achievement id="40">
<title>Have Gun Will Travel </title>
<artwork>http://</artwork>
<gamerscore>20</gamerscore>
<unlocked>true</unlocked>
<unlockdate>7/4/2010</unlockdate>
</achievement>

Help With Simplexml Traversal

Similar Tutorials

View Content

Hi, I don't know why the foreach loop doesn't output the text node content of <toFirstName> and <toLastName>?

please see email.xml file below:
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>
</email>

Please see script below:
=================
Code: [Select]
<?php
$simpleXMLObj=simplexml_load_file("email.xml");

foreach($simpleXMLObj->message[0]->to[0] AS $curDOM) {
print $curDOM->toFirstName->getName."<br />".$curDOM->toLastName->getName."<br />";
?>

Please help me out, I would really appreciate it!

Simplexml Problem

Similar Tutorials

View Content

Hello,

I'm trying to read the data of a xml file with the help of simplexml. I'm having trouble reading subchilds.

For example im trying to read the following xml:

<root>
<child>
<subchild>
<dataineed/>
<dataineed/>
<dtaineed/>
<subchild>
</child>
</root>

I'm using the following code:

<?php

$oLinkjes = new SimpleXMLElement('http://feedlink.php', 0, TRUE);

$countcat = count($oLinkjes->subchild);

echo $countcat;

?>

It echo's the the result '0' which means that it does not successfully reads the subchild. Because of that i can't get the data i want.
When i change subchild to child is does echo '1'.

Anyone knows what I'm doing wrong here? I'm new to xml so there might be a easy fix to this.

Simplexml If Statement?

Similar Tutorials

View Content

Working with a now playing module for some music.

My music player outputs this kind of XML (WHEN THE SONG IS PLAYING):

<?xml version="1.0" encoding="utf-8" ?>
- <Playing station="Station">
- <item type="MUS">
<Artist>Beatles</Artist>
<SongTitle>Get Back</SongTitle>
</item>
</Playing>

My music player outputs this kind of XML (WHEN THE SONG IS NOT PLAYING):

<?xml version="1.0" encoding="utf-8" ?>
- <Playing station="Station">
- <item type="END">
<Artist>MORE MUSIC SOON</Artist>
<SongTitle />
</item>
</Playing>

Here's my PHP:

Code: [Select]
<?php

  $playing = simplexml_load_file("../playlist/nowplaying.xml");

  foreach ($playing->item as $item) {
      printf("Now playing: %s\n", $item->SongTitle);
      printf("by %s\n", $item->Artist);
      }


  ?>
I want to make my php document check the item TYPE. (item type="x"). If x equals "MUS", display the PHP like above. But if x displays "END", I want it to display something like "More music coming up".

Right now, it displays "MORE MUSIC SOON by "

I've attempted if statements to no avail, mainly because I'm not super familiar with them in PHP.

Ideas?