Ciao a tutti,
il seguente script dovrebbe popolare un form attingendo i dati da un record della mia tabella utenti (utilizzando una select sul campo univoco ID) e quindi popolare i campi di testo ed i valori delle select con il risultato dei valori che ho ottenuto dalla query.
In teoria dovrebbe funzionare così....in pratica non funge!
Mi sapreste dare una mano?
Codice PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Modifica scheda utente</title>
<link href="loginmodule.css" rel="stylesheet" type="text/css" />
<style type="text/css">
.auto-style1 {
text-align: center;
}
.auto-style3 {
text-align: center;
color: #FF9900;
font-size: medium;
}
.auto-style2 {
color: #FF9900;
text-align: center;
font-size: small;
}
.auto-style6 {
text-align: left;
}
.auto-style7 {
margin-left: 0px;
}
.auto-style4 {
margin-bottom: 0px;
}
</style>
</head>
<body>
<p class="auto-style1">
[img]RISE_minilogo.jpg[/img][img]sole.jpg[/img]</p>
<p class="auto-style1"></p>
<p class="auto-style1"></p>
<p class="auto-style3">[b]Modifica scheda utente[/b]</p>
<p class="auto-style3">
[url="admin_solel.php"]Homepage[/url] |
[url="member-profile.php"]Profilo personale[/url] | [url="logout.php"]Logout[/url]
</p>
<?php
session_start();
//Include database connection details
require_once('config.php');
//Array to store validation errors
$errmsg_arr = array();
//Validation error flag
$errflag = false;
//Connect to mysql server
$link = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}
//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
die("Unable to select database");
}
echo '
';
echo '
<h1></h1>
';
$qry ="SELECT nome,cognome,sesso,citta,titolo,codfis,reato,giustizia FROM utenti WHERE id='$_GET[id]'";
$result = mysql_query($qry);
$row = mysql_fetch_array($result);
echo '
';
<form action="modify_data.php" method="POST">
<p class="auto-style1"></p>
<p class="auto-style2"></p>
<CENTER><table>
<table align="center" cellpadding="2" cellspacing="0" style="width: 583px; height: 369px;" class="auto-style3">
<tr>
<th style="width: 134px">Nome </th>
<td class="auto-style1">
<input name="nome" type="text" class="textfield" id="nome" value="' . $row['nome'] . '" style="width: 421px" /></td>
</tr>
<tr>
<th style="width: 134px">[b]Cognome[/b] </th>
<td class="auto-style1">
<input name="cognome" type="text" class="textfield" id="cognome" value="' . $row['cognome'] . '" style="width: 424px" /></tr>
<tr>
<th style="width: 134px">Città</th>
<td>
<select name="citta" value="' . $row['citta'] . '">
<option value=""></option>
<option value="Palermo">Palermo</option>
<option value="Catania">Catania</option>
</select>
<tr>
<th style="width: 134px">[b]Titolo di Studio[/b]</th>
<td class="auto-style6">
<select name="titolo" value="' . $row['titolo'] . '" class="auto-style7">
<option value=""></option>
<option value="Licenza elementare">Licenza elementare</option>
<option value="Licenza media">Licenza media</option>
<option value="Diploma">Diploma</option>
<option value="Laurea">Laurea</option>
<option value="Nessuno">Nessuno</option>
</select>
</tr>
<tr>
<td style="width: 134px">[b]Sesso[/b]</td>
<td class="auto-style6">
<select name="sesso" value="' . $row['sesso'] . '">
<option value=""></option>
<option value="Uomo">Uomo</option>
<option value="Donna">Donna</option>
</select></td>
</tr>
<tr>
<td style="width: 134px">[b]Codice Fiscale[/b]</td>
<td class="auto-style1">
<input name="codfis" type="text" class="textfield" id="codfis" value="' . $row['codfis'] . '" style="width: 415px; height: 17px" /></td>
</tr>
<tr>
<td style="width: 134px">[b]Tipologia Reato[/b]</td>
<td>
<select name="reato" value="' . $row['reato'] . '">
<option value=""></option>
<option value="Contro il patrimonio">Contro il patrimonio</option>
<option value="Contro la persona">Contro la persona</option>
<option value="Contro L. 309/90">Contro L. 309/90</option>
<option value="ALTRO">ALTRO</option>
<option value="N.S.">N.S.</option>
</select></td>
</tr>
<tr>
<td style="width: 134px">
[b]Giustizia Adulti[/b]</td>
<td>
<select name="giustizia" value="' . $row['giustizia'] . '">
<option value=""></option>
<option value="Detenuti">Detenuti</option>
<option value="Semiliberi">Semiliberi</option>
<option value="Detenuti domiciliari">Detenuti domiciliari</option>
<option value="Affidati in prova ai s.s.">Affidati in prova ai s.s.</option>
<option value="Ex detenuti">Ex detenuti</option>
<option value="Arresti domiciliari">Arresti domiciliari</option>
<option value="Misure di sicurezza">Misure di sicurezza</option>
<option value="Sospensione pena">Sospensione pena</option>
</select></td>
</tr>
<tr>
<td class="auto-style1" colspan="2">
<input type="submit" name="Modifica" value="Modifica" class="auto-style4" /></td>
<input type="hidden" value="' . $_GET['id'] . '" name="id" />
</tr>
</form>
</table></CENTER>
';
?>
<p class="auto-style1"></p>
<p class="auto-style1"></p>
<p class="auto-style1"> </p>
<p class="auto-style1">
[img]euro.gif[/img]
[img]logo_comune_pa1.jpg[/img]</p>
</body>
</html>
Grazie!!!!
Rispondi quotando