Errore mysql per effettuare login

**sOoN92** · 20-05-2009, 15:47

ecco il codice...non so proprio come modificarlo...

<?php
include("config.inc.php");
include("header-news.php");
$file = $_SERVER['PHP_SELF'];

$amministrazione = md5("$secret");

function login() {
include("config.inc.php");
global $file;
global $amministrazione;

echo"<form action=$file method=post>
<table border=$table_border bordercolor=$bordercolor cellspacing=$cellspacing cellpadding=$cellpadding bgcolor=$bgcolor>
<td> <font color=$color size=2 face=$face>Login admin.</td>
<tr>
<td> <table border=$table_border2 bordercolor=$bordercolor2 cellspacing=$cellspacing2 cellpadding=$cellpadding2 bgcolor=$bgcolor2>
<td> <font color=$color size=$size face=$face>User:</td>
<td> <input type=text name=user class=input size=20 value=user></td>
<tr>
<td> <font color=$color size=$size face=$face>Password:</td>
<td> <input type=text name=password class=input size=20 value=password></td>
</table>
<tr>
<td> <input type=submit name=submit class=bottone value=Login></td>
</td>

</td></table></form>";

}

if($_POST['submit']) {

if($_POST['user'] && $_POST['password']) {
$query = "SELECT admin_ID FROM admin_news WHERE user = '$_POST[user]' AND password = '$_POST[password]'";
$risultato = mysql_query($query);
$num = mysql_num_rows($risultato);

if($num>0) {
Header("Location: $file?funzione=$amministrazione");
} else {
echo"<script>alert('User e/o password sbagliati');</script>";
}

} else {
echo"<script>alert('Inserisci user e password');</script>";
}
}

function amministrazione() {
include("config.inc.php");
global $file;
global $amministrazione;

$query = "SELECT * FROM notizie";
$ris = mysql_query($query);

$query = "SELECT * FROM notizie";
$res = mysql_query($query);

if($_GET['articolo']) {

$array_spazio = str_replace("_", " ", "$_GET[articolo]");

$query2 = "DELETE FROM notizie WHERE titolo = '$array_spazio'";
$ris2 = mysql_query($query2);
if($ris2) {
Header("Location: $file?funzione=$amministrazione");
}
}

echo"<form action=$file?funzione=$amministrazione name=articoli method=post>
<table border=$table_border bordercolor=$bordercolor cellspacing=$cellspacing cellpadding=$cellpadding bgcolor=$bgcolor>
<td> <font color=$color size=2 face=$face>Inserisci un articolo

↓<input type=submit name=submit2 class=bottone value=Inserisci>↓</td>
<tr>
<td> <table border=$table_border2 bordercolor=$bordercolor2 cellspacing=$cellspacing2 width=100% cellpadding=$cellpadding2 bgcolor=$bgcolor2>
<td> <font color=$color size=$size face=$face>Titolo:</td>
<td> <input type=text name=titolo class=input size=44 maxlenght=120></td>
<tr>
<td></td>
<td><input type=button name=bottone1 onClick=\"insert3('<img src=http://>')\" value=Immagine class=bottone><input type=button name=bottone2 onClick=\"insert4('')\" value=Link class=bottone>
<input type=button name=bottone3 onClick=\"insert5('')\" value=Grassetto class=bottone></td>
<tr>
<td valign=top> <font color=$color size=$size face=$face>Anteprima articolo:</td>
<td> <textarea name=anteprima_articolo rows=6 cols=43 class=input maxlenght=500></textarea></td>
<tr>
<td></td>
<td>
<a href=\"javascript:insert(':smile2:')\"><img src=$url_faccine/smile2.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile3:')\"><img src=$url_faccine/smile3.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile5:')\"><img src=$url_faccine/smile5.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile6:')\"><img src=$url_faccine/smile6.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile9:')\"><img src=$url_faccine/smile9.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile11:')\"><img src=$url_faccine/smile11.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile12:')\"><img src=$url_faccine/smile12.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile15:')\"><img src=$url_faccine/smile15.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile17:')\"><img src=$url_faccine/smile17.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile18:')\"><img src=$url_faccine/smile18.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile19:')\"><img src=$url_faccine/smile19.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile21:')\"><img src=$url_faccine/smile21.gif border=\"0\"></a>
<a href=\"javascript:insert(':smile22:')\"><img src=$url_faccine/smile22.gif border=\"0\"></a>
</td>
<tr>
<td></td>
<td><input type=button name=bottone6 onClick=\"insert6('<img src=http://>')\" value=Immagine class=bottone><input type=button name=bottone7 onClick=\"insert7('')\" value=Link class=bottone>
<input type=button name=bottone8 onClick=\"insert8('')\" value=Grassetto class=bottone></td>
<tr>
<td valign=top> <font color=$color size=$size face=$face>Articolo esteso:</td>
<td> <textarea name=articolo_esteso rows=10 cols=43 class=input></textarea></td>
<tr>
<td></td>
<td>
<a href=\"javascript:insert2(':smile2:')\"><img src=$url_faccine/smile2.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile3:')\"><img src=$url_faccine/smile3.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile5:')\"><img src=$url_faccine/smile5.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile6:')\"><img src=$url_faccine/smile6.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile9:')\"><img src=$url_faccine/smile9.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile11:')\"><img src=$url_faccine/smile11.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile12:')\"><img src=$url_faccine/smile12.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile15:')\"><img src=$url_faccine/smile15.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile17:')\"><img src=$url_faccine/smile17.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile18:')\"><img src=$url_faccine/smile18.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile19:')\"><img src=$url_faccine/smile19.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile21:')\"><img src=$url_faccine/smile21.gif border=\"0\"></a>
<a href=\"javascript:insert2(':smile22:')\"><img src=$url_faccine/smile22.gif border=\"0\"></a>
</td>
</table></td>
<tr>
<td><input type=radio name=icona value=0 checked><img src=$url_icone/thumb_news.png alt=general_news><input type=radio name=icona value=1><img src=$url_icone/thumb_internet.png alt=internet_news>
<input type=radio name=icona value=2><img src=$url_icone/thumb_link.png alt=link_news><input type=radio name=icona value=3><img src=$url_icone/thumb_software.png alt=software_news>
<input type=radio name=icona value=4><img src=$url_icone/thumb_hardware.png alt=hardware_news><input type=radio name=icona value=5><img src=$url_icone/thumb_download.png alt=download_news>
<input type=radio name=icona value=6><img src=$url_icone/thumb_risorse.png alt=risorse_news></form></td>
<tr>
<td><font color=$color size=2 face=$face>Cancella o modifica un articolo</td>
<tr>
<td> <table border=$table_border2 bordercolor=$bordercolor2 cellspacing=$cellspacing2 width=100% cellpadding=$cellpadding2 bgcolor=$bgcolor2>
<td><form name=andrea><center><font color=red size=1 face=$face>Cancella: </font><select name=lista onChange = \"self.location = document.andrea.lista[document.andrea.lista.selectedIndex].value;\">\n
><option selected> ------------------------------------------- </option>"; while($array = mysql_fetch_array($ris)) { $array_tratto = str_replace(" ", "_", "$array[titolo]");
echo"<option value=$file?funzione=$amministrazione&articolo=$ar ray_tratto>$array[titolo]</option>";
}
echo"</select></form>
<form name=and><font color=$color size=1 face=$face>Modifica: </font><select name=listaa onChange = \"self.location = document.and.listaa[document.and.listaa.selectedIndex].value;\">\n
><option selected> ------------------------------------------- </option>"; while($array2 = mysql_fetch_array($res)) { $array_tratto2 = str_replace(" ", "_", "$array2[titolo]");
echo"<option value=$file?funzione=modifica_articolo&articolo=$a rray_tratto2>$array2[titolo]</option>";
}
echo"</select></form></td>
</table></td>
<tr>
<td><form action=$file?funzione=$amministrazione method=post>
<font color=$color size=2 face=$face>Cambia user e password

↓<input type=submit name=submit3 class=bottone value=Cambia>↓</td>
<tr>
<td><table border=$table_border2 bordercolor=$bordercolor2 cellspacing=$cellspacing2 width=100% cellpadding=$cellpadding2 bgcolor=$bgcolor2>
<td align=right><font color=$color size=1 face=$face>User:</td>
<td><input type=text name=nuovo_user class=input size=20></td>
<tr>
<td align=right><font color=$color size=1 face=$face>Password:</td>
<td><input type=text name=nuova_password class=input size=20></td>
</form></table></td>
<tr>
<td></td>
</td></table>";

}

if($_POST['submit2']) {

if($_POST['titolo'] && $_POST['anteprima_articolo']) {

$anteprima = $_POST['anteprima_articolo'];
$esteso = $_POST['articolo_esteso'];

$faccine = array(":smile2:", ":smile3:", ":smile5:", ":smile6:", ":smile9:", ":smile11:", ":smile12:", ":smile15:", ":smile16:", ":smile17:", ":smile18:", ":smile19:", ":smile21:", ":smile22:");
$immagini = array("smile2.gif", "smile3.gif", "smile5.gif", "smile6.gif", "smile9.gif", "smile11.gif", "smile12.gif", "smile15.gif", "smile16.gif", "smile17.gif", "smile18.gif", "smile19.gif", "smile21.gif", "smile22.gif");
for($i = 0; $i < count($faccine); $i++)
$anteprima = str_replace("$faccine[$i]", "<img src=\"../..$meta_url" . $immagini[$i] . "\"></img>", "$anteprima");

$faccine2 = array(":smile2:", ":smile3:", ":smile5:", ":smile6:", ":smile9:", ":smile11:", ":smile12:", ":smile15:", ":smile16:", ":smile17:", ":smile18:", ":smile19:", ":smile21:", ":smile22:");
$immagini2 = array("smile2.gif", "smile3.gif", "smile5.gif", "smile6.gif", "smile9.gif", "smile11.gif", "smile12.gif", "smile15.gif", "smile16.gif", "smile17.gif", "smile18.gif", "smile19.gif", "smile21.gif", "smile22.gif");
for($o = 0; $o < count($faccine2); $o++)
$esteso = str_replace("$faccine2[$o]", "<img src=\"../..$meta_url" . $immagini2[$o] . "\"></img>", "$esteso");

$nome_array = array(
0 => 'ws_news.jpg',
1 => 'internet.jpg',
2 => 'weblinks.jpg',
3 => 'software.jpg',
4 => 'hardware.jpg',
5 => 'downloads.jpg',
6 => 'resources.jpg'
);

$valore_array = $_POST['icona'];
$icone = $nome_array[$valore_array];

qst è solo una parte

Discussione: Errore mysql per effettuare login

Strumenti discussione

Ricerca discussione

Visualizza

Visualizzazione discussione

Permessi di invio