Salve a tutti, ho il seguente problema:
Ho un database salvato in localhost tramite il phpMyAdmin e non riesco a modificare le tabelle mediante una pagina php. Ho seguito la guida trovata su html.it, ho modificato leggermente la pagina save.php in questo modo:
Codice PHP:
$db = mysql_connect($db_host, $db_user, $db_password);
or die ("Errore nella connessione. Verificare i parametri nel file config.inc.php");
mysql_select_db($db_name, $db)
or die ("Errore nella selezione del database. Verificare i parametri nel file config.inc.php");
$query = "INSERT INTO pesi (proprietario,dominio,tag,peso) VALUES ('$idutente', 'prova', 's', '$s')";
$query1= "INSERT INTO regola (proprietario,dominio,regola) VALUES ('$idutente', 'prova', '$selectformula')";
if (mysql_query($query, $db))
echo "L'articolo è stato inserito correttamente";
else
echo "Errore durante l'inserimento";
if (mysql_query($query1, $db))
echo "L'articolo è stato inserito correttamente";
else
echo "Errore durante l'inserimento";
mysql_close($db);
e questo codice è richiamato alla pressione di un button su un'altra pagina php il cui form è il seguente:
Codice PHP:
<form name="opzioni" method="post" action="save.php">
[B]Inserisci la formula da utilizzare:[/B]
<select name="selectformula"><option value="javascript:void(0)">Scegli...</option>
<option value="1">Formula lineare</option>
<option value="2">Formula esponenziale</option>
<option value="3">Formula logaritmica</option></select>
[B]Inserisci valore rilevanza (0-100):[/B] <input TYPE="text" name="selectpercentile" /></p>
PROPRIETARIO: <input name="idutente" type="text" /><input name="carica" type="button" value="Carica valori" onClick="caricavalori()"/><input name="default" type="button" value="Predefiniti" onClick="predefiniti()"/>
[b]Inserimento valori tag:[/b]</p>
<table style="width: 100%">
<tr>
<td style="width: 89px">S</td>
<td style="width: 197px"><input name="s" type="text" /></td>
<td style="width: 89px">UL</td>
<td><input name="ul" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">DEL</td>
<td style="width: 197px"><input name="del" type="text" /></td>
<td style="width: 89px">VAR</td>
<td><input name="var" type="text" /></td>
</tr>
<tr>
<td style="width: 89px; height: 26px;">A</td>
<td style="height: 26px; width: 197px"><input name="a" type="text" /></td>
<td style="width: 89px">WBR</td>
<td><input name="wbr" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">SMALL</td>
<td style="width: 197px"><input name="small" type="text" /></td>
<td style="width: 89px">XMP</td>
<td><input name="xmp" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">STRIKE</td>
<td style="width: 197px"><input name="strike" type="text" /></td>
<td style="width: 89px">SERVER</td>
<td><input name="server" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">KBD</td>
<td style="width: 197px"><input name="kbd" type="text" /></td>
<td style="width: 89px">SHADOW</td>
<td><input name="shadow" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">H6</td>
<td style="width: 197px"><input name="h6" type="text" /></td>
<td style="width: 89px">SIDEBAR</td>
<td><input name="sidebar" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">CITE</td>
<td style="width: 197px"><input name="cite" type="text" /></td>
<td style="width: 89px">BODY</td>
<td><input name="body" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">CODE</td>
<td style="width: 197px"><input name="code" type="text" /></td>
<td style="width: 89px">ACRONYM</td>
<td><input name="acronym" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">COL</td>
<td style="width: 197px"><input name="col" type="text" /></td>
<td style="width: 89px">BR</td>
<td><input name="br" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">COLGROUP</td>
<td style="width: 197px"><input name="colgroup" type="text" /></td>
<td style="width: 89px">HTML</td>
<td><input name="html" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">COMMENT</td>
<td style="width: 197px"><input name="comment" type="text" /></td>
<td style="width: 89px">B</td>
<td><input name="b" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">DD</td>
<td style="width: 197px"><input name="dd" type="text" /></td>
<td style="width: 89px">OL</td>
<td><input name="ol" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">H5</td>
<td style="width: 197px"><input name="h5" type="text" /></td>
<td style="width: 89px">DL</td>
<td><input name="dl" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">DEN</td>
<td style="width: 197px"><input name="den" type="text" /></td>
<td style="width: 89px">STRONG</td>
<td><input name="strong" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">DIR</td>
<td style="width: 197px"><input name="dir" type="text" /></td>
<td style="width: 89px">MENU</td>
<td><input name="menu" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">EMBED</td>
<td style="width: 197px"><input name="embed" type="text" /></td>
<td style="width: 89px">MARQUEE</td>
<td><input name="marquee" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">EM</td>
<td style="width: 197px"><input name="em" type="text" /></td>
<td style="width: 89px">H3</td>
<td><input name="h3" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">THEAD</td>
<td style="width: 197px"><input name="thead" type="text" /></td>
<td style="width: 89px">BLINK</td>
<td><input name="blink" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">BUTTON</td>
<td style="width: 197px"><input name="button" type="text" /></td>
<td style="width: 89px">BIG</td>
<td><input name="big" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">TFOOT</td>
<td style="width: 197px"><input name="tfoot" type="text" /></td>
<td style="width: 89px">Q PRE</td>
<td><input name="qpre" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">FIELDSET</td>
<td style="width: 197px"><input name="fieldset" type="text" /></td>
<td style="width: 89px">TH</td>
<td><input name="th" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">FN</td>
<td style="width: 197px"><input name="fn" type="text" /></td>
<td style="width: 89px">TR</td>
<td><input name="tr" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">FONT</td>
<td style="width: 197px"><input name="font" type="text" /></td>
<td style="width: 89px">I</td>
<td><input name="i" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">FRAME</td>
<td style="width: 197px"><input name="frame" type="text" /></td>
<td style="width: 89px">CENTER</td>
<td style="width: 222px"><input name="center" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">FRAMESET</td>
<td style="width: 197px"><input name="frameset" type="text" /></td>
<td style="width: 89px">CAPTION</td>
<td style="width: 222px"><input name="caption" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">TEXTAREA</td>
<td style="width: 197px"><input name="textarea" type="text" /></td>
<td style="width: 89px">FORM</td>
<td style="width: 222px"><input name="form" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">DIV</td>
<td style="width: 197px"><input name="div" type="text" /></td>
<td style="width: 89px">TITLE</td>
<td style="width: 222px"><input name="title" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">ADDRESS</td>
<td style="width: 197px"><input name="address" type="text" /></td>
<td style="width: 89px">H2</td>
<td style="width: 222px"><input name="h2" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">TT</td>
<td style="width: 197px"><input name="tt" type="text" /></td>
<td style="width: 89px">H1</td>
<td style="width: 222px"><input name="h1" type="text" /></td>
</tr>
<tr>
<td style="width: 89px">U</td>
<td style="width: 197px"><input name="u" type="text" /></td>
<td style="width: 89px"></td>
<td style="width: 222px"></td>
</tr>
</table>
<input TYPE="submit" value="Invia" />
<input TYPE="RESET" VALUE="Reimposta Campi" />
</p>
</form>
Praticamente alla pressione del button non succede nulla. Si apre la pagina bianca save.php e non salva i dati sul database. Ho sbagliato qualcosa?
Grazie mille!!