PHPXRef 0.7 : Drupal 6 (heimberg) : /update_organization

[Summary view] [Print] [Text view]
   1  <?php
   2  
   3  if($_REQUEST[name] != null){
   4  
   5      $requestName = addslashes($_REQUEST[name]);
   6  
   7      $sql = "UPDATE organization SET name = '$requestName'"; 
   8      
   9  
  10      if($_REQUEST[description] == ""){
  11          $sql = $sql . ", description = null ";
  12      } else {
  13          $requestDescription = addslashes($_REQUEST[description]);
  14          $sql = $sql . ", description = '" . $requestDescription . "'";
  15      }
  16  
  17      if($_REQUEST[phone] == ""){
  18          
  19          $sql = $sql . ",phone = null ";
  20      } else {
  21          $requestPhone = addslashes($_REQUEST[phone]);
  22          $sql = $sql . ",phone = '" . $requestPhone . "'";
  23      }
  24  
  25      if($_REQUEST[url] == ""){
  26          $sql = $sql . ",url = null ";
  27      } else {
  28          $requesturl = addslashes($_REQUEST[url]);
  29          $sql = $sql . ",url = '" .$requesturl . "'";
  30      }
  31  
  32          if($_REQUEST[state] == ""){
  33                  $sql = $sql . ",state = null ";
  34          } else {
  35              $requeststate = $_REQUEST[state];
  36                  $sql = $sql . ",state = '" .$requeststate . "'";
  37          }
  38  
  39      if($_REQUEST[categoryList] == ""){
  40          $sql = $sql . ",catId = null";
  41      } else {
  42          $sql = $sql . ",catId = '" . $_REQUEST[categoryList] . "'";
  43      }
  44      $sql = $sql . " where id = " . $_REQUEST[id];
  45  
  46      require_once ('DbLib-12.php');
  47      $db = &new DbLibMySQL;
  48      $db->OpenConnection();
  49      $db->Query($sql);
  50  
  51      $db->Query("Select id from organization WHERE name = '$requestName'");
  52      $db->GetNextRecord();
  53      $id = $db->GetField('id');
  54      $sql = "select name from category where id = $_REQUEST[categoryList]";
  55      $db->Query($sql);
  56      $db->GetNextRecord();
  57      $catName = $db->GetField('name');
  58  
  59      $db->CloseConnection();
  60      $msg = "The organization has been modified.";
  61  } else {
  62      //redirect

  63      header( 'Location: update.php' ) ;
  64  }
  65  ?>
  66  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/content_mgt.dwt" codeOutsideHTMLIsLocked="false" -->
  67  <head>
  68  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  69  <!-- InstanceBeginEditable name="doctitle" -->
  70  <title>Handler for the Modify Organization Form</title>
  71  <META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW">
  72  <!-- InstanceEndEditable -->
  73  <link href="../css/styles_plus_one.css" rel="stylesheet" type="text/css" />
  74  <link href="../css/styles_plus_two.css" rel="stylesheet" type="text/css" />
  75  <link href="../css/styles.css" rel="stylesheet" type="text/css" />
  76  <script src="../Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
  77  <script src="../Scripts/utility.js" type="text/javascript"></script>
  78  
  79  <!-- InstanceBeginEditable name="head" -->
  80          
  81          <meta name="generator" content="Adobe GoLive 5" />
  82          
  83          <meta name="ROBOTS" content="NOINDEX, NOFOLLOW" />
  84      <!-- InstanceEndEditable -->
  85  </head>
  86  
  87  <body>
  88  <div id="wrapper">
  89   <div id="topBar"><a href="../site_search.html">Search</a><a href="../faqs.html">FAQs</a><a href="../sitemap.html">Site Map</a></div> 
  90    <div id="headerBar"><script type="text/javascript">
  91  AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0','width','770','height','120','src','../swf/header2','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','movie','../swf/header2' ); //end AC code

  92  </script><noscript>
  93      <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="770" height="120">
  94        <param name="movie" value="../swf/header2.swf" />
  95        <param name="quality" value="high" />
  96        <embed src="../swf/header2.swf" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="770" height="120"></embed>
  97      </object></noscript>
  98    </div> 
  99    <div id="navBar">
 100        <a href="../index.html" class="menuItem">Home</a>
 101      <a href="../firm/our_firm.html" class="menuItem">Our Firm</a>
 102      <a href="../results/verdicts_settlements.html" class="menuItem">Verdicts &amp; Settlements</a>
 103      <a href="../practices/our_practices.html" class="menuItem">Our Practices</a>
 104      <a href="../attorneys/attorneys_staff.html" class="menuItem">Our Attorneys</a>
 105      <a href="resources.html" class="menuItem">Resources</a>
 106      <a href="../community/community_outreach.html" class="menuItem">Community Outreach</a>
 107      <a href="../contact/contact.html" class="menuItem">Contact Us</a>
 108      
 109      
 110    </div>
 111    
 112    
 113    <div id="mainBody">
 114        <table width="100%" border="0" cellspacing="0" cellpadding="0">
 115    <tr>
 116      <td id="leftNav">
 117          <a href="the_guide.php" class="subNav">THE GUIDE</a>
 118        <br/>
 119        <a href="add_category.php" class="subNav">Add a Category</a>
 120        <a href="delete_category.php" class="subNav">Delete a Category</a>
 121          <a href="update_category_chooser.php" class="subNav">Modify a Category</a>
 122        <br/>
 123          <a href="add_organization.php" class="subNav">Add an Organization</a>
 124        <a href="delete_organization.php" class="subNav">Delete an Organization</a>
 125          <a href="update_organization_chooser.php" class="subNav">Modify an Organization</a>
 126        
 127        </td>
 128      <td id="contentArea">
 129          
 130  
 131      
 132      
 133      <!-- InstanceBeginEditable name="contentRegion" -->
 134          <h1>Modify an Organization</h1>
 135          <p><?php echo $msg ?></p>
 136          <br />Name: <?php echo $_REQUEST[name] ?>
 137          <br />Description: <?php echo $_REQUEST[description] ?>
 138          <br />Phone: <?php echo $_REQUEST[phone] ?>
 139          <br />url: <a href="<?php echo $_REQUEST[url] ?>"><?php echo $_REQUEST[url] ?></a>
 140          <br />State: <?php echo $_REQUEST[state] ?>
 141          <br />Category: <?php echo $catName; ?>
 142  
 143          <p></p>
 144          <p><a href="update_organization.php?organizationList=<?php echo $id;?>">Modify this organization</a></p>
 145      <!-- InstanceEndEditable --></td>
 146    </tr>
 147  </table>
 148  </div>
 149  <div id="addressBar">1801 Century Park East - Suite 1920 - Los Angeles CA 90067 | TEL: (310) 553-1799 | Toll-Free: (800) 425-5557<br />
 150  2700 N. Central Avenue - Suite 1400 - Phoenix AZ 85004 | TEL:  (602) 285-4406 | Toll-Free: (800) 425-5557</div>
 151    <div id="footerBar">
 152      <table width="100%" border="0" cellspacing="0" cellpadding="0">
 153        <tr>
 154          <td style="padding-left:12px">&copy; Copyright 2006 Heimberg Law Group, LLP. &nbsp;All Rights Reserved. </td>
 155          <td align="right" style="padding-right:12px"><a href="../disclaimer.html">Disclaimer</a></td>
 156        </tr>
 157      </table>
 158    </div>
 159  </div>
 160  </body>
 161  <!-- InstanceEnd --></html>
PHP Cross Reference of Drupal 6 (heimberg)

/ -> update_organization_handler.php (source)
