动态网页技术PHP通过参数来生成MYSQL语句类

动态网页技术PHP通过参数来生成MYSQL语句类(3)    $conditions [ 0 ][ " condition " ] = " id='$id' " ;
   $conditions [ 0 ][ " connection " ] = "" ;
  
   $object -> clear_all_assign();
   $object -> setFields( $fields );
   $object -> setTables( $tables );
   $object -> setConditions( $conditions );
  
   if ( ! $object -> getQuerySQL()){ echo $object -> Error; exit ;}
   else { $sql = $object -> Result; echo $sql . " <br> " ;}
  
   echo " <b>Result Generate List with search on all fields</b><br> " ;
   $fields = Array ( " id " , " name " , " address " , " city " );
   $tables = Array ( " customer " );
   $id = 1 ;
   $search = " Fadjar Nurswanto " ;
   $object -> clear_all_assign();
   $object -> setFields( $fields );
   $object -> setTables( $tables );
   $object -> setSearch( $search );
  
   if ( ! $object -> getQuerySQL()){ echo $object -> Error; exit ;}
   else { $sql = $object -> Result; echo $sql . " <br> " ;}
  
   echo " <b>Result Generate List with search on some fields</b><br> " ;
   $fields = Array ( " id " , " name " , " address " , " city " );
   $tables = Array ( " customer " );
   $id = 1 ;
   $search = Array (
   " name " => " Fadjar Nurswanto " ,
   " address " => " Tomang Raya "
   );
  
   $object -> clear_all_assign();
   $object -> setFields( $fields );
   $object -> setTables( $tables );
   $object -> setSearch( $search );
  
   if ( ! $object -> getQuerySQL()){ echo $object -> Error; exit ;}