Ahh so the \ is escaping the space and not the quote. Good one. On Sat, 19 Jan 2002, Janet Valade wrote: > The problem is on this line. > > print ("<INPUT TYPE=\"submit\" NAME=\"button\" value=\ "Submit\">\n"); > > There is a space between the \ and the " before Submit. > > Janet > > ----- Original Message ----- > From: "Mike C" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Saturday, January 19, 2002 4:02 AM > Subject: [PHP] Re: Does anyone have the 'edit_member.php' script .... > > > > 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.\n<BR><BR>\n"); > > print ("<TABLE>\n"); > > print ("<TR>"); > > print ("<TD>Member ID</TD><TD>"); > > print ("<INPUT TYPE=text NAME=\"member_id\" size=10><BR>\n"); > > print ("</TD></TR>"); > > print ("<TR>"); > > print ("<TD>Password</TD><TD>"); > > print ("<INPUT TYPE=password NAME=\"password\" size=10><BR>\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 (false); > > } > > > > function html_begin ($title, $header) > > { > > print ("<html>\n"); > > print ("<head>\n"); > > > > if ($title) > > > > print ("<title>$title</title>\n"); > > print ("</head>\n"); > > print ("<body>\n"); > > > > if ($header) > > print ("<h2>$header</h2>\n"); > > } > > > > function html_end () > > { > > print ("</body></html>\n"); > > } > > > > ?> > > > > Regards > > Mike > > -- > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]