You keener!! Eagle eyes!
At 11:00 AM 1/19/2002 -0800, you 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]
