PHP PMA_analyzeWhereClauses函数代码示例

/**
 * Retrieve the values for pma edit mode
 *
 * @param type $where_clause where clauses
 * @param type $table        name of the table
 * @param type $db           name of the database
 *
 * @return type containing insert_mode,whereClauses, result array
 *              where_clauses_array and found_unique_key boolean value
 */
function PMA_getStuffForEditMode($where_clause, $table, $db)
{
    if (isset($where_clause)) {
        $where_clause_array = PMA_getWhereClauseArray($where_clause);
        list($whereClauses, $resultArray, $rowsArray, $found_unique_key) = PMA_analyzeWhereClauses($where_clause_array, $table, $db);
        return array(false, $whereClauses, $resultArray, $rowsArray, $where_clause_array, $found_unique_key);
    } else {
        list($results, $row) = PMA_loadFirstRowInEditMode($table, $db);
        return array(true, null, $results, $row, null, false);
    }
}

/**
 * Function to determine Insert/Edit rows
 *
 * @param string $where_clause where clause
 * @param string $db           current database
 * @param string $table        current table
 *
 * @return mixed
 */
function PMA_determineInsertOrEdit($where_clause, $db, $table)
{
    if (isset($_REQUEST['where_clause'])) {
        $where_clause = $_REQUEST['where_clause'];
    }
    if (isset($_SESSION['edit_next'])) {
        $where_clause = $_SESSION['edit_next'];
        unset($_SESSION['edit_next']);
        $after_insert = 'edit_next';
    }
    if (isset($_REQUEST['ShowFunctionFields'])) {
        $GLOBALS['cfg']['ShowFunctionFields'] = $_REQUEST['ShowFunctionFields'];
    }
    if (isset($_REQUEST['ShowFieldTypesInDataEditView'])) {
        $GLOBALS['cfg']['ShowFieldTypesInDataEditView'] = $_REQUEST['ShowFieldTypesInDataEditView'];
    }
    if (isset($_REQUEST['after_insert'])) {
        $after_insert = $_REQUEST['after_insert'];
    }
    if (isset($where_clause)) {
        // we are editing
        $insert_mode = false;
        $where_clause_array = PMA_getWhereClauseArray($where_clause);
        list($where_clauses, $result, $rows, $found_unique_key) = PMA_analyzeWhereClauses($where_clause_array, $table, $db);
    } else {
        // we are inserting
        $insert_mode = true;
        $where_clause = null;
        list($result, $rows) = PMA_loadFirstRow($table, $db);
        $where_clauses = null;
        $where_clause_array = array();
        $found_unique_key = false;
    }
    // Copying a row - fetched data will be inserted as a new row,
    // therefore the where clause is needless.
    if (isset($_REQUEST['default_action']) && $_REQUEST['default_action'] === 'insert') {
        $where_clause = $where_clauses = null;
    }
    return array($insert_mode, $where_clause, $where_clause_array, $where_clauses, $result, $rows, $found_unique_key, isset($after_insert) ? $after_insert : null);
}

 /**
  * Test for PMA_analyzeWhereClauses
  *
  * @return void
  */
 public function testAnalyzeWhereClause()
 {
     $clauses = array('a=1', 'b="fo\\o"');
     $dbi = $this->getMockBuilder('PMA_DatabaseInterface')->disableOriginalConstructor()->getMock();
     $dbi->expects($this->at(0))->method('query')->with('SELECT * FROM `db`.`table` WHERE a=1;', null, PMA_DatabaseInterface::QUERY_STORE)->will($this->returnValue('result1'));
     $dbi->expects($this->at(3))->method('query')->with('SELECT * FROM `db`.`table` WHERE b="fo\\o";', null, PMA_DatabaseInterface::QUERY_STORE)->will($this->returnValue('result2'));
     $dbi->expects($this->at(1))->method('fetchAssoc')->with('result1')->will($this->returnValue(array('assoc1')));
     $dbi->expects($this->at(4))->method('fetchAssoc')->with('result2')->will($this->returnValue(array('assoc2')));
     $GLOBALS['dbi'] = $dbi;
     $result = PMA_analyzeWhereClauses($clauses, 'table', 'db');
     $this->assertEquals(array(array('a=1', 'b="fo\\\\o"'), array('result1', 'result2'), array(array('assoc1'), array('assoc2')), ''), $result);
 }

 /**
  * Test for PMA_analyzeWhereClauses
  *
  * @return void
  */
 public function testAnalyzeWhereClause()
 {
     $clauses = array('a=1', 'b="fo\\o"');
     $dbi = $this->getMockBuilder('PMA\\libraries\\DatabaseInterface')->disableOriginalConstructor()->getMock();
     $dbi->expects($this->exactly(2))->method('query')->willReturnOnConsecutiveCalls('result1', 'result2');
     $dbi->expects($this->exactly(2))->method('fetchAssoc')->willReturnOnConsecutiveCalls(array('assoc1'), array('assoc2'));
     $GLOBALS['dbi'] = $dbi;
     $result = PMA_analyzeWhereClauses($clauses, 'table', 'db');
     $this->assertEquals(array(array('a=1', 'b="fo\\\\o"'), array('result1', 'result2'), array(array('assoc1'), array('assoc2')), ''), $result);
 }

 */
$analyzed_sql = PMA_Table::analyzeStructure($db, $table);
/**
 * Get the list of the fields of the current table
 */
PMA_DBI_select_db($db);
$table_fields = array_values(PMA_DBI_get_columns($db, $table));
$paramTableDbArray = array($table, $db);
/**
 * Determine what to do, edit or insert? 
 */
if (isset($where_clause)) {
    // we are editing
    $insert_mode = false;
    $where_clause_array = PMA_getWhereClauseArray($where_clause);
    list($where_clauses, $result, $rows, $found_unique_key) = PMA_analyzeWhereClauses($where_clause_array, $table, $db);
} else {
    // we are inserting
    $insert_mode = true;
    $where_clause = null;
    list($result, $rows) = PMA_loadFirstRow($table, $db);
    $where_clauses = null;
    $where_clause_array = null;
    $found_unique_key = false;
}
// Copying a row - fetched data will be inserted as a new row,
// therefore the where clause is needless.
if (isset($_REQUEST['default_action']) && $_REQUEST['default_action'] === 'insert') {
    $where_clause = $where_clauses = null;
}
// retrieve keys into foreign fields, if any