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) _

talk show tell print

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



  <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
  
  <html>
  <head>
      <title>Create New Customer</title>
  <?php
      //get information
      sName = _POST["txtName"];
      sAddress = _POST["txtAddress"];
      sCity = _POST["txtCity"];
      sState = _POST["txtState"];
      sZipCode = _POST["txtZipCode"];
      sPhone = _POST["txtPhone"];
      sEmail = _POST["txtEmail"];
      
      //status message
      sStatus = "";
          
      //database information
      sDBServer = "your.database.server";
      sDBName = "your_db_name";
      sDBUsername = "your_db_username";
      sDBPassword = "your_db_password";
  
      //create the SQL query string
      sSQL = "Insert into Customers(Name,Address,City,State,Zip,Phone,`E-mail`) ".
                " values ('sName','sAddress','sCity','sState', 'sZipCode'".
                ", 'sPhone', 'sEmail')";
  
      oLink = mysql_connect(sDBServer,sDBUsername,sDBPassword);
      @mysql_select_db(sDBName) or sStatus = "Unable to open database";
          
      if(sStatus == ''){
          if(oResult = mysql_query(sSQL)) {
              sStatus = "Added customer; customer ID is ".mysql_insert_id();
           } else {
              sStatus = "An error occurred while inserting; customer not saved.";
          }
      }
  
      mysql_close(oLink);
  ?>
      <script type="text/javascript">
      
          window.onload = function () {
              top.frames["displayFrame"].saveResult("<?php echo sStatus ?>");        
          }
  
      </script>
  </head>
  <body>
  </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) _

(C) Æliens 20/2/2008

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.