PHP - Writing To Database After Unserialize

I have written some code to past information from one page to a diffrent page however all the variables are sent over but they are not writting to the database could anyone help me out please ....

$ud_P_Id = $_POST['ud_P_Id'];
$ud_LastName = $_POST['ud_LastName'];
$ud_FirstName = $_POST['ud_FirstName'];
$ud_GroupCode=$_POST['ud_GroupCode'];
$ud_P_Unit1=$_POST['ud_P_Unit1'];
$ud_P_Unit2=$_POST['ud_P_Unit2'];
$ud_P_Unit3=$_POST['ud_P_Unit3'];
$ud_P_Unit6=$_POST['ud_P_Unit6'];
$ud_P_Unit14=$_POST['ud_P_Unit14'];
$ud_P_Unit20=$_POST['ud_P_Unit20'];
$ud_P_Unit27=$_POST['ud_P_Unit27'];
$ud_P_Unit28=$_POST['ud_P_Unit28'];
$ud_P_Unit42=$_POST['ud_P_Unit42'];
$ud_P_Unit10=$_POST['ud_P_Unit10'];
$ud_P_Unit11=$_POST['ud_P_Unit11'];
$ud_P_Unit12=$_POST['ud_P_Unit12'];
$ud_P_Unit13=$_POST['ud_P_Unit13'];
$ud_P_Unit1454=$_POST['ud_P_Unit1454'];
$ud_P_Unit15=$_POST['ud_P_Unit15'];
$ud_P_Unit16=$_POST['ud_P_Unit16'];
$ud_P_Unit17=$_POST['ud_P_Unit17'];
$ud_P_Unit18=$_POST['ud_P_Unit18'];


$con = mysql_connect('localhost', 'lccstude_progre', '********');
$db= "lccstude_pro";
if (! $con)
die("Couldn't connect to MySQL");
mysql_select_db($db , $con)
or die("Couldn't open $db: ".mysql_error());




mysql_query("UPDATE BTECL31113 SET FirstName='$ud_FirstName' , LastName='$ud_LastName' , GroupCode='$ud_GroupCode' , Unit1='$ud_P_Unit1' , Unit2='$ud_P_Unit2' , Unit3='$ud_P_Unit3' , Unit6='$ud_P_Unit6' , Unit14='$ud_P_Unit14' , Unit20='$ud_P_Unit20' , Unit27='$ud_P_Unit27' , Unit28='$ud_P_Unit28' , Unit42='$ud_P_Unit42' , Unit10='$ud_P_Unit10' , Unit11='$ud_P_Unit11' , Unit12='$ud_P_Unit12' , Unit13='$ud_P_Unit13' , Unit1454='$ud_P_Unit1454' , Unit15='$ud_P_Unit15' , Unit16= $ud_P_Unit16' , Unit17='$ud_P_Unit17' , Unit18='$ud_P_Unit18' WHERE P_Id='$ud_P_Id'");

echo "Record Updated";

mysql_close($con);



Please any help would be great

I'm writing a script that takes user input from a html form and updates the database with the new data. In this example the user is updating the data about the university they attend. The problem with this is, the script to update the database with the new information appears to be not working - the new data is not being added to the database. The SQL queries used in the script work in phpMyadmin, and the variables - $uni and $username - contain the data the correct data. This has me stumped, could someone look over this for me please and tell me what is going wrong here.

Code: [Select]
<?php

  include 'connect.php';
  
  session_start();
  $_SESSION['username']; 
  
  if(!(isset($_SESSION['login']) && $_SESSION['login']!= " ")){
       header("Location: login.php");
   }
   
  $username = $_SESSION['username'];
  $tablename = 'usr_test';
  

  $uni = $_POST['uni'];
  
  $uni = stripslashes($uni);
  $uni = mysql_real_escape_string($uni);
  $uni = trim($uni);

if(isset($uni))
{  
   $username = $_SESSION['username'];
   $loc = mysql_query("SELECT * FROM usr_test WHERE usr = '$username'");

   if (mysql_num_rows($loc) == 0)
   header("Location:notlogged.php");
   
   else 

   {

    extract(mysql_fetch_array($loc));

    mysql_query("UPDATE usr_test SET uni = ('$uni') WHERE usr = '$username'") or die (mysql_error());
    header("Location:profile.php");

   }
    }

  ?>

Hey,

I'm trying to work out how I can have a simple script that will work like this:

Page 1 - Heading, Paragraph, Image read from database.
Page 2 - Has text boxes allowing you to change heading, paragraph and image (url) with each edit using a different text box. (Admin panel)

The database connection would be in a separate file.

So far I've got the database connection sorted.

Code: [Select]
<?php
//Database Information
$dbtype = "mysql"; 
$db_host = "localhost";
$db_user = "";
$db_pass = "";
$db_name = "";
$db_port = "";
$db_table_prefix = "userCake_";
?>
At the top of each of the other pages this is what I've got.
Code: [Select]
<?php 
require_once("models/config.php");
?>
Let's say I give each bit stored in the database a page ID and an object ID.

If the page selected is index.php how can we give it a page ID of 1 and give then include all the separate 'objects' throughout the page?

Hopefully this makes sense?

Cheers,
Jack

guys this is my code
<?php
include("header.php");
include("conn.php");
?>
<html>
<head>
</head>
<body>
<table border="1" cellpadding="0" cellspacing="0" align="center">
<tr>
<td>Please Enter the Amount</td>
<td valign="top" align="left" width="200">
<form action="next.php" method="post">
<input name="amount" value="1" size="7">
</td>
<tr>
<td>From:</td>
<td valign="top" align="left" width="200">
<?php

$real= array (
'USD'=>1,
'PAK'=>1.6323,
'GBP'=>1.02544
);


$abc= mysql_real_escape_string( serialize($real) );
//$ddsr=unserialize($abc);


//$abc= implode(",",$real);
//echo $abc;
$from= array('Dollars','Rupees','Pounds');
$length = count($from);
//$dbs=implode(",",$from);



$dql = "INSERT INTO countrytype (`ID`,`fromcountry`,`tocountry`) VALUES ('','".$abc."','".$abc."')";
mysql_query($dql) or die(mysql_error());

$to= array('Dollars','Rupees','Pounds');
$to=str_replace("","",$to);
?>
<input type="hidden" name="h1" value="<?php echo $length;?>">
<select>
<?PHP
$dgd= "SELECT * FROM countrytype GROUP BY ID";
$aws= mysql_query($dgd) or die(mysql_error());
while($row=mysql_fetch_array($aws))
{
$des=stripslashes($row['fromcountry']);
$dsw=unserialize($des);
//$des=explode("",$row['fromcountry']);
//var_dump($dsw);
//echo "<td>".$row['ID']."<td>";
//echo "<td>".$dsw."<td>";
$k=1;
foreach($dsw as $key=>$value)
{
echo "<option name='ad[]' value='$value'>$value</option>";
//print_r(array_keys($des));

$k++;

}
}
//$sss=explode("",$row['fromcountry']);
//echo $sss;

?>
</select>
<select>
<?php
$i=0;
$k=1;
foreach($from as $abd => $value)
{

     
     
   echo   "<option name='ar[]' value='$value' >$value</option>";
      $k++;

}

   
?></td></tr></select>

<td>To: </td><td><select>
<?php
foreach($to as $abd => $value)
{
$i++;

   echo "<option id='i' >$value</option>";
   
}


?>
</select>
<input type="submit" name="sub" value="Convert!"/>
</form>
</td>
</tr>


</tr>



</table>

</body>
</html>

serilization works but when i fetch it from database and unserialize it nothing works