SQL & Database
£20-250 GBP
Πληρώθηκε κατά την παράδοση
I am looking for a developer who can create me the following query using hooks to insert data into a new table in mysql.
Due to schema of the tables which formidablepro stores its data, i am finding it difficult to pull a query to get the desired result.
So either i need someone to build me a query or use the available hooks to insert the data submitted by the forms into a new table with all of its fields in a column structure. (possibly a pivot but not sure how that would work)
I can use the following example to do this but i need all hooks as follows to insert, update and duplicate if needed.
[login to view URL]
add_action('frm_after_create_entry', 'copy_into_my_table', 20, 2);
function copy_into_my_table($entry_id, $form_id){
if($form_id == 4){ //change 4 to the form id of the form to copy
global $wpdb;
$values = array('col_name1' => $_POST['item_meta'][25], 'col_name2' => $_POST['item_meta'][26]);
//replace 25 and 26 with the field ids of the Formidable form. Change col_name to the column names in your table
$wpdb->insert('table_name', $values);
}
}
add_action('frm_after_update_entry', 'copy_into_my_table', 20, 2);
frm_after_duplicate_entry
I need it to check to ensure the table has been created also before insert/update/duplicate
Thanks Chris
Ταυτότητα Εργασίας: #17112763
Σχετικά με την εργασία
Ανατέθηκε στον:
17 freelancers κάνουν προσφορές κατά μέσο όρο £174 για αυτή τη δουλειά
Hi there! I have good skills and strong experience with HTML, CSS, Javascript, MySQL, PHP for over 10 years. I can deliver clean and solid codes. I can start work right now and finish within your deadline. This is m Περισσότερα
SO SERVICES that I can Offer with my skills are: LOGO Designing, Flyer, Banner, Email Designing PSD Creation/Mockup of Website PSD to Responsive HTML using Twitter Bootstrap/Foundation HTML to Responsive Wordpress Περισσότερα
sir pm me im good in wp/php i can finish this fast - price is negotiable ... sir pm me im good in wp/php i can finish this fast - price is negotiable ...
I am having more than 9 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili Περισσότερα
Hello I'm a senior developer who has 5+ years of experiences on Mysql, Oracle and Web Development. Please send me a message and discuss more detail about your project. I will make query for you. I can make any sq Περισσότερα
Hello, Hope you are doing well. I have analyzed your job requirements for a MySQL developer. I can surely assist you to create queries with hooks to insert data into a new table in mysql. I am a Motivated Περισσότερα
Hello sir, I would like to work with you .. I'll really appreciate for that if I can get chance to work with you :) Hope you'll revert this proposal. Thank you,
I am capable of writing queries similar to this. I just need specifics of what the database is structured as and some means to test it with your database. I have lots of experience writing sql queries. Thanks.