{"id":2661,"date":"2022-08-30T15:26:43","date_gmt":"2022-08-30T15:26:43","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/02\/04\/php-query-for-mysql-text-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:26:43","modified_gmt":"2022-08-30T15:26:43","slug":"php-query-for-mysql-text-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/php-query-for-mysql-text-collection-of-common-programming-errors\/","title":{"rendered":"php query for mysql text-Collection of common programming errors"},"content":{"rendered":"

i’m having problems while querying for mysql “text” data.<\/p>\n

here’s my code:<\/p>\n

$result_odg = mysqli_query($con,\"SELECT * FROM agenda WHERE data = '\" . $today . \"' AND odg IS NOT NULL\");\necho \"<\/code><\/pre>\n
ODG:<\/code><\/h4>\n
\";\n\nif (mysqli_fetch_array($result_odg)) {\n    $i = 1;\n    echo \"<\/pre>\n
“; while($row = mysqli_fetch_array($result_odg)) { if($i % 2 == 0) $cellID = “even”; else $cellID = “odd”; echo “”; $i == $i++; } echo ”<\/p>\n\n\n
” . $row[‘testo’] . “<\/td>\n<\/tr>\n<\/table>\n
\"; } else { echo \"No ODG\"; }<\/code><\/p>\n
the table have the following fields: id, data_ins, data, testo, odg, agenda, ok.<\/p>\n
using any other name than “testo” in $row['testo']<\/code> (example $row['id']<\/code>) will print out the text. is there any special query to do for “TEXT” type fields? maybe because it’s too heavy and needs a particular array? can’t find anything about this on the manual…<\/p>\n
    \n
  1. \n
    please use<\/p>\n
    \/\/ no need to fetch the result for check (shorten runtime time)\nif ($result_odg) {\n\n    while($row = mysqli_fetch_assoc($result_odg)) {\n        \/\/ use $row['testo'] is possible\n\n        \/\/ replace this too\n        $i++;\n    }\n}\n<\/code><\/pre>\n<\/li>\n
  2. \n
    To make query fast select only those fields which needed.In this case your query should be like:<\/p>\n
    $result_odg = mysqli_query($con,\"SELECT testo FROM agenda WHERE data = '\" . $today . \"' AND odg IS NOT NULL\");\n<\/code><\/pre>\n<\/li>\n<\/ol>\n
    Originally posted 2014-02-04 13:27:02. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
    i’m having problems while querying for mysql “text” data. here’s my code: $result_odg = mysqli_query($con,”SELECT * FROM agenda WHERE data = ‘” . $today . “‘ AND odg IS NOT NULL”); echo ” ODG: “; if (mysqli_fetch_array($result_odg)) { $i = 1; echo ” “; while($row = mysqli_fetch_array($result_odg)) { if($i % 2 == 0) $cellID = […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2661","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2661","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=2661"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/2661\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=2661"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=2661"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=2661"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}