本文整理汇总了PHP中oci_define_by_name函数的典型用法代码示例。如果您正苦于以下问题：PHP oci_define_by_name函数的具体用法？PHP oci_define_by_name怎么用？PHP oci_define_by_name使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了oci_define_by_name函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: defineByName
public function defineByName($columnName, &$variable, $type = SQLT_CHR)
{
set_error_handler(static::getErrorHandler());
$isSuccess = oci_define_by_name($this->resource, $columnName, $variable, $type);
restore_error_handler();
return $isSuccess;
}示例2: count_rows
function count_rows(&$conn, $select, $binds)
{
$sql = "SELECT COUNT(*) AS num_rows FROM({$select})";
$stmt = oci_parse($conn, $sql);
foreach ($binds as $handle => $var) {
oci_bind_by_name($stmt, $handle, $binds[$handle]);
}
oci_define_by_name($stmt, "NUM_ROWS", $num_rows);
oci_execute($stmt);
oci_fetch($stmt);
return $num_rows;
}示例3: isUserPresent
function isUserPresent($userName, $password)
{
ini_set('display_errors', 'On');
$db = "w4111c.cs.columbia.edu:1521/adb";
$conn = oci_connect("kpg2108", "test123", $db);
$stmt = oci_parse($conn, "select count(*) as NUM_ROWS from users where login_id = '{$userName}' and password ='{$password}'");
oci_define_by_name($stmt, 'NUM_ROWS', $this->num_rows);
oci_execute($stmt);
oci_fetch($stmt);
oci_close($conn);
if ($this->num_rows > 0) {
return true;
} else {
return false;
}
}示例4: getMoviesBasedOnMovieName
function getMoviesBasedOnMovieName($searchText, $conn)
{
$inside = "false";
$searchQuery = "select * from movies where upper(moviename) like '%" . strtoupper($searchText) . "%'";
$movieMatches = oci_parse($conn, $searchQuery);
oci_execute($movieMatches);
while (($row = oci_fetch_array($movieMatches, OCI_BOTH)) != false) {
$movieshows = oci_parse($conn, "select showid,movieid,screenid,theatreid,to_char(starttime, 'yyyy-mm-dd hh24:mi:ss') as starttime, price from movieshow where starttime >=sysdate and movieid = " . $row['MOVIEID'] . "order by starttime");
oci_execute($movieshows);
while (($movieshowRow = oci_fetch_array($movieshows, OCI_BOTH)) != false) {
$inside = "true";
$starttime = date_format(date_create($movieshowRow['STARTTIME']), 'Y-m-d H:i:s');
$theatreDetails = oci_parse($conn, "select theatrename from theatres where theatreid=" . $movieshowRow['THEATREID']);
oci_define_by_name($theatreDetails, 'THEATRENAME', $theatrename);
oci_execute($theatreDetails);
echo "<br>";
echo "<div class='movie'>";
echo "<form action='/ticket-booking/ticket-selection.php' method='post'>";
echo "<a class='review' href= '/ticket-booking/view-reviews.php?type=theatre&theatreid=" . $movieshowRow['THEATREID'] . "'>View Review</a>";
if (isset($_SESSION['username'])) {
echo " <a class='review' href='/ticket-booking/reviews.php?type=theatre&theatreid=" . $movieshowRow['THEATREID'] . "'>Write Review</a>";
}
echo "<br>";
while (oci_fetch($theatreDetails)) {
echo "<span class='title'>Theatre: </span><span class='titleValue'>" . $theatrename . "</span>";
echo "<input type=hidden name='theatrename' value=\"" . $theatrename . "\">";
}
echo "<br>";
echo "<span class='title'>Movie: </span><span class='titleValue'>" . $row['MOVIENAME'] . "</span><span class='rating'> <img src='includes/likes.png'/ title='Users Rating'>" . number_format($row['RATING'] / 10 * 100, 0) . "%</span>";
echo "<br>";
echo "<span class='title'>Show Start Time: </span><span class='titleValue'>" . $movieshowRow['STARTTIME'] . "</span>";
echo "<span class='movieOrder'><input type='submit' value='Select'></span>";
echo "<input type=hidden name='showid' value=\"" . $movieshowRow['SHOWID'] . "\">";
echo "<input type=hidden name='theatreid' value=\"" . $movieshowRow['THEATREID'] . "\">";
echo "<input type=hidden name='movieid' value=\"" . $movieshowRow['MOVIEID'] . "\">";
echo "<input type=hidden name='screenid' value=\"" . $movieshowRow['SCREENID'] . "\">";
echo "<input type=hidden name='moviename' value=\"" . $row['MOVIENAME'] . "\">";
echo "<input type=hidden name='moviestarttime' value=\"" . $movieshowRow['STARTTIME'] . "\">";
echo "<input type=hidden name='ticketprice' value=\"" . $movieshowRow['PRICE'] . "\">";
echo "<input type=hidden name='movierating' value=\"" . number_format($row['RATING'] / 10 * 100, 0) . "\">";
echo "</form>";
echo "</div>";
}
}
return $inside;
}示例5: getReview
function getReview($flightDesc)
{
ini_set('display_errors', 'On');
$db = "w4111c.cs.columbia.edu:1521/adb";
$conn = oci_connect("kpg2108", "test123", $db);
$stmt = oci_parse($conn, "Select u.fname,f.flight_desc,r.travel_date,r.description from review r join flight f on R.FLIGHT_ID = F.FLIGHT_ID join users u on R.USER_ID = u.user_id where F.FLIGHT_DESC = '" . $flightDesc . "'");
oci_define_by_name($stmt, 'NUM_ROWS', $this->num_rows);
oci_execute($stmt);
oci_close($conn);
$arrayOfReviewDetails = array();
while ($row = oci_fetch_row($stmt)) {
$review = new Review();
$review->setFlightName($row[0]);
$review->setFlightDescription($row[1]);
$review->setTravelDate($row[2]);
$review->setReviewDescription($row[3]);
array_push($arrayOfReviewDetails, $review);
}
return $arrayOfReviewDetails;
}示例6: insert
/**
* Voer insert uit en return last inserted id
*
* @param string $sequence
* @param bool $commit
* @return int|false $lastId
*/
public function insert($sequence = null, $commit = self::COMMIT)
{
if ($this->statement->getStatementType() != 'INSERT') {
return false;
}
if (empty($sequence)) {
return false;
}
if (!$this->execute($commit)) {
return false;
}
// try to return the currval of the given sequence
$resource = oci_parse($this->statement->getConnectionResource(), "select " . $sequence . ".currval cv from dual");
oci_define_by_name($resource, 'CV', $lastId);
$flag = $commit === true ? OCI_COMMIT_ON_SUCCESS : OCI_DEFAULT;
if (!oci_execute($resource, $flag)) {
return false;
}
oci_fetch($resource);
return $lastId;
}示例7: oci_bind_by_name
oci_bind_by_name($insertIntoFabQcParse, ":PROJNAME", $projName);
oci_bind_by_name($insertIntoFabQcParse, ":UPDATEQTY", $updateQty);
$modRes = oci_execute($modParse);
$insertIntoFabRes = oci_execute($insertIntoFabParse);
$insertIntoFabQcRes = oci_execute($insertIntoFabQcParse);
if ($modRes && $insertIntoFabRes && $insertIntoFabQcRes) {
oci_commit($conn);
} else {
oci_rollback($conn);
}
$checkerSql = "SELECT MD.TOTAL_QTY AS TOTALQTY, MDA.SUMASSIGNEDQTY \r\n FROM MASTER_DRAWING MD \r\n INNER JOIN (SELECT MDA.HEAD_MARK, MDA.PROJECT_NAME, SUM(MDA.ASSIGNED_QTY) AS SUMASSIGNEDQTY \r\n FROM MASTER_DRAWING_ASSIGNED MDA \r\n GROUP BY MDA.HEAD_MARK, MDA.PROJECT_NAME)\r\n MDA ON MD.HEAD_MARK = MDA.HEAD_MARK AND MD.PROJECT_NAME = MDA.PROJECT_NAME \r\n WHERE MD.HEAD_MARK = :HEADMARK AND MD.PROJECT_NAME = :PROJNAME";
$checkerParse = oci_parse($conn, $checkerSql);
oci_bind_by_name($checkerParse, ":HEADMARK", $headMarkSelect);
oci_bind_by_name($checkerParse, ":PROJNAME", $projName);
oci_define_by_name($checkerParse, "TOTALQTY", $totalQuantity);
oci_define_by_name($checkerParse, "SUMASSIGNEDQTY", $totalAssignedQuantity);
oci_execute($checkerParse);
while (oci_fetch($checkerParse)) {
$totalQuantity;
}
while (oci_fetch($checkerParse)) {
$totalAssignedQuantity;
}
if ($totalAssignedQuantity == $totalQuantity) {
$updateStatusMdSql = "UPDATE MASTER_DRAWING SET SUBCONT_STATUS = 'ASSIGNED' " . "WHERE HEAD_MARK = :HEADMARK AND PROJECT_NAME = :PROJNAME";
$updateStatusMdParse = oci_parse($conn, $updateStatusMdSql);
oci_bind_by_name($updateStatusMdParse, ":HEADMARK", $headMarkSelect);
oci_bind_by_name($updateStatusMdParse, ":PROJNAME", $projName);
$updateStatusMdRes = oci_execute($updateStatusMdParse);
if ($updateStatusMdRes) {
oci_commit($conn);示例8: oci_execute
oci_execute($subcontTotalTonnFourDaysParse);
while (oci_fetch($subcontTotalTonnFourDaysParse)) {
$tonnSubcontFourDays;
}
$subcontTotalTonnFiveDaysSql = "SELECT SUM(FAB.WEIGHT) AS CURRENTTONNSUBCONTFIVEDAYS, FAB.SUBCONT_ID " . "FROM FABRICATION_HIST, VW_FAB_INFO FAB WHERE FAB.HEAD_MARK = FABRICATION_HIST.HEAD_MARK " . "AND TO_CHAR(FAB_ENTRY_DATE, 'MM/DD/YYYY') = TO_CHAR(SYSDATE - 5, 'MM/DD/YYYY') " . "AND FAB.PROJECT_NAME = :PROJNAME AND FAB.SUBCONT_ID = '{$row['SUBCONT_ID']}' " . "GROUP BY FAB.SUBCONT_ID";
$subcontTotalTonnFiveDaysParse = oci_parse($conn, $subcontTotalTonnFiveDaysSql);
oci_bind_by_name($subcontTotalTonnFiveDaysParse, ":PROJNAME", $projectName);
oci_define_by_name($subcontTotalTonnFiveDaysParse, "CURRENTTONNSUBCONTFIVEDAYS", $tonnSubcontFiveDays);
oci_execute($subcontTotalTonnFiveDaysParse);
while (oci_fetch($subcontTotalTonnFiveDaysParse)) {
$tonnSubcontFiveDays;
}
$subcontTotalTonnSixDaysSql = "SELECT SUM(FAB.WEIGHT) AS CURRENTTONNSUBCONTSIXDAYS, FAB.SUBCONT_ID " . "FROM FABRICATION_HIST, VW_FAB_INFO FAB WHERE FAB.HEAD_MARK = FABRICATION_HIST.HEAD_MARK " . "AND TO_CHAR(FAB_ENTRY_DATE, 'MM/DD/YYYY') = TO_CHAR(SYSDATE - 6, 'MM/DD/YYYY') " . "AND FAB.PROJECT_NAME = :PROJNAME AND FAB.SUBCONT_ID = '{$row['SUBCONT_ID']}' " . "GROUP BY FAB.SUBCONT_ID";
$subcontTotalTonnSixDaysParse = oci_parse($conn, $subcontTotalTonnSixDaysSql);
oci_bind_by_name($subcontTotalTonnSixDaysParse, ":PROJNAME", $projectName);
oci_define_by_name($subcontTotalTonnSixDaysParse, "CURRENTTONNSUBCONTSIXDAYS", $tonnSubcontSixDays);
oci_execute($subcontTotalTonnSixDaysParse);
while (oci_fetch($subcontTotalTonnSixDaysParse)) {
$tonnSubcontSixDays;
}
$averageSubcontProdThisWeek = ($tonnSubcontToday + $tonnSubcontYesterday + $tonnSubcontTwoDays + $tonnSubcontThreeDays + $tonnSubcontFourDays + $tonnSubcontFiveDays + $tonnSubcontSixDays) / 7;
$no = $no + 1;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("A{$baris}", $row['SUBCONT_ID'])->setCellValue("B{$baris}", $subcontStatus)->setCellValue("C{$baris}", number_format($tonnSubcont, 2))->setCellValue("D{$baris}", number_format($tonnSubcontToday, 2))->setCellValue("E{$baris}", number_format($tonnSubcontYesterday, 2))->setCellValue("F{$baris}", number_format($tonnSubcontTwoDays, 2))->setCellValue("G{$baris}", number_format($tonnSubcontThreeDays, 2))->setCellValue("H{$baris}", number_format($tonnSubcontFourDays, 2))->setCellValue("I{$baris}", number_format($tonnSubcontFiveDays, 2))->setCellValue("J{$baris}", number_format($tonnSubcontSixDays, 2))->setCellValue("K{$baris}", number_format($averageSubcontProdThisWeek, 2));
$baris = $baris + 1;
}
// nama dari sheet yang aktif
$objPHPExcel->getActiveSheet()->setTitle('SUBCONTRACTOR REPORT');
$objPHPExcel->setActiveSheetIndex(0);
$formattedFileName = date("m/d/Y_h:i", time());
// simpan file excel dengan nama umr2013.xls
//saat file berhasil di buat, otomatis pop up download akan muncul示例9: oci_parse
$qtySql = "SELECT TOTAL_QTY AS UNIT_QTY FROM MASTER_DRAWING WHERE PROJECT_NAME = :PROJNAME AND COMP_TYPE = :COMP AND HEAD_MARK = :HM";
$qtyParse = oci_parse($conn, $qtySql);
oci_bind_by_name($qtyParse, ":PROJNAME", $projectName);
oci_bind_by_name($qtyParse, ":COMP", $componentType);
oci_bind_by_name($qtyParse, ":HM", $headmarkType);
oci_define_by_name($qtyParse, "UNIT_QTY", $unitQty);
oci_execute($qtyParse);
?>
<?php
$assignedQtySql = "SELECT SUM (MDA.ASSIGNED_QTY) AS ASSIGN_QTY " . " FROM MASTER_DRAWING_ASSIGNED MDA INNER JOIN MASTER_DRAWING MD ON MD.HEAD_MARK = MDA.HEAD_MARK AND MD.DWG_STATUS = 'ACTIVE' " . " WHERE MD.PROJECT_NAME = :PROJNAME AND MD.COMP_TYPE = :COMP AND MD.HEAD_MARK = :HM";
$assignedQtyParse = oci_parse($conn, $assignedQtySql);
oci_bind_by_name($assignedQtyParse, ":PROJNAME", $projectName);
oci_bind_by_name($assignedQtyParse, ":COMP", $componentType);
oci_bind_by_name($assignedQtyParse, ":HM", $headmarkType);
oci_define_by_name($assignedQtyParse, "ASSIGN_QTY", $assignmentQty);
oci_execute($assignedQtyParse);
?>
<?php
while (oci_fetch($qtyParse)) {
$unitQty;
}
?>
<?php
while (oci_fetch($assignedQtyParse)) {
$assignmentQty;
}
?>
<?php 示例10: oci_connect
<h2>Bitácora de Administrador</h2>
<p>Consulta de todas las operaciones ejecutadas.</p>
<div class="row-fluid">
<div class="span8">
<hr>
<!--Construir tabla para reporte de bitácora-->
<?php
$conn = oci_connect('dranzer', 'fabulousmax', 'localhost/XE');
if ($conn) {
$query = "SELECT * FROM BITACORA WHERE ROL = 'admin'";
$stid = oci_parse($conn, $query);
oci_define_by_name($stid, 'ROL', $rol);
oci_define_by_name($stid, 'USUARIO', $usuario);
oci_define_by_name($stid, 'FECHA', $fecha);
oci_define_by_name($stid, 'DESCRIPCION', $descripcion);
oci_execute($stid);
echo "<table class=\"table table-striped\">\n\t\t\t\t\t\t\t\t\t\t<thead>\n\t\t\t\t\t\t\t\t\t\t\t<tr>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Rol</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Usuario</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Fecha</th>\n\t\t\t\t\t\t\t\t\t\t\t\t<th>Descripción</th>\n\t\t\t\t\t\t\t\t\t\t\t</tr>\n\t\t\t\t\t\t\t\t\t\t</thead>\n\t\t\t\t\t\t\t\t\t\t<tbody>";
while (oci_fetch($stid)) {
echo "<tr><td>{$rol}</td><td>{$usuario}</td><td>{$fecha}</td><td>{$descripcion}</td></tr>";
}
echo "</tbody>\n\t\t\t\t\t\t\t\t\t</table>";
oci_free_statement($stid);
oci_close($conn);
}
?>
<!--fin tabla-->
</div><!--/span-->
<div class="span4">
<p><a class="btn btn-large btn-inverse" href="#">Bitácora de Administrador »</a></p>
</div><!--/span-->示例11: connect_to_base
// 5 Испорчен
// 7 Уничтожен
// 6 Похищен
// 8 Передан
// 266 Утратил силу
include "../../config.php";
include "../../function.php";
include "../../ibs_connector.php";
connect_to_base();
#Было до 28.09.2015
//$query_a7 = mysql_query("SELECT `a7`.*, `user`.`id_in_ibs` FROM `user`, `a7` WHERE `unit_id` = 0 AND `a7`.`user_id` > 0 AND `user`.`user_id` = `a7`.`user_id` AND `user`.`id_in_ibs` > 0");
$query_a7 = mysql_query("\n\tSELECT `a7`.*, `user`.`id_in_ibs` \n\tFROM `user`, `a7`\n\t WHERE `unit_id` = 0\n\t AND `a7`.`user_id` > 0 \n\tAND `user`.`user_id` = `a7`.`user_id` \n\tAND `user`.`id_in_ibs` > 0\n\tAND NOT EXISTS \n\t(SELECT 1 \n\tFROM user_unit uu, unit u\n\tWHERE uu.unit_id = u.unit_id\n\tAND u.unit_id = 44\n\tAND uu.user_id =`a7`.`user_id` )\n");
if (mysql_num_rows($query_a7) == 0) {
echo 'Не обнаруженно бланков БСО';
exit;
}
while ($row = mysql_fetch_assoc($query_a7)) {
//В этой част проверяем есть ли в базе IBS полис с таким номером у данного пользователя и с такой же серией в статусе выдан
$oracle_sql_count = oci_parse($conn, "\n select count(*) AS NUM_ROWS\n from bso_document bd,\n bso_doc_cont bdc,\n ins.bso b,\n bso_series bs,\n ins.bso_hist bh\n where b.bso_id = bh.bso_id\n and b.bso_hist_id = bh.bso_hist_id\n and b.num >= bdc.num_start\n and (b.num <= bdc.num_end or bdc.num_end is null)\n and bh.bso_doc_cont_id = bdc.bso_doc_cont_id\n and bd.bso_document_id = bdc.bso_document_id\n and b.bso_series_id = bs.bso_series_id\n and bdc.bso_series_id = bs.bso_series_id\n and b.num = '" . $row['number'] . "'\n and bs.bso_type_id = 3 --А7\n and bd.contact_to_id = " . $row['id_in_ibs'] . " --AGENT_ID\n and bh.hist_type_id = 1 -- статус полиса выдан\n and bh.num = (select max(bh1.num)\n from ins.bso_hist bh1\n where bh1.bso_id = b.bso_id)\n ");
oci_define_by_name($oracle_sql_count, 'NUM_ROWS', $num_rows);
oci_execute($oracle_sql_count);
oci_fetch($oracle_sql_count);
//echo $num_rows;
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if ($num_rows == 0) {
mysql_query("DELETE FROM `a7` WHERE `number` = '" . $row['number'] . "'");
echo 'Удалён A7 №' . $row['number'];
}
//oci_free_statement($oracle_sql_count);
//oci_close($oracle_sql_count);
}示例12: session_start
<table class="table" style="border:1px solid #ddd;" align="center">
<caption class="text-center"><h4>注册用户信息表</h4></caption>
<tr>
<th style="border:1px solid #ddd;" align="center" bgcolor="#f1f1f1">用户名</th>
<th style="border:1px solid #ddd;" align="center" bgcolor="#f1f1f1">申请权限</th>
<th style="border:1px solid #ddd;" align="center" bgcolor="#f1f1f1">操作</th>
</tr>
<?php
session_start();
if ($_SESSION['priority'] == 0) {
if ($_SESSION['username']) {
include "../conn.php";
// $conn = ocilogon('scott','123','192.168.100.34:1521/linuxorcl','AL32UTF8');
$stmt = oci_parse($conn, "select * from T_USER where VERIFY='0'");
oci_define_by_name($stmt, "USERNAME", $username);
oci_define_by_name($stmt, "PRIORITY", $priority);
oci_execute($stmt);
while (oci_fetch($stmt)) {
?>
<tr>
<td style="border:1px solid #ddd;" align="center"><?php
echo $username;
?>
</td>
<td style="border:1px solid #ddd;" align="center"><?php
echo $priority;
?>
</td>
<td style="border:1px solid #ddd;" align="center"><a href="../application/modverify.php?post=<?php
echo $username;
?>示例13: oci_pconnect
}
// GENERATE THE APPLICATION PAGE
$conn = oci_pconnect(ORA_CON_UN, ORA_CON_PW, ORA_CON_DB);
// 1. SET THE CLIENT IDENTIFIER AFTER EVERY CALL
// 2. USING UNIQUE VALUE FOR BACK END USER
oci_set_client_identifier($conn, $_SESSION['username']);
$username = htmlentities($_SESSION['username'], ENT_QUOTES);
?>
<?php
$projectName = strval($_GET['ProjectName']);
$prjSql = "SELECT PROJECT_NO,PROJECT_CODE FROM PROJECT WHERE PROJECT_NAME = :projectName ";
$PrjParse = oci_parse($conn, $prjSql);
oci_bind_by_name($PrjParse, ":projectName", $projectName);
oci_define_by_name($PrjParse, "PROJECT_NO", $PROJECT_NO);
oci_define_by_name($PrjParse, "PROJECT_CODE", $PROJECT_CODE);
oci_execute($PrjParse);
$query = "SELECT HEAD_MARK FROM MASTER_DRAWING WHERE PROJECT_NAME = :projectName ";
$result = oci_parse($conn, $query);
oci_bind_by_name($result, ":projectName", $projectName);
oci_execute($result);
?>
<?php
while (oci_fetch($PrjParse)) {
$PROJECT_CODE;
$PROJECT_NO;
}
?>
<label for="name" class="col-sm-2 control-label"><font color="red">COLI NUMBER</font></label>示例14: bindColumn
public function bindColumn($column, &$param, $type = null, $maxlen = null, $driverdata = null)
{
// this defining by name doesn't seem to work when used in this manner,
// so we will store the types bound here and handle type conversion in fetch
if (!is_null($type)) {
$this->bindTypeMap[$column] = $type;
}
return oci_define_by_name($this->sth, $column, $param, null);
}示例15: bindColumn
/**
* {@inheritdoc}
*/
public function bindColumn($column, &$param, $type = null)
{
return oci_define_by_name($this->_sth, strtoupper($column), $param, $type);
}