Advertisement
Guest User

Untitled

a guest
Dec 4th, 2016
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.90 KB | None | 0 0
  1. <form method="POST" action="http://www.progressivetrade.org/wp-content/themes/zerif-pro/events/csv.php">
  2. <div class="clear"></div>
  3. <input class="inp1" type="text" name="add_phone" placeholder="Ваш телефон">
  4. <div class="clear"></div>
  5. <input class="inp1" type="text" name="add_sname" placeholder="Имя и Фамилия">
  6. <div class="clear"></div>
  7. <input class="inp1" type="text" name="add_email" placeholder="E-mail">
  8. <div class="clear"></div>
  9. <button id="btn_info" class="forex_button"> Я участвую</button>
  10. </form>
  11.  
  12. <?php<br>
  13. CONST HOST = 'localhost'; <br>
  14. CONST USER = 'u0258277_default';<br>
  15. CONST PSWD = 'PyE26in8';<br>
  16. CONST DB = 'u0258277_kaloos';<br>
  17.  
  18. $mysqli = new mysqli(HOST, USER, PSWD, DB);<br>
  19. $mysqli->query("SET NAMES UTF8"); <br>
  20. $datetime = date("Y-m-d H:i:s");<br>
  21. $name = $_POST['add_sname'];<br>
  22. $email = $_POST['add_email'];<br>
  23. $phone = $_POST['add_phone'];<br>
  24. $url = $_SERVER['HTTP_REFERER'];<br>
  25. $user_agent = $_SERVER['HTTP_USER_AGENT']; <br>
  26. $ip = $_SERVER['REMOTE_ADDR'];<br>
  27. $query = "INSERT INTO leads (`fsname`,`email`,`phone`,`datetime`, `user-agent`, `ip`,`url`) VALUES($name,$email, $phone , $datetime, $user_agent, $ip, $url)";
  28. $result = $mysqli->query($query);<br>
  29.  
  30. echo $query;<br>
  31. print_r($_POST);<br>
  32. ?>
  33.  
  34. <script>
  35. var MyAjax = {"ajaxurl":"http://progressivetrade.org/wp-admin/admin-ajax.php"};
  36. jQuery.get(MyAjax.ajaxurl, {
  37. name:name,
  38. email:email,
  39. tel:tel,
  40. },function(data){
  41. });
  42.  
  43. //для неавторизованных пользователей
  44. add_action( 'wp_ajax_nopriv_test', 'my_ajax_guest_lure');
  45. //для авторизованных пользователей
  46. add_action( 'wp_ajax_test', 'my_ajax_guest_lure');
  47.  
  48. </script>
  49.  
  50. 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 )
  51.  
  52. <form method="POST" action="">
  53. <div class="clear"></div>
  54. <input class="inp1" type="text" name="add_phone" placeholder="Ваш телефон">
  55. <div class="clear"></div>
  56. <input class="inp1" type="text" name="add_sname" placeholder="Имя и Фамилия">
  57. <div class="clear"></div>
  58. <input class="inp1" type="text" name="add_email" placeholder="E-mail">
  59. <div class="clear"></div>
  60. <button id="btn_info" name="contact-form" class="forex_button"> Я участвую</button>
  61. </form>
  62.  
  63. function theme_form_init() {
  64.  
  65. if( ! isset($_POST['contact-form']) ) return false;
  66.  
  67. global $wpdb;
  68.  
  69. $args = array(
  70. 'fsname' => isset($_POST['add_sname']) ? esc_attr( trim($_POST['add_sname']) ) : '',
  71. 'email' => isset($_POST['add_phone']) ? esc_attr( trim($_POST['add_phone']) ) : '',
  72. 'phone' => isset($_POST['add_email']) ? esc_attr( trim($_POST['add_email']) ) : '',
  73. 'datetime' => date('Y-m-d H:i:s'),
  74. 'user-agent' => $_SERVER['HTTP_USER_AGENT'],
  75. 'ip' => $_SERVER['REMOTE_ADDR'],
  76. 'url' => $_SERVER['HTTP_REFERER'],
  77. );
  78.  
  79. $result = $wpdb->insert( $wpdb->prefix . 'leads', $args );
  80.  
  81. var_dump($result);
  82. }
  83. add_action('wp', 'theme_form_init');
  84.  
  85. $query = "INSERT INTO leads (`fsname`,`email`,`phone`,`datetime`, `user-agent`, `ip`,`url`) VALUES($name,$email, $phone , $datetime, $user_agent, $ip, $url)";
  86.  
  87. $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