PHP - Parse The Nested Variables In Xml Using Php

   $BoxSize = array("smallbox" = array("length" => 12, "width" => 10, "depth" => 2.5),
      "mediumbox" = array("length" => 30, "width" => 20, "depth" => 4),
      "largebox" = array("length" => 60, "width" => 40, "depth" => 11.5));
      

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>';

Code: [Select]
This is a clip of my PHP file:
<?php
$con = mysql_connect($host,$username,$password);
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db($database, $con);

$result = mysql_query("SELECT * FROM purchase_order
WHERE purchase_order_number=='$purchase_order_number'");

while($row = mysql_fetch_array($result))
  {
$vendor=$row['vendor'];
$purchase_order_date=$row['purchase_order_date'];
$ship=$row['ship'];
$state=$row['state'];
$fob=$row['fob'];
$terms=$row['terms'];
$buyer=$row['buyer'];
$freight=$row['freight'];
$req_date=$row['req_date'];
$confirming_to=$row['confirming_to'];
$remarks=$row['remarks'];
$tax=$row['tax']
 } // [i][u][b]<-- This is line 88 (The one with the error)[/b][/u][/i]
?>Thanks in advance!

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());
?>

im stuck on this section of code atm
its failing on the line "or die(mysql_error());"

i think its the $table ifs. ive tryed "" around the query but i get other errors then
 
<?php

if ($_GET['make'] == ''){
      //no input

          //all
               if ($_GET['make'] == 'all'){      
              $table = $result6 = mysql_query("SELECT * FROM dsgi_serval where comments like '{$_GET['make']}'");

                  //pass
                   if ($_GET['make'] == 'pass'){      
                   $table = $result6 = mysql_query("SELECT * FROM dsgi_serval where comments like '{$_GET['make']}'");
                       
                        //not pass
                        if ($_GET['make'] == 'notpass'){
                        $table = $result6 = mysql_query("SELECT * FROM dsgi_serval where comments not like '{$_GET['make']}'");
 }else{         
          //by make                 
         $table = $result6 = mysql_query("SELECT * FROM dsgi_serval where comments not like '{$_GET['make']}'");
}

}
}
}


  ?>
<div id="right">

  <?php
  
echo "$table";
or die(mysql_error()); 
$result=mysql_query($sql);
?>

Hi guys,

Was wondering if anyone can help me with this. Here's what I'm trying to do:

I've retrieved values from table a from mysql and post them on a form.

Code: [Select]
echo "<tr><td>" .$row['id']. "</td><td>" .$row['name']. "<input type='hidden' name=name[] value=" .$row['name']. "></td><td><select name='item[]'><option value ='' selected='selected'>Please Select</option><option value ='1'>1</option><option value ='2'>2</option><option value ='3'>3</option></td></tr>";

and now i'm trying to display these information one more time on a different page. So I did the usual retrieval

Code: [Select]
$name = $_POST['name'];
$item = $_POST['item'];

Then I'm using foreach loop to retrieve the item values.

Code: [Select]
foreach ($item as $getitem => $value)     
{
echo "<tr><td>";
echo $value;
echo "</td></tr>";
}

Here is where I'm stumped. What's the best way to associate the name to the item.

while loop?

Thanks for the help.

I'm a bit confused here on for loops. I don't quite understand why this script outputs what it does and I'd like it if someone could explain it to me.

Code: (php) [Select]
<?php
for ($i = 1; $i < 3; $i = $i + 1) {
for ($j = 1; $j < 3; $j = $j + 1) {
echo "'i' is {$i}, 'j' is {$j}<br />";
}
}
?>
Result:
Code: [Select]
'i' is 1, 'j' is 1
'i' is 1, 'j' is 2
'i' is 2, 'j' is 1
'i' is 2, 'j' is 2

Hello i am new here, and new to php too.
I try to learn php from about 20 days, and i am getting stuck in something, somebody asked me to make a program that will produce the following output, i have to use a nested for loop:
1
22
333
4444
55555
........etc

The code for is:
Code: [Select]
for($a=1;$a<10;$a++)
{
   echo "<br>";

   for ($b=0;$b<$a;$b++)
   echo $a;

}I do know this is something elementary, but really i cannot understand how it works is there any saint that will comment the code and explain step by step whats happening there?
Thank you.

while($comp = mysql_fetch_assoc($company))
{ echo "company name: $comp['name'] <br>";
 $c = mysql_fetch_assoc(mysql_query("SELECT * FROM comp_images WHERE company='". $comp['name'] ."'"));
echo $c;
}

When I use that, it only echos one image URL, none others.

Hello everybody,

I hope someone can help me. I've got a database table with subscriber info linked to various tenders. The current layout of the table is as follows (this is dummy data):

Subscriber                       Category            Email                          Tender Info
Dummy Company 1         Advertisting        email@email.com        Tender 1
Dummy Company 1         Advertisting        email@email.com        Tender 2
Dummy Company 1         Advertisting        email@email.com        Tender 3
Dummy Company 1         Advertisting        email@email.com        Tender 4
Dummy Company 2         Marketing           email2@email.com      Tender 5
Dummy Company 2         Marketing           email2@email.com       Tender 6

What I'm trying to do, is to send Company 1 an email with the info for all 4 tenders. If I do a normal loop, it sends 4 emails, each mail having the info only for one tender.  Here's my code:

Code: [Select]
//Select subscriber and email address, grouped to only have one entry per sub
$subs = "SELECT subscriber, email FROM tenders_temp GROUP BY subscriber";
$query = mysql_query($subs);


while ($subsrs = mysql_fetch_array($query)) {

//Select all tenders info
$tender = "SELECT * FROM tenders_temp WHERE subscriber = '".$subsrs['subscriber']."'";
$restender = mysql_query($tender);


//Send email
$msg = "<html><body>
<table width='100%' border='0' cellspacing='0' cellpadding='10'>";
 
while ($rstend = mysql_fetch_array($restender)) {

$msg .= "
   <tr>
<td valign='top'><strong>SUBSCRIBER:</strong></td>
<td colspan='3'>".$rstend['subscriber']."</td>
   </tr>
   <tr>
<td valign='top'><strong>CATEGORY:</strong></td>
<td colspan='3'>".$rstend['tender_interests']."</td>
</tr>
  <tr>
<td width='16%' valign='top'><strong>REFERENCE: </strong></td>
<td width='34%'>".$rstend['reference']."</td>
<td width='15%'><strong>CLOSING:</strong></td>
<td width='35%'>".$rstend['closedate']."&nbsp;".$rstend['closetime']."</td>
  </tr>
  <tr>
<td valign='top'><strong>DESCRIPTION:</strong></td>
<td colspan='3'>".$rstend['summary']."&nbsp;".$rstend['description']."&nbsp;".$rstend['detail']."</td>
</tr>
  <tr>
<td valign='top'><strong>CONTACT:</strong></td>
<td colspan='3'>".$rstend['organization'].";&nbsp;".$rstend['contact'].";&nbsp;Phone:&nbsp;".$rstend['dial_code']." ".$rstend['telno'].";&nbsp;
Email:&nbsp;".$rstend['email']."</td>
</tr>
  <tr>
<td valign='top'><strong>DOCUMENTATION:</strong></td>
<td colspan='3'>".$rstend['documentation']."</td>
  </tr>
  <tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td colspan='2'>&nbsp;</td>
  </tr>
  <tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
<td colspan='2'>&nbsp;</td>
  </tr>";
}
$msg .= "
</table>
</body></html>";

$headers  = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
$headers .= "From: info@tenders24.com\r\n";
$headers .= "Reply-To: info@tenders24.com\r\n";
$headers .= "Return-Path: info@tenders24.com\r\n";
$headers .= "Organization: Tenders24\r\n"; 
$headers .= "X-Priority: 3\r\n";


mail($subsrs['email'], "Tenders24", $msg, $headers);

}

Looking at this code, in theory it should work. The first query groups the entries to have one email address, then the second loop, takes each entry and loops the number of tenders inside the email. I'm getting an error with this tho.

Code: [Select]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource
Can anybody please help??


Thanks in advance!

Karen

I have a nested array. I'm trying to write code to produce the minimum value foreach first key of the $test array. So, ideally it would produce what's in the $result array. I don't know why i can't figure out how to do this. The multiple nests are throwing me off. I think i'm over thinking this.

Code: [Select]
<?php

$test['abcd']['0'] = array('10','100','300');
$test['abcd']['1'] = array('1000','100','3000');
$test['abcd']['3'] = array('23','89','700');

$test['efgh']['0'] = array('3','55','300');
$test['efgh']['1'] = array('160','160','9000');
$test['efgh']['3'] = array('900','89','200');

//$result['abcd'] = 10;
//$result['efgh'] = 3;

?>

 
i have been trying to make this work for days, this needs to also include a discount for staying over >=5 days in Tokyo, no matter what i do i always gets syntax error this class is making me crazy how do i go about getting the discount in this????? please help
<?php
      $destination = $_POST['destination'];
      $numTravelers = $_POST['numTravelers'];
      $numNights = $_POST['numNights'];
      $airFare = $_POST['airFare'];
      $hotel = $_POST['hotel'];
               
       if ($destination == Barcelona)
       {$airFare = 875.00;
       $perNight = 85.00;}
       elseif ($destination == Cairo)
       {$airFare= 950.00;
       $perNight = 98.00;}
       elseif ($destination == Rome)
       {$airFare = 875.00;
       $perNight = 110.00;}
       elseif ($destination == Santiago)
       {$airFare = 820.00;
       $perNight = 85.00;}
       elseif ($destination == Tokyo)
         {$airFare = 1575.00;
         $perNight = 240.00;}
this is where i can not figure out how to put in the discount off the airfare for staying over five days
      elseif ($destination == Tokyo && $numNights >=5)            
      $tickets = $numTravelers * $airFare;
      $hotel = $numTravelers * $numNights * $perNight;
      $totalCost = $tickets + $hotel;
      
      print("<p>Destination: $destination<br />");
      print("Number of people: $numTravelers<br />");
      print("Number of nights: $numNights<br />");
      print("Airline Tickets: $".number_format($tickets, 2)."<br />");
      print("Hotel Charges: $".number_format($hotel, 2)."</p>");
      print("<p><strong>TOTAL COST: $".number_format($totalCost, 2)."</strong></p>");
   ?>

Hi there, im trying to nest two do loops. The first loop works fine but the last loop doesnt seem to work at all.



Code: [Select]
<? $colname_Planet = "-1";
if (isset($_GET['recordID'])) {
  $colname_Planet = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_swb, $swb);
$query_Planet = sprintf("SELECT * FROM planet WHERE PlanetName = %s", GetSQLValueString($colname_Planet, "text"));
$Planet = mysql_query($query_Planet, $swb) or die(mysql_error());
$row_Planet = mysql_fetch_assoc($Planet);
$totalRows_Planet = mysql_num_rows($Planet);

$plans = $row_Planet['PlanetName'];

$colname_Fleet = "-1";
if (isset($_GET['recordID'])) {
  $colname_Fleet = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_swb, $swb);
$query_Fleet = sprintf("SELECT * FROM fleet WHERE PlanetName =  '$plans'");
$Fleet = mysql_query($query_Fleet, $swb) or die(mysql_error());
$row_Fleet = mysql_fetch_assoc($Fleet);
$totalRows_Fleet = mysql_num_rows($Fleet);

$fleetships = $row_Fleet['FleetName'];

$colname_Ships = "-1";
if (isset($_GET['recordID'])) {
  $colname_Ships = (get_magic_quotes_gpc()) ? $_GET['recordID'] : addslashes($_GET['recordID']);
}
mysql_select_db($database_swb, $swb);
$query_Ships = sprintf("SELECT * FROM ships WHERE FleetName = '$fleetships'");
$Ships = mysql_query($query_Ships, $swb) or die(mysql_error());
$row_Ships = mysql_fetch_assoc($Ships);
$totalRows_Ships = mysql_num_rows($Ships); ?>
<?php do { ?>
<?php echo $row_Fleet['FleetName']; ?>
<?php echo $row_Fleet['PlanetName']; ?>
<?php do { ?>
<?php echo $row_Ships['ShipName']; ?>
<?php } while ($row_Ships = mysql_fetch_assoc($Ships)); ?>
<?php } while ($row_Fleet = mysql_fetch_assoc($Fleet)); ?>
If you can spot anything wrong, please let me know.

Thanks

Hello everyone,

I'm trying to pull a list of email campaigns from constant contact and display them on our site,

require_once('ctctWrapper.php');
$data = new CampaignsCollection();
$campaigns = $data->listCampaigns();
foreach ($campaigns as $campaign) {

foreach ($campaign as $value) {

$feed .= $value . "\r\n";

}
}
echo $feed;
The above code gives me the following error Quote

Catchable fatal error: Object of class Campaign could not be converted to string in /home/******/public_html/tmpl/default.php on line 13


If I just print the array, this is how it starts out
Code: (xml) [Select]
Array ( [0] => Campaign Object ( [campaignName:private] => SimpleXMLElement Object ( [0] => aaaCopy of March 2011 Newsletter ) [id:private] => SimpleXMLElement Object ( [0] => http://api.constantcontact.com/ws/customers/******/campaigns/1105174741613 ) [link:private] => SimpleXMLElement Object ( [0] => /ws/customers/******/campaigns/1105174741613 ) [status:private] => SimpleXMLElement Object ( [0] => Draft ) [campaignDate:private] => SimpleXMLElement Object ( [0] => 2011-04-14T17:07:23.245Z ) [lastEditDate:private] => [campaignSent:private] => [campaignOpens:private] => [campaignClicks:private] => [campaignBounces:private] => [campaignForwards:private] => [campaignOptOuts:private] => [campaignSpamReports:private] => [subject:private] => [fromName:private] => [campaignType:private] => [vawp:private] => [vawpLinkText:private] => [vawpText:private] => [permissionReminder:private] => [permissionReminderText:private] => [greetingSalutation:private] => [greetingName:private] => [greetingString:private] => [orgName:private] => [orgAddr1:private] => [orgAddr2:private] => [orgAddr3:private] => [orgCity:private] => [orgState:private] => [orgInternationalState:private] => [orgCountry:private] => [orgPostalCode:private] => [incForwardEmail:private] => [forwardEmailLinkText:private] => [incSubscribeLink:private] => [subscribeLinkText:private] => [emailContentFormat:private] => [emailContent:private] => [textVersionContent:private] => [styleSheet:private] => [lists:private] => Array ( ) [fromEmailAddress:private] => [fromEmailAddressLink:private] => [replyEmailAddress:private] => [replyEmailAddressLink:private] => [archiveStatus:private] => [archiveUrl:private] => ) [1] => Campaign Object ( [campaignName:private] => SimpleXMLElement Object ( [0] => March 2011 Newsletter ) [id:private] => SimpleXMLElement Object ( [0] => http://api.constantcontact.com/ws/customers/******/campaigns/1104754710085 ) [link:private] => SimpleXMLElement Object ( [0]

I think the problem is with     echo "<td>".$row["countnow($i)"]."</td>"; it's not showing anything, any ideas how to fix it?
Code: [Select]
$i = 1;
While ($i <25)
{
?>
  <tr>
    <td><?php echo $i; ?></td>
    <?php 
$sql = "SELECT * FROM `systems` WHERE `solarSystemName` LIKE $sname" or die (mysql_error());
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)){
    echo "<td>".$row["countnow($i)"]."</td>";
}
?>
<tr>
<?php
$i++;
}