How to Display and Update Data?
-
I am Newbie into WP So need some Help for Insert & Update into Default Database of WordPress.
QUERY : 1
I have ‘contactdb’ table into wp_mydb database which is default database. Also Installed the ‘Contact Form 7 Plugin, Contact Form 7 Dynamic Text’
In said table There are some fields in the ‘contactdb’
Field : ContactForm 7 IDs : Database Field Name
(1) Id : “application-id” : app_id
(2) First Name : “first-name” : f_name
(3) Last Name : “last-name” : l_name
(4) Status : “status” : c_status
(2) Remarks : “remarks” : c_remarksNow when I click on Contact Form 7 above details should be inserted into database.
What should I do for It?
add_action(‘wpcf7_before_send_mail’,’save_to_db’);
function save_to_db($cf7) {
//declare your varialbes, for example:
$application_id = $cf7->posted_data[“application-id”];
$fitst_name = $cf7->posted_data[“first-name”];
$last_name = $cf7->posted_data[“last-name”];
$status_txt = $cf7->posted_data[“status”];
$remarks_txt = $cf7->posted_data[“remarks”];$wpdb->insert(‘contactdb’, array( ‘application-id’ => $_POST[“$application_id”], ‘first-name’ => $_POST[“$first_name”], ‘last-name’ => $_POST[“$last_name”], ‘status’ => $_POST[“$status_txt”], ‘remarks’ => $_POST[“$remarks_txt”]), array( ‘%s’, ‘%s’, ‘%s’,’%s’,’%s’ ) )
}
When I click on Submit Page just refresh and Dose not insert anything? Why?
QUERY : 2
How can I update Once I inserted it with above method?
I use Exec-PHP Plugin to Display Code Result onto Page
- The topic ‘How to Display and Update Data?’ is closed to new replies.