Wordpress - insert string with wpdb

Question

I have code like this:

global $wpdb;
    $wpdb->insert(
        'name_of_table',
        array(

            'someInteger' => $surveyResult6,
            'someString' => $surveyResult7
        ),
        array(

            '%d',
            '%s'
        )
    );
    // Increment database rows
    $wpdb->insert_id;
    echo $surveyResult7;

...and I have problem with insert string inside my table.

There' s no error, evrything seems to be fine but there's no new record in my database. If I change string to digit and submit form once again, there appear new row with two digits.

I' ve read some topics with problem like this one (wpdb and strings) but I don't find any clue how to fix it. Could anyone tell me what should I do?

remove single quote before '%d' , hope this is copy paste error — Jigar Shah
– Jigar Shah, Commented Sep 27, 2017 at 9:08

B. Desai · Accepted Answer · 2017-09-27 09:22:53Z

1

You have error in your script

global $wpdb;
    $wpdb->insert(
        'name_of_table',
        array(

            'someInteger' => $surveyResult6,
            'someString' => $surveyResult7
        ),
        array(

            '%d', //<---remove unwanted single quotes
            '%s'
        )
    );
    // Increment database rows
    $wpdb->insert_id;
    echo $surveyResult7;

edited Sep 27, 2017 at 9:22

answered Sep 27, 2017 at 9:09

B. Desai

16.4k5 gold badges28 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Adrian Over a year ago

I take these from Wordpress'es example: codex.wordpress.org/Class_Reference/wpdb If I remove single quotes I get error: "Parse error: syntax error, unexpected '%', expecting ')'"

B. Desai Over a year ago

check updated answer you also have one extra single quote before '%d',

Adrian Over a year ago

I removed one, not necesarry single quote before '%d', and do what you wrote but sadly it' s still doesn't work.

Adrian · Accepted Answer · 2017-09-27 10:01:05Z

0

I resolved my own problem. I write an answer for people with problem like mine.

I don't know why but if you have (for example) 5 variables in form and one of them is string you have to complete form (all fields). If you skip one of input there' s a problem. The strangest is fact, that if you have only digits as a variables to send to your database, you can skip some fields and code will create row with your and empty values.

answered Sep 27, 2017 at 10:01

Adrian

133 bronze badges

Collectives™ on Stack Overflow

Wordpress - insert string with wpdb

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related