{"id":2123,"date":"2019-08-15T14:30:36","date_gmt":"2019-08-15T13:30:36","guid":{"rendered":"https:\/\/ibex.tech\/cloud\/?p=2123"},"modified":"2025-12-01T12:04:10","modified_gmt":"2025-12-01T12:04:10","slug":"select-2","status":"publish","type":"post","link":"https:\/\/ibex.tech\/cloud\/wordpress\/database\/queries-database\/select-2","title":{"rendered":"SELECT"},"content":{"rendered":"\n<h4 class=\"wp-block-heading\">Return Results or False if none<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>\/*\n  $Results = MyFunctionName();\n  if ($Results !== False)\n  {\n    foreach ($Results as $Result)\n    {\n      = $Result&#91;'MyColumnName'];\n    }\n  }\n*\/\n\n  $sql = $wpdb-&gt;prepare(\"SELECT * FROM {$wpdb-&gt;prefix}my_table_name WHERE FileName = %s\", $FileName);\n  if (current_user_can('administrator'))\n    $wpdb-&gt;show_errors();\n  $Results = $wpdb-&gt;get_results($sql, ARRAY_A);\n  if (count($Results) == 0)\n    return(False);\n  else\n    return($Results);<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Loop through all row results<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>  $sql = $wpdb-&gt;prepare(\"SELECT * FROM {$wpdb-&gt;prefix}my_table_name WHERE FileName = %s\", $FileName);\n  if (current_user_can('administrator'))\n    $wpdb-&gt;show_errors();\n  $Results = $wpdb-&gt;get_results($sql, ARRAY_A);\n  foreach ($Results as $Result)\n  {\n    $MyValue = $Result&#91;'MyColumnName'];\n  }<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Get single result<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>\/*\n  $Result = MyFunctionName();\n  if ($Result !== False)\n  {\n    \/\/ = $Result&#91;'MyColumnName'];\n  }\n*\/\n\n  $sql = $wpdb->prepare(\"SELECT * FROM {$wpdb->prefix}my_table_name WHERE FileName = %s\", $FileName);\n  if (current_user_can('administrator'))\n    $wpdb->show_errors();\n  $Results = $wpdb->get_results($sql, ARRAY_A);\n  if (count($Results) > 0)\n    return($Results&#91;0]);       \/\/Get the first row of the results\n  else\n    return(False);\n<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Is a result returned?<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code> if (!isset($Result&#91;'MyColumnName']))\n    return;<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Select From Row + Value Array<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>\/*\n  $FieldNamesArray = array('ColumnName1', 'ColumnName2');\n  $Results = db_user_read_fields(bp_loggedin_user_id(), $FieldNamesArray);\n  $ColumnName1 = &#91;'ColumnName1'];\n  $ColumnName2 = &#91;'ColumnName2'];\n*\/\nfunction db_user_read_fields($user_id, $FieldNamesArray)\n{\n  global $wpdb;\n\n  $sql = \"SELECT \";\n\n  $FirstField = true;\n  foreach ($FieldNamesArray as $key)\n  {\n    if ($FirstField)\n      $sql .= \" $key \";\n    else\n      $sql .= \", $key \";\n    $FirstField = false;\n  }\n  \n  $sql .= $wpdb-&gt;prepare(\" FROM {$wpdb-&gt;prefix}tbl_my_table WHERE user_id = %d\", $user_id);\n\n  $Results = $wpdb-&gt;get_results($sql, ARRAY_A);\n  $Results = $Results&#91;0];       \/\/Get the first row of the results\n\n  return ($Results);\n}<\/code><\/pre>\n\n\n\n<h4 class=\"wp-block-heading\">Read SQL Server Time<\/h4>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/******************************************\n\/\/******************************************\n\/\/********** READ SQL SERVER TIME **********\n\/\/******************************************\n\/\/******************************************\nfunction db_read_server_time ()\n{\n  global $wpdb;\n  \n  $sql =\"SELECT NOW() as SqlServerDateTimeNow\";\n  if (current_user_can('administrator'))\n    $wpdb-&gt;show_errors();\n  $Results = $wpdb-&gt;get_results($sql, ARRAY_A);\n  if (count($Results) &gt; 0)\n    return($Results&#91;0]&#91;'SqlServerDateTimeNow']);\n  else\n    return(\"\");     \n}<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Return Results or False if none Loop through all row results Get single result Is a result returned? Select From Row + Value Array Read SQL Server Time<\/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-2123","post","type-post","status-publish","format-standard","hentry","category-queries-database"],"_links":{"self":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/2123","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=2123"}],"version-history":[{"count":18,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/2123\/revisions"}],"predecessor-version":[{"id":5197,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/2123\/revisions\/5197"}],"wp:attachment":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/media?parent=2123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/categories?post=2123"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/tags?post=2123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}