want to export form input to xml using php

[printline]

Hello All

I'm quite new to xml vs. PHP, so i hope someone can help with an issue i have been struggeling with.

I have an html form, that when submitted, it should create an xml file, and save in a certain place on my server.

I know that this can be done using php, but i'm not sure how....?

Here is my php (which needs to be configured to output the xml file):

[PHP]<?php

$conn = mssql_connect(' host','username ','password');
mssql_select_db ('databasename' ,$conn);

session_start() ;
header("Cache-control: private");
session_registe r("LoggedIn") ;
session_registe r("SavedSearchT ype");
session_registe r("SalesRepID") ;
session_registe r("SavedCustID" );
session_registe r("SavedFromDat e");
session_registe r("SavedToDate" );
session_registe r("WebCompanyNa me");
session_registe r("CompanyName" );
session_registe r('WebUserType' );

if (!isset($_POST['CustID'])) {
$_POST['CustID'] = trim($_SESSION['SavedCustID']);
}

$_SESSION['SavedCustID'] = "All";
if (trim($_SESSION['ShowDetails']) == "Y") {
if (trim($_SESSION['WebUserType']) == "Rep") {
$_SESSION['SavedCustID'] = trim($_POST['CustID']);
}}

if ($_SESSION['LoggedIn'] != true) {
@include("./login.php");
return;
}

$a = trim($_SESSION['UserID']);
$b = trim($_SESSION['Password']);
$query = "select * from USERINFO where (UserID = '" . $a . "' and Password = '" . $b . "')";
// print($query);
$result = mssql_query($qu ery,$conn);
if (mssql_num_rows ($result) > 0) {
$userinfo = mssql_fetch_arr ay($result);
$CompanyName = $userinfo['CompanyName'];
$Addr1 = $userinfo['Addr1'];
$Addr2 = $userinfo['Addr2'];
$City = $userinfo['City'];
$State = $userinfo['State'];
$Zip = $userinfo['Zip'];
$Country = $userinfo['Country'];
$Phone = $userinfo['Phone'];
$CustID = trim($userinfo['CustID']);
} else {
$CompanyName = "";
$Addr1 = "";
$Addr2 = "";
$City = "";
$State = "";
$Zip = "";
$Country = "";
$Phone = "";
$CustID = "";
}
?>
[/PHP]

Here is my form:

[HTML]<form method="post" name="shopform" action="" onsubmit="retur n checkFields3(); ">

<input type="hidden" name="CompanyNa me" value="<?php echo $CompanyName; ?>" />
<input type="hidden" name="Addr1" value="<?php echo $Addr1; ?>" />
<input type="hidden" name="Addr2" value="<?php echo $Addr2; ?>" />
<input type="hidden" name="City" value="<?php echo $City; ?>" />
<input type="hidden" name="Zip" value="<?php echo $Zip; ?>" />
<input type="hidden" name="Country" value="<?php echo $Country; ?>" />
<input type="hidden" name="Phone" value="<?php echo $Phone; ?>" />
<input type="hidden" name="CustID" value="<?php echo $CustID; ?>" />

<table>
<tr>
<td>
<input name="part_name " type="text" size="30" />
</td>
</tr>
<tr>
<td>
<input name="layers" value="2" type="radio" />
<input name="layers" value="4" type="radio" />
<input name="layers" value="6" type="radio" />
<input name="layers" value="8" type="radio" />
</td>
</tr>
<tr>
<td>
<input name="quantity" type="text" value="" size="5" />
</td>
</tr>
<input name="pcbwidth" type="text" value="" size="5" />
<input name="pcbheight " type="text" value="" size="5" />
</td>
</tr>
<tr>
<td>
<input name="thickness " value="1.0" type="radio" />
<input name="thickness " value="1.6" type="radio" />
<input name="thickness " value="2.0" type="radio" />
</td>
</tr>
<tr>
<td>
<input name="cuoutthic kness" type="radio" value="35 µ" />
<input name="cuoutthic kness" type="radio" value="70 µ" />
</td>
</tr>
<tr>
<td>
<input name="surface" value="Silver" type="radio" />
<input name="surface" value="Leadfree HAL" type="radio" />
</td>
</tr>
<tr>
<td>
<input name="delivery" value="5 Working Days" type="radio" />
<input name="delivery" value="8 Working Days" type="radio" />
<input name="delivery" value="10 Working Days" type="radio" />
<input name="delivery" value="15 Working Days" type="radio" />
</td>
</tr>
</table>
</form>[/HTML]

And the generated xmlfile should look something similar to this:

[HTML]<?xml version="1.0" encoding="UTF-8"?>
<Header>xxxxx </Header>
- <Customer_Inf o>
<Company_name>x xxxx</Company_name>
<Address>xxxx x</Address>
<City>xxxxx</City>
<Zip>xxxxx</Zip>
<Country>xxxx x</Country>
<CustID>xxxxx </CustID>
</Customer_Info>
- <CAD_Data>
<part_name>xxxx xxx</part_name>
<layers>xxxxxxx </layers>
<quantity>xxxxx xx</quantity>
<pcbwidth>xxxxx xx</pcbwidth>
<pcbheight>xxxx xxx</pcbheight>
<thickness>xxxx xxx</thickness>
<copperthicknes s>xxxxxxx</copperthickness >
<delivery>xxxxx xx</delivery>
</CAD_Data>[/HTML]

Any input/solution to this problem is more than welcome.

Thanks in advance!

[Dormilich]

If cou can make allowances to the structure of the xml file you can have a look at WDDX. this essentially serializes variables (e.g. arrays) into xml.
WDDX at Wikipedia