Php > Databases sample source codes

Tired to edit forms this simple script will edit or update ANY MySQL database

Tired to edit forms this simple script will edit or update ANY MySQL database

<?

/* USE : generik.php3?db=BASE&table=TABLE&kn=USED_INDEX_NAME&key=ID_OF_INDEX */ 
<? 
echo "<html><head>       
<STYLE TYPE='text/css'> 
.Legende      { background-color: #CCCCCC; }       
.fond         { background-color: #000000; } 
.Data         { background-color: #EEEEEE; } 
.foot         { background-color: #FFFFFF; } 


P.titre 
{ 
    font-family: helvetica, arial, geneva, sans-serif; 
    color: #003300; 
    font-weight: 800; 
} 
</STYLE> 
<head><body>" ; 
$mysql_link = mysql_connect("localhost", $db, "PUT YOUR PASSWORD HERE "); 
mysql_select_db($db, $mysql_link); 


function BZ_ShowSet ( $row_table_def ,  $data  ) 
{ 
  $field = $row_table_def["Field"]; 
$set = str_replace("set(", "", $row_table_def["Type"]); 
          $set = ereg_replace("\)$", "", $set); 
          $set   = explode (",", $set ) ; 
          for ($vals = explode(",", $data); list($t, $k) = each($vals);) { 
            $vset[$k] = 1; 
          } 
          $size = min(4, count($set)); 
          for ($j=0; $j<count($set);$j++) 
              { 
                 echo "<INPUT TYPE='checkbox' name=$field$j option value='".htmlspecialchars(substr($set[$j], 1, -1))."'"; 
                 if ($vset[substr($set[$j], 1, -1)]) 
                 echo " checked"; 
              echo ">    ".htmlspecialchars(substr($set[$j], 1, -1))." <br> \n"; 
             } 
              
} 


function BZ_ShowEnum ( $row_table_def ,  $data  ) 
{ 
   $field = $row_table_def["Field"]; 
$set = str_replace("enum(", "", $row_table_def["Type"]); 
          $set = ereg_replace("\)$", "", $set); 

    
           $set  =  explode (",", $set ) ; 
          echo "<select name='$field'>\n";           
          echo "<option value=\"\">\n"; 
          for ($j=0; $j<count($set);$j++) 
              { 
              echo '<option value="'.substr($set[$j], 1, -1).'"'; 
              if ($data == substr($set[$j], 1, -1) || ($data == "" && substr($set[$j], 1, -1) == $row_table_def["Default"])) 
                 echo " selected"; 
              echo ">".htmlspecialchars(substr($set[$j], 1, -1))."\n"; 
              } 
          echo "</select>"; 
} 

function  BZ_CalcSet ($setName  ) 
  { 
  $out = 0 ; 
  $bitVal = 1 ; 
  for ( $bit = 0 ; $bit < 64 ; ++$bit ) 
    { 
    $theGlobalName = $setName.$bit ; 
      eval ( "global $"."$theGlobalName ; " )   ; 
    $theString = "$"."thevalue = $".$theGlobalName.";" ; 
     eval ( $theString ); 
    if ( $thevalue ) { $out |= $bitVal  ; }   ; 
    $bitVal<<= 1; 
    } 
return $out ; 
} 
/* START */ 
$table_def = mysql_db_query($db , "SHOW FIELDS FROM $table") ; 
if (isset($action)) 
   { 
   if ( $table_def ) 
     { 
     if( $action =="update" )  $query =" UPDATE    $table SET  " ; 
         if( $action =="write" )  $query =" INSERT into     $table VALUES (  " ; 
          
       $virgule = "" ; 
       for ($i=0;$i<mysql_num_rows($table_def);$i++) 
       { 
       $row_table_def = mysql_fetch_array($table_def); 
       $field = $row_table_def["Field"]; 

         if (  "TIME_UPDT"  == $field    ) 
          { 
         $value = date("Y-m-d H:i:s", time()); 
            $theString  = "$"."$field = '".$value ."';" ; 
            
             
            eval ($theString) ;    
          } 
           
           if ($action =="write" &&  "TIME_CREA"  == $field    ) 
          { 
              
         $value = date("Y-m-d H:i:s", time()); 
            $theString  = "$"."$field = '".$value ."';" ; 
           
            eval ($theString) ;    
                
          } 
           
     
          $theString =  "$"."value = $"."$field ; " ; 

        switch (ereg_replace("\\(.*", "", $row_table_def['Type'])) { 
       case "set": 
              $value =   BZ_CalcSet (  $field) ; 
                 if( $action =="update" )   $query .= "$virgule $field = (($field &0 ) |  $value ) "; 
                     if( $action =="write" )   $query .= "$virgule    $value   "; 

            break; 
       default: 
             eval ( $theString ); 
             $value  = addslashes  ($value ); 
              if( $action =="write" )   $query .= "$virgule  '$value' "; 
              if( $action =="update" )  $query .= "$virgule $field=  '$value' "; 
            break; 
       } 
        $virgule ="," ; 
       } 
     } 
      if( $action =="update" )  $query .= "WHERE ID = '$ID' " ; 
       if( $action =="write" )  $query .=  ")" ; 
        
     if ( mysql_query (  $query ) ) 
             { 
             echo "<h1>Success  </h1>" ; 
             } 
        else 
            { 
            echo "<h1>Wrong query    </h1>" ; 
            } 
     echo  $query  ; 
      
   exit ; 
   } 

if (isset($kn)) 
   { 

   $result = mysql_db_query($db, "SELECT * FROM $table WHERE $kn = '$key' "); 
   $row = mysql_fetch_array($result); 

   } 
else 
   { 
   $result = mysql_db_query($db, "SELECT * FROM $table LIMIT 1"); 
   } 
if (!$table_def) 
   { 
   exit(); 
   } 
else 
   { 
               echo " <tr> <td   class='bar'> "; 
            echo "<p class='titre'> Edit a  ". $table ." record on database ".$db." </p>  </td></tr>  "; 
            echo " <tr> <td   class='fond'>  "; 
   ?> 
   <form method="post" action="generik.php3"> 
   <input type="hidden" name="server" value="<?php echo $server;?>"> 
   <input type="hidden" name="db" value="<?php echo $db;?>"> 
   <input type="hidden" name="table" value="<?php echo $table;?>"> 
   <input type="hidden" name="goto" value="<?php echo $goto;?>"> 
   <?php 
   if ( $key !="" ) 
          { 
          echo '<input type="hidden" name="kn" value="' .  $kn . '">' ; 
          echo '<input type="hidden" name="key" value="' .  $key . '">' ; 
           echo '<input type="hidden" name="action" value="update">' ; 
          } 
     else 
         { 
         echo '<input type="hidden" name="action" value="write">' ; 
         } 
    echo "\n" ; 
       echo "   <table border=0  cellspacing='1' bgcolor='#FFFFF' WIDTH='100%' > " ; 
    echo "\n" ; 
   for ($i=0;$i<mysql_num_rows($table_def);$i++) 
       { 
       $row_table_def = mysql_fetch_array($table_def); 
       $field = $row_table_def["Field"]; 
       $len = mysql_field_len($result,$i); 


     if( !  ereg ("ID" , $field )  ) 
      { 
      echo "<tr><td  class='Legende".$a."'  >  <STRONG> ".  ereg_replace ("_"," ", $field ). " </STRONG>   </td>\n";        
       } 
       switch (ereg_replace("\\(.*", "", $row_table_def['Type'])) 
       { 
       case "set": 
            $type = "set"; 
            break; 
       case "enum": 
            $type = "enum"; 
            break; 
       default: 
            $type = $row_table_def['Type']; 
            break; 
       } 
       if (isset($row) && isset($row[$field])) { 
           $special_chars = htmlspecialchars($row[$field]); 
           $data = $row[$field]; 
        } 
  /********  HERE you have to check for  some condition to    HIDE some fields *****/ 
if( !  ereg ("ID" , $field )  ) 
      { 
       echo "<td class=Data >" ;    
       if (strstr($row_table_def["Type"], "text")) 
          { 
          echo "<textarea name='$field'   ROWS= 6 COLS=32 >$special_chars</txtarea>\n"; 
          } 
       elseif (strstr($row_table_def["Type"], "enum")) 
          { 
           BZ_ShowEnum ( $row_table_def  ,  $data ) ; 
          } 
       elseif (strstr($row_table_def["Type"], "set")) 
          { 
      
          BZ_ShowSet ( $row_table_def  ,  $data ) ; 
          } 
       else 
          { 
          $len = ($len>40)? 40 : $len ; 
          echo "<input type=text name='$field' value=\"".$special_chars."\" size =\"$len\" maxlength=$len>"; 
          } 
           echo "</td></tr>\n"; 
        } 
      else 
          { 
              echo "<input type=hidden name='$field' value=\"".$special_chars."\" >"; 
          } 
       } 
   echo "</table>\n"; 
   } 
echo "  <center> <input type='submit' value='OK'></center> \n </form> \n</td></tr> \n </body>\n<html>" ; 
?>