Как Работать С Таблицами В Selenium PHP?

{
   "require":{
      "php":">=7.1",
      "phpunit/phpunit":"^9",
      "phpunit/phpunit-selenium": "*",
      "php-webdriver/webdriver":"1.8.0",
      "symfony/symfony":"4.4",
      "brianium/paratest": "dev-master"
   }
}

composer require

 "[PHP-1] Counting number of rows and columns in WebTable",
      "name" => "[PHP-1] Counting number of rows and columns in WebTable",
      "platform" => "Windows 10",
      "browserName" => "Chrome",
      "version" => "85.0"
    );
    return $capabilities;
  }

  public function setUp(): void
  {
    $url = "https://". $GLOBALS['LT_USERNAME'] .":" . $GLOBALS['LT_APPKEY'] ."@hub.lambdatest.com/wd/hub";
    $capabilities = $this->build_browser_capabilities();
    /* $this->webDriver = RemoteWebDriver::create('http://localhost:4444/wd/hub', $capabilities); */
    $this->webDriver = RemoteWebDriver::create($url, $capabilities);
  }

  public function tearDown(): void
  {
    $this->webDriver->quit();
  }
  /*
  * @test
  */ 
  public function test_SwitchToNewWindow()
  {
    $test_url = "https://www.w3schools.com/html/html_tables.asp";
    $title = "HTML Tables";

    $this->webDriver->get($test_url);
    $this->webDriver->manage()->window()->maximize();
    sleep(5);

    $driver = $this->webDriver;
    $this->webDriver->wait()->until(
      function () use ($driver) {
      $elements = $this->webDriver->findElements(WebDriverBy::className('w3-example'));
          return count($elements) > 0;
      },
      'Error locating W3 example element'
    );

    $num_rows = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr")));
    echo ("\nRows in table are " . $num_rows);

    $num_cols = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr[2]/td")));
    print("\nColumns in table are " . $num_cols);

    $this->assertEquals($title, $this->webDriver->getTitle());
  }
}
?>

use PHPUnit\Framework\TestCase;
use Facebook\WebDriver\Remote\DesiredCapabilities;
use Facebook\WebDriver\Remote\RemoteWebDriver;
use Facebook\WebDriver\WebDriverBy;

$GLOBALS['LT_USERNAME'] = "user-name";
# accessKey:  AccessKey can be generated from automation dashboard or profile section
$GLOBALS['LT_APPKEY'] = "access-key";

public function build_browser_capabilities(){
    /* $capabilities = DesiredCapabilities::chrome(); */
    $capabilities = array(
      "build" => "[PHP-1] Counting number of rows and columns in WebTable",
      "name" => "[PHP-1] Counting number of rows and columns in WebTable",
      "platform" => "Windows 10",
      "browserName" => "Chrome",
      "version" => "85.0"
    );
    return $capabilities;
  }

$this->webDriver = RemoteWebDriver::create($url, $capabilities);

$driver = $this->webDriver;
$this->webDriver->wait()->until(
function () use ($driver) {
      $elements = $this->webDriver->findElements(WebDriverBy::className('w3-example'));
          return count($elements) > 0;
},
'Error locating W3 example element'
);

$num_rows = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr")));
echo ("\nRows in table are " . $num_rows);

$num_cols = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr[2]/td")));
echo("\nColumns in table are " . $num_cols);

vendor\bin\phpunit WebTable_Get_Rows_ColsTest.php

 "[PHP-2] Print the data available in rows and columns",
      "name" => "[PHP-2] Print the data available in rows and columns",
      "platform" => "Windows 10",
      "browserName" => "Chrome",
      "version" => "85.0"
    );
    return $capabilities;
  }

  public function setUp(): void
  {
    $url = "https://". $GLOBALS['LT_USERNAME'] .":" . $GLOBALS['LT_APPKEY'] ."@hub.lambdatest.com/wd/hub";
    $capabilities = $this->build_browser_capabilities();
    $this->webDriver = RemoteWebDriver::create($url, $capabilities);
  }

  public function tearDown(): void
  {
    $this->webDriver->quit();
  }
  /*
  * @test
  */ 
  public function test_SwitchToNewWindow()
  {
    $test_url = "https://www.w3schools.com/html/html_tables.asp";
    $title = "HTML Tables";
    $before_XPath = "//*[@id='customers']/tbody/tr[";
    $aftertd_XPath = "]/td[";
    $aftertr_XPath = "]";

    $this->webDriver->get($test_url);
    $this->webDriver->manage()->window()->maximize();
    sleep(5);

    $driver = $this->webDriver;
    $this->webDriver->wait()->until(
    function () use ($driver) {
        $elements = $this->webDriver->findElements(WebDriverBy::className('w3-example'));
        return count($elements) > 0;
    },
    'Error locating W3 example element'
    );

    $rows = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr")));
    echo ("\nRows in table are " . $rows);

    $columns = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr[2]/td")));
    echo("\nColumns in table are " . $columns);
    echo("\n");
    echo("\n");

    for($t_row = 2; $t_row <= $rows; $t_row++)
    {
        for($t_column = 1; $t_column <= $columns; $t_column++)
        {
            $FinalXPath = $before_XPath .$t_row. $aftertd_XPath .$t_column. $aftertr_XPath;
            $cell = $this->webDriver->findElement(WebDriverBy::xpath($FinalXPath));
            $cell_text = $cell->getText();
            echo($cell_text);
            echo("\n");
        }
        echo("\n");
    }
    $this->assertEquals($title, $this->webDriver->getTitle());
  }
}
?>

$before_XPath = "//*[@id='customers']/tbody/tr[";
$aftertd_XPath = "]/td[";
$aftertr_XPath = "]";

for($t_row = 2; $t_row <= $rows; $t_row++)
{
  for($t_column = 1; $t_column <= $columns; $t_column++) { $FinalXPath = $before_XPath .$t_row. $aftertd_XPath .$t_column. $aftertr_XPath; $cell = $this->webDriver->findElement(WebDriverBy::xpath($FinalXPath));
    $cell_text = $cell->getText();
    echo($cell_text);
    echo(" ");
  }
  echo("\n");
}

"//*[@id='customers']/tbody/tr[" .$t_row. "]/td[" .$t_column. "]"

"//*[@id='customers']/tbody/tr[" .$t_row. "]/td[column_number]"

 "[PHP-3] Read data in the rows of a web table",
      "name" => "[PHP-3] Read data in the rows of a web table",
      "platform" => "Windows 10",
      "browserName" => "Chrome",
      "version" => "85.0"
    );
    return $capabilities;
  }

  public function setUp(): void
  {
    $url = "https://". $GLOBALS['LT_USERNAME'] .":" . $GLOBALS['LT_APPKEY'] ."@hub.lambdatest.com/wd/hub";
    $capabilities = $this->build_browser_capabilities();
    $this->webDriver = RemoteWebDriver::create($url, $capabilities);
  }

  public function tearDown(): void
  {
    $this->webDriver->quit();
  }
  /*
  * @test
  */ 
  public function test_SwitchToNewWindow()
  {
    $test_url = "https://www.w3schools.com/html/html_tables.asp";
    $title = "HTML Tables";
    $before_XPath = "//*[@id='customers']/tbody/tr[";
    $aftertd_XPath_1 = "]/td[1]";
    $aftertd_XPath_2 = "]/td[2]";
    $aftertd_XPath_3 = "]/td[3]";

    $this->webDriver->get($test_url);
    $this->webDriver->manage()->window()->maximize();
    sleep(5);

    $driver = $this->webDriver;
    $this->webDriver->wait()->until(
    function () use ($driver) {
        $elements = $this->webDriver->findElements(WebDriverBy::className('w3-example'));
        return count($elements) > 0;
    },
    'Error locating W3 example element'
    );

    $rows = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr")));
    echo ("\nRows in table are " . $rows);
    echo("\n");

    $cols = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr[2]/td")));
    print("\nColumns in table are " . $cols);
    echo("\n\n");

    $this->assertEquals($title, $this->webDriver->getTitle());

    echo("Data present in Rows, Col - 1\n");
    echo("-----------------------------\n");
    echo("\n");

    for($t_row = 2; $t_row <= ($rows); $t_row++)
    {
        $FinalXPath = $before_XPath .$t_row. $aftertd_XPath_1;
        $cell = $this->webDriver->findElement(WebDriverBy::xpath($FinalXPath));
        $cell_text = $cell->getText();
        echo($cell_text);
        echo("\n");
    }
    echo("\n\n");
    echo("Data present in Rows, Col - 2\n");
    echo("-----------------------------\n");
    echo("\n");

    for($t_row = 2; $t_row <= ($rows); $t_row++)
    {
       $FinalXPath = $before_XPath .$t_row. $aftertd_XPath_2;
        $cell = $this->webDriver->findElement(WebDriverBy::xpath($FinalXPath));
        $cell_text = $cell->getText();
        echo($cell_text);
        echo("\n");
    }

    echo("\n\n");
    echo("Data present in Rows, Col - 3\n");
    echo("-----------------------------\n");
    echo("\n");

    for($t_row = 2; $t_row <= ($rows); $t_row++)
    {
        $FinalXPath = $before_XPath .$t_row. $aftertd_XPath_3;
        $cell = $this->webDriver->findElement(WebDriverBy::xpath($FinalXPath));
        $cell_text = $cell->getText();
        echo($cell_text);
        echo("\n");
    }
    echo("\n\n");
    echo("Fetched all the records from the table\n");   
  }
}
?>

$before_XPath = "//*[@id='customers']/tbody/tr[";
$aftertd_XPath_1 = "]/td[1]";
$aftertd_XPath_2 = "]/td[2]";
$aftertd_XPath_3 = "]/td[3]";

for($t_row = 2; $t_row <= ($rows); $t_row++) { $FinalXPath = $before_XPath .$t_row. $aftertd_XPath_1; $cell = $this->webDriver->findElement(WebDriverBy::xpath($FinalXPath));
    $cell_text = $cell->getText();
    echo($cell_text);
    echo("\n");
}

"//*[@id='customers']/tbody/tr[2]/th[".$t_column. "]"

 "[PHP-4] Read data in the columns of a web table",
      "name" => "[PHP-4] Read data in the columns of a web table",
      "platform" => "Windows 10",
      "browserName" => "Chrome",
      "version" => "85.0"
    );
    return $capabilities;
  }

  public function setUp(): void
  {
    $url = "https://". $GLOBALS['LT_USERNAME'] .":" . $GLOBALS['LT_APPKEY'] ."@hub.lambdatest.com/wd/hub";
    $capabilities = $this->build_browser_capabilities();
    /* $this->webDriver = RemoteWebDriver::create('http://localhost:4444/wd/hub', $capabilities); */
    $this->webDriver = RemoteWebDriver::create($url, $capabilities);
  }

  public function tearDown(): void
  {
    $this->webDriver->quit();
  }
  /*
  * @test
  */ 
  public function test_SwitchToNewWindow()
  {
    $test_url = "https://www.w3schools.com/html/html_tables.asp";
    $title = "HTML Tables";
    $before_XPath_1 = "//*[@id='customers']/tbody/tr[1]/th[";
    $before_XPath_2 = "//*[@id='customers']/tbody/tr[2]/td[";
    $after_XPath = "]";

    $this->webDriver->get($test_url);
    $this->webDriver->manage()->window()->maximize();
    sleep(5);

    $driver = $this->webDriver;
    $this->webDriver->wait()->until(
    function () use ($driver) {
        $elements = $this->webDriver->findElements(WebDriverBy::className('w3-example'));
        return count($elements) > 0;
    },
    'Error locating W3 example element'
    );

    $rows = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr")));
    echo ("Rows in table are " . $rows);

    $columns = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr[2]/td")));
    echo("\nColumns in table are " . $columns);
    echo("\n");
    echo("\n");

    $this->assertEquals($title, $this->webDriver->getTitle());

    echo("\n\n");
    echo("Data present in Col - 1 i.e. Title\n");
    echo("-----------------------------\n");
    echo("\n");

    for($t_col = 1; $t_col <= $columns; $t_col++)
    {
        $FinalXPath = $before_XPath_1 .$t_col. $after_XPath;
        $cell = $this->webDriver->findElement(WebDriverBy::xpath($FinalXPath));
        $cell_text = $cell->getText();
        echo($cell_text);
        echo("\n");
    }

    echo("\n\n");
    echo("Data present in Col - 2\n");
    echo("-----------------------\n");
    echo("\n");

    for($t_col = 1; $t_col <= $columns; $t_col++)
    {
        $FinalXPath = $before_XPath_2 .$t_col. $after_XPath;
        $cell = $this->webDriver->findElement(WebDriverBy::xpath($FinalXPath));
        $cell_text = $cell->getText();
        echo($cell_text);
        echo("\n");
    }   
    echo("\n\n");
    echo("Fetched all the records from the table\n");
  }
}
?>

$before_XPath_1 = "//*[@id='customers']/tbody/tr[1]/th["; 
$before_XPath_2 = "//*[@id='customers']/tbody/tr[2]/td["; 
$after_XPath = "]";

for($t_col = 1; $t_col <= ($columns); $t_col++) 
{ 
$FinalXPath = $before_XPath_1 .$t_col. $after_XPath; 
$cell = $this->webDriver->findElement(WebDriverBy::xpath($FinalXPath)); $cell_text = $cell->getText(); 
echo($cell_text); 
echo("\n"); }

 "[PHP-5] Perform a search for an element in the web table",
      "name" => "[PHP-5] Perform a search for an element in the web table",
      "platform" => "Windows 10",
      "browserName" => "Chrome",
      "version" => "85.0"
    );
    return $capabilities;
  }

  public function setUp(): void
  {
    $url = "https://". $GLOBALS['LT_USERNAME'] .":" . $GLOBALS['LT_APPKEY'] ."@hub.lambdatest.com/wd/hub";
    $capabilities = $this->build_browser_capabilities();
    /* $this->webDriver = RemoteWebDriver::create('http://localhost:4444/wd/hub', $capabilities); */
    $this->webDriver = RemoteWebDriver::create($url, $capabilities);
  }

  public function tearDown(): void
  {
    $this->webDriver->quit();
  }
  /*
  * @test
  */ 
  public function test_SwitchToNewWindow()
  {
    $test_url = "https://www.w3schools.com/html/html_tables.asp";
    $title = "HTML Tables";
    $before_XPath = "//*[@id='customers']/tbody/tr[";
    $aftertd_XPath = "]/td[";
    $aftertr_XPath = "]";
    $search_text = " Magazzini Alimentari Riuniti";

    $this->webDriver->get($test_url);
    $this->assertEquals($title, $this->webDriver->getTitle());
    $this->webDriver->manage()->window()->maximize();
    sleep(5);

    $driver = $this->webDriver;
    $this->webDriver->wait()->until(
    function () use ($driver) {
        $elements = $this->webDriver->findElements(WebDriverBy::className('w3-example'));
        return count($elements) > 0;
    },
    'Error locating W3 example element'
    );

    $rows = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr")));
    echo ("\nRows in table are " . $rows);

    $columns = count ($this->webDriver->findElements(WebDriverBy::xpath("//*[@id='customers']/tbody/tr[2]/td")));
    echo("\nColumns in table are " . $columns);
    echo("\n");
    echo("\n");

    $elem_found = False;

    for($t_row = 2; $t_row <= $rows; $t_row++)
    {
        for($t_column = 1; $t_column <= $columns; $t_column++)
        {
            $FinalXPath = $before_XPath . $t_row . $aftertd_XPath . $t_column . $aftertr_XPath;
            $cell = $this->webDriver->findElement(WebDriverBy::xpath($FinalXPath));
            $cell_text = $cell->getText();
            if ((strcasecmp($cell_text, $search_text)) == 0)
            {
                $concat_str = "Search Text " . $search_text . " is present at row " . $t_row . " and column " . $t_column . " in the table";
                echo($concat_str);
                $elem_found = True;
                break;
            }
        }
    }

    if ($elem_found == False)
    {
        echo("Search Text " . $search_text ." not found");
    }
  }
}
?>

$before_XPath = "//*[@id='customers']/tbody/tr[";
$aftertd_XPath = "]/td[";
$aftertr_XPath = "]";
$search_text = " Magazzini Alimentari Riuniti";

for($t_row = 2; $t_row <= $rows; $t_row++) 
{ 
for($t_column = 1; $t_column <= $columns; $t_column++) { $FinalXPath = $before_XPath . $t_row . $aftertd_XPath . $t_column . $aftertr_XPath; ................................ ................................ } }

$cell = $this->webDriver->findElement(WebDriverBy::xpath($FinalXPath)); $cell_text = $cell->getText();

if ((strcasecmp($cell_text, $search_text)) == 0) 
{ 
$concat_str = "Search Text " . $search_text . " is present at row " . $t_row . " and column " . $t_column . " in the table"; 
echo($concat_str); 
$elem_found = True; 
break; }

if ($elem_found == False) { echo("Search Text " . $search_text ." not found"); }