proper use of flush()
Posted: Sat Sep 13, 2003 5:46 pm
after reading up on flush at php.net, i'm still not quite sure how to use it where i want. i figured that i have two choices: play aaround and risk corrupting my db, or posting on this and getting advise from those with more experience, which, with any luck, will allow me to get it right the first time.
i'm trying to get the progress of the deletion to print to the screen as it occurs. here's the function that deletes a user (note, to even see this choice on the "admin page" you have to be a full administrator or the webmaster, and there's a double check in the function itself. all variables not taken from post or cookies or db retrievals, are set in the includes.)
i'm trying to get the progress of the deletion to print to the screen as it occurs. here's the function that deletes a user (note, to even see this choice on the "admin page" you have to be a full administrator or the webmaster, and there's a double check in the function itself. all variables not taken from post or cookies or db retrievals, are set in the includes.)
Code: Select all
function delu(){ # delete a user
include("/home/joshua/includes/fyd.altincs.php"); # includes file (precautionary measure)
$un=$_COOKIE['un']; $pw=$_COOKIE['pw']; $deluser=$_POST['deluser'];
# check for access in the db
$db=mysql_connect($host, $login3, $pass3) or die("cannot access mysql"); # connect to the db
$fyd=mysql_select_db('findyourdesire', $db) or die("cannot access db"); # get the db
$accessfind=mysql_query("SELECT site_access FROM users WHERE username='$un' AND password='$pw'", $db);
$accessret=mysql_fetch_array($accessfind); $sa=$accessret['site_access'];
if(($sa!=$adm)&&($sa!=$wbm)){ error(); } # if not full admin or webmaster, error
else{ # we're authorized to delete
if(isset($_POST['action'])){ # we're gonna delete
$deluser=$_POST['deluser']; $gone=0; $errs='<p>';
$findinfo=mysql_query("SELECT uid,email FROM users WHERE username='$deluser'", $db);
if(mysql_num_rows($findinfo)){ // we found the user
$getinfo=mysql_fetch_array($findinfo); $email=$getinfo['email']; $todel=$getinfo['uid']; $delerr=0;
if($_POST['reason']!=''){ # if there was a reason given for the deletion
$from='Administration_Of_FindYourDesire.com'; $reason=$_POST['reason'];
$message="Your account was terminated. If you join again and continue this behaviour your ISP will be contacted.
Our reason for terminating your account:
$reason";
mail($to, 'Deletion of your Account', $message, $from);
}
echo " <p>Deleting $deluser...\n"; $imgbase=$faup; $npib=$fuup;
foreach($images as $key=>$value){ # for each possible picture
echo " <br />Checking for $value\n"; $pica=$imgbase.$key.$deluser.'.jpg';
$picb=$imgbase.'old.'.$key.$deluser.'.jpg'; $picc=$npib.$key.$deluser.'.jpg';
/* delete the pics if they exist */
if(is_file($pica)){ unlink($pica); echo " <br />Removing $pica\n"; }
if(is_file($picb)){ unlink($picb); echo " <br />Removing $picb\n"; }
if(is_file($picc)){ unlink($picc); echo " <br />Removing $picc\n"; }
}
echo " <br />Deleting of user $deluser from table BIO";
$dfs=mysql_query("DELETE FROM bio WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){ // successful deletion
$gone++; echo " <br />Removed $deluser (user # $todel) from table BIO";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db); $delerr=1;
$errs.="<br />Bio:$errno: $error";
}
echo " <br />Deleting of user $deluser from table COMMENTS";
$dfs=mysql_query("DELETE FROM comments WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table COMMENTS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Comments:$errno: $error";
}
echo " <br />Deleting of user $deluser from table FRIENDS";
$dfs=mysql_query("DELETE FROM friends WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table FRIENDS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Friends:$errno: $error";
}
echo " <br />Deleting of user $deluser from table INTERESTS";
$dfs=mysql_query("DELETE FROM interests WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table INTERESTS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db); $delerr=1;
$errs.="<br />Interests:$errno: $error";
}
echo " <br />Deleting of user $deluser from table MAIL";
$dfs=mysql_query("DELETE FROM mail WHERE to_id='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table MAIL";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Mail:$errno: $error";
}
echo " <br />Deleting of user $deluser from table MSGS";
$dfs=mysql_query("DELETE FROM msgs WHERE to_id='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table MSGS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Msgs:$errno: $error";
}
echo " <br />Deleting of user $deluser from table PESTS";
$dfs=mysql_query("DELETE FROM pests WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table POSTS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Posts:$errno: $error";
}
echo " <br />Deleting of user $deluser from table POSTS";
$dfs=mysql_query("DELETE FROM posts WHERE author='$deluser'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table POSTS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Posts:$errno: $error";
}
echo " <br />Deleting of user $deluser from table STATS";
$dfs=mysql_query("DELETE FROM stats WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table STATS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db); $delerr=1;
$errs.="<br />Stats:$errno: $error";
}
echo " <br />Deleting of user $deluser from table THREADS";
$dfs=mysql_query("DELETE FROM threads WHERE thread_auth='$deluser'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table THREADS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Threads:$errno: $error";
}
echo " <br />Deleting of user $deluser from table TOPS";
$dfs=mysql_query("DELETE FROM tops WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table TOPS";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Tops:$errno: $error";
}
echo " <br />Deleting of user $deluser from table VOTES";
$dfs=mysql_query("DELETE FROM votes WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
$gone++; echo " <br />Removed $deluser (user # $todel) from table VOTES";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db);
$errs.="<br />Votes:$errno: $error";
}
$errs.='</p>';
if(!($delerr)){ # stats,bio,interests did not result in an error (may be expanded to more)
echo " <br />Deleting of user $deluser from table USERS";
$dfs=mysql_query("DELETE FROM users WHERE uid='$todel'", $db);
if(mysql_affected_rows($db)==1){
echo " <br />Deletion of user $deluser complete.</p>\n$errs";
}else{ // error
$errno=mysql_errno($db); $error=mysql_error($db); $delerr=1;
echo "<br />Users:$errno: $error</p>\n$errs";
}
}else{ // something is wrong
echo " <br />Deletion of user $deluser encountered errors. uid=$todel username=$deluser";
echo " </p>\n$errs";
}
}else{ // we made a mistake
$errno=mysql_errno($db); $error=mysql_error($db); // what's wrong
$err="<p>query: SELECT uid,email FROM users WHERE username='$deluser'<br />$errno:$error</p>";
echo $err; // tell admin what went wrong
}
}
echo <<<END
<form action="$_SERVER[PHP_SELF]" method="POST" style="margin:0">
<input type="hidden" name="fn" value="delu">
<input type="hidden" name="action" value="delete">
$tsnw
<tr><td><u>User Name</u></td><td><u>Reason</u></td><td>User Deletion</td></tr>
<tr>
<td><input type="text" name="deluser" size="15" maxlength="15"></td>
<td><input type="text" name="reason" size="15"></td>
<td><input type="submit" value="Delete!"></td>
</tr>
</table>
</form>
</center>
</body>
</html>
END;
}
}