Forums | MacLife

<?php


        $post_values = array_values($_POST);
        $post_keys = array_keys($_POST);
        $post_count = count($_POST);
            
        
        
        for($y=0; $y<$post_count; $y++){
        
            if(is_array($post_values[$y]) && $post_keys[$y] == 'myCheckbox'){
            
                $check_box_array = $post_values[$y];
                        
            }
        
        }
        
            
        $checkbox_count = count($check_box_array);
        
        
        // connect to DB
        $link = mysql_connect('localhost', 'username', 'password');
        
        mysql_select_db('databsename', $link);
        
        // retrieve all table names in DB
        $table_query = mysql_query("SHOW TABLES FROM databsename") or die(mysql_error());
        
        
        while($row = mysql_fetch_array($table_query, MYSQL_ASSOC)){
                    
            mysql_select_db('databsename', $link);
            $field_name_query = mysql_query("SELECT * FROM ".$row['Tables_in_databsename']."") or die(mysql_error());
            $num_fields = mysql_num_fields($field_name_query);
        
                for($z=0; $z<$num_fields; $z++){
                
                    // create FIELD NAME array for each table
                    $field_name_array[] = mysql_field_name($field_name_query, $z);
            
                } // end field name loop for TABLE            
            
            
            // check for regID in FIELD NAME array
            
            if(is_array($field_name_array) && in_array('regID',$field_name_array)){
            
                
                        for($x=0; $x<$checkbox_count; $x++){
                
                        
                                    $regid_sql = "SELECT * FROM ".$row['Tables_in_databsename']." WHERE regid=".$check_box_array[$x]."";
                                    
                                    
                                     
                                    mysql_select_db('databsename', $link);
                                    $regid_query = mysql_query($regid_sql);
                                    $regid_result = mysql_fetch_assoc($regid_query);
                                    $num_regid_results = mysql_num_rows($regid_query);
                                    
                        
                                    
                                    
                                    if($num_regid_results > 0){
                                    
                                        mysql_select_db('databsename', $link);
                                        $delete_regid = "DELETE FROM ".$row['Tables_in_databsename']." WHERE ".$row['Tables_in_databsename'].".regID = ".$regid_result['regID']."";

                                        $delete_regid_query = mysql_query($delete_regid) or die(mysql_error));
                                        
                                    
                                    } // end if            
                                    
                                    
                                    
                        } // end FOR each checkbox value in tablename
                        
                
            } // end if regID in FIELD NAME array
            
            
            
            
            
            unset($field_name_array);
        
        }

        
        
        
        mysql_close($link);
        

        
        
?>