serialize function
Posted: Tue Jun 03, 2008 4:31 pm
Hi
I am trying to use the serialize function but I think I have something incorrect because I am getting a blank page when I submit my form.
I am trying to use the serialize function but I think I have something incorrect because I am getting a blank page when I submit my form.
Code: Select all
//request:
$request = serialize($_POST['request']);
$query=INSERT INTO request VALUES('$request');
mysql_query($query) or die (mysql_error());
$query = "SELECT * from Request";
$result = mysql_query($query);
while (mysql_fetch_array($result, MYSQL_ASSOC))
{
$request = unserialize($row['request']);
foreach ($request as $value)
{
echo "$value -";
}
echo "<br/>\n";
}
mysql_query($query) or die (mysql_error());
//Run Insert Query
$query = "INSERT INTO Log (DateRcvd, OrigDept, OrigContact, RespOffice, Request, contents, refer, deadline, GivenTo, stats, outcome, notes, complete)
VALUES ('$drcvd', '$ODT', '$ocont', '$RSP', '$contents', '$REF', '$deadline', '$request', '$givento', '$status', '$outcome', '$notes', '$completed')";
$result = mysql_query($query);