/**
* @covers mychaelstyle\storage\providers\Mysql::get
* @depends testPut
*/
public function testGet()
{
$this->object->connect($this->uri, $this->options);
// get contents
$contents = $this->object->get('/tmp.txt');
$this->assertEquals(file_get_contents($this->org_example), $contents);
// to file
$tmp = tempnam(sys_get_temp_dir(), 'tmp_mychaelstyle_storage_mysql_test_');
$result = $this->object->get('/tmp.txt', $tmp);
$this->assertTrue($result);
$this->assertEquals(file_get_contents($this->org_example), file_get_contents($tmp));
// disconnect
$this->object->disconnect();
}
<html>
<body>
<?php
$sql = new Mysql();
if (array_key_exists('code', $_POST)) {
$sql->insertProduct($_POST['code'], $_POST['name'], $_POST['price']);
}
$result = $sql->showProduct();
while ($row = mysqli_fetch_array($result)) {
echo "<br>";
echo $row['code'] . " | " . $row['name'] . " | " . $row['price'];
echo "<br>";
}
$sql->disconnect();
?>
<form action="/index" method="post">
<div>code: <input type='text' name="code" required></div>
<div>name: <input type='text' name="name" required></div>
<div>price: <input type='text' name="price" required></div>
<div><input type="submit" value="Add"></div>
</form>
</body>
</html>
