{"id":1878,"date":"2018-10-26T11:54:47","date_gmt":"2018-10-26T11:54:47","guid":{"rendered":"https:\/\/ibex.tech\/cloud\/?p=1878"},"modified":"2022-02-17T07:14:02","modified_gmt":"2022-02-17T07:14:02","slug":"php4-update","status":"publish","type":"post","link":"https:\/\/ibex.tech\/cloud\/mysql\/php-versions\/php4-old-code\/queries-php4-old-code\/php4-update","title":{"rendered":"PHP4 UPDATE"},"content":{"rendered":"

\nThis is PHP4 Code!<\/strong><\/em><\/span>\n<\/p>\n

\r\n\r\n$result = @mysql_query("UPDATE some_table SET\r\n\t\t\t\t\timage_filename = '',\r\n\t\t\t\t\tsomething_else = 4\r\n\t\t\t\tWHERE indexer = $destid\r\n\t\t\t\t");\r\n<\/code><\/pre>\n
\nExample Update From An HTML Form
\n<\/h4>\n
\r\n\r\n<!-------------------------------->\r\n<!-------------------------------->\r\n<!----- ADD TO DATABASE FORM ----->\r\n<!-------------------------------->\r\n<!-------------------------------->\r\n<h2>Add To Database<\/h2>\r\n<?php\r\nif ( (isset($_POST['action'])) && ($_POST['action'] == "add_to_database") )\r\n{\r\n\t$field1 = @mysql_real_escape_string($_POST['field1']);\r\n\t$field2 = @mysql_real_escape_string($_POST['field2']);\r\n\t\r\n\t\/\/$field1 = trim($field1);\r\n\t\/\/$field1 = ucwords($field1);\r\n\t\r\n\t$field_checkbox = 0;\r\n\tif(isset($_POST['field_checkbox']) && $_POST['field_checkbox'] == 'Yes')\r\n\t\t$field_checkbox = 1;\r\n\t\r\n\r\n\t$query1 = @mysql_query("SELECT * FROM my_table WHERE field1 = '$field1'");\r\n\tif (@mysql_num_rows($query1))\r\n\t{\r\n\t\techo "VALUE ALREADY EXISTS!<br \/>";\r\n\t}\r\n\telse if ( ($field1 == "") || ($field2 == "") )\r\n\t{\r\n\t\techo "INVALID FORM CONTENTS!<br \/>";\r\n\t}\r\n\telse\r\n\t{\r\n\t\t$result = @mysql_query("INSERT INTO my_table (\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tfield1,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tfield2,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tfield_checkbox\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t) VALUES (\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'$field1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t'$field2',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t$field_checkbox\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t)");\r\n\r\n\t\r\n\t\t\/\/Go to the new page\r\n\t\theader("Location: my_page.php");\r\n\t\tdie();\r\n\r\n\r\n\t\t\r\n\t}\r\n}\r\n?>\r\n<form id="AddRecordForm" action="myfile.php" method="POST">\r\n  <input type="hidden" name="action" value="add_to_database" \/>\r\n  <input type="hidden" name="some_id" value="<?php echo "$some_id";?>" \/>\r\n\r\n  <label>Field 1:<\/label><br \/>\r\n  <input type="text" name="field1" value="<?php echo "$field1";?>" size="80"  \/><br \/>\r\n\r\n  <label>Field 2:<\/label><br \/>\r\n  <input type="text" name="field2" value="<?php echo "$field2";?>" size="80"  \/><br \/>\r\n  \r\n  <label>FieldCheckbox:<\/label><br \/>\r\n  <input type="checkbox" name="field_checkbox" value="Yes" \/><br \/>\r\n\r\n  <input type="submit" value="Store" id="Send" \/>\r\n<\/form>\r\n<\/code><\/pre>\n
\n \n<\/p>\n
\nMaths Operations In Update Queries
\n<\/h4>\n
\r\n\r\n\tmysql_query("UPDATE some_table SET some_value_a = some_value_a + 1, some_value_b = some_value_b + 10  WHERE id = 1");\r\n<\/code><\/pre>\n
\n \n<\/p>\n
\n <\/p>\n","protected":false},"excerpt":{"rendered":"
This is PHP4 Code! $result = @mysql_query("UPDATE some_table SET image_filename = '', something_else = 4 WHERE indexer = $destid "); Example Update From An HTML Form <!——————————–> <!——————————–> <!—– ADD TO DATABASE FORM —–> <!——————————–> <!——————————–> <h2>Add To Database<\/h2> <?php if ( (isset($_POST[‘action’])) && ($_POST[‘action’] == "add_to_database") ) { $field1 = @mysql_real_escape_string($_POST['field1']); $field2 = @mysql_real_escape_string($_POST['field2']); […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[156],"tags":[],"class_list":["post-1878","post","type-post","status-publish","format-standard","hentry","category-queries-php4-old-code"],"_links":{"self":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1878","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=1878"}],"version-history":[{"count":1,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1878\/revisions"}],"predecessor-version":[{"id":1879,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/posts\/1878\/revisions\/1879"}],"wp:attachment":[{"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/media?parent=1878"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/categories?post=1878"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ibex.tech\/cloud\/wp-json\/wp\/v2\/tags?post=1878"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}