Advertisement
Guest User

Untitled

a guest
Jul 15th, 2017
1,422
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. <?php
  2.  
  3. //external db details
  4. $username = 'user';
  5. $password = 'pass';
  6. $database = 'datbase';
  7. $host = '192.xxx.xxx.xxx';
  8.  
  9. //create new wpdb instance
  10. $mydb = new wpdb($username, $password, $database, $host);
  11.  
  12. //limit hook to only fire on particular form ID (optional)
  13. if ( $cf7->id == 112 ) {
  14.  
  15. //get posted form fields
  16. $field1 = $cf7->posted_data["FName"];
  17. $field2 = $cf7->posted_data["email-656"];
  18. $field3 = $cf7->posted_data["TName"];
  19. $field4 = $cf7->posted_data["Edad"];
  20. $field5 = $cf7->posted_data["Sucursal"];
  21. $field6 = $cf7->posted_data["Ciudad"];
  22. $field7 = $cf7->posted_data["Message"];
  23. $field8 = date('m/d/Y');
  24.  
  25. //insert into external db
  26. $mydb->insert(
  27. //name of external db table
  28. 'Cotizador',
  29. //name of table columns and which fields to insert
  30. array(
  31. 'nombre' => $field1,
  32. 'telefono' => $field3,
  33. 'email' => $field2,
  34. 'edad' => $field4,
  35. 'ciudad' => $field6,
  36. 'mensaje' => $field7,
  37. 'sucursal' => $field5,
  38. 'fecha' => $field8
  39. ),
  40. //field formats: %s = string, %d = integer, %f = float
  41. array(
  42. '%s','%s','%s','%s','%s','%s','%s','%s'
  43. )
  44. );
  45. }
  46. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement