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-sql-12-admin-delete-sql.php / php



  #! /usr/bin/php
  <?php
  include '../lib/common.php';
  include '../lib/db.php';
  
  // retrieve list of tables
  table_result = mysql_query('SHOW TABLES', GLOBALS['DB']);
  while (table_row = mysql_fetch_array(table_result))
  {
      // retrieve list of column names in table 
      column_result = mysql_query('SHOW COLUMNS FROM ' . table_row[0],
          GLOBALS['DB']);    
      while (column_row = mysql_fetch_assoc(column_result))
      {
          // if the table has an IS_DELETED field then delete old records
          if (column_row['Field'] == 'IS_DELETED')
          {
              mysql_query('DELETE FROM ' . table_row[0] . ' WHERE ' .
                  'IS_DELETED = 1', GLOBALS['DB']);
  
              // break out to process next table
              mysql_free_result(column_result);
              break;
          }
      }
      mysql_free_result(column_result);
  }
  mysql_free_result(table_result);
  mysql_close(GLOBALS['DB']);
  ?>
[] 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.