Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form method="POST" action="http://www.progressivetrade.org/wp-content/themes/zerif-pro/events/csv.php">
- <div class="clear"></div>
- <input class="inp1" type="text" name="add_phone" placeholder="Ваш телефон">
- <div class="clear"></div>
- <input class="inp1" type="text" name="add_sname" placeholder="Имя и Фамилия">
- <div class="clear"></div>
- <input class="inp1" type="text" name="add_email" placeholder="E-mail">
- <div class="clear"></div>
- <button id="btn_info" class="forex_button"> Я участвую</button>
- </form>
- <?php<br>
- CONST HOST = 'localhost'; <br>
- CONST USER = 'u0258277_default';<br>
- CONST PSWD = 'PyE26in8';<br>
- CONST DB = 'u0258277_kaloos';<br>
- $mysqli = new mysqli(HOST, USER, PSWD, DB);<br>
- $mysqli->query("SET NAMES UTF8"); <br>
- $datetime = date("Y-m-d H:i:s");<br>
- $name = $_POST['add_sname'];<br>
- $email = $_POST['add_email'];<br>
- $phone = $_POST['add_phone'];<br>
- $url = $_SERVER['HTTP_REFERER'];<br>
- $user_agent = $_SERVER['HTTP_USER_AGENT']; <br>
- $ip = $_SERVER['REMOTE_ADDR'];<br>
- $query = "INSERT INTO leads (`fsname`,`email`,`phone`,`datetime`, `user-agent`, `ip`,`url`) VALUES($name,$email, $phone , $datetime, $user_agent, $ip, $url)";
- $result = $mysqli->query($query);<br>
- echo $query;<br>
- print_r($_POST);<br>
- ?>
- <script>
- var MyAjax = {"ajaxurl":"http://progressivetrade.org/wp-admin/admin-ajax.php"};
- jQuery.get(MyAjax.ajaxurl, {
- name:name,
- email:email,
- tel:tel,
- },function(data){
- });
- //для неавторизованных пользователей
- add_action( 'wp_ajax_nopriv_test', 'my_ajax_guest_lure');
- //для авторизованных пользователей
- add_action( 'wp_ajax_test', 'my_ajax_guest_lure');
- </script>
- INSERT INTO leads (`fsname`,`email`,`phone`,`datetime`, `user-agent`, `ip`,`url`) VALUES(Валерка Пупкин,email@email.ru, 0961245657 , 2016-12-02 16:22:56, Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.99 Safari/537.36, 176.241.107.18, http://progressivetrade.org/events/)Array ( [add_phone] => 0961245657 [add_sname] => Валерка Пупкин [add_email] => email@email.ru )
- <form method="POST" action="">
- <div class="clear"></div>
- <input class="inp1" type="text" name="add_phone" placeholder="Ваш телефон">
- <div class="clear"></div>
- <input class="inp1" type="text" name="add_sname" placeholder="Имя и Фамилия">
- <div class="clear"></div>
- <input class="inp1" type="text" name="add_email" placeholder="E-mail">
- <div class="clear"></div>
- <button id="btn_info" name="contact-form" class="forex_button"> Я участвую</button>
- </form>
- function theme_form_init() {
- if( ! isset($_POST['contact-form']) ) return false;
- global $wpdb;
- $args = array(
- 'fsname' => isset($_POST['add_sname']) ? esc_attr( trim($_POST['add_sname']) ) : '',
- 'email' => isset($_POST['add_phone']) ? esc_attr( trim($_POST['add_phone']) ) : '',
- 'phone' => isset($_POST['add_email']) ? esc_attr( trim($_POST['add_email']) ) : '',
- 'datetime' => date('Y-m-d H:i:s'),
- 'user-agent' => $_SERVER['HTTP_USER_AGENT'],
- 'ip' => $_SERVER['REMOTE_ADDR'],
- 'url' => $_SERVER['HTTP_REFERER'],
- );
- $result = $wpdb->insert( $wpdb->prefix . 'leads', $args );
- var_dump($result);
- }
- add_action('wp', 'theme_form_init');
- $query = "INSERT INTO leads (`fsname`,`email`,`phone`,`datetime`, `user-agent`, `ip`,`url`) VALUES($name,$email, $phone , $datetime, $user_agent, $ip, $url)";
- $query = 'INSERT INTO leads (`fsname`,`email`,`phone`,`datetime`, `user-agent`, `ip`,`url`) VALUES("'.$name.'","'.$email.'", "'.$phone.'", "'.$datetime.'", "'.$user_agent.'", "'.$ip.'", "'.$url.'")';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement