$wpdb->replace Can't replace value of table wordpress database

Question

I write code to save data in to the database table.

I want Replace a row in a table if it exists or insert a new row in a table if the row did not already exist.

http://codex.wordpress.org/Class_Reference/wpdb

I use $wpdb->replace function and then add $wpdb->insert_id to end of code.

But when run my own wordpress plugin . only add new rows with values .Can't replace values.

 $wpdb->replace( $wpdb->prefix . 'fafa', 
   array( 
   'title' =>  trim($row->item(0)->nodeValue) ,
   'liveprice' =>  trim($row->item(2)->nodeValue)  ,
   'changing' =>   trim($row->item(4)->nodeValue)  ,
   'lowest' =>   trim($row->item(6)->nodeValue)  ,
   'topest' =>   trim($row->item(8)->nodeValue)  ,
   'time' =>   trim($row->item(10)->nodeValue)   ), 
   array( 
   '%s',
   '%s',
   '%s',
   '%s',
   '%s',
   '%s'
) );
 $wpdb->inser_Id;

table photo

table

strucher

In Following photo Now id is Unique

which of those fields are unique in that table: `'title' 'liveprice', 'changing', 'lowest','topest','time'` ? — Alex, Feb 25 '15 at 17:02
Oh, I I did not know primary key isn't unique.. I want replace all fields id-title-liveprice ,... @Alex — rahavard, Feb 25 '15 at 17:19
Now id is Unique .. I changed in table... you can see in top photo @Alex — rahavard, Feb 25 '15 at 17:30
that what I guessed from the beginning. and that means that until your query doesn't include the same ID - it just creates new one. you never tried to update any unique record with any ID — Alex, Feb 25 '15 at 17:49
really? do you know the structure of your table??? just include `CREATE TABLE` statement in your post, but not screenshots — Alex, Feb 25 '15 at 17:51
I want Replace a row in a table if it exists or insert a new row in a table if the row did not already exist... Two weeks is that I'm trying out .. But I'm stuck in this issue — rahavard, Feb 25 '15 at 17:56
if you know the record you want to update - you should send an ID of that row. if you don't know and you mean that the Title is enough to say that the record is the same - so set `title` as unique key in your table. — Alex, Feb 25 '15 at 17:58
How can I Send Id of the row? can you write example code?@Alex — rahavard, Feb 25 '15 at 19:47

score 0 · Answer 1 · answered Feb 25 '15 at 18:42

0

this is in your code--->>>>>>>

$wpdb->inser_Id; ***********************

it should be--->>>>>>>>

$wpdb->insert_Id;

answered Feb 25 '15 at 18:42

Atif

280
1
11

2

No it shouldn't, it should be `$wpdb->insert_id;` – Peter Featherstone Jun 04 '17 at 14:34

$wpdb->replace Can't replace value of table wordpress database

1 Answers1