Form Action to Database

Hi,

If you want to auto-fill your own database table with a different table structure then you can use the action ‘cptslotsb_process_data’ to intercept the submission and get the data:

add_action( 'cptslotsb_process_data', 'new_appointent', 11, 1 );

function new_appointment($params)
{
// do stuff here,
// $params is an associative array with the booking data
}

Thank you for using the plugin!

add_action( ‘cptslotsb_process_data’, ‘new_appointent’, 11, 1 );
function new_appointment($params){
global $wpdb;
$wpdb->insert(‘testbookinghook’, array(‘id’ => ’22’));
// do stuff here,
// $params is an associative array with the booking data
}

This code is not inserting id = 22 into the database table ‘testbookinghook’.
Can you help me with what is wrong? Can you show some example code?
Note: the table has only one column with no primary key.

• This reply was modified 2 years, 11 months ago by Praveeen Sasikumar.

Also how to display Booking successful message?

Hi,

There may be a query error in that code (ex: missing prefix from table name). Try installing a “query monitor” plugin to easily debug that.

Use the following settings field to indicate the address of the page that contains teh successful booking message:

https://wptimeslot.dwbooster.com/images/articles/thank-you-page.png

Thank you!