if statement get action error...?
Posted: Sat Dec 18, 2004 6:27 am
Hi, i'm using if statements to carryout an action, depending on the link clicked but i'm getting "Parse error: parse error in /home/sn202/public_html/useradmin.php on line 16" error which is the line "if ($action="show") {" any ideas wot wrong with this...?
PHP Code:
The code i'm using for the links is:
"useradmin.php?action=show"
I'm also using the "if ($action=="...") {" to display required html for that action eg forms etc.
Any help with this will be much appreciated!!!
Regards,
Simon.
PHP Code:
Code: Select all
<?php
$self $_SERVER['PHP_SELF'];
$username = $_POST['username'];
$role = $_POST['role'];
$action = $_GET['action'];
#connect to MYSQL
$conn = @mysql_connect( "linuxproj", "***", "****" )
or die( "could not connect" );
#select the specified database
$rs = @mysql_select_db ( "db_sn202", $conn )
or die( "could not select database" );
$action=(isset($_GET['action']) ? $_GET['action'] : "")
#runs slected PHP function
#show users
if ($action=="show") {
#create the sql query
$sql="select * from users";
#exercute the query
$rs = mysql_query( $sql, $conn )
or die( "could not exercute query: " mysql_error() );
#write data
while( $row = mysql_fetch_array( $rs ) )
{
echo( "ID: " . $row["id"] );
echo( "Username: " . $row["username"];
echo( "role: " . $row["role"] . "<br>");
}
}
#add user
if ($action=="add") {
if( $username and $role ) #ensure values exist
{ #create the sql query
$sql="insert into users (username, role)
values ( $username, "$role" )";
#exercute the query
$rs = mysql_query( $sql, $conn )
or die( "could not exercute query: " mysql_error();
#confirm the added record details
if($rs) { echo( "record added:$username $role" ); }
}
#delete user
if ($action=="delete") {
if( $username ) #ensure values exist
{ #create the sql query
$sql="delete from users where username=$username";
#exercute the query
$rs = mysql_query( $sql, $conn )
or die( "could not exercute query: " mysql_error() );
#confirm the added record details
if($rs) { echo( "record deleted:$username" ); }
}
#update user detailes
if ($action=="update") {
if( $username ) #ensure values exist
{ #create the sql query
$sql="update users set username = $username where username = $oldusername";
#exercute the query
$rs = mysql_query( $sql, $conn )
or die( "could not exercute query" );
$sql="update users set role = $role where username = $username";
#exercute the query
$rs = mysql_query( $sql, $conn )
or die( "could not exercute query: " mysql_error() );
#confirm the added record details
if($rs) { echo( "record updated:$userid $username $role" ); }
}
?>"useradmin.php?action=show"
I'm also using the "if ($action=="...") {" to display required html for that action eg forms etc.
Any help with this will be much appreciated!!!
Regards,
Simon.