{source 0}

setQuery($sql); //$db =& JFactory::getDBO(); //$sql = "INSERT INTO kontakty (email,name,mobile) VALUES ('".$_POST['email']."','".$_POST['name']."','".$_POST['mobile']."')"; //$db->query( $sql ); // Get a db connection. $db = JFactory::getDbo(); // Create a new query object. $query = $db->getQuery(true); // Insert columns. $columns = array('email', 'name', 'mobile'); // Insert values. $values = array($db->quote($_POST['email']),$db->quote($_POST['name']),$db->quote($_POST['mobile'])); // Prepare the insert query. $query ->insert($db->quoteName('kontakty')) ->columns($db->quoteName($columns)) ->values(implode(',', $values)); // Set the query using our newly populated query object and execute it. $db->setQuery($query); $db->execute(); //napojení na CRM $url = 'https://podporovatel.arnika.org/api/form!send'; $fields = array( 'name'=>$_POST['name'], 'email'=>$_POST['email'], 'phone'=>$_POST['mobile'], 'newsletter'=>true, 'topic'=>"2", 'source'=>"POODŘÍ ŽIJE", 'locale'=>"cs", 'confirm'=>"1", 'petition'=>"16", 'redirect'=>"https://poodrizije.cz/?dekujeme=1" ); // build the urlencoded data $postvars = http_build_query($fields); // open connection $ch = curl_init(); // set the url, number of POST vars, POST data curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_POST, count($fields)); curl_setopt($ch, CURLOPT_POSTFIELDS, $postvars); // execute post $result = curl_exec($ch); // print_r($result); // close connection curl_close($ch); $info = "Děkujeme za podporu"; $info="Děkujeme Vám za podporu a budeme Vás pravidelně informovat o aktuálním dění."; } function test_input($data) { $data = trim($data); $data = stripslashes($data); $data = htmlspecialchars($data); return $data; } ?>

{/source}