{"id":2025,"date":"2019-05-04T13:13:13","date_gmt":"2019-05-04T12:13:13","guid":{"rendered":"https:\/\/ibex.tech\/cloud\/?p=2025"},"modified":"2025-04-24T22:13:00","modified_gmt":"2025-04-24T21:13:00","slug":"update-2","status":"publish","type":"post","link":"https:\/\/ibex.tech\/cloud\/wordpress\/database\/queries-database\/update-2","title":{"rendered":"UPDATE"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">Simple Update<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>  global $wpdb;\n  $sql = $wpdb-&gt;prepare(\"UPDATE {$wpdb-&gt;prefix}tbl_my_table SET\n\t\t\t\t\t\tmy_fieldname1 = 123,\n\t\t\t\t\t\tmy_fieldname2 = %s\n\t\t\t\t\tWHERE indexer = %d\n\t\t\t\t\t\", $my_field2, $some_value);\n  $wpdb-&gt;query($sql);<\/code><\/pre>\n\n\n\n<h5 class=\"wp-block-heading\">If you need to know whether UPDATE was successful<\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code>  $Success = $wpdb-&gt;query($sql);    \/\/Returns False on Error, otherwise the number of rows affected (will be 0 if you update a row but there were no actual changes of values made)\n  if ($Success === False)\n    return(False);\n  else\n    return(True);<\/code><\/pre>\n\n\n\n<h5 class=\"wp-block-heading\">If you need to know how many rows were affected<\/h5>\n\n\n\n<pre class=\"wp-block-code\"><code>  $Count = $wpdb-&gt;query($sql);\n  \n  if ($Count &gt; 0)\n    return(True);\n  else\n    return(False);<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Update From Row + Value Array<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>\/*\n  \/\/You can use NOW and NULL with this, e.g.:\n    $FieldNamesValuesArray&#91;'ColumnName'] = 'NOW';\n    $FieldNamesValuesArray&#91;'ColumnName'] = 'NULL';\n\n  $FieldNamesValuesArray = array();\n  $FieldNamesValuesArray&#91;'ColumnName1'] = $ColumnName1;\n  $FieldNamesValuesArray&#91;'ColumnName2'] = $ColumnName2;\n  DbUserWriteFields($user_id, $FieldNamesValuesArray);\n*\/\nfunction DbUserWriteFields($user_id, $FieldNameValueArray)\n{\n  global $wpdb;\n  \n  $sql = \"UPDATE {$wpdb->prefix}tbl_my_table SET \";\n\n  $FirstField = true;\n  foreach ($FieldNameValueArray as $key => $value)\n  {\n    if (!$FirstField)\n      $sql .= \",\";\n    $FirstField = false;\n    \n    if ($value === 'NOW')\n      $sql .= \" $key = NOW() \";\n    else if ($value === 'NULL')\n      $sql .= \" $key = NULL \";\n    else\n      $sql .= $wpdb->prepare(\" $key = %s \", $value);\n  }\n  \n  $sql .= $wpdb->prepare(\" WHERE user_id = %d\", $user_id);\n\n  if (current_user_can('administrator'))\n    $wpdb->show_errors();\n  $wpdb->query($sql);\n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Simple Update If you need to know whether UPDATE was successful If you need to know how many rows were affected Update From Row + Value Array<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[169],"tags":[],"class_list":["post-2025","post","type-post","status-publish","format-standard","hentry","category-queries-database"],"_links":{"self":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/2025","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/comments?post=2025"}],"version-history":[{"count":21,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/2025\/revisions"}],"predecessor-version":[{"id":4966,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/2025\/revisions\/4966"}],"wp:attachment":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/media?parent=2025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/categories?post=2025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/tags?post=2025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}