It was suggested I send this to the list. The 'samp_db.inc' file follows this. The
parse error is:
Parse error: parse error in /edit_member.php on line 11
#edit_member.php
?php
include (/users/mike/documents/include_files/samp_db.inc);
define (initial_page, 0);
define (display_entry, 1);
define (update_entry, 2);
function solicit_member_id ()
{
global $PHP_SELF;
printf (FORM METHOD=\post\ ACTION=\%s?action=%d\\n,
$PHP_SELF, DISPLAY_ENTRY);
print (Enter your membership ID number and password,\n);
print (then select submit.\nBRBR\n);
print (TABLE\n);
print (TR);
print (TDMember ID/TDTD);
print (INPUT TYPE=text NAME=\member_id\ size=10BR\n);
print (/TD/TR);
print (TR);
print (TDPassword/TDTD);
print (INPUT TYPE=password NAME=\password\ size=10BR\n);
print (/TD/TR);
print (/TABLE\n);
print (INPUT TYPE=\submit\ NAME=\button\ value=\Submit\\n);
print /FORM\n;
}
function display_entry ()
{
global $PHP_SELF;
global $member_id, $password;
$member_id = trim ($member_id);
if (empty ($member_id))
die (No member ID specified);
if (!ereg (^[0-9]+$, $member_id))
die (Invalid member ID specified (must be a number));
if (empty ($password))
die (No password specified);
if (check_pass ($member_id, $password))
$admin = 0;
else if (check_pass (0, $password))
$admin = 1;
else
die (Invalid password);
$query = SELECT last_name, first_name, suffix, email,
. street, city, state, zip, phone, interests,
. member_id, expiration
. FROM member
. WHERE member_id = $member_id
. ORDER by last_name;
$result = mysql_query ($query)
or die (Cannot execute query);
if (mysql_num_rows ($result) == 0)
die (No user with member_id = $member_id found);
if (mysql_num_rows ($result) 1)
die (More than one user with member_id = $member_id found);
printf (FORM METHOD=\post\ ACTION=\%s?action=%d\\n,
$PHP_SELF, UPDATE_ENTRY);
hidden_field (member_id, $member_id);
hidden_field (password, $password);
print (TABLE\n);
$row = mysql_fetch_array ($result);
display_column (Member ID, $row, member_id, 0);
display_column (Expiration, $row, expiration, $admin);
display_column (Last name, $row, last_name, 1);
display_column (First name, $row, first_name, 1);
display_column (Suffix, $row, suffix, 1);
display_column (Email, $row, email, 1);
display_column (Street, $row, street, 1);
display_column (City, $row, city, 1);
display_column (State, $row, state, 1);
display_column (Zip, $row, zip, 1);
display_column (Phone, $row, phone, 1);
display_column (Interests, $row, interests, 1);
print (/TABLE\n);
print (INPUT TYPE=\submit\ NAME=\button\ value=\ Submit\\n);
print /FORM\n;
}
function check_pass ($id, $pass)
{
$query = Select password from member_pass where member_id = $id;
if (!($result = mysql_query ($query)))
die (Error reading password table);
if (!($row = mysql_fetch_array ($result)))
return (FALSE);
return ($row[password] == $pass);
}
function display_column ($label, $row, $col_name, $editable)
{
print (TR\n);
printf (TD%s/TD\n, htmlspecialchars ($label));
$value = htmlspecialchars ($row[$col_name]);
if ($editable)
{
$str = sprintf (INPUT TYPE=text NAME=\row[%s]\, $col_name);
$str .= sprintf ( VALUE=\%s\ SIZE=\80\\n, $value);
}
else
$str = $value;
printf (TD%s/TD\n, $str);
print (/TR\n);
}
function update_entry ()
{
global $row, $member_id, $password;
$member_id = trim ($member_id);
if (empty ($member_id))
die (No member ID specified);
if (!ereg (^[0-9]+$, $member_id))
die (Invalid member ID specified (must be number));
if (!check_pass ($member_id, $password) !check_pass (0, $password))
die (Invalid password);
$result = mysql_query (select * from member where 1 = 0);
if (!$result)
die (Cannot query member table);
$query = Update member ;
$delim = set ;# put set before first column,, before others
while (list ($col_name, $val) = each ($row))
{
$query .= $delim $col_name =;
$delim = ,;
$val = trim ($val);
if (empty ($val))
{
if (nullable ($result, $col_name))
$query .= NULL;
else
$query .= \\;
}
else
$query .= \ . addslashes ($val) . \;
}
$query .= where member_id = $member_id;
if (mysql_query ($query) mysql_affected_rows () 0)
print (Entry updated successfully.\n);
else
print (Entry not updated.\n);
}
function nullable ($result, $col_name)
{
for ($i = 0; $i mysql_num_fields ($result); $i++)
{
if (!($fld = mysql_fetch_field ($result, $i)))
continue;
if ($fld-name == $col_name)
return (!$fld-not_null);
}
return (0);
}
if (empty ($action))
$action = INITIAL_PAGE;
$title = Historical League member editing form;
html_begin ($title, $title);
samp_db_connect()
or die (Cannot connect to the server);
switch ($action)
{
case initial_page:
solicit_member_id ();
break;
case display_entry:
display_entry ();
break;
case update_entry:
update_entry ();
break;
default:
die (Unknown action code ($action));
}
html_end ();
?
_
#samp_db.inc
?php
function samp_db_connect ()
{
$link = mysql_pconnect (localhost,username,password);
if ($link mysql_select_db (samp_db))
return ($link);
return
