How to insert data using wpdb

Question

I have wriiten as following    name  Kumkum    email  kumkum gmail com    phone  3456734567    country  India    course  Database    message  hello i want to read db    now   new DateTime     datesent  now- gt format  Y-m-d H i s        global  wpdb   sql    wpdb- gt prepare    INSERT INTO  wp submitted form         name   email   phone   country   course   message   datesent   values      name   email   phone   country   course   message   datesent           wpdb- gt query  sql     It s not working    It throws error    Please help me in correcting it

User · Accepted Answer

Use  wpdb- gt insert     wpdb- gt insert  wp submitted form   array       name    gt   Kumkum        email    gt   kumkum gmail com        phone    gt   3456734567          and so on      Addition from  mastrianni   wpdb- gt insert sanitizes your data for you  unlike  wpdb- gt query which requires you to sanitize your query with  wpdb- gt prepare  The difference between the two is  wpdb- gt query allows you to write your own SQL statement  where  wpdb- gt insert accepts an array and takes care of sanitizing sql for you

User · Answer

You have to check your quotes properly    sql    wpdb- gt prepare       INSERT INTO  wp submitted form                 name   email   phone   country   course   message   datesent     values   name   email   phone   country   course   message   datesent      wpdb- gt query  sql     OR you can use like    sql    INSERT INTO  wp submitted form              name   email   phone   country   course   message   datesent       values   name   email   phone   country   course   message   datesent      wpdb- gt query  sql     Read http   codex wordpress org Class Reference wpdb

User · Answer

global  wpdb   insert    wpdb- gt query  INSERT INTO  front-post   id    content   VALUES    id     content

User · Answer

wpdb- gt query  insert into    table name    name  email  country  country  course  message  datesent  values    name    email     phone     country     course     message

User · Answer

Problem in your SQL    You can construct your sql like this     wpdb- gt prepare    INSERT INTO  wp submitted form        name   email   phone   country   course   message   datesent       values    name     email     phone     country               course     message     datesent          You can also use  wpdb- gt insert     wpdb- gt insert  table name   input array

User · Answer

Try this  I recently leaned about  wpdb- gt prepare HERE and added into our Free Class Booking plugin  plugin approved on wordpress org and will live soon   global  wpdb   tablename    wpdb- gt prefix    submitted form     name        Kumkum     string value use   s  email       kumkum gmail com     string value use   s  phone       3456734567     numeric value use   d  country     India     string value use   s  course      Database     string value use   s  message     hello i want to read db     string value use   s  now        new DateTime      string value use   s  datesent    now- gt format  Y-m-d H i s      string value use   s   sql    wpdb- gt prepare  INSERT INTO   tablename    name    email    phone    country    course    message    datesent   values   s   s   d   s   s   s   s     name   email   phone   country   course   message   datesent     wpdb- gt query  sql     Thanks -Frank

User · Answer

The recommended way  as noted in codex     wpdb- gt insert   table name  array  column name 1   gt  hello    other   gt  123   array    s     d         So  you d better to sanitize values - ALWAYS CONSIDER THE SECURITY

User · Answer

Just use wpdb- gt insert tablename  coloumn  format  and wp will prepare that s query   lt  php global  wpdb   wpdb- gt insert  wp submitted form   array      name    gt   name      email    gt   email      phone    gt   phone      country    gt   country      course    gt   course      message    gt   message      datesent    gt   now         gt

[php] How to insert data using wpdb

Examples related to php

Examples related to wordpress