MySQL i brisanje... i jos nesto :)

[ Nemanja Avramović @ 11.02.2005. 17:17 ] @

E, ljudi, 'vako:
Fora je da npr. 10ak kompova imaju server na sebi i kad su online, da to javljaju mom sajtu (sve sam to sredio). Sad je ostao deo oko PHP-a koji treba da vidi da li su racunari u poslednjih 5 minuta online, i ako jesu, da ih includuje (a oni generisu spisak fajlova koji se share-uju), a ako nisu, onda ih brise iz baze... evo celog fajla:

Code:

<?php
include 'connection.php';
$kjuri = "SELECT port,ip,count,lseen FROM $db_table"; //select all entries in database
$broj = 0; //reset number

while ( $row = mysql_fetch_array($query) ) {
$sad = time(); //get current timestamp
$port =  $row["port"]; //get data...
$ip =  $row["ip"];
$count =  $row["count"];
$lseen =  $row["lseen"];

if (($sad - $lseen) < 300) { include 'http://' . $ip . ':' . $port . '/'; } //if pc was online in last 5mins, include it...
else { //...and if wasn't, delete it from table
#delete from list
$sql = "DELETE * FROM $db_table WHERE ip = '$ip'";
mysql_query($sql);
}
//increase number on every step
$broj = $broj + $count;
}
//display
echo "<br><br>There are $broj file(s) available now!";

?>

...samo da napomenem da je u fajlu connection.php definisan $db_table, i da se connection.php konektuje na bazu, i da to lepo radi (jer radi skripta za javljanje da li je online, a ona se konektuje na isti nacin)...

e, da: jel' dobro napisan query za SELECT (gore); treba da selektuje sve iz baze, i jel dobro napisan DELETE?

[ Nemanja Avramović @ 12.02.2005. 12:40 ] @

E, ovako... problem je bio sto nisam kod select poslao mysql_query();, sada sam to uradio i sve radi, osim sto ne brise iz baze kad treba (ELSE).
Query sam promenio u:

Code:

$sql = "DELETE FROM $db_table WHERE id = '$id' LIMIT 1";
mysql_query($sql);

...medjutim, ne brise ga iz baze...

moze mala pomoc samo... samo mi jos ovo trebaaaaaaa! :)

edit: evo celog fajla, mozda Vam bude lakse:

Code:

<?php
include 'connection.php';
$kjuri = "SELECT id,port,ip,count,lseen FROM $db_table"; //select all entries in database
$broj = 0; //reset number

$query = mysql_query($kjuri);

while ( $row = mysql_fetch_array($query) ) {
$sad = time(); //get current timestamp
$port =  $row["port"]; //get data...
$ip =  $row["ip"];
$id =  $row["ip"];
$count =  $row["count"];
$lseen =  $row["lseen"];

$razlika = $sad - $lseen; //test only
echo $razlika; //test only

if (($sad - $lseen) < 300) { include 'http://' . $ip . ':' . $port . '/'; } //if pc was online in last 5mins, include it...
else { //...and if wasn't, delete it from table
#delete from list
$sql = "DELETE FROM $db_table WHERE id = '$id' LIMIT 1";
mysql_query($sql);
}
//increase number on every step
$broj = $broj + $count;
}
//display
echo "<br><br>There are $broj file(s) available now!";
?>

[ Nemanja Avramović @ 12.02.2005. 13:01 ] @

bilo:
$ip = $row["ip"];
$id = $row["ip"];

a treba:
$ip = $row["ip"];
$id = $row["id"];

...tako je to kad samo kopiram red pa `izmenim` vrednosti...