Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //external db details
- $username = 'user';
- $password = 'pass';
- $database = 'datbase';
- $host = '192.xxx.xxx.xxx';
- //create new wpdb instance
- $mydb = new wpdb($username, $password, $database, $host);
- //limit hook to only fire on particular form ID (optional)
- if ( $cf7->id == 112 ) {
- //get posted form fields
- $field1 = $cf7->posted_data["FName"];
- $field2 = $cf7->posted_data["email-656"];
- $field3 = $cf7->posted_data["TName"];
- $field4 = $cf7->posted_data["Edad"];
- $field5 = $cf7->posted_data["Sucursal"];
- $field6 = $cf7->posted_data["Ciudad"];
- $field7 = $cf7->posted_data["Message"];
- $field8 = date('m/d/Y');
- //insert into external db
- $mydb->insert(
- //name of external db table
- 'Cotizador',
- //name of table columns and which fields to insert
- array(
- 'nombre' => $field1,
- 'telefono' => $field3,
- 'email' => $field2,
- 'edad' => $field4,
- 'ciudad' => $field6,
- 'mensaje' => $field7,
- 'sucursal' => $field5,
- 'fecha' => $field8
- ),
- //field formats: %s = string, %d = integer, %f = float
- array(
- '%s','%s','%s','%s','%s','%s','%s','%s'
- )
- );
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement