Mysql to write xml

dgreenhouse · #11 (**permalink**) 05-12-09, 05:04 PM

Slight mistake...

As far as the custom temporary variables' table is concerned, you can use a generated session id
versus using the form_id and ip address - which wouldn't work properly anyway in this situation.

This session id is added as a hidden form element to each pages' form and will have to be generated for the first page of the multi-page forms. This is of course for the case where you've detected that the visitor doesn't have cookies enabled (if you want to include those visitors).

So... This table would be structured like:
session_id (char(40)), form_id (varchar(16)), variables (blob).

You could still add the IP address if you like for minimal assurance that the form hasn't been hi-jacked.

For additional security, you'd need to add a unique id to each form that gets generated each time.
(You'll of course need an additional table to store the token values)

So for a more full form structure:

Code:

<form action="" method="post">
  <input type="hidden" name="sid" value="seesion_id_generated_value_here" />
  <input type="hidden" name="tkn" value="unique_token_generated_value_here" />
  <input type="text" name="var1" />
  <input type="text" name="var2" />
  <input type="checkbox" name="var3" />
  <input type="submit" name="submit" value="Click Me!" />
</form>

t-soft · #12 (**permalink**) 05-16-09, 04:10 AM

page 1................................................. ..............

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Welcome to the World of  babies</title>
</head>

<body>
<form method="POST" action="Page2.php" name="B1">

<p>       &nbsp ;        & nbsp;       &nb sp;     
<marquee></marquee>                &n bsp;       &nbs p;    
<font color="#FF6666"> <font face="Algerian" size="6">Welcome to the World
of  babies</font></font></p>
<p> </p>
<p><font size="4" color="#008000">Enter Your Full Name --</font>       &nb sp;       &nbsp ;     
<input type="text" name="Fullname" size="20"></p>
<p><font size="4" color="#008000">Annual Income in thousands --       &nbsp ;
</font><input type="text" name="Income" size="20"></p>
<p><font size="4" color="#008000"><font face="Times New Roman">Address --</font><font face="Arial"> 
</font>       &nb sp;       &nbsp ;        & nbsp;       &nb sp;  
</font><input type="text" name="Address" size="20"></p>
<p><font size="4" color="#008000">City -- </font>       &nb sp;       &nbsp ;        & nbsp;       &nb sp;       &nbsp ;        & nbsp;  
<input type="text" name="City" size="20"></p>
<p><font size="4" color="#008000">State --        &n bsp;       &nbs p;                 &n bsp;       
</font><input type="text" name="State" size="20"></p>
<p><font color="#008000" size="4">Contact Number--        &n bsp;       &nbs p;       &nbsp ;
</font><input type="text" name="Contactnumber" size="20"></p>
<p>       &nbsp ;        & nbsp;       &nb sp;       &nbsp ;        & nbsp;       &nb sp;       &nbsp ;        & nbsp; </p>
<p>       &nbsp ;        & nbsp;       &nb sp;       &nbsp ;        & nbsp;       &nb sp;       &nbsp ; 
<b>
<input type="submit" value="Submit" onClick="page2.php" name="B1" style="font-family: Times New Roman; font-weight: bold; font-size: 12pt"></b>                 &n bsp;       &nbs p;                 &n bsp;    <b><input type="reset" value="Clear" name="B2" style="font-family: Times New Roman; font-size: 12pt; font-weight: bold"></b>                 </p>
</form>
<b><form method="POST" action="Page2.php" name="32">
 </form>        </p>

</body>

</html>

.................................................. ...page 2................................................. .

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>We Need Some More Information So That We Can Help You Better</title>
</head>

<body>
<form method="POST" action="Page3.php" name="B1">
<p><font size="5" face="Algerian" color="#800000">     
We Need Some More Information So That We Can Help You Better...</font></p>
<p> </p>
<p><font face="Times New Roman" size="4" color="#008000">Message--        &n bsp;       &nbs p;                 &n bsp;    
</font><input type="text" name="Message" size="20"></p>
<p><font color="#008000"><font size="4">Are You Married? Give details --     
</font></font><input type="text" name="Status" size="20"><font color="#008000">
</font></p>
<p><font size="4" color="#008000">Criminal Record -- </font><font size="4"> </font>       &nb sp;       &nbsp ;        & nbsp;     
<input type="text" name="Crecord" size="20"></p>
<p><font size="4" color="#008000">Reason To Adopt--        &n bsp;       &nbs p;       
</font><input type="text" name="Reson" size="20"></p>
<p> </p>
<p>       &nbsp ;        & nbsp;       &nb sp;       &nbsp ;        & nbsp;
<input type="submit" value="Submit" onClick="page3.php" name="B1" style="font-family: Times New Roman; font-weight: bold; font-size: 12pt">       &n bsp;       &nbs p;             
<input type="reset" value="Clear" name="B2" style="font-family: Times New Roman; font-size: 12pt; font-weight: bold"></p>
<p> </p>
</form>
<b><form method="POST" action="Page3.php" name="32">
<?
$a1=$_POST['Fullname'];
$a2=$_POST['Income'];
$a3=$_POST['Address'];
$a4=$_POST['City'];
$a5=$_POST['State'];
$a6=$_POST['Contactnumber'];

$con=mysql_connect('localhost','root','password') or die('ERROR');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}if (mysql_query("CREATE DATABASE adoption",$con))
{
echo "Database created";
mysql_select_db("adoption",$con);
}

mysql_select_db("adoption",$con);

if (mysql_query("CREATE TABLE information(Fullname varchar(30),Income int(30),Address varchar(30),
City varchar(20),State varchar(20),Contactnumber int(12)",$con))
{
echo "Table created";
}

$p="insert into information(Fullname,Income,Address,City,State,Con tactnumber)values
('$a1','$a2','$a3','$a4','$a5','$a6')";
mysql_query($p);
?>

</body>

</html>
.................................................. ...........page 3................................................. .......

<html>

<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/xml; charset=windows-1252">
<title>Thanks For Your Valuable Time We Will Get Back To You Within Next 48 Hrs
</title>
</head>
<body>
<?
$a7=$_POST['Message'];
$a8=$_POST['Status'];
$a9=$_POST['Crecord'];
$a10=$_POST['Reson'];

$con=mysql_connect('localhost','root','password') or die('ERROR');
if (!$con)
{
die('Could not connect: ' . mysql_error());
}if (mysql_query("CREATE DATABASE adoption",$con))
{
echo "Database created";
mysql_select_db("adoption",$con);
}
else
mysql_select_db("adoption",$con);

if (mysql_query("alter table information add(Message varchar(50),Status varchar(10),Crecord varchar(30),
Reson varchar(30)",$con))
{
echo "Table created";
}

$p="insert into information(Message,Status,Crecord,Reson)values
('$a7','$a8','$a9','$a10')";
mysql_query($p);

if(!$dbconnect = mysql_connect('localhost', 'root', 'password')) {
echo "Connection failed to the host 'localhost'.";
exit;
} // if
if (!mysql_select_db('adoption')) {
echo "Cannot connect to database 'adoption'";
exit;
} // if
$table_id = 'information';
$query = "SELECT * FROM $table_id";
$dbresult = mysql_query($query, $dbconnect);
// create a new XML document
$doc = domxml_new_doc('1.0');
// create root node
$root = $doc->create_element('root');
$root = $doc->append_child($root);
$root = $doc->create_element('root');
$root = $doc->append_child($root);
// process one row at a time
while($row = mysql_fetch_assoc($dbresult)) {
// add node for each row
$occ = $doc->create_element($table_id);
$occ = $root->append_child($occ);
// add a child node for each field
foreach ($row as $fieldname => $fieldvalue) {
$child = $doc->create_element($fieldname);
$child = $occ->append_child($child);
$value = $doc->create_text_node($fieldvalue);
$value = $child->append_child($value);
} // foreach
} // while
// get completed xml document
$xml_string = $doc->dump_mem(true);
//echo $xml_string;

$fh = fopen("c:/testdir/file1.xml","w");
fwrite($fh,$xml_string);
fclose($fh);
//$handle = fopen($filename, "w");
//fwrite($handle, $csv_code);
//fclose($handle);
//where $filename ='\\parag.xml';
?>
<p> </p>
<p> </p>
<p> </p>
<p><font face="Algerian" size="5" color="#800000">Thanks For Your Valuable Time
We Will Get Back To You Within Next 48 Hrs & Will Fix the Appointment...</font></p>
</body>
</html>
.................................................. ....................................end........... .................................................. .

t-soft · #13 (**permalink**) 05-16-09, 04:18 AM

dgreenhouse i appreciate all the help from you and i am really thank full also.

The purpose of generating the new xml file is the fom data stored in XML will be utilized in a desktop based application later on to produce pdf. that is entire idea of creating new xml. we can generate pdf on web itself but that's not the requirement. The above code is what i have developed. It is generating a XML file but i need a xml file to be generated everytime form is submitted..

t-soft · #14 (**permalink**) 05-16-09, 04:57 AM

I am really really tensed and need to figure out things.
A feature of the application would be that if user filled half form then, next time it should continue from there itself so i suppose i have to first store all data in database and in the end on or after submission i have to generate new xml file (in some directory on server), for every new submission.

Looking forward for guidance of an expert like you.