PHP pdoData Examples

Example #1

File: adHocMenu.php Project: papertapeman/AdHoc-Query-System-php

"><?php 
            echo $row['title'];
            ?>
</A>&nbsp;&nbsp;<BR>
</TD>
<?php 
        } else {
            ?>
	<TD class="ahMenu2">&nbsp;&nbsp;<?php 
            echo pdoData($row, "title");
            ?>
&nbsp;&nbsp;</TD>
	<TD class="ahMenu3">
	<FORM ACTION="adhocMenu.php" METHOD="POST">
	 <INPUT TYPE="hidden" NAME="nextmenu" VALUE="<?php 
            echo pdoData($row, "sub_menu_num");
            ?>
">
	 <INPUT TYPE="submit" VALUE="Next">
	</FORM>
	</TD>
<?php 
        }
    }
    ?>
</TR>
<?php 
}
pdoDisconnect($connAdHoc);
//-----------------------------------------------------------------------------------
?>

Example #2

File: adHocParam.php Project: papertapeman/AdHoc-Query-System-php

</TR></TABLE>
<CENTER>
<IMG SRC="<?php 
echo cHeaderImagePath;
?>
" ALT="" BORDER="0" WIDTH="299" HEIGHT="95"></A>
<BR><BR>
<span class="header18"><?php 
echo pdoData($row, "title");
?>
</span>
</CENTER>
<?php 
traceHide($sql);
traceHide("menunum/linenum=" . $thisMenu . "/" . $thisLine);
$selectStmt = pdoData($row, "select_stmt");
if (queryHasParams($selectStmt)) {
    $paramStr = explode(cParamDelimiter, $selectStmt);
    //step through the parameters and create corresponding form inputs
    //these are called '_n', where n is their index within array
    //splitParamStrArray
    $formInputsStr = "";
    for ($i = 1; $i < count($paramStr); $i += 2) {
        traceHide("requestName=" . $paramStr[$i]);
        $formInputsStr = $formInputsStr . "<TR><TD class=\"ahParam\">" . $paramStr[$i] . "</TD>" . "<TD class=\"ahParam\"><INPUT TYPE=\"text\" NAME=\"" . $paramStr[$i] . "\" VALUE=\"" . requestValue($paramStr[$i]) . "\" class=\"text\"></TD><TD>&nbsp;</TD></TR>";
    }
}
pdoDisconnect($connAdHoc);
?>
<FORM ACTION="adHocQuery.php" NAME="InputForm" METHOD="POST">
<CENTER>

Example #3

File: adHocQuery.php Project: papertapeman/AdHoc-Query-System-php

                ?>
        <br/>
        <p class="ahTitleOtherLinks"><?php 
                echo $relatedTitle;
                ?>
 (<?php 
                echo $numRecords;
                ?>
 items)</p>
        <UL>
<?php 
            }
            foreach ($adhocStmt as $row) {
                $nextScript = hasAllParams(pdoData($row, "select_stmt")) ? "adHocQuery.php" : "adHocParam.php";
                TraceHide(pdoData($row, "menu_num") . "/" . pdoData($row, "line_num") . ", " . pdoData($row, "title"));
                $linkHTML = "<A HREF=\"" . $nextScript . "?menunum=" . pdoData($row, "menu_num") . "&linenum=" . pdoData($row, "line_num") . queryStringData("") . "\">" . pdoData($row, "title") . "</A>";
                ?>
        <LI class="ahOtherLinks"><?php 
                echo $linkHTML;
                ?>
</LI><br />
<?php 
            }
            ?>
      </UL>
<?php 
            pdoDisconnect($connAdHoc);
        }
    }
}
?>

Example #4

File: adHocAdminEditMenu.php Project: papertapeman/AdHoc-Query-System-php

<?php 
foreach ($rows as $row) {
    if ($curMenu == pdoData($row, "sub_menu_num")) {
        $sel = "SELECTED";
    } else {
        $sel = "";
    }
    ?>
 <OPTION <?php 
    echo $sel;
    ?>
 VALUE="<?php 
    echo pdoData($row, "sub_menu_num");
    ?>
"><?php 
    echo pdoData($row, "title");
    ?>
</OPTION>
<?php 
}
pdoClose($stmt);
pdoDisconnect($connAdHoc);
?>
</SELECT>
</TD>
</TR>
<TR>
<TD>
Title:<BR>
</TD>
<TD>