/**
* @test
*/
public function findByUidsReturnsCorrectCountForString() {
$uidArray = array();
$uidArray[]=$this->testDatabase>createRecord('tx_powermail_domain_model_forms',array());
$uidArray[]=$this->testDatabase>createRecord('tx_powermail_domain_model_forms',array());
$uidArray[]=$this->testDatabase>createRecord('tx_powermail_domain_model_forms',array());
$uidArray[]=$this->testDatabase>createRecord('tx_powermail_domain_model_forms',array());
$uidArray[]=$this->testDatabase>createRecord('tx_powermail_domain_model_forms',array());
$this->assertSame(5,$this->fixture->findByUids(implode(',',$uidArray))->count());
}
}
createRecord('McCaw', 'Richie', 'RichieMcCaw.jpg', 'Captain', $connection);
createRecord('Vito', 'Victor', 'VictorVitto.jpg', 'Loose Forwards', $connection);
createRecord('Smith', 'Aaron', 'AaronSmith.jpg', 'Halves', $connection);
createRecord('Barrett', 'Beauden', 'BeaudenBarrett.jpg', 'Halves', $connection);
createRecord('Dagg', 'Israel', 'IsraelDagg.jpg', 'Back 3', $connection);
createRecord('Carter', 'Dan', 'DanCarter.jpg', 'Halves', $connection);
createRecord('Jane', 'Cory', 'CoryJane.jpg', 'Back 3', $connection);
createRecord('Woodcock', 'Tony', 'TonyWoodcock.jpg', 'Tight 5', $connection);
createRecord('Perenara', 'TJ', 'TJPerenara.jpg', 'Halves', $connection);
createRecord('Smith', 'Ben', 'BenSmith.jpg', 'Back 3', $connection);
createRecord('Messam', 'Liam', 'LiamMessan.jpg', 'Loose Forwards', $connection);
createRecord('Savea', 'Julian', 'JulianSavea.jpg', 'Back 3', $connection);
createRecord('Coles', 'Dane', 'DaneColes.jpg', 'Tight 5', $connection);
createRecord('Fekitoa', 'Malakai', 'MalakaiFekitoa.jpg', 'Midfield', $connection);
createRecord('Read', 'Kieran', 'KieranReaid.jpg', 'Loose Forwards', $connection);
$selectString = "SELECT * FROM tblPlayer";
$result = mysqli_query($connection, $selectString);
echo "Select all record...<br>";
echo "<table>";
echo "<tr><th>ID</th><th>LastName</th><th>FirstName</th><th>Image</th><th>Position</th></tr>";
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>";
foreach ($row as $index => $value) {
if ($index == 'Image') {
echo "<td><img src = {$value} alt='photo'></td>";
} else {
echo "<td>{$value}</td>";
}
}
echo "</tr>";
$result = mysqli_query($connection, $dropQuery);
$createQuery = "CREATE TABLE tblCountry\n(\n\t\n\tCountryName\t\tVARCHAR(20) NOT NULL,\n\tFlagImage\t\t\tVARCHAR(50) NOT NULL,\n\tCountryCode VARCHAR(3) NOT NULL,\n\n\tPRIMARY KEY(CountryCode)\n\t\n\t\n)";
$result = mysqli_query($connection, $createQuery);
function createRecord($CountryName, $FlagImage, $CountryCode, $connection)
{
$insertQuery = "INSERT into tblCountry (CountryName, FlagImage, CountryCode)\n\t\t\t\t\t\t\tVALUES ('{$CountryName}','{$FlagImage}', '{$CountryCode}')";
$result = mysqli_query($connection, $insertQuery);
if ($result != 1) {
$error = mysqli_error($connection);
}
}
createRecord('New Zealand', 'newzealand.jpg', 'NZL', $connection);
createRecord('Australian', 'australian.jpg', 'AUS', $connection);
createRecord('South Africa', 'southafica.jpg', 'SA', $connection);
createRecord('France', 'france.jpg', 'FFR', $connection);
createRecord('England', 'england.jpg', 'ENG', $connection);
$selectString = "SELECT * FROM tblCountry";
$result = mysqli_query($connection, $selectString);
echo "<table>";
echo "<tr><th>Country Name</th><th>FlagImage</th><th>Country Code</th></tr>";
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>";
foreach ($row as $index => $value) {
if ($index == 'FlagImage') {
echo "<td><img src = {$value} alt='photo'></td>";
} else {
echo "<td>{$value}</td>";
}
}
echo "</tr>";
}
<?php
require 'logic/CoreLogic.php';
loginChek($link);
if (isset($_POST['header'])) {
createRecord($link);
}
$under = getOptions($link);
require 'templates/header.php';
require 'templates/add.php';
require 'templates/footer.php';
