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

<?php<\/p>\n

<\/span>\/\/This\u00a0loops\u00a0through\u00a0all\u00a0the\u00a0records\u00a0that\u00a0have\u00a0been\u00a0displayed\u00a0on\u00a0the\u00a0page.<\/p>\n

<\/span>for\u00a0(<\/span>$index\u00a0<\/span>=\u00a0<\/span>0<\/span>;\u00a0<\/span>$index\u00a0<\/span><=\u00a0<\/span>$counter<\/span>;\u00a0<\/span>$index<\/span>++)\u00a0{<\/p>\n

\u00a0\u00a0\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\/*
\n
\u00a0\u00a0\u00a0\u00a0This\u00a0part\u00a0sets\u00a0a\u00a0variable\u00a0with\u00a0the\u00a0names\u00a0we\u00a0created\u00a0in\u00a0the\u00a0first\u00a0section.\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0We\u00a0start\u00a0with\u00a00\u00a0and\u00a0go\u00a0until\u00a0the\u00a0number\u00a0saved\u00a0in\u00a0the\u00a0$index_count\u00a0variable.
\n
\u00a0\u00a0\u00a0\u00a0*\/\u00a0
\n
\u00a0\u00a0\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$varSubmissionID\u00a0<\/span>=\u00a0<\/span>'SubmissionID'<\/span>.<\/span>$index<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$varPostedBy\u00a0<\/span>=\u00a0<\/span>'PostedBy'<\/span>.<\/span>$index<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$varLink\u00a0<\/span>=\u00a0<\/span>'Link'<\/span>.<\/span>$index<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$varDescription\u00a0<\/span>=\u00a0<\/span>'Description'<\/span>.<\/span>$index<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$varApproved\u00a0<\/span>=\u00a0<\/span>'Approved'<\/span>.<\/span>$index<\/span>;<\/p>\n

\u00a0\u00a0\u00a0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0<\/span>\/*
\n
\u00a0\u00a0\u00a0\u00a0This\u00a0is\u00a0the\u00a0variable\u00a0variable\u00a0section.\u00a0\u00a0We\u00a0take\u00a0the\u00a0value\u00a0that\u00a0was\u00a0assigned\u00a0
\n
\u00a0\u00a0\u00a0\u00a0to\u00a0each\u00a0name\u00a0variable.\u00a0\u00a0For\u00a0example\u00a0the\u00a0first\u00a0time\u00a0through\u00a0the\u00a0loop\u00a0we\u00a0are\u00a0
\n
\u00a0\u00a0\u00a0\u00a0at\u00a0the\u00a0record\u00a0assigned\u00a0with\u00a0SubmissionID0.\u00a0\u00a0The\u00a0value\u00a0given\u00a0to\u00a0SubmissionID0\u00a0
\n
\u00a0\u00a0\u00a0\u00a0is\u00a0set\u00a0from\u00a0the\u00a0first\u00a0section.\u00a0\u00a0We\u00a0access\u00a0this\u00a0value\u00a0by\u00a0taking\u00a0the\u00a0variable\u00a0
\n
\u00a0\u00a0\u00a0\u00a0variable\u00a0of\u00a0what\u00a0SubmissionID0\u00a0is.
\n
\u00a0\u00a0\u00a0\u00a0*\/<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$SubmissionIDvalue\u00a0<\/span>=\u00a0$<\/span>$varSubmissionID<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$PostedByvalue\u00a0<\/span>=\u00a0$<\/span>$varPostedBy<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$Linkvalue\u00a0<\/span>=\u00a0$<\/span>$varLink<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$Descriptionvalue\u00a0<\/span>=\u00a0$<\/span>$varDescription<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$Approvedvalue\u00a0<\/span>=\u00a0$<\/span>$varApproved<\/span>;<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>\/\/Update\u00a0the\u00a0database<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>$sql\u00a0<\/span>=\u00a0<\/span>\"UPDATE\u00a0submissions\u00a0SET\u00a0PostedBy='$PostedByvalue',Link='$Linkvalue',\"<\/span>.
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>\"Description='$Descriptionvalue'\u00a0WHERE\u00a0SubmissionID=$SubmissionIDvalue'\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0<\/span>$result\u00a0<\/span>=\u00a0<\/span>mysql_query<\/span>(<\/span>$sql<\/span>);<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>\/\/If\u00a0the\u00a0link\u00a0was\u00a0marked\u00a0approved\u00a0set\u00a0the\u00a0value\u00a0of\u00a0the\u00a0Approved\u00a0field<\/p>\n

\u00a0\u00a0\u00a0\u00a0<\/span>if\u00a0(<\/span>$Approvedvalue\u00a0<\/span>==\u00a0<\/span>'-1'<\/span>)\u00a0{
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$sql\u00a0<\/span>=\u00a0<\/span>\"UPDATE\u00a0submissions\u00a0SET\u00a0Approved='-1'\u00a0WHERE\u00a0SubmissionID=$SubmissionIDvalue\"<\/span>;
\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/span>$result\u00a0<\/span>=\u00a0<\/span>mysql_query<\/span>(<\/span>$sql<\/span>);
\n
\u00a0\u00a0\u00a0\u00a0}<\/p>\n

}<\/p>\n

<\/span>?>
\n
<\/span>
\n<\/span>
\n<\/code><\/font><\/div>\n

\nI hope this has helped you to understand the basics of variable variables and given you
\nsome ideas of how to use them in future projects. They were pretty confusing to me at
\nfirst, but once you get the basic understanding of how variable variables work they’re a
\npiece of cake. Let me know if you have any other questions.<\/div>\n
\n–Robert<\/div>\n<\/div>\n

<\/p>\n

\n
\u00ab Previous Page<\/a><\/div>\n
1<\/a> <\/div>\n
| <\/div>\n
2<\/a> <\/div>\n
| <\/div>\n
3<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

By Robert Berkowitz on September 28, 2000 <?php \/\/This\u00a0loops\u00a0through\u00a0all\u00a0the\u00a0records\u00a0that\u00a0have\u00a0been\u00a0displayed\u00a0on\u00a0the\u00a0page. for\u00a0($index\u00a0=\u00a00;\u00a0$index\u00a0<=\u00a0$counter;\u00a0$index++)\u00a0{ \u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\/* \u00a0\u00a0\u00a0\u00a0This\u00a0part\u00a0sets\u00a0a\u00a0variable\u00a0with\u00a0the\u00a0names\u00a0we\u00a0created\u00a0in\u00a0the\u00a0first\u00a0section.\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0We\u00a0start\u00a0with\u00a00\u00a0and\u00a0go\u00a0until\u00a0the\u00a0number\u00a0saved\u00a0in\u00a0the\u00a0$index_count\u00a0variable. \u00a0\u00a0\u00a0\u00a0*\/\u00a0 \u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0$varSubmissionID\u00a0=\u00a0‘SubmissionID’.$index; \u00a0\u00a0\u00a0\u00a0$varPostedBy\u00a0=\u00a0‘PostedBy’.$index; \u00a0\u00a0\u00a0\u00a0$varLink\u00a0=\u00a0‘Link’.$index; \u00a0\u00a0\u00a0\u00a0$varDescription\u00a0=\u00a0‘Description’.$index; \u00a0\u00a0\u00a0\u00a0$varApproved\u00a0=\u00a0‘Approved’.$index; \u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\/* \u00a0\u00a0\u00a0\u00a0This\u00a0is\u00a0the\u00a0variable\u00a0variable\u00a0section.\u00a0\u00a0We\u00a0take\u00a0the\u00a0value\u00a0that\u00a0was\u00a0assigned\u00a0 \u00a0\u00a0\u00a0\u00a0to\u00a0each\u00a0name\u00a0variable.\u00a0\u00a0For\u00a0example\u00a0the\u00a0first\u00a0time\u00a0through\u00a0the\u00a0loop\u00a0we\u00a0are\u00a0 \u00a0\u00a0\u00a0\u00a0at\u00a0the\u00a0record\u00a0assigned\u00a0with\u00a0SubmissionID0.\u00a0\u00a0The\u00a0value\u00a0given\u00a0to\u00a0SubmissionID0\u00a0 \u00a0\u00a0\u00a0\u00a0is\u00a0set\u00a0from\u00a0the\u00a0first\u00a0section.\u00a0\u00a0We\u00a0access\u00a0this\u00a0value\u00a0by\u00a0taking\u00a0the\u00a0variable\u00a0 \u00a0\u00a0\u00a0\u00a0variable\u00a0of\u00a0what\u00a0SubmissionID0\u00a0is. \u00a0\u00a0\u00a0\u00a0*\/ \u00a0\u00a0\u00a0\u00a0$SubmissionIDvalue\u00a0=\u00a0$$varSubmissionID; \u00a0\u00a0\u00a0\u00a0$PostedByvalue\u00a0=\u00a0$$varPostedBy; \u00a0\u00a0\u00a0\u00a0$Linkvalue\u00a0=\u00a0$$varLink; \u00a0\u00a0\u00a0\u00a0$Descriptionvalue\u00a0=\u00a0$$varDescription; \u00a0\u00a0\u00a0\u00a0$Approvedvalue\u00a0=\u00a0$$varApproved; \u00a0\u00a0\u00a0\u00a0\/\/Update\u00a0the\u00a0database \u00a0\u00a0\u00a0\u00a0$sql\u00a0=\u00a0“UPDATE\u00a0submissions\u00a0SET\u00a0PostedBy=’$PostedByvalue’,Link=’$Linkvalue’,”. \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0“Description=’$Descriptionvalue’\u00a0WHERE\u00a0SubmissionID=$SubmissionIDvalue'”; \u00a0\u00a0\u00a0\u00a0$result\u00a0=\u00a0mysql_query($sql); \u00a0\u00a0\u00a0\u00a0\/\/If\u00a0the\u00a0link\u00a0was\u00a0marked\u00a0approved\u00a0set\u00a0the\u00a0value\u00a0of\u00a0the\u00a0Approved\u00a0field \u00a0\u00a0\u00a0\u00a0if\u00a0($Approvedvalue\u00a0==\u00a0‘-1′)\u00a0{ \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$sql\u00a0=\u00a0“UPDATE\u00a0submissions\u00a0SET\u00a0Approved=’-1′\u00a0WHERE\u00a0SubmissionID=$SubmissionIDvalue”; \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0$result\u00a0=\u00a0mysql_query($sql); \u00a0\u00a0\u00a0\u00a0} } ?> I hope this has helped… <\/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-1365","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1365","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=1365"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1365\/revisions"}],"predecessor-version":[{"id":3240,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/1365\/revisions\/3240"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=1365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=1365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=1365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}