当前位置: 首页>>代码示例>>PHP>>正文


PHP oci_define_by_name函数代码示例

本文整理汇总了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;
 }
开发者ID:jpina,项目名称:oci8,代码行数:7,代码来源:Oci8Statement.php

示例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;
}
开发者ID:nsahoo,项目名称:cmssw-1,代码行数:12,代码来源:pager_functions.php

示例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;
     }
 }
开发者ID:NLP-Project,项目名称:AirLine-Reservation-System,代码行数:16,代码来源:UserAccountModel.php

示例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 "&nbsp;<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'>&nbsp;&nbsp;&nbsp;<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;
}
开发者ID:balajisuiaji474,项目名称:ticket-booking,代码行数:46,代码来源:list-theatres.php

示例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;
 }
开发者ID:NLP-Project,项目名称:AirLine-Reservation-System,代码行数:20,代码来源:ReviewModel.php

示例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;
 }
开发者ID:winkbrace,项目名称:oracle,代码行数:28,代码来源:Executor.php

示例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);
开发者ID:weltesdeveloper,项目名称:weltesinformationcenter,代码行数:31,代码来源:subcontAssignmentIndexMultiple.php

示例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
开发者ID:weltesdeveloper,项目名称:weltesinformationcenter,代码行数:31,代码来源:SubcontReportXlsGen.php

示例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 
开发者ID:weltesdeveloper,项目名称:weltesinformationcenter,代码行数:31,代码来源:showUpdateableElements.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 &raquo;</a></p>
					</div><!--/span-->
开发者ID:nyandranzz,项目名称:todoticket,代码行数:31,代码来源:bitacora.php

示例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);
}
开发者ID:pinicilin2006,项目名称:osago,代码行数:31,代码来源:a7_return_delete.php

示例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;
            ?>
开发者ID:hongwozai,项目名称:emms,代码行数:31,代码来源:reg.php

示例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>
开发者ID:weltesdeveloper,项目名称:weltesinformationcenter,代码行数:31,代码来源:showUpdateableElementsNEW.php

示例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);
 }
开发者ID:df-arif,项目名称:df-core,代码行数:9,代码来源:PdoAdapter.php

示例15: bindColumn

 /**
  * {@inheritdoc}
  */
 public function bindColumn($column, &$param, $type = null)
 {
     return oci_define_by_name($this->_sth, strtoupper($column), $param, $type);
 }
开发者ID:nvdnkpr,项目名称:symfony-demo,代码行数:7,代码来源:OCI8Statement.php


注:本文中的oci_define_by_name函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。