Quando eseguo lo script mi compare il seguente errore:Codice PHP:<html>
<head>
<title>Titolo</title>
</head>
<body>
<?php
include ("config.php");
if(isset($_POST['add']))
{
$attributo = intval($_POST['attributo']);
$sql = "INSERT INTO tabella1 "."(Fkattributo) "."VALUES
(".$_POST['attributo'].")";
mysql_select_db('prova');
$retval = mysql_query( $sql, $cn );
if(! $retval )
{
die('Could not enter data: ' . mysql_error());
}
}
else
{
$DBName="prova";
mysql_select_db("$DBName") or die("Impossibile connettersi al database $DBName");
$sqlquery ="SELECT * FROM tabella";
$result = mysql_query($sqlquery);
if (!$sqlquery) {
exit ('<p> Errore mentre recuperavo i dati' . mysql_error() . '</p>');
}
echo "<div id=styled-select> <select name='Attribute'>";
echo "<option value='0'>:: select ::</option>";
while ($value= mysql_fetch_array($result))
{
echo "<option value = ".$value['id'].">".$value['Attribute']."</option>";
}echo "</select> </div><br> ";
mysql_close($cn);
?>
<form method="post" action="<?php $_PHP_SELF ?>">
<br> <br>
<p>
<input name="add" type="submit" id="add" value="Add">
</p>
<br>
</form>
<?php
}
?>
</body>
</html>
Notice: Undefined index: attributo in C:\xampp\htdocs\project\... on line 13
Notice: Undefined index: attributo in C:\xampp\htdocs\project\... on line 17
Could not enter data: Column count doesn't match value count at row 1
Come posso risolvere questo problema? grazie a tutti
Rispondi quotando
Originariamente inviata da Valeria89
