-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathXeroUser.php
68 lines (48 loc) · 1.39 KB
/
XeroUser.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
<?php
class XeroUser {
//ATTRIBUTES
public $_title = 'User';
public $_pk = 'xeroXUserID'; //our primary key title
protected $_table = 'xerouser'; //MySQL table name
//OUR FIELDS
public $xeroXUserID = ''; //Our primary Key
public $userID = 0;
//XERO Fields
public $XUserID; //Xero's primary key
public $FirstName;
public $LastName;
public $OrganisationRole;
function __construct($dataarray,$userID)
{
// Intitlize all the variable
// print_r($dataarray);
foreach($dataarray->User as $row)
{
$this->XUserID=$row->UserID;
$this->FirstName=$row->FirstName;
$this->LastName=$row->LastName;
$this->OrganisationRole=$row->OrganisationRole;
//echo $this->AccountID."<br> sdfsdsd ";
$this->insert();
}
return true;
}
//CRUD
public function insert(){
$insert = sprintf("INSERT INTO ".$this->_table."
(userID, XUserID, FirstName, LastName ,OrganisationRole)
VALUES
('%d', '%s', '%s', '%s', '%s');",
mysql_real_escape_string($this->userID),
mysql_real_escape_string($this->XUserID),
mysql_real_escape_string($this->FirstName),
mysql_real_escape_string($this->LastName),
mysql_real_escape_string($this->OrganisationRole)
);
$result = mysql_query($insert);
}
/*
Any other utilities you need here
*/
}
?>