<?php
  $link = mysql_connect ("194.81.104.22", "s12415617", "12415617");
  mysql_select_db ("db12415617");
 
  $CARNAME = $_GET['CARNAME'];
  $FUELTYPE = $_GET['FUELTYPE'];
  $TRANSMISSION = $_GET['TRANSMISSION'];
  $ENGINESIZE = $_GET['ENGINESIZE'];
  $DOORS = $_GET['DOORS'];
  $TOTAL = $_GET['TOTAL'];
  $AVAILABLE = $_GET['AVAILABLE'];
  $DATEADDED = $_GET['DATEADDED'];
      
  $query = "INSERT into CAR_TABLE (ID, CARNAME, FUELTYPE, TRANSMISSION, ENGINESIZE, DOORS, TOTAL, AVAILABLE, DATEADDED) values (null, '$CARNAME', '$FUELTYPE', '$TRANSMISSION', '$ENGINESIZE', '$DOORS', '$TOTAL', '$AVAILABLE',
  '$DATEADDED')";
  $result = mysql_query ($query);
      
   $query = "SELECT * from CAR_TABLE where CARNAME='$CARNAME',FUELTYPE='$FUELTYPE', TRANSMISSION='$TRANSMISSION', ENGINESIZE='$ENGINESIZE', DOORS='$DOORS', 
  AVAILABLE='$AVAILABLE', TOTAL='$TOTAL', DATEADDED='$DATEADDED'";
  $result = mysql_query ($query);
  
  //header ("Content-Type: application/xml");
  print ("<?xml version=\"1.0\" ?>");
  print "\n<database>\n";
  for ($i = 0; $i < mysql_num_rows ($result); $i ++)
  {        
    $row = mysql_fetch_object ($result);

    print " <record>\n";
    print "  <ID>$row->ID</ID>\n";
    print "  <CARNAME>$row->CARNAME</CARNAME>\n";
    print "  <FUELTYPE>$row->FUELTYPE</FUELTYPE>\n";
    print "  <TRANSMISSION>$row->TRANSMISSION</TRANSMISSION>\n";
    print "  <ENGINESIZE>$row->ENGINESIZE</ENGINESIZE>\n";
	print "  <DOORS>$row->DOORS</DOORS>\n";
	print "  <TOTAL>$row->TOTAL</TOTAL>\n";
	print "  <AVAILABLEE>$row->AVAILABLE</AVAILABLE>\n";
	print "  <AVAILABLE>$row->AVAILABLE</AVAILABLE>\n";
    print " </record>\n";
  }
  print "</database>\n";
      
  mysql_close ($link);
 ?>
 