WPDB returns 0 instead of the idHow to get last inserted row ID from wordpress database?Accessing wpdb (wordpress database) from laravel controller$wpdb SELECT query is returning the COUNT?Wordpress multi-user, custom database, potential concurrency problems when using global wpdbwordpress wpdb update difficulties$wpdb->prepare() returns NULL or empty on seemingly correct SQL statement$wpdb returns no results with SELECT query$wpdb is null despite being globalWordPress $wpdb returns null$wpdb not working, doesn't show anything in posts

How can a jailer prevent the Forge Cleric's Artisan's Blessing from being used?

What is the term when two people sing in harmony, but they aren't singing the same notes?

Calculating the number of days between 2 dates in Excel

What does the "3am" section means in manpages?

How will losing mobility of one hand affect my career as a programmer?

What (else) happened July 1st 1858 in London?

Is there a problem with hiding "forgot password" until it's needed?

Organic chemistry Iodoform Reaction

Can a malicious addon access internet history and such in chrome/firefox?

A workplace installs custom certificates on personal devices, can this be used to decrypt HTTPS traffic?

Female=gender counterpart?

I'm in charge of equipment buying but no one's ever happy with what I choose. How to fix this?

Why does this part of the Space Shuttle launch pad seem to be floating in air?

Stereotypical names

Java - What do constructor type arguments mean when placed *before* the type?

Is there enough fresh water in the world to eradicate the drinking water crisis?

Superhero words!

Can I rely on these GitHub repository files?

What do you call the infoboxes with text and sometimes images on the side of a page we find in textbooks?

My boss asked me to take a one-day class, then signs it up as a day off

Why are on-board computers allowed to change controls without notifying the pilots?

Could solar power be utilized and substitute coal in the 19th century?

In Star Trek IV, why did the Bounty go back to a time when whales were already rare?

Who must act to prevent Brexit on March 29th?



WPDB returns 0 instead of the id


How to get last inserted row ID from wordpress database?Accessing wpdb (wordpress database) from laravel controller$wpdb SELECT query is returning the COUNT?Wordpress multi-user, custom database, potential concurrency problems when using global wpdbwordpress wpdb update difficulties$wpdb->prepare() returns NULL or empty on seemingly correct SQL statement$wpdb returns no results with SELECT query$wpdb is null despite being globalWordPress $wpdb returns null$wpdb not working, doesn't show anything in posts













0















I am trying to insert the following into WordPress but it always returns 0.



global $wpdb;
$table = $wpdb->prefix.'you_table_name';
$data = array('column1' => 'data one', 'column2' => 123);
$format = array('%s','%d');
$wpdb->insert($table,$data,$format);
$my_id = $wpdb->insert_id;
echo $my_id;









share|improve this question

















  • 1





    Have you checked the table structure in the database? print error message, using $wpdb->print_error(); and give here.

    – Jaydip Nimavat
    Mar 7 at 11:31
















0















I am trying to insert the following into WordPress but it always returns 0.



global $wpdb;
$table = $wpdb->prefix.'you_table_name';
$data = array('column1' => 'data one', 'column2' => 123);
$format = array('%s','%d');
$wpdb->insert($table,$data,$format);
$my_id = $wpdb->insert_id;
echo $my_id;









share|improve this question

















  • 1





    Have you checked the table structure in the database? print error message, using $wpdb->print_error(); and give here.

    – Jaydip Nimavat
    Mar 7 at 11:31














0












0








0








I am trying to insert the following into WordPress but it always returns 0.



global $wpdb;
$table = $wpdb->prefix.'you_table_name';
$data = array('column1' => 'data one', 'column2' => 123);
$format = array('%s','%d');
$wpdb->insert($table,$data,$format);
$my_id = $wpdb->insert_id;
echo $my_id;









share|improve this question














I am trying to insert the following into WordPress but it always returns 0.



global $wpdb;
$table = $wpdb->prefix.'you_table_name';
$data = array('column1' => 'data one', 'column2' => 123);
$format = array('%s','%d');
$wpdb->insert($table,$data,$format);
$my_id = $wpdb->insert_id;
echo $my_id;






wordpress






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Mar 7 at 10:21









Fahad UddinFahad Uddin

7,12555144233




7,12555144233







  • 1





    Have you checked the table structure in the database? print error message, using $wpdb->print_error(); and give here.

    – Jaydip Nimavat
    Mar 7 at 11:31













  • 1





    Have you checked the table structure in the database? print error message, using $wpdb->print_error(); and give here.

    – Jaydip Nimavat
    Mar 7 at 11:31








1




1





Have you checked the table structure in the database? print error message, using $wpdb->print_error(); and give here.

– Jaydip Nimavat
Mar 7 at 11:31






Have you checked the table structure in the database? print error message, using $wpdb->print_error(); and give here.

– Jaydip Nimavat
Mar 7 at 11:31













0






active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55041358%2fwpdb-returns-0-instead-of-the-id%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55041358%2fwpdb-returns-0-instead-of-the-id%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Save data to MySQL database using ExtJS and PHP [closed]2019 Community Moderator ElectionHow can I prevent SQL injection in PHP?Which MySQL data type to use for storing boolean valuesPHP: Delete an element from an arrayHow do I connect to a MySQL Database in Python?Should I use the datetime or timestamp data type in MySQL?How to get a list of MySQL user accountsHow Do You Parse and Process HTML/XML in PHP?Reference — What does this symbol mean in PHP?How does PHP 'foreach' actually work?Why shouldn't I use mysql_* functions in PHP?

Compiling GNU Global with universal-ctags support Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 23:30 UTC (7:30pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!Tags for Emacs: Relationship between etags, ebrowse, cscope, GNU Global and exuberant ctagsVim and Ctags tips and trickscscope or ctags why choose one over the other?scons and ctagsctags cannot open option file “.ctags”Adding tag scopes in universal-ctagsShould I use Universal-ctags?Universal ctags on WindowsHow do I install GNU Global with universal ctags support using Homebrew?Universal ctags with emacsHow to highlight ctags generated by Universal Ctags in Vim?

Add ONERROR event to image from jsp tldHow to add an image to a JPanel?Saving image from PHP URLHTML img scalingCheck if an image is loaded (no errors) with jQueryHow to force an <img> to take up width, even if the image is not loadedHow do I populate hidden form field with a value set in Spring ControllerStyling Raw elements Generated from JSP tagds with Jquery MobileLimit resizing of images with explicitly set width and height attributeserror TLD use in a jsp fileJsp tld files cannot be resolved