Please help me on this :)

[thili55]

I have the following php code that I call in a flash chat program I have. Basically what I am doing is the user types in a username in my flash program, clicks login and it sends the username to my database. Then there is a logout button, when it is clicked, it will called the '&logout' code. So what I need the logout code to do is delete that username the person was using from the database. Anyone think they can help me out here and point me in the right direction.

This first bit is here only until I get the database stuff working, so right now I have the usernames being sent to a txt file as well as the database.

<?php	
	// remove excess chars and keyboard inputs
	$nick = str_replace ( "\n","", $nickname );
	$nick = str_replace ( "\r","", $nick );
	$nick = str_replace ( "<", "", $nick );
	$nick = str_replace ( ">", "", $nick );
	$nick = stripslashes ( $nick );
	// get the text files
	$login = "login.txt";		
	$fplog= fopen( $login, "a+" );
	$fwlog = fwrite( $fplog, "$nick\n" );
	fclose( $fplog );
?>

&logged=
<?php
	require("settings.php");

@mysql_select_db("$DBName") or die("Unable to select
database $DBName");

$sqlquery = "INSERT INTO $table
VALUES('$id','$nick')";

$results = mysql_query($sqlquery);

mysql_close();

$login = "login.txt";
$tempLogin = file( $login );
$valid = implode( "", $tempLogin );
echo $valid;	
?>

&logout=
<?php
	require("settings.php");

@mysql_select_db("$DBName") or die("Unable to select
database $DBName");

$sqlquery = "DELETE nick FROM $table
WHERE nick = '$nick';";

$results = mysql_query($sqlquery);

mysql_close();	
?>

[thili55]

bump 🙁

[John_Canyon]

$sqlquery = "DELETE nick FROM $table
WHERE nick = '$nick';";

Should read

$sqlquery = "DELETE FROM $table
WHERE nick = '$nick';";

[thili55]

nah ive tried that doesnt work. If I enter a specific username I know is in the database with this code it will work:

$sqlquery = "DELETE nick FROM $table
    WHERE nick = 'test';";

[tsinka]

Hi,

did you try to insert a echo $sqlquery before executing mysql_query ? What does it look like ?

The standard delete query is

"DELETE FROM <table> WHERE". So if you execute DELETE FROM $table WHERE nick='test' with a known nick it should work even without nick between DELETE and FROM.

Additionally, you can remove the ;.

$sqlquery = "DELETE FROM ".$table." WHER nick='".$nick."'";

Just echo the query prior to executing mysql_query to see if it looks ok. Do you get any MySQL errors ?

Regards,
Thomas

[thili55]

&logout= DELETE FROM users WHERE nick=oooooo

thats what is echoed from my logout.php, so the code is right but it just wont delete from my database. It will if I specify which name exactly to delete instead of $nick though.

[kevinsequeira]

shouldnt that be

DELETE FROM users WHERE nick='oooooo' ??

if its a text field you need to enclose it in quotes right ??

try this

$sqlquery = "DELETE nick FROM $table WHERE nick = '".$nick."'";
reg
kevin

[thili55]

Should that &logout= at the beginning of my logout code matter? Cause when I echo it the &logout is included with the sql query. Or does it not effect the query ?

[thili55]

Check out my chat here and see the logout output for your self.

http://www.swgfreak.com/k/chat.swf

login with a username, then click the logout button, it should load up a new window with the sqlquery echoed.

[thili55]

Right on I got it working. Forgot I changed the field name of nick to users in the database. Doh lol. I had the wrong sql query before anyways so your guys help wasn't all a waste 🙂