本文整理汇总了PHP中nnull函数的典型用法代码示例。如果您正苦于以下问题：PHP nnull函数的具体用法？PHP nnull怎么用？PHP nnull使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了nnull函数的15个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: nnull
" width="16%" height="30px" align="center" class="text2" style="background-color:#fff; border:1px dotted #B8B8B8;"><?php
echo nnull($drOU["name"], "/");
?>
</td>
<td id="_td-4-<?php
echo $cnt_;
?>
" width="16%" height="30px" align="center" class="text2" style="background-color:#fff; border:1px dotted #B8B8B8;"><?php
echo DateTimeFormat($drOD["borndate"], $dateformat);
?>
</td>
<td id="_td-5-<?php
echo $cnt_;
?>
" width="12%" height="30px" align="center" class="text2" style="background-color:#fff; border:1px dotted #B8B8B8;"><?php
echo nnull($drOD["licensetype"], "/");
?>
</td>
<td id="_td-6-<?php
echo $cnt_;
?>
" width="15%" height="30px" align="center" class="text2" style="background-color:#fff; border:1px dotted #B8B8B8;"><?php
echo DateTimeFormat($drOD["licenseexp"], $dateformat);
?>
</td>
<td id="_td-7-<?php
echo $cnt_;
?>
" width="8%" height="30px" align="center" class="text2" style="background-color:#fff; border:1px dotted #B8B8B8;">
<button id="_modBtn-<?php
echo $cnt_;示例2: getQUERY
$naslov = getQUERY("n");
$vozilo = getQUERY("vo");
$sofer1 = getQUERY("d1");
$sofer2 = getQUERY("d2");
$sofer3 = getQUERY("d3");
$datum = getQUERY("d");
$vreme = getQUERY("v");
$alarm = getQUERY("alarm");
$zadrz = getQUERY("zadrz");
$pause1 = getQUERY("pause1");
$pause2 = getQUERY("pause2");
$pause3 = getQUERY("pause3");
$pause4 = getQUERY("pause4");
$pause5 = getQUERY("pause5");
/*Za ZKPelagonija*/
$culid = nnull(getQUERY("culid"), 0);
/*Za ZKPelagonija*/
$totalkm = getQUERY("totalkm");
$totaltime = getQUERY("totaltime");
if ($alarm == "/") {
$alarm = 0;
}
if ($zadrz == "/") {
$zadrz = 0;
}
//dim dat() as string = split(datum,"-")
//dim datum1 = dat(2) & "-" & dat(1) & "-" & dat(0)
$tmpDT = new DateTime($datum . ' ' . $vreme);
$tmpDT = $tmpDT->format("Y-m-d H:i:s");
$sqlInsert = "insert into rnalogheder (datetime, VehicleID, DriverID1, DriverID2, DriverID3, StartDate, Name, ClientID, userID, Alarm, toStay, Pause1, Pause2, Pause3, Pause4, Pause5, TotalKm, TotalTime, culid) ";
$sqlInsert .= " Values (now(), " . $vozilo . ", " . $sofer1 . ", " . $sofer2 . ", " . $sofer3 . ", '" . $tmpDT . "', '" . $naslov . "', " . session("client_id") . ", " . session("user_id") . ", " . $alarm . ", " . $zadrz . ", " . $pause1 . ", " . $pause2 . ", " . $pause3 . ", " . $pause4 . ", " . $pause5 . ", " . $totalkm . ", " . $totaltime . ", " . $culid . " )";示例3: dic
}
?>
width:<?php
echo $width;
?>
%; font-size:11px; padding-left:3px" align="left" class="corner5 text5 <?php
echo $classTr;
?>
colZone"><span id="spanZone-<?php
echo $drVehicle["id"];
?>
" onmousemove="ShowPopup(event, '<span class=\'text5\'><?php
echo dic("Reports.CurrZone");
?>
</span>')" onmouseout="HidePopup()"><?php
echo nnull(pg_fetch_result($dsCurrPos, 0, "zonenames"), "/");
?>
</span></td>
<?php
if ($clientType == 2) {
$dsTaxiData = query("select count(*) cnt, sum(price) price, sum(pricewith) pricewith from reporttaxi where vehicleid=" . $drVehicle["id"] . " and startdate between '" . DateTimeFormat(now(), "Y-m-d 00:00:00") . "' and '" . DateTimeFormat(now(), "Y-m-d H:i:s") . "'");
?>
<td style="<?php
echo $dntoursS;
?>
; width:6%; font-size:11px;" align="center" class="corner5 text5 <?php
echo $classTr;
?>
colNTours">
<span id="spanCntTours-<?php
echo $drVehicle["id"];示例4: header
<script type="text/javascript" src="../js/jquery.js"></script>
<script type="text/javascript" src="../js/iScroll.js"></script>
<script type="text/javascript" src="../js/jquery-ui.js"></script>
<script type="text/javascript" src="../js/settings.js"></script>
<script type="text/javascript" src="../js/share.js"></script>
<link href="../tracking/mlColorPicker.css" rel="stylesheet" type="text/css" />
<script type="text/javascript" src="../tracking/mlColorPicker.js" ></script>
<script type="text/javascript" src="../main/main.js"></script>
</head>
<?php
if (session('user_id') == "261") {
echo header('Location: ../sessionexpired/?l=' . $cLang);
}
if (is_numeric(nnull(session("user_id")) . "") == false) {
echo header('Location: ../sessionexpired/?l=' . $cLang);
}
opendb();
$sqlV = "";
if (session("role_id") == "2") {
$sqlV = "select id from vehicles where clientID=" . session("client_id");
} else {
$sqlV = "select vehicleID from uservehicles where userID=" . session("user_id") . "";
}
$Allow = getPriv("settings", session("user_id"));
if ($Allow == false) {
echo header('Location: ../?l=' . $cLang . '&err=permission');
}
$AllowUSettings = true;
//getPriv("UserSettings", session("user_id"));示例5: opendb
opendb();
$city = nnull(utf8_urldecode(getQUERY('city')), "");
$country = getQUERY("country");
$elevation = nnull(utf8_urldecode(getQUERY('elevation')), "");
$fullname = nnull(utf8_urldecode(getQUERY('fullname')), "");
$lon = getQUERY("lon");
$lat = getQUERY("lat");
$otime = getQUERY("otime");
$temp = getQUERY("temp");
$feelslike = getQUERY("feelslike");
$wind = getQUERY("wind");
$visibility = getQUERY("visibility");
$weather = nnull(utf8_urldecode(getQUERY("weather")), "");
$humidity = getQUERY("humidity");
$icon = nnull(utf8_urldecode(getQUERY("icon")), "");
$iconurl = nnull(utf8_urldecode(getQUERY("iconurl")), "");
$cntW = dlookup("select count(*) from weatherstations where city='" . $city . "'");
if ($cntW > 0) {
$sqlAddW = "UPDATE weatherstations set observationtime='" . $otime . "', temerature=" . $temp;
$sqlAddW .= ", feelslike=" . $feelslike . ", weather='" . $weather . "', humidity='" . $humidity;
$sqlAddW .= "', visibility=" . $visibility . ", wind=" . $wind . ", icon='" . $icon . "', iconurl='" . $iconurl . "'";
$sqlAddW .= " where city='" . $city . "'";
RunSQL($sqlAddW);
echo "update";
} else {
$sqlAddW = "INSERT INTO weatherstations (city, country, elevation, fullname, latitude, longitude, observationtime, temerature, feelslike, weather, humidity, visibility, wind, icon, iconurl) VALUES ";
$sqlAddW .= "('" . $city . "', '" . $country . "', '" . $elevation . "', '" . $fullname . "', " . $lat . ", " . $lon . ", '" . $otime . "', " . $temp . ", " . $feelslike . ", '" . $weather . "', '" . $humidity . "', " . $visibility . ", " . $wind . ", '" . $icon . "', '" . $iconurl . "')";
RunSQL($sqlAddW);
echo "insert";
}
closedb();示例6: set_time_limit
<?php
include "../include/functions.php";
include "../include/db.php";
?>
<?php
include "../include/params.php";
include "../include/dictionary2.php";
set_time_limit(0);
opendb();
$vehid = getQUERY("vehid");
$lon = getQUERY('lon');
$lat = getQUERY('lat');
$_name = nnull(utf8_urldecode(getQUERY('name')), "");
$_description = nnull(utf8_urldecode(getQUERY('description')), "");
$garminid = dlookup("select coalesce((select garminid from stopstatus where toid=" . $vehid . " order by datetime desc limit 1), 0)");
$garminid = $garminid + 1;
$sqlAddPoi = "insert into stopstatus (fromid, toid, clientid, userid, datetime, text, garminid, latitude, longitude, location) values";
$sqlAddPoi .= "(" . session("user_id") . ", " . $vehid . ", " . session("client_id") . ", " . session("user_id") . ", now(),";
$sqlAddPoi .= "'" . $_name . "', " . $garminid . ", " . $lat . ", " . $lon . ", '" . $_description . "')";
$ret = RunSQL($sqlAddPoi);
echo $garminid;
closedb();示例7: DateTimeFormat
function DateTimeFormat($date, $format)
{
return date_format(new Datetime(nnull($date, date($format))), $format);
}示例8: nnull
$pastKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId . " and Datetime >= '" . $lastDateKm . "' and Datetime <= '" . DateTimeFormat($LastDay, "Y-m-d" . " 23:59:59") . "'"), 0);
$Km = nnull(dlookup("select km from currkm where vehicleid=" . $vehId), 0);
$proKm = $pastKm + $Km;
} else {
$proKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId), 0);
}
} else {
if ($lastDateKm != "") {
if ($lastDateKm <= $dt) {
$pastKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId . " and Datetime >= '" . $lastDateKm . "' and Datetime <= '" . DateTimeFormat($dt, "Y-m-d" . " 23:59:59") . "'"), 0);
$Km = nnull(dlookup("select km from currkm where vehicleid=" . $vehId), 0);
$proKm = $pastKm + $Km;
} else {
$proKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId . " and Datetime <= '" . DateTimeFormat($dt, "Y-m-d" . " 23:59:59") . "' "), 0);
}
/*$pastKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId . " and Datetime >= '" . DateTimeFormat($lastDateKm, "Y-m-d H:i:s") . "' and Datetime <= '" . DateTimeFormat($dt, "Y-m-d" . " 23:59:59") . "'"), 0);
$Km = nnull(dlookup("select km from currkm where vehicleid=" . $vehId), 0);
$proKm = $pastKm + $Km;*/
} else {
$proKm = nnull(dlookup("select SUM(distance)/1000 from rshortreport where vehicleid=" . $vehId . " and Datetime <= '" . DateTimeFormat($dt, "Y-m-d" . " 23:59:59") . "' "), 0);
}
}
$metric = dlookup("select metric from users where id=" . session("user_id"));
if ($metric == 'mi') {
$metricvalue = 0.621371;
} else {
$metricvalue = 1;
}
closedb();
echo number_format(round($proKm * $metricvalue, 0));
exit;示例9: session_start
?>
<?php
session_start();
header("Content-type: text/html; charset=utf-8");
?>
<?php
$vehID = getQUERY("vehID");
$dt = DateTimeFormat(getQUERY("dt"), 'Y-m-d H:i:s');
$driver = nnull(getQUERY("driver"), "");
$km = getQUERY("km");
$loc = getQUERY("loc");
$liters = nnull(getQUERY("liters"), 0);
$litersLast = nnull(getQUERY("litersLast"), 0);
$price = nnull(getQUERY("price"), 0);
$pay = getQUERY("pay");
opendb();
$checkCnt = dlookup("select count(*) from fuel where vehicleid=" . $vehID . " and datetime = '" . $dt . "' and driverid=" . $driver . "\r\n\tand km = " . $km . " and price = " . $price . " and liters = " . $liters . " and literslast = " . $litersLast . " and pay = '" . $pay . "' and location = '" . $loc . "'");
if ($checkCnt == 0) {
if ($driver == "") {
RunSQL("INSERT INTO fuel (vehicleid, datetime, km, price, liters, literslast, pay, location) \r\n\t\t VALUES (" . $vehID . ", '" . DateTimeFormat($dt, "Y-m-d H:i:s") . "', " . $km . ", " . $price . ", " . $liters . ", \r\n\t\t " . $litersLast . ", '" . $pay . "','" . $loc . "')");
} else {
RunSQL("INSERT INTO fuel (vehicleid, datetime, driverid, km, price, liters, literslast, pay, location) \r\n\t\t VALUES (" . $vehID . ", '" . DateTimeFormat($dt, "Y-m-d H:i:s") . "', " . $driver . ", " . $km . ", " . $price . ", " . $liters . ", \r\n\t\t " . $litersLast . ", '" . $pay . "', '" . $loc . "')");
}
echo 1;
} else {
echo 0;
}
closedb();
exit;示例10: opendb
<?php include "../include/db.php" ?>
<?php include "../include/params.php" ?>
<?php include "../include/dictionary2.php" ?>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script>
lang = '<?php echo $cLang?>';
</script>
<?php
opendb();
$clienttypeid = dlookup("select clienttypeid from clients where id = " . session("client_id"));
$metric = nnull(dlookup("select metric from users where id = " . session("user_id")), "1");
if ($metric == 'mi') {
$value = 0.621371;
} else {
$value = 1;
}
If ($metric == "Km" or $metric == 'km') {
$unitSpeed = "Km/h";
} Else {
$unitSpeed = "mph";
}
$id = str_replace("'", "''", NNull($_GET['id'], ''));
$dsedit = query("select * from alarms where id=" . $id . " and clientid = " . Session("client_id"));
$tipotnaAlarmot = pg_fetch_result($dsedit, 0, "poiid");
?>
<script type="text/javascript">示例11: session_start
<?php
include "../include/db.php";
include "../include/functions.php";
include "../include/params.php";
include "../include/dictionary2.php";
?>
<?php
session_start();
header("Content-type: text/html; charset=utf-8");
?>
<?php
$datetime = getQUERY("dt");
$driver = nnull(getQUERY("driver"), "");
$veh = getQUERY("veh");
$km = getQUERY("km");
$type = getQUERY("type");
$loc = getQUERY("loc");
$desc = getQUERY("desc");
$comp = getQUERY("comp");
$price = getQUERY("price");
$pay = getQUERY("pay");
if (is_numeric($km) == false) {
$km = "0";
}
if (is_numeric($price) == false) {
$price = "0";
}
if ($type == 0) {
$type = "Associate";示例12: header
if (session('user_id') == "261") {
echo header('Location: ../sessionexpired/?l=' . $cLang);
}
if (!is_numeric(session('user_id'))) {
echo header('Location: ../sessionexpired/?l=' . $cLang);
}
$user_id = session("user_id");
$client_id = session("client_id");
opendb();
$dsAll = query("select defaultmap, datetimeformat, timezone, idleover, metric, cl.clienttypeid, ci.latitude, ci.longitude, cl.allowedrouting, cl.allowedfm, cl.allowedmess, cl.allowedalarms from users u left outer join clients cl on cl.id = u.clientid left outer join cities ci on ci.id = cl.cityid where u.id = " . $user_id);
$allowedrouting = pg_fetch_result($dsAll, 0, "allowedrouting");
$allowedFM = pg_fetch_result($dsAll, 0, "allowedfm");
$allowedMess = pg_fetch_result($dsAll, 0, "allowedmess");
$allowedAlarms = pg_fetch_result($dsAll, 0, "allowedalarms");
$vh = nnull(getQUERY("v"), "0");
$mins = nnull(getQUERY("mins"), "0");
$DefMap = pg_fetch_result($dsAll, 0, "defaultmap");
$clientUnit = pg_fetch_result($dsAll, 0, "metric");
//$DefMap = "GOOGLEM";
$CPosition = "";
$strLon = "";
$strLat = "";
$AllowedMaps = "";
$MinMin = 1;
$strTaxi = "";
$strPas = "";
$sLon = "21.432767";
$sLat = "41.996434";
$isEmpty = 0;
$cntIgn = dlookup("select count(portname) from vehicleport where vehicleid=" . $vh . " and porttypeid=1");
if ($cntIgn == 0) {示例13: query
$sql_ .= "left outer join vehicles v on v.id=hl.vehicleid ";
$sql_ .= "where hl.datetime='" . $dat . "' and hl.vehicleid=" . $vehID;
//$strLM = "select status, latitude, longitude, speed, " . $ign . " ignition, location, poinames, poiids from historylog where datetime='" . $dat . "' and vehicleid=" . $vehID;
$dsH = query($sql_);
//echo "select status, latitude, longitude, speed, " . $ign . " ignition, location, poinames, poiids from historylog where datetime='" . $dat . "' and vehicleid=" . $vehID;
//exit;
$status = pg_fetch_result($dsH, 0, "status");
$speed = pg_fetch_result($dsH, 0, "speed");
$sedista = pg_fetch_result($dsH, 0, "sedista");
$location = pg_fetch_result($dsH, 0, "location");
$poiname = pg_fetch_result($dsH, 0, "poinames");
$poiids = pg_fetch_result($dsH, 0, "poiids");
$ignition = pg_fetch_result($dsH, 0, $ign);
$sLon = pg_fetch_result($dsH, 0, "longitude");
$sLat = pg_fetch_result($dsH, 0, "latitude");
$tzone = nnull(dlookup("select timezone from users where id=" . $uid), 1);
$tzone = $tzone - 1;
$DFormat1 = "dd-MM-yyyy";
//nnull(dlookup("select DateFormat from usersettings where userid=" . $uid),"dd-MM-yyyy");
$TFormat1 = "24 Hour Time";
//nnull(dlookup("select TimeFormat from usersettings where userid=" . $uid),"24 Hour Time");
$TFormat = "";
$DFormat = "";
if ($DFormat1 == "dd-MM-yyyy") {
$DFormat = "d-m-Y";
} else {
if ($DFormat1 == "yyyy-MM-dd") {
$DFormat = "Y-m-d";
} else {
$DFormat = "m-d-Y";
}示例14: dic
<td align=center style="background-color:#E5E3E3; border:1px dotted #2f5185; width:67px; color:#ff6633; font-weight:bold;"><?php dic("Fm.Delete") ?></td>
</tr>
<?php
while ($drAd=pg_fetch_array($dsAD)) {
$idDriver = $drAd["driverid"];
$cntDr = dlookup("select count(*) from drivers where ID=" . $idDriver);
$sqlDrivers = "select fullname, code from drivers where id=" . $idDriver;
$dsDrivers = query($sqlDrivers);
If ($cntDr > 0) {
//drDrivers = dsDrivers.Tables(0).Rows(0)
?>
<tr id="tr<?php echo $cnt ?>" style=" color: #2F5185; font-family: Arial,Helvetica,sans-serif; font-size: 11px; ">
<td height=25px align=left style="background-color:#fff; border:1px dotted #B8B8B8; padding-left:10px"><?php echo nnull(pg_fetch_result($dsDrivers, 0, "code"), "/") ?></td>
<td height=25px align=left style="background-color:#fff; border:1px dotted #B8B8B8; padding-left:10px; width:200px"><?php echo nnull(pg_fetch_result($dsDrivers, 0, "fullname"), "/") ?></td>
<td height=25px align=center style="background-color:#fff; border:1px dotted #B8B8B8; ">
<button id="btn<?php echo $cnt ?>" class="btn-driver" style="height:27px; margin-left:8px; margin-right:8px; width:30px" onclick="DelAllowedDriver(<?php echo $cnt ?>, <?php echo $drAd["id"] ?>)"></button>
</td>
</tr>
<?php
$cnt = $cnt + 1;
} //end if
} //end while
}
else
{
?>
<tr><td colspan=3 class="text2" style="font-style:italic"><?php dic("Fm.NoAllDrivers") ?></td></tr>
<?php示例15: dlookup
$clienttypeid = dlookup("select clienttypeid from clients where id = " . $cid);
$holidays = nnull(getQUERY("holidays"), '');
if ($holidays == 1) {
$dsNonworkingdays = query("select * from nonworkingdays where active='1' and datetime between '" . DateTimeFormat(now(), 'Y') . '-01-01' . " 00:00:00' and '" . DateTimeFormat(now(), 'Y') . '-12-31' . " 23:59:59'");
while ($drHoliday = pg_fetch_array($dsNonworkingdays)) {
$sdH = DateTimeFormat($drHoliday["datetime"], 'Y-m-d 00:00:00');
$edH = DateTimeFormat($drHoliday["datetime"], 'Y-m-d 23:59:59');
//$r = runsql("insert into test1(lastitem, dt) values ('".$sdH . " - ".$edH . "', '1900-01-01')");
$ret = query("select cachereportsparams('" . $sdH . "', '" . $edH . "', ' clientid = " . $cid . "')");
if ($clienttypeid == 2) {
$ret = query("select cachetaxiparams1('" . $sdH . "', '" . $edH . "', ' clientid = " . $cid . "')");
$ret = query("select cachetaxiparams2('" . $sdH . "', '" . $edH . "', ' clientid = " . $cid . "')");
}
}
} else {
$date = nnull(getQUERY("date"), '');
if ($date != '') {
$date = DateTimeFormat($date, 'Y-m-d');
$sd = $date . " 00:00:00";
$ed = $date . " 23:59:59";
$ret = query("select cachereportsparams('" . $sd . "', '" . $ed . "', ' clientid = " . $cid . "')");
if ($clienttypeid == 2) {
$ret = query("select cachetaxiparams1('" . $sd . "', '" . $ed . "', ' clientid = " . $cid . "')");
$ret = query("select cachetaxiparams2('" . $sd . "', '" . $ed . "', ' clientid = " . $cid . "')");
}
} else {
$dayType = getQUERY("dayType");
$from = '00:00:00';
//getQUERY("from");
$to = '23:59:59';
//getQUERY("to");