Codice PHP:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
</head>
<body background="../images/sfondo.jpg">
<p align="right">
<font face="Arno Pro Light Display" size="2">[url="logout.php"]Logout[/url]</font></p>
<p align="center">
[img]../images/ForumSystem.gif[/img]</p>
<form action="alteraprofilopersonale.php" method="post">
<?php
session_start();
$prova=$_SESSION["type"];
if($prova=='Utente'){
$odbc_dns = "db_forum";
$odbc_userid = "";
$odbc_password = "";
$nomeutente = $_GET["nomeutente"];
$query = "SELECT Username
FROM Utente
WHERE Username ='" . $nomeutente . "'" ;
if ( !( $odbc_db = odbc_connect($odbc_dns, $odbc_userid, $odbc_password) ) )
die("Could not connect to ODBC data source $odbc_dns");
if ( !( $odbc_rs = odbc_do($odbc_db, $query) ) )
die("Error executing query $query");
$num_cols = odbc_num_fields($odbc_rs);
if ($num_cols < 1)
die("Query retured an empty set");
while( odbc_fetch_row($odbc_rs) )
{
echo "<TR>";
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TD>";
$utente = odbc_result($odbc_rs, $a);
echo "</TD>";
}
echo "</TR><input type='hidden' name='utente' value='" . $utente . "'>";
}
$query = "SELECT Nome
FROM Utente
WHERE Username ='" . $nomeutente . "'";
if ( !( $odbc_db = odbc_connect($odbc_dns, $odbc_userid, $odbc_password) ) )
die("Could not connect to ODBC data source $odbc_dns");
if ( !( $odbc_rs = odbc_do($odbc_db, $query) ) )
die("Error executing query $query");
$num_cols = odbc_num_fields($odbc_rs);
if ($num_cols < 1)
die("Query retured an empty set");
echo "<TABLE>";
echo("<TR>");
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TH><font face='Rage Italic' size='4' color='#005CB9'>";
echo odbc_field_name($odbc_rs, $a);
echo "</font></TH>";
}
echo "</TR>";
while( odbc_fetch_row($odbc_rs) )
{
echo "<TR>";
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TD>";
$nome = odbc_result($odbc_rs, $a);
echo "</TR><input type='text' name='nome' value='" . $nome . "'></TD>";
}
}
$query = "SELECT Cognome
FROM Utente
WHERE Username ='" . $nomeutente . "'";
if ( !( $odbc_db = odbc_connect($odbc_dns, $odbc_userid, $odbc_password) ) )
die("Could not connect to ODBC data source $odbc_dns");
if ( !( $odbc_rs = odbc_do($odbc_db, $query) ) )
die("Error executing query $query");
$num_cols = odbc_num_fields($odbc_rs);
if ($num_cols < 1)
die("Query retured an empty set");
echo "<TABLE>";
echo("<TR>");
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TH><font face='Rage Italic' size='4' color='#005CB9'>";
echo odbc_field_name($odbc_rs, $a);
echo "</font></TH>";
}
echo "</TR>";
while( odbc_fetch_row($odbc_rs) )
{
echo "<TR>";
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TD>";
$cognome = odbc_result($odbc_rs, $a);
echo "</TR><input type='text' name='cognome' value='" . $cognome . "'></TD>";
}
}
$query = "SELECT Data_di_nascita
FROM Utente
WHERE Username ='" . $nomeutente . "'";
if ( !( $odbc_db = odbc_connect($odbc_dns, $odbc_userid, $odbc_password) ) )
die("Could not connect to ODBC data source $odbc_dns");
if ( !( $odbc_rs = odbc_do($odbc_db, $query) ) )
die("Error executing query $query");
$num_cols = odbc_num_fields($odbc_rs);
if ($num_cols < 1)
die("Query retured an empty set");
echo "<TABLE>";
echo("<TR>");
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TH><font face='Rage Italic' size='4' color='#005CB9'>";
echo odbc_field_name($odbc_rs, $a);
echo "</font></TH>";
}
echo "</TR>";
while( odbc_fetch_row($odbc_rs) )
{
echo "<TR>";
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TD>";
$data = odbc_result($odbc_rs, $a);
echo "</TR><input type='text' name=data' value='" . $data . "'></TD>";
}
}
$query = "SELECT Email
FROM Utente
WHERE Username ='" . $nomeutente . "'";
if ( !( $odbc_db = odbc_connect($odbc_dns, $odbc_userid, $odbc_password) ) )
die("Could not connect to ODBC data source $odbc_dns");
if ( !( $odbc_rs = odbc_do($odbc_db, $query) ) )
die("Error executing query $query");
$num_cols = odbc_num_fields($odbc_rs);
if ($num_cols < 1)
die("Query retured an empty set");
echo "<TABLE>";
echo("<TR>");
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TH><font face='Rage Italic' size='4' color='#005CB9'>";
echo odbc_field_name($odbc_rs, $a);
echo "</font></TH>";
}
echo "</TR>";
while( odbc_fetch_row($odbc_rs) )
{
echo "<TR>";
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TD>";
$email = odbc_result($odbc_rs, $a);
echo "</TR><input type='text' name='email' value='" . $email . "'></TD>";
}
}
$query = "SELECT Città
FROM Utente
WHERE Username ='" . $nomeutente . "'";
if ( !( $odbc_db = odbc_connect($odbc_dns, $odbc_userid, $odbc_password) ) )
die("Could not connect to ODBC data source $odbc_dns");
if ( !( $odbc_rs = odbc_do($odbc_db, $query) ) )
die("Error executing query $query");
$num_cols = odbc_num_fields($odbc_rs);
if ($num_cols < 1)
die("Query retured an empty set");
echo "<TABLE><center>";
echo("<TR>");
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TH><font face='Rage Italic' size='4' color='#005CB9'>";
echo odbc_field_name($odbc_rs, $a);
echo "</TH></font>";
}
echo "</TR>";
while( odbc_fetch_row($odbc_rs) )
{
echo "<TR>";
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TD>";
$città = odbc_result($odbc_rs, $a);
echo "</TD>";
}
echo "</TR><input type='text' name='città' value='" . $città . "'>";
}
echo "</TABLE></center>";
$query = "SELECT Firma
FROM Utente
WHERE Username ='" . $nomeutente . "'";
if ( !( $odbc_db = odbc_connect($odbc_dns, $odbc_userid, $odbc_password) ) )
die("Could not connect to ODBC data source $odbc_dns");
if ( !( $odbc_rs = odbc_do($odbc_db, $query) ) )
die("Error executing query $query");
$num_cols = odbc_num_fields($odbc_rs);
if ($num_cols < 1)
die("Query retured an empty set");
echo "<TABLE>";
echo("<TR>");
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TH><font face='Rage Italic' size='4' color='#005CB9'>";
echo odbc_field_name($odbc_rs, $a);
echo "</font></TH>";
}
echo "</TR>";
while( odbc_fetch_row($odbc_rs) )
{
echo "<TR>";
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TD>";
$firma = odbc_result($odbc_rs, $a);
echo "</TR><input type='text' name='firma' value='" . $firma . "'></TD>";
}
}
$query = "SELECT Avatar
FROM Utente
WHERE Username ='" . $nomeutente . "'";
if ( !( $odbc_db = odbc_connect($odbc_dns, $odbc_userid, $odbc_password) ) )
die("Could not connect to ODBC data source $odbc_dns");
if ( !( $odbc_rs = odbc_do($odbc_db, $query) ) )
die("Error executing query $query");
$num_cols = odbc_num_fields($odbc_rs);
if ($num_cols < 1)
die("Query retured an empty set");
echo "<TABLE>";
echo("<TR>");
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TH><font face='Rage Italic' size='4' color='#005CB9'>";
echo odbc_field_name($odbc_rs, $a);
echo "</font></TH>";
}
echo "</TR>";
while( odbc_fetch_row($odbc_rs) )
{
echo "<TR>";
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TD>";
$avatar = odbc_result($odbc_rs, $a);
echo "</TR><input type='text' name='avatar' value='" . $avatar . "'></TD>";
}
}
$query = "SELECT Tipologia
FROM Utente
WHERE Username ='" . $nomeutente . "'";
if ( !( $odbc_db = odbc_connect($odbc_dns, $odbc_userid, $odbc_password) ) )
die("Could not connect to ODBC data source $odbc_dns");
if ( !( $odbc_rs = odbc_do($odbc_db, $query) ) )
die("Error executing query $query");
$num_cols = odbc_num_fields($odbc_rs);
if ($num_cols < 1)
die("Query retured an empty set");
echo "<TABLE>";
echo("<TR>");
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TH><font face='Rage Italic' size='4' color='#005CB9'>";
echo odbc_field_name($odbc_rs, $a);
echo "</font></TH>";
}
echo "</TR>";
while( odbc_fetch_row($odbc_rs) )
{
echo "<TR>";
for($a = 1; $a <= $num_cols; $a++)
{
echo "<TD>";
$type = odbc_result($odbc_rs, $a);
echo "</TR><input type='text' name='type' value='" . $type . "'></TD>";
}
}
}
?> <input type="submit" name="submit" value="Continua"> </td>
<td width="307">
</tr>
</table></form>
</body>
</html>
dov'è ke non va??? grazie mille
Rispondi quotando