[PHP] pobierz, plaintext 
/* user related parameter */
if ($subsidary == 'wex') {
	define("AUTHTOKEN", "mojtoken");
	}
elseif ($subsidary == 'dub') {
	define("AUTHTOKEN", "mojtoken1");
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
if ($subsidary == 'wex') {
	$query = "replace into rightone_crm.leads (id, firstname, lastname) value ";
}
elseif ($subsidary == 'dub') {
	$query = "replace into rightone_crm.leadsltd (id, firstname, lastname) value ";
}
[PHP] pobierz, plaintext 

[HTML] pobierz, plaintext 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''624745000000780017','Adrian','Adryjanek','1989-09-12','Carey Glass','Glass Work' at line 1
[HTML] pobierz, plaintext 

[HTML] pobierz, plaintext 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1224189000000180007','Ewa Anna','Gwizdon','1961-10-17','St. Gabriels Nursing Ho' at line 1
[HTML] pobierz, plaintext 

[PHP] pobierz, plaintext 
<?php
$subsidary = $_POST['subsidary'];
/* NOTE: Define your mysql database parameters in moduleDependant class */
 
/* Constant Declarations */
define("TARGETURL", "https://crm.zoho.com/crm/private/xml/Leads/getRecords");
 
/* user related parameter */
if ($subsidary == 'wex') {
	define("AUTHTOKEN", "token1");
	}
elseif ($subsidary == 'dub') {
	define("AUTHTOKEN", "token2");
}
 
define("SCOPE", "crmapi");
 
/* create a object */
$utilObj = new Utilities();
 
 
/* set parameters */
$parameter = "";
$parameter = $utilObj->setParameter("scope", SCOPE, $parameter);
$parameter = $utilObj->setParameter("authtoken", AUTHTOKEN, $parameter);
$parameter = $utilObj->setParameter("selectColumns", "Leads(LEADID,First Name,Last Name)", $parameter);
 
/* Call API */
$response = $utilObj->sendCurlRequest(TARGETURL, $parameter);
 
$utilObj->parseXMLandInsertInDB($response);
 
class Utilities {
 
    public function setParameter($key, $value, $parameter) {
        if ($parameter === "" || strlen($parameter) == 0) {
            $parameter = $key . '=' . $value;
        } else {
            $parameter .= '&' . $key . '=' . $value;
        }
        return $parameter;
    }
 
    public function parseXMLandInsertInDB($xmldata) {
        $xmlString = <<<XML
$xmldata 
XML;
        $xml = simplexml_load_string($xmlString);
        if (isset($xml->result)) {
            $modeuleDependantObj = new moduleDependant();
            $output = $modeuleDependantObj->insertInDB($xml);
        } else if (isset($xml->error)) {
            echo "Error code: " . $xml->error->code . "<br/>";
            echo "Error message: " . $xml->error->message;
        }
    }
 
    public function sendCurlRequest($url, $parameter) {
        try {
            /* initialize curl handle */
            $ch = curl_init();
            /* set url to send post request */
            curl_setopt($ch, CURLOPT_URL, $url);
            /* allow redirects */
            curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
            /* return a response into a variable */
            curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
			curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);// Turn off the server and peer verification 
			curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, FALSE); 
            /* times out after 30s */
            curl_setopt($ch, CURLOPT_TIMEOUT, 30);
            /* set POST method */
            curl_setopt($ch, CURLOPT_POST, 1);
            /* add POST fields parameters */
            curl_setopt($ch, CURLOPT_POSTFIELDS, $parameter);
            /* execute the cURL */
            $result = curl_exec($ch);
            curl_close($ch);
            return $result;
        } catch (Exception $exception) {
            echo 'Exception Message: ' . $exception->getMessage() . '<br/>';
            echo 'Exception Trace: ' . $exception->getTraceAsString();
        }
    }
}
class moduleDependant {
    /* Define your mysql database parameters */
 
    private $host = "localhost";
    private $username = "joomla";
    private $password = "joomla";
 
    public function insertInDB($xml) {
        $numberOfRecords = count($xml->result->Leads->row);
        /* $records[row value][field value] */
        $records[][] = array();
        for ($i = 0; $i < $numberOfRecords; $i++) {
            $numberOfValues = count($xml->result->Leads->row[$i]->FL);
            for ($j = 0; $j < $numberOfValues; $j++) {
                switch ((string) $xml->result->Leads->row[$i]->FL[$j]['val']) {
                    /* Get attributes as element indices */
                    case 'LEADID':
                        $records[$i]['LEADID'] = (string) $xml->result->Leads->row[$i]->FL[$j];
                        break;
                    case 'First Name':
                        $records[$i]['First Name'] = (string) $xml->result->Leads->row[$i]->FL[$j];
                        break;
                    case 'Last Name':
                        $records[$i]['Last Name'] = (string) $xml->result->Leads->row[$i]->FL[$j];
                        break;
                }
            }
        }
 
        /* Inserting in database */
        $connection = mysql_connect($this->host, $this->username, $this->password) or die(mysql_error());
		if ($subsidary == 'wex') {
		$query = "replace into rightone_crm.leads (id, firstname, lastname) value ";
		}
		elseif ($subsidary == 'dub') {
		$query = "replace into rightone_crm.leadsltd (id, firstname, lastname) value ";
		}
		for ($k = 0; $k < count($records); $k++) {
            if ($k == 0) {
                $query .= "('" . $records[$k]['LEADID'] . "','" . $records[$k]['First Name'] . "','" . mysql_real_escape_string($records[$k]['Last Name']) . "')";
            }
            if ($k > 0) {
                $query .= ", ('" . $records[$k]['LEADID'] . "','" . $records[$k]['First Name'] . "','" . mysql_real_escape_string($records[$k]['Last Name']) . "')";
            }
        }
        $result = mysql_query($query, $connection) or die(mysql_error());
        if (isset($result) && mysql_affected_rows($connection) == count($records)) {
            echo "Data's are inserted in database successfully.<br/><br/> ";
 
            /* Table structure of inserted data, you can check inserted data by uncommenting a below section */
            /*
              $insertedTable = "<table cellspacing=0 cellpadding='4px' border=1>";
              $insertedTable .= "<tr><td>Lead ID</td><td>First Name</td><td>Last Name</td><td>Company</td></tr>";
              for ($k = 0; $k < count($records); $k++) {
              $insertedTable .= "<tr><td>" . $records[$k]['LEADID'] . "</td><td>" . $records[$k]['First Name'] . "</td><td>" . $records[$k]['Last Name'] . "</td><td>" . $records[$k]['Company'] . "</td></tr>";
              }
              $insertedTable .= "</table>";
              echo $insertedTable;
             */
        } else {
            echo 'Some error while inserting in database';
        }
    }
 
}
?>
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$query = "replace into rightone_crm.leads (id, firstname, lastname, dob, company, occupation, income, spousename, spouselastname, spousedob, spousecompany, spouseoccupation, spouseincome, street, area, city, state, child1name, child1dob, child2name, child2dob, child3name, child3dob, child4name, child4dob) values ";
[PHP] pobierz, plaintext 

[HTML] pobierz, plaintext 
Zapytanie wyglada tak: ('1224189000000180007','Ewa Anna','Gwizdon','1961-10-17','St. Gabriels Nursing Home','Chef','','Maciej Jan','Pawlowski','1970-01-14','Onsite Refeuling','HGV Driver','32400','11 Ballyhoy Avenue','','Raheny, Dublin 5','Dublin','Kacper Pawlowski','1995-02-04','Krystian Pawlowski','2000-07-30','','','',''), ('1224189000000174021','Izabella','Imołczyk','','','','0','','','','','','0','16 Devlin Street','Fermoy','Fermoy','Co.Cork','','','','','','','',''), ('1224189000000174011','Dorota','Malec','1983-03-17','','','','','','1983-01-11','','','','','','Letterkenny','Co. Donegal','Tomek?','2007-02-03','','','','','',''), ('1224189000000174007','Adam','Wickowski','1978-12-24','','','','','','','','','','','','Galway','Co. Galway','','','','','','','',''), ('1224189000000165001','Mariusz','Mariusz','1979-05-07','','Cleaner In Meat Factory','','Partnerka','','','','','','','','','Co. Leitrim','','','','','','','',''), ('1224189000000162093','Krystian','Aleksander','1979-10-18','Burke Shipping Group','HMV Driver','36400','','','','','','','30 Kilmore Avenue','Coolock','Dublin 17','Co.Dublin 17','','','','','','','',''), ('1224189000000158027','Ernest','Luft','','','Welder','','','','','','','','56 Riverwalk','','Dublin','','','','','','','','',''), ('1224189000000157070','AA','Testowy','','','','0','','','','','','0','','','','','','','','','','','',''), ('1224189000000148001','Justyna','Dybas','','','','','','','','','','','','','Dublin','Co.Dublin','','','','','','','',''), ('1224189000000144281','Krzysztof','Reczek','','TKCCC','Garage Owner','0','Agnieszka','','','','','0','51 Burnell Green','Northern Cross','Dublin 17','Dublin','','','','','','','','') A tak wyglada blad:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''1224189000000180007','Ewa Anna','Gwizdon','1961-10-17','St. Gabriels Nursing Ho' at line 1
[HTML] pobierz, plaintext 

[PHP] pobierz, plaintext 
/* Inserting in database */
$connection = mysql_connect($this->host, $this->username, $this->password) or die(mysql_error());
		$query = "replace into rightone_crm.leads (id, firstname, lastname, dob, company, occupation, income, spousename, spouselastname, spousedob, spousecompany, spouseoccupation, spouseincome, street, area, city, state, child1name, child1dob, child2name, child2dob, child3name, child3dob, child4name, child4dob) value ";
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
echo 'To zawiera zmienna:';
var_dump($subsidary);
if ($subsidary == 'wex') {
 
		$query = "replace into rightone_crm.leads (id, firstname, lastname) value ";
 
		}
 
		elseif ($subsidary == 'dub') {
 
		$query = "replace into rightone_crm.leadsltd (id, firstname, lastname) value ";
 
		}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
/* user related parameter */
if ($_POST['subsidary'] == 'wex') {
	define("AUTHTOKEN", "token1");
	}
elseif ($_POST['subsidary'] == 'dub') {
	define("AUTHTOKEN", "token2");
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
if ($_POST['subsidary'] == 'wex') {
		$query = "replace into rightone_crm.leads (id, firstname, lastname, dob, company, occupation, income, spousename, spouselastname, spousedob, spousecompany, spouseoccupation, spouseincome, street, area, city, state, child1name, child1dob, child2name, child2dob, child3name, child3dob, child4name, child4dob) value ";
		}
elseif ($_POST['subsidary'] == 'dub') {
		$query = "replace into rightone_crm.leadsltd (id, firstname, lastname, dob, company, occupation, income, spousename, spouselastname, spousedob, spousecompany, spouseoccupation, spouseincome, street, area, city, state, child1name, child1dob, child2name, child2dob, child3name, child3dob, child4name, child4dob) value ";
		}
[PHP] pobierz, plaintext