Code: Select all
<?php
class MembersTest extends PHPUnit_TestCase {
public function setUp()
{
mysql_connect(localhost,'root','');
mysql_select_db('tblname');
mysql_query("TRUNCATE members");
}
public function TearDown()
{
mysql_close();
}
$newinsertdata=new Members;
$query=mysql_query("INSERT INTO members SET memberTypeId='1', memberFName='testFname', memberLName='testLname', memberAddress='testAddress', memberCity='testCity', memberState='testState', memberZip='123456', memberCountry='India', memberPhone='1234567', memberEmail='test@testmail.com', memberFax='1234567890',enableFlag='true'");
$memberid_insertd=mysql_insert_id();
$resExpectedInsertd=array((string)$memberid_insertd,'1','testFname','testLname','testAddress','testCity','testState','123456','India','1234567','test@testmail.com','1234567890','true');
$query=mysql_query("SELECT * FROM members WHERE memberId=$memberid_insertd");
$resActualInsertd=mysql_fetch_row($query);
$this->assertEquals($resExpectedInsertd,$resActualInsertd, "COULD NOT INSERT DATA.");
?>Code: Select all
mysql_query("TRUNCATE members");