{"id":1364,"date":"2018-01-19T19:22:45","date_gmt":"2018-01-19T19:22:45","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/variable-variables-page-2\/"},"modified":"2018-01-19T19:24:44","modified_gmt":"2018-01-19T19:24:44","slug":"variable-variables-page-2","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/variable-variables-page-2\/","title":{"rendered":"Variable Variables Page 2"},"content":{"rendered":"
\n
\n
By Robert Berkowitz<\/div>\n
on September 28, 2000<\/div>\n<\/p><\/div>\n
\n

Example<\/h2>\n
\nLet’s say you have a MySQL database that stores link submissions for sites of interest.
\nIn that database there is a table called submissions. The fields in the submissions table are as follows:<\/div>\n
\n
\n\tSubmissionID\n\tPostedBy\n\tLink\n\tDescription\n\tApproved\n<\/pre>\n<\/div>\n
\nYou want to be able to display all the submissions that have been made but are not yet approved in
\na table.  The editor will then be able to correct any typing mistakes, select the proper radio
\nbutton next to each link for approval, and submit them all at once.<\/div>\n
\nFirst, when you pull the data from the database and display it on the page you must set each name
\nfor every record to be unique.  This will enable us to loop through the records and be able to
\nidentify what value goes where once the submit button has been pressed.  To do this we do the following:<\/div>\n
\n<\/p>\n
<?php<\/p>\n
<\/span>\/\/Initialize\u00a0counter\u00a0variables<\/p>\n
<\/span>$index\u00a0<\/span>=\u00a0<\/span>0<\/span>;
\n
<\/span>$index_count\u00a0<\/span>=\u00a0<\/span>0<\/span>;<\/p>\n
echo\u00a0<\/span>\"<form\u00a0method=post\u00a0action=$PHP_SELF>n\"<\/span>;
\n
echo\u00a0<\/span>\"<table>n\"<\/span>;
\n
echo\u00a0<\/span>\"<tr><td><b>Posted\u00a0By<\/b><\/td><td><b>Link<\/b><\/td>\"<\/span>.
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\"<td><b>Description<\/b><\/td><td><b>Approved<\/b><\/td><\/tr>n\"<\/span>;<\/p>\n
<\/span>\/*
\n
Assuming\u00a0we\u00a0already\u00a0have\u00a0retrieved\u00a0the\u00a0records\u00a0from\u00a0the\u00a0database\u00a0into\u00a0an\u00a0array\u00a0setting\u00a0
\n
$myrow\u00a0=\u00a0mysql_fetch_array().\u00a0\u00a0The\u00a0do...while\u00a0loop\u00a0assigns\u00a0a\u00a0value\u00a0to\u00a0the\u00a0$xstr\u00a0variable\u00a0
\n
by\u00a0taking\u00a0the\u00a0name\u00a0and\u00a0concatenating\u00a0the\u00a0value\u00a0of\u00a0$index\u00a0to\u00a0the\u00a0end\u00a0starting\u00a0with\u00a00.\u00a0\u00a0So\u00a0
\n
the\u00a0first\u00a0time\u00a0through\u00a0the\u00a0loop\u00a0$SubmissionIDStr\u00a0would\u00a0have\u00a0a\u00a0value\u00a0of\u00a0SubmissionID0\u00a0the\u00a0
\n
next\u00a0time\u00a0through\u00a0it\u00a0would\u00a0be\u00a0SubmissionID1\u00a0and\u00a0so\u00a0forth.
\n
*\/<\/p>\n
<\/span>do\u00a0{<\/p>\n
<\/span>$SubmissionIDStr\u00a0<\/span>=\u00a0<\/span>SubmissionID<\/span>.<\/span>$index<\/span>;
\n
<\/span>$PostedByStr\u00a0<\/span>=\u00a0<\/span>PostedBy<\/span>.<\/span>$index<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$LinkStr\u00a0<\/span>=\u00a0<\/span>Link<\/span>.<\/span>$index<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$DescriptionStr\u00a0<\/span>=\u00a0<\/span>Description<\/span>.<\/span>$index<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$ApprovedStr\u00a0<\/span>=\u00a0<\/span>Aprroved<\/span>.<\/span>$index<\/span>;<\/p>\n
<\/span>\/\/This\u00a0section\u00a0would\u00a0print\u00a0the\u00a0values\u00a0onto\u00a0the\u00a0screen\u00a0one\u00a0record\u00a0per\u00a0row<\/p>\n
<\/span>printf<\/span>(<\/span>\"<tr><td><input\u00a0type=hidden\u00a0name=%s\u00a0value=%s><input\u00a0type=text\u00a0name=%s\u00a0value=%s><\/td>
\n
<td><input\u00a0type=text\u00a0name=%s\u00a0value=%s><\/td><td><input\u00a0type=text\u00a0name=%s\u00a0value=%s><\/td>
\n
<td><input\u00a0type=radio\u00a0name=%s\u00a0value=-1>Yes<input\u00a0type=radio\u00a0name=%s\u00a0value=0\u00a0checked>No<\/td><\/tr>n\"<\/span>,\u00a0
\n
<\/span>$SubmissionIDStr<\/span>,\u00a0<\/span>$myrow<\/span>[<\/span>\"SubmissionID\"<\/span>],\u00a0<\/span>$PostedByStr<\/span>,\u00a0<\/span>$myrow<\/span>[<\/span>\"PostedBy\"<\/span>],\u00a0<\/span>$LinkStr<\/span>,\u00a0<\/span>$myrow<\/span>[<\/span>\"Link\"<\/span>],\u00a0
\n
<\/span>$DescriptionStr<\/span>,\u00a0<\/span>$myrow<\/span>[<\/span>\"Description\"<\/span>],\u00a0<\/span>$ApprovedStr<\/span>,\u00a0<\/span>$ApprovedStr<\/span>);<\/p>\n
<\/span>\/\/Increase\u00a0counter\u00a0values\u00a0by\u00a01\u00a0for\u00a0each\u00a0loop<\/p>\n
<\/span>$index<\/span>++;
\n
<\/span>$index_count<\/span>++;<\/p>\n
}\u00a0while\u00a0(<\/span>$myrow\u00a0<\/span>=\u00a0<\/span>mysql_fetch_array<\/span>(<\/span>$result<\/span>));<\/p>\n
<\/span>\/\/\u00a0I\u00a0also\u00a0had\u00a0to\u00a0create\u00a0an\u00a0index\u00a0count\u00a0to\u00a0keep\u00a0track\u00a0of\u00a0the\u00a0total\u00a0number\u00a0of\u00a0rows.<\/p>\n
<\/span>echo\u00a0<\/span>\"<INPUT\u00a0TYPE=hidden\u00a0NAME=counter\u00a0VALUE=$index_count>n\"<\/span>;<\/p>\n
echo\u00a0<\/span>\"<INPUT\u00a0TYPE=submit><\/form>n\"<\/span>;<\/p>\n
<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n
\nAfter the submit button is pressed to we have to loop through all the variables on the page again.
\nWe are able to do this with the $index_count variable we created.  Next, we assign the value of
\nthose variables to yet another variable in the second step.  This is where variable variables come into play.<\/div>\n<\/div>\n
<\/p>\n
\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/div>\n
| <\/div>\n
3<\/a> <\/div>\n
Next Page \u00bb<\/a><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
By Robert Berkowitz on September 28, 2000 Example Let’s say you have a MySQL database that stores link submissions for sites of interest. In that database there is a table called submissions. The fields in the submissions table are as follows: SubmissionID PostedBy Link Description Approved You want to be… <\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1364","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1364","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=1364"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1364\/revisions"}],"predecessor-version":[{"id":3239,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1364\/revisions\/3239"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}