Documentation for NLS Bibliography Maintenance Functions on bogrex

NLS Bibliography - Maintenance Documentation

Process / program name

* / x_pub_update.php3

Description

This program displays the current publisher information to the user, blank or existing information, for the publisher id number. The user may edit any of the fields and submit the updated information. When the 'submit' button is pressed, the program first deletes all data in the publisher fields associated with the publisher id number in the database, then it inserts the publisher information associated with the publisher id number into the Publisher table from the 'new' values. In this way a new record can be processed the same as an existing one.

Files called / (used) by the program

NameWhat it doesFiles called
top.php3Adds a header to the page. 
bottom.htmlAdds a footer to the page. 
*.php3  

mySQL Statement(s)

  • mysql_query("delete from PUBLISHERS where PUBLISHER_NUMBER=$idnum", $db);
  • mysql_query("insert into PUBLISHERS values ($idnum,'$publisher','$contact','$afil','$street1','$street2','$city','$state','$stateabb','$zip','$country','$phone','$email','$web','$affirm','$recd','$government','$copyright','$duration','$fax')",$db)

    Javascript

    require('top.html');
    require('bottom.html');
    FORM ACTION=\" *.php3\"

    manuals/system/bib-maint/maintenance/d-x_pub_update.php3