本文整理汇总了PHP中oci_define_by_name函数的典型用法代码示例。如果您正苦于以下问题:PHP oci_define_by_name函数的具体用法?PHP oci_define_by_name怎么用?PHP oci_define_by_name使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了oci_define_by_name函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的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 " <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;
}
开发者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 »</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
示例16: bindColumn
/**
* Binds a column to a PHP variable
* @param mixed $column The number of the column or name of the column
* @param mixed $param The PHP variable to which the column should be bound
* @param int $type
* @param int $maxLength
* @param mixed $options
* @return bool
*/
public function bindColumn($column, &$param, $type = PDO::PARAM_STR, $maxlen = -1, $driverdata = null)
{
$type = $this->removeBitFlag(${$type}, PDO::PARAM_INPUT_OUTPUT);
$ociParamType = $this->pdo2OciParamConst($type);
// LOBs
if ($lob_desc = $this->oci_lob_desc($ociParamType)) {
$this->_lobs[$this->_lobsCount]['type'] = $ociParamType;
$this->_lobs[$this->_lobsCount]['lob'] = @oci_new_descriptor($this->ociPdoAdapter->getOciConnection(), $lob_desc);
$res = $this->_lobs[$this->_lobsCount]['lob'];
$this->checkError($res);
$res = @oci_define_by_name($this->stmt, $column, $this->_lobs[$this->_lobsCount]['lob'], $ociParamType);
$this->checkError($res);
$this->_lobs[$this->_lobsCount]['var'] = $param;
$this->_lobs[$this->_lobsCount]['input'] = false;
$this->_lobsCount++;
} else {
$res = @oci_define_by_name($this->stmt, $column, $param, $ociParamType);
$this->checkError($res);
}
return $res;
}
开发者ID:neutrinobg,项目名称:yii2-oci2pdo,代码行数:30,代码来源:OciPdoStatementAdapter.php
示例17: htmlentities
$username = htmlentities($_SESSION['username'], ENT_QUOTES);
$projectName = strval($_GET['var1']);
?>
<?php
$compProfileSql = "SELECT MASTER_DRAWING.PROJECT_NAME, MASTER_DRAWING.COMP_TYPE, COMP_TYPE_SUMM.JUMLAH JML_DWG,\r\n SUM(FABRICATION.MARKING) JML_MARKING,\r\n SUM(FABRICATION.CUTTING) JML_CUTTING,\r\n SUM(FABRICATION.ASSEMBLY) JML_ASSEMBLY,\r\n SUM(FABRICATION.WELDING) JML_WELDING,\r\n SUM(FABRICATION.DRILLING) JML_DRILLING,\r\n SUM(FABRICATION.FINISHING) JML_FINISHING, SUM(PAINTING.BLASTING) JML_BLASTING,\r\n SUM(PAINTING.PRIMER) JML_PRIMER, SUM(PAINTING.INTERMEDIATE) JML_INTERMEDIATE, SUM(PAINTING.FINISHING) JML_FINISH\r\n\r\n FROM FABRICATION, MASTER_DRAWING, COMP_TYPE_SUMM, PAINTING\r\n WHERE FABRICATION.HEAD_MARK = MASTER_DRAWING.HEAD_MARK AND\r\n MASTER_DRAWING.PROJECT_NAME = COMP_TYPE_SUMM.PROJECT_NAME AND\r\n MASTER_DRAWING.COMP_TYPE = COMP_TYPE_SUMM.COMP_TYPE AND\r\n PAINTING.HEAD_MARK = MASTER_DRAWING.HEAD_MARK AND MASTER_DRAWING.PROJECT_NAME = :PROJNAME\r\n\r\n GROUP BY MASTER_DRAWING.COMP_TYPE,\r\n MASTER_DRAWING.PROJECT_NAME, COMP_TYPE_SUMM.JUMLAH";
$compProfileParse = oci_parse($conn, $compProfileSql);
oci_bind_by_name($compProfileParse, ":PROJNAME", $projectName);
oci_execute($compProfileParse);
$content = "\r\n <!DOCTYPE html>\r\n <html lang=\"en\">\r\n <head>\r\n <meta charset=\"UTF-8\">\r\n <title>PRODUCTION REPORT Check List</title>\r\n <link rel=\"stylesheet\" href=\"http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css\">\r\n <link rel=\"stylesheet\" href=\"http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css\">\r\n <script src=\"http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js\"></script>\r\n <script src=\"http://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js\"></script>\r\n <style type=\"text/css\">\r\n .bs-example{\r\n margin: 20px;\r\n }\r\n </style>\r\n </head>\r\n <body>\r\n <div class=\"bs-example\">\r\n <table class=\"table table-bordered\">\r\n <thead>\r\n <tr>\r\n <th>COMPONENT</th>\r\n <th>TOTAL DRAWING</th>\r\n <th>DRAWING ASSIGNED</th>\r\n <th>MARKING SUM</th>\r\n <th>CUTTING SUM</th>\r\n <th>ASSEMBLY SUM</th>\r\n <th>WELDING SUM</th>\r\n <th>DRILLING SUM</th>\r\n <th>FAB FINISHING SUM</th>\r\n <th>BLASTING SUM</th>\r\n <th>PRIMER SUM</th>\r\n <th>INTERMEDIATE SUM</th>\r\n <th>PAINT FINISHING SUM</th> \r\n </tr>\r\n </thead>\r\n <tbody>";
while (($row = oci_fetch_array($compProfileParse, OCI_BOTH)) != false) {
$totalDrawingSql = "SELECT SUM(MASTER_DRAWING.TOTAL_QTY) TOTALQTY FROM MASTER_DRAWING WHERE MASTER_DRAWING.COMP_TYPE = :COMPTYPE AND MASTER_DRAWING.PROJECT_NAME = :PROJNAME";
$totalDrawingParse = oci_parse($conn, $totalDrawingSql);
oci_bind_by_name($totalDrawingParse, ":COMPTYPE", $row['COMP_TYPE']);
oci_bind_by_name($totalDrawingParse, ":PROJNAME", $projectName);
oci_define_by_name($totalDrawingParse, "TOTALQTY", $totalDrawingQty);
oci_execute($totalDrawingParse);
while (oci_fetch($totalDrawingParse)) {
$totalDrawingQty;
}
$content .= "<tr>\r\n <td>{$row['COMP_TYPE']}</td>\r\n <td>{$totalDrawingQty}</td>\r\n <td>{$row['JML_DWG']}</td>\r\n <td>{$row['JML_MARKING']}</td>\r\n <td>{$row['JML_CUTTING']}</td>\r\n <td>{$row['JML_ASSEMBLY']}</td>\r\n <td>{$row['JML_WELDING']}</td>\r\n <td>{$row['JML_DRILLING']}</td>\r\n <td>{$row['JML_FINISHING']}</td>\r\n <td>{$row['JML_BLASTING']}</td>\r\n <td>{$row['JML_PRIMER']}</td>\r\n <td>{$row['JML_INTERMEDIATE']}</td>\r\n <td>{$row['JML_FINISH']}</td>\r\n <tr>";
}
$content .= "</tbody>\r\n </table>\r\n </div>\r\n </body>\r\n </html>";
$list_header = "\r\n <div style=\"display:block; background-color:#f2f2f2; padding:10px; border-bottom:2pt solid #cccccc; color:#6e6e6e; font-size:.85em; font-family:verdana;\">\r\n <div style=\"float:left; width:33%; text-align:left;\">\r\n <img src=\"images/wenlogo.jpg\">\r\n </div>\r\n <div style=\"float:left; width:33%; text-align:center;\">";
$_SESSION[cd - dropdown];
$list_header .= "Production Report by Component List for {$projectName}\r\n </div>\r\n <br style=\"clear:left;\"/>\r\n </div>";
$list_footer = "\r\n <div style=\"display:block;\">\r\n <div style=\"float:left; width:33%; text-align:left;\">\r\n \r\n </div>\r\n <div style=\"float:left; width:33%; text-align:center;\">\r\n Page phptopdf_on_page_number of phptopdf_pages_total\r\n </div>\r\n <div style=\"float:left; width:33%; text-align:right;\">\r\n Generated by {$username}\r\n \r\n </div>\r\n <br style=\"clear:left;\"/>\r\n </div>";
$pdf_options = array("source_type" => 'html', "source" => $content, "action" => 'view', "page_orientation" => 'landscape', "file_name" => 'sample_pdf_report.pdf', "header" => $list_header, "footer" => $list_footer);
// CALL THE phpToPDF FUNCTION WITH THE OPTIONS SET ABOVE
phptopdf($pdf_options);
// OPTIONAL - PUT A LINK TO DOWNLOAD THE PDF YOU JUST CREATED
开发者ID:weltesdeveloper,项目名称:weltesinformationcenter,代码行数:31,代码来源:ProductionChecklistReportPdfGen.php
示例18: elseif
} elseif (!empty($_GET['sz_id'])) {
//egy kis felhasználói adat
if (isset($_SESSION['user'])) {
$felh_id_sql = "SELECT F_ID FROM FELHASZNALO WHERE FELHASZNALONEV = '{$_SESSION['user']}'";
$felh_id_lekerdez = oci_parse($conn, $felh_id_sql);
oci_execute($felh_id_lekerdez);
while (oci_fetch($felh_id_lekerdez)) {
$fi_id = oci_result($felh_id_lekerdez, 'F_ID');
}
}
$szaki_sql = "SELECT * FROM SZAKI WHERE SZ_ID = '{$_GET['sz_id']}'";
$szaki = oci_parse($conn, $szaki_sql);
oci_execute($szaki);
$ert_atlag_sql = "SELECT AVG(PONT) AS ATLAG FROM ERTEKELES WHERE SZ_ID='{$_GET['sz_id']}'";
$ert_atlag = oci_parse($conn, $ert_atlag_sql);
oci_define_by_name($ert_atlag, 'ATLAG', $atlag);
oci_execute($ert_atlag);
oci_fetch($ert_atlag);
while (oci_fetch($szaki)) {
?>
<div class="col-md-6">
<div id="adatok">
<h2><?php
echo oci_result($szaki, 'NEVE');
?>
</h2>
<h4>Értékelése: <?php
echo round($atlag, 2);
?>
</h4>
<p>
开发者ID:polaroi8d,项目名称:szakik,代码行数:31,代码来源:profile.php
示例19: oci_execute
oci_execute($sumParse);
while (oci_fetch($sumParse)) {
$total;
}
$subcontAssignedSql = "SELECT GET_BLDG_ASSGWT(:projName) TOTALASSIGNED FROM DUAL";
$subcontAssignedParse = oci_parse($conn, $subcontAssignedSql);
oci_bind_by_name($subcontAssignedParse, ":projName", $projectName);
oci_define_by_name($subcontAssignedParse, "TOTALASSIGNED", $totalAssignedWeight);
oci_execute($subcontAssignedParse);
while (oci_fetch($subcontAssignedParse)) {
$totalAssignedWeight;
}
$currFabTonnSql = "SELECT GET_BLDG_FAB(:projName) AS CURRENT_SUM FROM DUAL";
$currFabTonnParse = oci_parse($conn, $currFabTonnSql);
oci_bind_by_name($currFabTonnParse, ":projName", $projectName);
oci_define_by_name($currFabTonnParse, "CURRENT_SUM", $currentFabricationSum);
oci_execute($currFabTonnParse);
while (oci_fetch($currFabTonnParse)) {
$currentFabricationSum;
}
$percAssigned = $totalAssignedWeight / $total * 100;
$percFab = $currentFabricationSum / $total * 100;
$barisReportWeight = $baris + 1;
$barisReportAssigned = $baris + 2;
$barisReportNotAssigned = $baris + 3;
$barisFabWeight = $baris + 4;
$barisFabNotWeight = $baris + 5;
$objPHPExcel->setActiveSheetIndex(0)->setCellValue("B{$barisReportWeight}", 'TOTAL PROJECT WEIGHT')->setCellValue("F{$barisReportWeight}", number_format($total, 0))->setCellValue("B{$barisReportAssigned}", 'TOTAL PROJECT WEIGHT ASSIGNED')->setCellValue("F{$barisReportAssigned}", number_format($totalAssignedWeight, 0))->setCellValue("G{$barisReportAssigned}", number_format($percAssigned, 2) . '%')->setCellValue("B{$barisReportNotAssigned}", 'TOTAL PROJECT NOT ASSIGNED')->setCellValue("F{$barisReportNotAssigned}", number_format($total - $totalAssignedWeight, 0))->setCellValue("G{$barisReportNotAssigned}", number_format(100 - $percAssigned, 2) . '%')->setCellValue("B{$barisFabWeight}", 'TOTAL FABRICATION WEIGHT')->setCellValue("F{$barisFabWeight}", number_format($currentFabricationSum, 0))->setCellValue("G{$barisFabWeight}", number_format($percFab, 2) . '%')->setCellValue("B{$barisFabNotWeight}", 'NOT FABRICATION WEIGHT')->setCellValue("F{$barisFabNotWeight}", number_format($total - $currentFabricationSum, 0))->setCellValue("G{$barisFabNotWeight}", number_format(100 - $percFab, 2) . '%');
$objPHPExcel->getActiveSheet()->getStyle("F{$barisReportWeight}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle("F{$barisReportAssigned}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
$objPHPExcel->getActiveSheet()->getStyle("F{$barisFabWeight}")->getNumberFormat()->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1);
开发者ID:weltesdeveloper,项目名称:weltesinformationcenter,代码行数:31,代码来源:ComponentReportXlsGen.php
示例20: DefineByName
public function DefineByName($statement, $column_name, &$variable, $type = SQLT_CHR)
{
return oci_define_by_name($statement, $column_name, $variable, $type);
}
开发者ID:Zniel,项目名称:fl_crtlpanel_self_dev,代码行数:4,代码来源:pm_oracle.class.php
注:本文中的oci_define_by_name函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论