PHP - Detect Pc Detail/information

I am an extremly novice at this php stuff. I have a file that displays a vehicle listing based on a xml feed. I am trying to add a link to another detail page by clicking on the words Full Detail (bolded below in the code) and send me to another page (index.php?option=com_content&view=article&id=6 (joomla)), the item detail page is based on the vehicle id and has the vehicle details show up. the detail page is also a xml file with the item info. I assume I have to use the <a href.... but how do I add the Id of the vehicle. Do I use a .($_Get['vehicleid']).

Follow me?

Partial Listing of Vehciles

Code: [Select]
$doc = new DOMDocument();
$doc->loadXML($output);
$vehicles = $doc->getElementsByTagName("vehicle");
//print_r($xmlarray);
$results = print_r($xmlarray, true);
echo $results;
foreach ($vehicles as $vehicle) {

    $vehicleIDs = $vehicle->getElementsByTagName("vehicleID");
    $vehicleID = $vehicleIDs->item(0)->nodeValue;
    $years = $vehicle->getElementsByTagName("year");
    $year = $years->item(0)->nodeValue;
    $makes = $vehicle->getElementsByTagName("make");
    $make = $makes->item(0)->nodeValue;
    $models = $vehicle->getElementsByTagName("model");
    $model = $models->item(0)->nodeValue;
    $prices = $vehicle->getElementsByTagName("price");
    $price = $prices->item(0)->nodeValue;
    $modelExts = $vehicle->getElementsByTagName("modelExt");
    $modelExt = $modelExts->item(0)->nodeValue;
    $conditions = $vehicle->getElementsByTagName("condition");
    $condition = $conditions->item(0)->nodeValue;
    $auxPhotoss = $vehicle->getElementsByTagName("auxPhotos");
    $auxPhotos = $auxPhotoss->item(0)->nodeValue;
    $transmissions = $vehicle->getElementsByTagName("transmission");
    $transmission = $transmissions->item(0)->nodeValue;
    $cylinderss = $vehicle->getElementsByTagName("cylinders");
    $cylinders = $cylinderss->item(0)->nodeValue;
    $fueltypes = $vehicle->getElementsByTagName("fueltype");
    $fueltype = $fueltypes->item(0)->nodeValue;
    $doorss = $vehicle->getElementsByTagName("doors");
    $doors = $doorss->item(0)->nodeValue;
    $financings = $vehicle->getElementsByTagName("financing");
    $financing = $financings->item(0)->nodeValue;
    $paymentFrequencys = $vehicle->getElementsByTagName("paymentFrequency");
    $paymentFrequency = $paymentFrequencys->item(0)->nodeValue;
    $kilometerss = $vehicle->getElementsByTagName("kilometers");
    $kilometers = $kilometerss->item(0)->nodeValue;
    $imgSrcs = $vehicle->getElementsByTagName("imgSrc");
    $imgSrc = $imgSrcs->item(0)->nodeValue;
    $formattedprice = sprintf("%01.2f", $price);
    $price_currency = number_format($price, 2, ".", ",");
    if ($price_currency == 0) {
        $price_currency = "CONTACT DEALER";
    }

    $featuress = $vehicle->getElementsByTagName("features");
    $features = $featuress->item(0)->childNodes;
    $featureCount = $features->length;
    $i = 0;
    $featurestring = "";
    while ($i < $featureCount) {
        $i++;
        $featureA[$i] = $features->item($i - 1)->nodeValue;
        $featurestring .= ($i % 2 == 0 ? $featureA[$i] . ", " : "");
    }
   
echo "<table style=background-color: rgb(246, 246, 246)text-align: left width: 900px height: 100px\n";
echo "    border=0 cellpadding=2 cellspacing=2>\n";
echo "    <tbody>\n";
echo "    <tr>\n";
echo "    <td\n";
echo "    style=background-color: black font-family: Helvetica,Arial,sans-serif><small><span\n";
echo "    style=color: yellow><span style=font-weight: bold>Vehicle ID:</span>\n";
echo "    $vehicleID</span></small></td>\n";
echo "    <td\n";
echo "    style=background-color: rgb(255, 204, 0) font-family: Helvetica,Arial,sans-serif width: 147px><small>Year:\n";
echo "    $year</small></td>\n";
echo "    <td\n";
echo "    style=background-color: rgb(255, 204, 0) font-family: Helvetica,Arial,sans-serif width: 109px><small>Make:\n";
echo "    $make</small></td>\n";
echo "    <td\n";
echo "    style=background-color: rgb(255, 204, 0) font-family: Helvetica,Arial,sans-serif width: 141px><small>Model:\n";
echo "    $model</small></td>\n";
echo "    <td\n";
echo "    style=background-color: black font-family: Helvetica,Arial,sans-serif width: 147px><small><span\n";
echo "    style=color: rgb(255, 204, 0) font-weight: bold>Price: $\n";
echo "    $price_currency</span></small></td>\n";
echo "    </tr>\n";
echo "    <tr>\n";
echo "    <td colspan=1 rowspan=3><small><span\n";
echo "    style=font-family: Helvetica,Arial,sans-serif><img src=$imgSrc></span></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>Condition:\n";
echo "    $condition</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 109px><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 141px><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small></small></td>\n";
echo "    </tr>\n";
echo "    <tr width=147\n";
echo "    style=font-family: Helvetica,Arial,sans-serif>\n";
echo "    <small></small><td\n";
echo "    style=background-color: black width: 147px colspan=4 \n";
echo "    rowspan=1><span style=color: rgb(255, 204, 0)><a href=\"http://heavyequipmentwantedads.com/icardemo/inventory/getitems.php?&$vehicleID\" title=\"Full Details (View)\" target=\"_new\">Full Details (View)</a></span></td>\n";
echo "  <small></small></tr>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>Transmission\n";
echo "    : $transmission</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 109px><small>Doors:\n";
echo "    $doors</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 141px><small>FuelType: $fueltype</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>KM:\n";
echo "    $kilometers</small></td>\n";
echo "    </tr>\n";
echo "    <tr>\n";
echo "    <td style=background-color: rgb(204, 204, 204)><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small>Cylinders:\n";
echo "    $cylinders</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 109px><small></small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 141px><small>Features: $featurestring</small></td>\n";
echo "    <td\n";
echo "    style=font-family: Helvetica,Arial,sans-serif width: 147px><small></small></td>\n";
echo "    </tr>\n";
echo "    </tbody>\n";
echo "    </table>\n";

Partial listing of items:

Code: [Select]
<?php
$xmldata ='<dealerAccount>
<accountNum>xxxxxx</accountNum>
<dealerPwd>xxxxxxxxx</dealerPwd>
<data>item</data>
<vehicleID>'.$vehicleID.'</vehicleID>
</dealerAccount>';
$URL = "http://www.wheelsonline.ca/api/";
 
$ch = curl_init($URL);
//curl_setopt($ch, CURLOPT_MUTE, 1);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_POST, 1);
curl_setopt($ch, CURLOPT_HTTPHEADER, array('Content-Type: text/xml'));
curl_setopt($ch, CURLOPT_POSTFIELDS, "$xmldata");
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$output = curl_exec($ch);
curl_close($ch);

$doc=new DOMDocument();
$doc->loadXML($output);
$items=$doc->getElementsByTagName("item");
$results = print_r($xmlarray, true);
echo $results;

?>

I have a form with a table that contains ONLY dropdown menus for users to select quantities from 25 dinner items.  It contains some Javascript, but nothing fancy.  In an effort to establish my database and TEST to see how some PHP functions might respond so I could improve my form, I created a mini version of the db in MySQL.

But when I click the submit button, the page blinks, the address bar fills with field names, but there is no connect.  No error messages.  No data transfer.  NO NOTHING!

I searched the web and copied a form and plugged it in (an html form, a php insert file, and a MySQL database) and it worked fine.  I peared down my page to mirror it, and still, no success.

What little detail am I missing??  If I have 25 fields but create a db for the first 6, should it function?
If I reduce it and try to re-use the same db, am I persuing a problem?
I've tried error trapping and changing the form inputs, but it just still doesn't connect.

Please help!

Hello,

I have a database with the following tables:

students       groups          exams           examDay      relation         master             detail
=======     =====          =====         =======     ======        ======          =====
idStudent    idGroup           idExam         idExDay        idRelation      idMaster          idDetail
idGroup       groupName     examName   exDate         idGroup          idGroup           idMaster
studName                                                                   idExDay          idRelation        idExam
                                                                                   idExam           idStudent
                                                                                   coursesAtt      idExDay

I am trying to make a report from the Master and Detail tables that will have the table header like this:

Group | Examination Date | Student Name | Exam1 | Exam2| .... | Exam n

in which Exam1, Exam2,... are the exams names and they had to take the values from coursesAtt column.

Is this possible? I could make a view (doing joins and group by) by the results will be displayed on row. That's why I ask for your help.

Thanks

I want to create a master-detail page using PHP. Rather than getting data from a MYSQL database, I want to get the data from an associative array. Is this possible? Please someone show me the way forward. Please help.

Hi all expert. I am a newbie in this PHP programming. I need your help or advise on the PHP. And question is, I have a list of data and the details are as below: ID  BILLNO   DATE        AMOUNT   ITEM   DESCRIPTION   QTY   UPRICE
1   IV001   01/01/2015   100.00   A1     Balloon        1    30.00
2   IV001   01/01/2015   100.00   A2         Bag        2    20.00
3   IV001   01/01/2015   100.00   A3         Pen        3    10.00
4   IV002   02/01/2015    20.00   A3         Pen        2    10.00
5   IV003   02/01/2015    50.00   A1     Balloon        1    30.00
6   IV003   02/01/2015    50.00   A2         Bag        1    20.00     How can I make the output in xml by using PHP to output as below: <RECORD>
  <HEADER BILLNO="IV001" DATE="01/01/2015" AMOUNT="100.00>
    <DETAIL ITEM="A1" DESCRIPTION="Balloon" QTY="1" UPRICE="30.00">
    </DETAIL>
    <DETAIL ITEM="A2" DESCRIPTION="Bag" QTY="2" UPRICE="20.00">
    </DETAIL>
    <DETAIL ITEM="A3" DESCRIPTION="Pen" QTY="3" UPRICE="10.00">
    </DETAIL>
  </HEADER>
  <HEADER BILLNO="IV002" DATE="02/01/2015" AMOUNT="20.00>
    <DETAIL ITEM="A3" DESCRIPTION="Balloon" QTY="2" UPRICE="10.00">
    </DETAIL>
  </HEADER>
</RECORD>     Your feedback is highly appreciated. Thank you.