php - How to insert a single row to a Wordpress database table? -

-

intro:

i have function handles contact form variables in website.

  • user enters name, email , text.
  • function.php gets variables using javascript.
  • i more information on user on way - ip, country, utm tags if any, ect.

then added code part saves variables respectively on sql table.

i created table 'wp_contact_form' using phpmyadmin.

used code part in function: 

global $wpdb;   $wpdb->insert(      'wp_contact_form',      array(          'con_ip'          => $_cookie['ip'],          'con_name'        => $fullname,          'con_email'       => $email,          'con_text'        => $message,          'con_country'     => $_cookie['country'],          'con_reigon'      => $_cookie['region'],          'con_city'        => $_cookie['city'],          'con_utm_source'  => $_cookie['utm_source'],          'con_utm_medium'  => $_cookie['utm_medium'],          'con_utm_campain' => $_cookie['utm_campaign'],          'con_utm_term'    => $_cookie['utm_term'],          'con_utm_content' => $_cookie['utm_content']     ),      array(          '%s',          '%s',          '%s',          '%s',          '%s',          '%s',          '%s',          '%s',          '%s'     )  );

and still blank table. tried following this: https://codex.wordpress.org/class_reference/wpdb#insert_rows

without success.

db structure: http://i.stack.imgur.com/kq8oz.png enter image description here

full function code: 

/**     contact form using ajax  **/   add_action('wp_ajax_nopriv_submit_contact_form', 'submit_contact_form');   // send information contact form  function submit_contact_form(){      // utm variables 'get_the_utm_vars()' function     //$utm = get_the_utm_vars();      // if there $_post['email']...     if( isset($_post['email']) && ($_post['validation'] == true ) ) {          // parameters         $email = $_post['email']; // gets email of user..         $email_to = "arik@ example.pro";         $utm_emails = array(             'tova@ example.pro',             'yonatan@ example.pro',              'arik@ example.pro',             'gal@ example.pro',               'shai@ example.pro',               'walid@ example.pro'                     );         $fullname = $_post['fullname'];         $message = $_post['text'];          $email_subject = " example intro: $email";               $headers = array(                 'from: '. $fullname .' <'. $email .'>',                  'bcc:  yonatan@ example.pro',                  'bcc:  gal@ example.pro',                  'bcc:  eran@ example.pro',                  'bcc:  tova@ example.pro',                  'bcc:  walid@ example.pro',                  'content-type: text/html; charset=\"utf-8\"; format=flowed \r\n'             );          $utm_headers = array(             'from: '. $fullname .' <'. $email .'>'             );           // send email yh, , if sent - do:         if ( wp_mail($email_to,$email_subject,$message,$headers) ) {              // tells me mail has been sent             echo json_encode( array("result"=>"complete") );              //add utm variables emails text             $message .= "\r\n \r\n \r\n ip: ". $_cookie['ip'] ."\r\n country: ". $_cookie['country'] ."\r\n region: ". $_cookie['region'] ."\r\n city: ". $_cookie['city'] ." \r\n utm source: ".$_cookie['utm_source']." \r\n utm medium: ".$_cookie['utm_medium']." \r\n utm campaign: ".$_cookie['utm_campaign']."\r\n utm term: ".$_cookie['utm_term']." \r\n utm content: ".$_cookie['utm_content']." ";             // mail tova utm paramseters             wp_mail($utm_emails,$email_subject,$message,$utm_headers);           } else {             echo json_encode(array("result"=>"mail_error"));             var_dump($globals['phpmailer']->errorinfo);     }         wp_die();     }               global $wpdb;       $wpdb->insert(          'wp_contact_form',          array(              'con_ip'          => $_cookie['ip'],              'con_name'        => $fullname,              'con_email'       => $email,              'con_text'        => $message,              'con_country'     => $_cookie['country'],              'con_reigon'      => $_cookie['region'],              'con_city'        => $_cookie['city'],              'con_utm_source'  => $_cookie['utm_source'],              'con_utm_medium'  => $_cookie['utm_medium'],              'con_utm_campain' => $_cookie['utm_campaign'],              'con_utm_term'    => $_cookie['utm_term'],              'con_utm_content' => $_cookie['utm_content']         ),          array(              '%s',              '%s',              '%s',              '%s',              '%s',              '%s',              '%s',              '%s',              '%s'         )      );        }

try this

     global $wpdb;             $table = wp_contact_form;             $data = array(         'con_ip'          => $_cookie['ip'],          'con_name'        => $fullname,          'con_email'       => $email,          'con_text'        => $message,          'con_country'     => $_cookie['country'],          'con_reigon'      => $_cookie['region'],          'con_city'        => $_cookie['city'],          'con_utm_source'  => $_cookie['utm_source'],          'con_utm_medium'  => $_cookie['utm_medium'],          'con_utm_campain' => $_cookie['utm_campaign'],          'con_utm_term'    => $_cookie['utm_term'],          'con_utm_content' => $_cookie['utm_content']             );             $format = array(         '%s',          '%s',          '%s',          '%s',          '%s',          '%s',          '%s',          '%s',          '%s',         '%s',         '%s',         '%s'             );            $success=$wpdb->insert( $table, $data, $format );             if($success) { echo 'success'; } else { echo 'not success';  }

Comments

Post a Comment

Popular posts from this blog

python - pip install -U PySide error -

-
does know how avoid following error when running pip install -u pyside per official website instructions here: https://pypi.python.org/pypi/pyside/#installing-pyside-on-a-mac-os-x-system note have done brew install qt successfully. you using pip version 7.0.3, version 7.1.2 available. should consider upgrading via 'pip install --upgrade pip' command. collecting pyside using cached pyside-1.2.4.tar.gz installing collected packages: pyside running setup.py install pyside complete output command /applications/anaconda/bin/python -c "import setuptools, tokenize;__file__='/private/var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-build-cpxemt/pyside/setup.py';exec(compile(getattr(tokenize, 'open', open)(__file__).read().replace('\r\n', '\n'), __file__, 'exec'))" install --record /var/folders/dy/ttgqhqqx3g9bsbsnqnxsk2z80000gq/t/pip-0r7hri-record/install-record.txt --single-version-externally-managed --compile: ...
Read more

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

-
simple question: i'm trying initialize array within c++ class declaration: using namespace std; #include <string> class myclass{ public: string myarray[] = {"a","b","c"}; }; and i'm getting error: error: brace-enclosed initializer not allowed here before ‘{’ token no, without complied c++11 compiler, cannot initialize member array in declaration. have initialize array member in constructor. , don't use open array if know number of elements initialize array.
Read more

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -

-
i trying add nodes dagre graph through cityscape.js. problem nodes not painted. code have: cy.add({ group: "nodes", data: { id:"n0",name:"n0",weight: 75 }, }); $.ajax(url).done(function(jsontree){ var newnodes=[]; for(var i=1;i<6;i++){ //var child = jsontree.result[i]; newnodes.push( { group: "nodes", data: { id: "n"+i, name:"n"+i}}, { group: "edges", data: { id: "e"+i, source: "n0", target: "n"+i } } ); } cy.add(newnodes); any ideas? have used loaded function reload graph not work. not know if have use specific function reload graph. thank in advance. you need add positions new nodes. cytoscape.js docs : it important note positions of newly added nodes must defined when calling cy.add(). nodes can not placed in graph without valid position — otherwise not displayed. yo...
Read more