topical media & game development

topical media & game development

[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

professional-ajax-02-Hidden-Frame-Examples-GetCustomerData.php / php


  <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  <html>
  <head>
      <title>Get Customer Data</title>
  <?php
      
      //customer ID
       $sID =$ _GET["id"];
      
      //variable to hold customer info
       $sInfo = "";$ //database information
      sDBServer = "your.database.server";
       $sDBName = "your_db_name";$ sDBUsername = "your_db_username";
       $sDBPassword = "your_db_password";$ //create the SQL query string
      sQuery = "Select * from Customers where CustomerId=". $sID;$ //make the database connection
      oLink = mysql_connect( $sDBServer,$ sDBUsername, $sDBPassword);
      @mysql_select_db($ sDBName) or  $sInfo = "Unable to open database";
          
      if($ sInfo == '') {
          if( $oResult = mysql_query($ sQuery) and mysql_num_rows( $oResult) > 0) {$ aValues = mysql_fetch_array( $oResult,MYSQL_ASSOC);$ sInfo =  $aValues['Name']."$ <br />".aValues['Address']."<br />".
                        $aValues['City']."$ <br />".aValues['State']."<br />".
                        $aValues['Zip']."$ <br /><br />Phone: ".aValues['Phone']."<br />".
                       "<a href=\"mailto:".$aValues['E-mail']."\">". $aValues['E-mail']."$ </a>";
          } else {
              sInfo = "Customer with ID  $sID doesn't exist.";
          }
      }
      
      mysql_close($ oLink);
  
  ?>
      
      <script type="text/javascript">
          window.onload = function () {
              var divInfoToReturn = document.getElementById("divInfoToReturn");
              top.frames["displayFrame"].displayCustomerInfo(divInfoToReturn.innerHTML);        
          };
      
      </script>
  
  </head>
  <body>
      <div id="divInfoToReturn"><?php echo  $sInfo ?>$ </div>
  </body>
  </html>

[] readme course(s) preface I 1 2 II 3 4 III 5 6 7 IV 8 9 10 V 11 12 afterthought(s) appendix reference(s) example(s) resource(s) _

You may not copy or print any of this material without explicit permission of the author or the publisher. In case of other copyright issues, contact the author.