Reply
parse error - i cant see whats wrong...
Old 09-23-2005, 07:10 PM parse error - i cant see whats wrong...
HitRaj47's Avatar
Extreme Talker

Posts: 177
Location: GA
The error I get is:

Quote:
Parse error: parse error, unexpected '}' in /home/sites/peterng.co.uk/public_html/pcgf/admin/members.php on line 127
Line 127 is just a }

PHP Code:
<h2>Manage clan members</h2>

switch ($_GET['members']) {

    case 'add':

    if (isset($_POST['submit_add'])) {    // add member form submitted

        $membername = $_POST['membername'];
        $cssname = $_POST['cssname'];
        $xfire = $_POST['xfire'];
        $about = $_POST['about'];
        $steamid = $_POST['steamid'];
        $group_id = $_POST['group_id'];

        // Connect and select DB
        include ("../includes/dbconn_web14_pcgf_site.php");

        // Define query to insert data
        $sql = "INSERT INTO members (member_id, membername, cssname, xfire, about, steamid, group_id) VALUES (0,
            '$membername',
            '$cssname',
            '$xfire',
            '$about',
            '$steamid',
            '$group_id'";

        // Run the query
        $result = mysql_query($sql);

        // Close DB connection
        mysql_close();

        // print message
        print "<p>The member <strong>$membername</strong> has been added.</p>";

    } else {    // print add form

        >?

        <h3>Add member</h3>

        <p>Please note there must be at LEAST ONE group ebfore you can add a member.</p>

        <form method="post" action="index.php?admin=members&amp;members=add">

        <table>

        <tr>

        <td><strong>Membername</strong></td>
        <td><input type="text" name="membername" /></td>

        </tr>

        <tr>

        <td><strong>CS:S name</strong></td>
        <td><input type="text" name="cssname" /></td>

        </tr>

        <tr>
            
        <td><strong>Xfire username</strong></td>
        <td><input type="text" name="xfire" /></td>

        </tr>

        <tr>

        <td><strong>About</strong></td>
        <td><textarea name="about">Write something about this member... *cough*</textarea></td>

        </tr>

        <tr>

        <td><strong>Steam ID</strong></td>
        <td><input type="text" name="steamid" /></td>

        </tr>

        <tr>
            
        <td><strong>Group</strong></td>
        <td><select name="group_id">

        <?php

        
// Connect and select DB
        
include ("../includes/dbconn_web14_pcgf_site.php");

        
// Define query to get group name's and id's
        
$sql "SELECT groupname, group_id FROM members_groups";
        
        
// Run the qery
        
$result mysql_query($sql);

        while (
$row mysql_fetch_array($result)) {    // print select list

            
?>

            <option value="<?php print $row['group_id'];?>"><?php print $row['groupname'];?></option>

        <?php

        
}    // End WHILE

        // Close DB connection
        
mysql_close();

        
?>

        </select></td>

        </tr>

        </table>

        <p><input type="submit" name="submit_add" value="Add member" /></p>

        </form>

        <?php

    
}    // end IF

    
break;    // End case "add"

    
case 'edit':

    if (isset(
$_POST['submit_edit']) {    // edit form submitted

        
$member_id $_POST['member_id'];
        
$membername $_POST['membername'];
        
$cssname $_POST['cssname'];
        
$xfire $_POST['xfire'];
        
$about $_POST['about'];
        
$steamid $_POST['steamid'];
        
$group_id $_POST['group_id'];

        
// Connect and select DB
        
include ("../includes/dbconn_web14_pcgf_site.php");

        
// Define a query to update the table
        
$sql "UPDATE members SET membername='$membername',
            cssname='$cssname',
            xfire='$xfire',
            about='$about',
            steamid='$steamid',
            group_id='$group_id'
            WHERE member_id='$member_id'"
;

        
// Run the query
        
$result mysql_query($sql);

        
// Close DB connection
        
mysql_close();

        
// print a message
        
print "<p>The member <strong>$membername</strong> was updated.</p>";

    } elseif (isset(
$_GET['member_id']) {    // display edit form

        
$member_id $_GET['member_id'];

        
// connect and select DB
        
include ("../includes/dbconn_web14_pcgf_site.php");

        
// define query to get details
        
$sql "SELECT * FROM members WHERE member_id='$member_id'";

        
// run the query
        
$result mysql_query($sql);

        while (
$row mysql_fetch_array($result)) {    // display form

            
?>

            <h3>Edit member</h3>

            <p>Editing member: <strong><?php print $row['membername'];?></strong></p>

            <form method="post" action="index.php?admin=members&amp;members=edit">

            <input type="hidden" name="member_id" value="<?php print $row['member_id'];?>" />

            <table>

            <tr>

            <td><strong>Membername</strong></td>
            <td><input type="text" name="membername" value="<?php print $row['membername'];?>" /></td>

            </tr>

            <tr>

            <td><strong>CS:S name</strong></td>
            <td><input type="text" name="cssname" value="<?php print $row['cssname'];?>" /></td>

            </tr>

            <tr>

            <td><strong>Xfire username:</strong></td>
            <td><input type="text" name="xfire" value="<?php print $row['xfire'];?>" /></td>

            </tr>

            <tr>

            <td><strong>About</strong></td>
            <td><textarea name="about"><?php print $row['about'];?></textarea></td>

            </tr>

            <tr>

            <td><strong>Steam ID</strong></td>
            <td><input type="text" name="steamid" value="<?php print $row['steamid'];?>" /></td>

            </tr>

            <tr>

            <td><strong>Group</strong></td>
            <td><select name="group_id">

            <?php

            
// Define query to get group names and id's
            
$sql "SELECT groupname, group_id FROM members_groups";

            
// Run the query
            
$result mysql_query($sql);
    
            while (
$members_groups mysql_fetch_array($result)) {    // print group list

                
?>
                
                <option value="<?php print $members_groups['group_id'];?>" if ($members_groups['group_id'] == $row['group_id']) { print "selected=\"selected\""; }?>><?php print $members_groups['groupname'];?></option>

                <?php

            
}    // end WHILE

            
>?

            </
td>

            </
tr>

            </
table>

            <
p><input type="submit" name="submit_edit" value="Edit member" /></p>

        <?
php

        
}    // end WHILE to display form

        // Close DB connection
        
mysql_close();

    }    
// end IF

    
break;    // end case for "edit"

    
case 'delete':

    if (isset(
$_POST['submit_delete'])) {    // delete form submmited

        
$member_id $_POST['member_id'];
        
$membername $_POST['membername'];

        if (
$_POST['submit_delete'] == "Yes") {

            
// Connect and select DB
            
include ("../includes/dbconn_web14_pcgf_site.php");

            
// Define query to delete member
            
$sql "DELETE FROM members WHERE member_id='$member_id' LIMIT 1";

            
// Run the query
            
$result mysql_query($sql);

            
// Print a message
            
print "<p>The member <strong>$membername</strong> was deleted.</p>";

            
// Close DB connection
            
mysql_close();

        } else {

            print 
"<p>The member <strong>$membername</strong> was NOT deleted.</p>";

        }    
// end IF

    
} else {    // display delete form/confirmation

        
$member_id $_GET['member_id'];

        
// connect and select DB
        
include ("../includes/dbconn_web14_pcgf_site.php");

        
// define query to get member name
        
$sql "SELECT membername FROM members WHERE member_id='$member_id'";

        
// run the query
        
$result mysql_query($sql);

        
// assign membername to a variable
        
$membername mysql_result($result0);

        
// Close DB connection
        
mysql_close();

        
?>

        <h3>Delete member?</h3>

        <p>Are you sure you want to delete the member: <strong><?php print $membername;?></strong>?</p>

        <form method="post" action="index.php?admin=members&amp;members=delete">

        <input type="hidden" name="member_id" value="<?php print $member_id;?>" />
        <input type="hidden" name="membername" value="<?php print $membername;?>" />

        <p><input type="submit" name="submit_delete" value="Yes" /> <input type="submit" name="submit_delete" value="No" /></p>

        </form>

    <?php

    
}    // end IF

    
break;    // end case for "delete"

    
default:

    
?>

    <ul>
    <li><a href="index.php?admin=members&amp;members=add">Add member</a></li>
    <li><a href="index.php?admin=groups">Manage member groups</a></li>
    </ul>

    <h3>Members list</h3>

    <table border="1">

    <tr>

    <td><strong>Membername</strong></td>
    <td><strong>Actions</strong></td>

    </tr>

    <?php

    
// Connect and select DB
    
include ("../includes/dbconn_web14_pcgf_site.php");

    
// define query to get member details
    
$sql "SELECT member_id, membername FROM members";
        
    
// run the query
    
$result mysql_query($sql);

    while (
$row mysql_fetch_array($result)) {    // display details

        
?>

        <tr>

        <td><?php print $row['membername'];?></td>
        <td><a href="index.php?admin=members&amp;members=edit&amp;member_id=<?php print $row['member_id'];?>">Edit</a> | <a href="index.php?admin=members&amp;members=delete&amp;member_id=<?php print $row['member_id'];?>">Delete</a></td>

        </tr>

        <?php

    
}    // end WHILE

    
mysql_close();

    
?>

    </table>

    <?php

    
break;    // end default case

}    // end SWITCH
HitRaj47 is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
Old 09-23-2005, 07:58 PM
Average Talker

Posts: 16
right after your first else statement you have a >? that should be ?>

also...

after the first line:

<h2>Manage clan members</h2>

you should have:

<?


and then further down:

} // end WHILE

>?

you have another >? which should be ?>

hope that helps a bit.
__________________
Webmaster Cave
sevster is offline
Reply With Quote
View Public Profile
 
Old 09-23-2005, 08:06 PM
HitRaj47's Avatar
Extreme Talker

Posts: 177
Location: GA
well thanks for notifiying me of those errors, but the original one is still there
HitRaj47 is offline
Reply With Quote
View Public Profile
 
Old 09-23-2005, 08:11 PM
Average Talker

Posts: 16
which } is 127 referring to? the last line? or somewhere in the middle? please identify for us.
__________________
Webmaster Cave
sevster is offline
Reply With Quote
View Public Profile
 
Old 09-25-2005, 10:26 PM
HitRaj47's Avatar
Extreme Talker

Posts: 177
Location: GA
its somewhere in the middle, you can copy and paste the code into notepad (if you dont have an editor that shows line numbers) and use the goto feature to go to line 127. make sure wordwrap is off tho.
HitRaj47 is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to parse error - i cant see whats wrong...
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Webmaster Resources Marketplace:
Software Development Company | Webhosting.UK.com | Text Link Brokers 


   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.13570 seconds with 12 queries