本文整理汇总了PHP中cln函数的典型用法代码示例。如果您正苦于以下问题:PHP cln函数的具体用法?PHP cln怎么用?PHP cln使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了cln函数的13个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: cln
if (isset($_POST['delete']) and $_POST['delete'] == 'Cancel') {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$fstvl_id = cln($_POST['fstvl_id']);
$sql = "SELECT fstvl_url FROM fstvl WHERE fstvl_id='{$fstvl_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error acquiring festival URL: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
header('Location: ' . $row['fstvl_url']);
exit;
}
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$fstvl_url = cln($_GET['fstvl_url']);
$sql = "SELECT fstvl_id FROM fstvl WHERE fstvl_url='{$fstvl_url}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error checking that URL has given valid data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
$fstvl_id = $row['fstvl_id'];
if (mysqli_num_rows($result) == 0) {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/404.html.php';
} else {
$sql = "SELECT fstvl_nm FROM fstvl WHERE fstvl_id='{$fstvl_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
示例2: cln
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/includes/helpers.inc.php';
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$awrd_yr = cln($_GET['awrd_yr']);
if ($awrd_yr < 1000 || $awrd_yr > 9999) {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/404.html.php';
} else {
if ($awrd_yr > 1000) {
$awrd_yr_lst = '<a href="/awards/year/' . html($awrd_yr - 1) . '">' . html($awrd_yr - 1) . '</a>';
} else {
$awrd_yr_lst = NULL;
}
if ($awrd_yr < 9999) {
$awrd_yr_nxt = '<a href="/awards/year/' . html($awrd_yr + 1) . '">' . html($awrd_yr + 1) . '</a>';
} else {
$awrd_yr_nxt = NULL;
}
$pagetitle = html($awrd_yr);
$sql = "SELECT awrds_nm, awrds_url, awrd_yr, awrd_yr_end, awrd_yr_url, DATE_FORMAT(awrd_dt, '%d %b %Y') AS awrd_dt_dsply, COALESCE(awrds_alph, awrds_nm)awrds_alph, thtr_fll_nm\n FROM awrd\n INNER JOIN awrds ON awrdsid=awrds_id\n LEFT OUTER JOIN thtr ON thtrid=thtr_id\n WHERE awrd_yr='{$awrd_yr}' OR awrd_yr_end='{$awrd_yr}'\n ORDER BY awrd_dt DESC, awrds_alph ASC";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error acquiring award categories (for display) data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
while ($row = mysqli_fetch_array($result)) {
if (preg_match('/TBC$/', $row['thtr_fll_nm'])) {
$thtr = '<em>' . html($row['thtr_fll_nm']) . '</em>';
} else {
$thtr = html($row['thtr_fll_nm']);
示例3: cln
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/includes/helpers.inc.php';
include $_SERVER['DOCUMENT_ROOT'] . '/includes/feature/index.inc.php';
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$ftr_url = cln($_GET['ftr_url']);
$sql = "SELECT ftr_id FROM ftr WHERE ftr_url='{$ftr_url}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error checking that URL has given valid data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
$ftr_id = $row['ftr_id'];
if (mysqli_num_rows($result) == 0) {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/404.html.php';
} else {
$sql = "SELECT ftr_nm FROM ftr WHERE ftr_id='{$ftr_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error acquiring feature data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
$pagetitle = html($row['ftr_nm']);
$sql = "SELECT 1 FROM ptftr WHERE ftrid='{$ftr_id}' LIMIT 1";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error checking for existence of feature for playtext: ' . mysqli_error($link);
示例4: cln
if (isset($_POST['delete']) and $_POST['delete'] == 'Cancel') {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$thtr_typ_id = cln($_POST['thtr_typ_id']);
$sql = "SELECT thtr_typ_url\n FROM thtr_typ\n WHERE thtr_typ_id='{$thtr_typ_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error acquiring theatre type URL: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
header('Location: ' . $row['thtr_typ_url']);
exit;
}
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$thtr_typ_url = cln($_GET['thtr_typ_url']);
$sql = "SELECT thtr_typ_id\n FROM thtr_typ\n WHERE thtr_typ_url='{$thtr_typ_url}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error checking that URL has given valid data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
$thtr_typ_id = $row['thtr_typ_id'];
if (mysqli_num_rows($result) == 0) {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/404.html.php';
} else {
$sql = "SELECT thtr_typ_nm FROM thtr_typ WHERE thtr_typ_id='{$thtr_typ_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
示例5: cln
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/includes/helpers.inc.php';
include $_SERVER['DOCUMENT_ROOT'] . '/includes/genre/index.inc.php';
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$gnr_url = cln($_GET['gnr_url']);
$sql = "SELECT gnr_id FROM gnr WHERE gnr_url='{$gnr_url}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error checking that URL has given valid data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
$gnr_id = $row['gnr_id'];
if (mysqli_num_rows($result) == 0) {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/404.html.php';
} else {
$sql = "SELECT gnr_nm FROM gnr WHERE gnr_id='{$gnr_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error acquiring genre data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
$pagetitle = html($row['gnr_nm']);
$gnr_nm = html($row['gnr_nm']);
$sql = "SELECT 1 FROM prdgnr WHERE gnrid='{$gnr_id}'\n UNION\n SELECT 1 FROM rel_gnr INNER JOIN prdgnr ON rel_gnr1=gnrid WHERE rel_gnr2='{$gnr_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
示例6: html
}
if (strlen($wri_prsn_fll_nm) > 255 || strlen($wri_prsn_url) > 255) {
$wri_prsn_errors++;
$errors['wri_prsn_excss_lngth'] = '</br>**Writer (person) name and its URL are allowed a maximum of 255 characters each. Please amend entries that exceed this amount.**';
}
} else {
$wri_prsn_errors++;
$wri_prsn_smcln_err_arr[] = $wri_prsn_nm;
$errors['wri_prsn_smcln'] = '</br>**You must assign a given name and family name to the following using [;;]: ' . html(implode(' / ', $wri_prsn_smcln_err_arr)) . '.**';
}
if ($wri_prsn_errors == 0) {
$wri_prsn_frst_nm_cln = cln($wri_prsn_frst_nm);
$wri_prsn_lst_nm_cln = cln($wri_prsn_lst_nm);
$wri_prsn_fll_nm_cln = cln($wri_prsn_fll_nm);
$wri_prsn_sffx_num_cln = cln($wri_prsn_sffx_num);
$wri_prsn_url_cln = cln($wri_prsn_url);
$sql = "SELECT prsn_frst_nm, prsn_lst_nm, prsn_sffx_num\n FROM prsn\n WHERE NOT EXISTS (SELECT 1 FROM prsn WHERE prsn_frst_nm='{$wri_prsn_frst_nm_cln}' AND prsn_lst_nm='{$wri_prsn_lst_nm_cln}')\n AND prsn_fll_nm='{$wri_prsn_fll_nm_cln}' AND prsn_sffx_num='{$wri_prsn_sffx_num_cln}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error checking for writer person full name with assigned given name and family name: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
if (mysqli_num_rows($result) > 0) {
if ($row['prsn_sffx_num']) {
$wri_prsn_nm_error_sffx_dsply = '--' . $row['prsn_sffx_num'];
} else {
$wri_prsn_nm_error_sffx_dsply = '';
}
$wri_prsn_nm_err_arr[] = $row['prsn_frst_nm'] . ';;' . $row['prsn_lst_nm'] . $wri_prsn_nm_error_sffx_dsply;
示例7: cln
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/includes/helpers.inc.php';
include $_SERVER['DOCUMENT_ROOT'] . '/includes/profession/index.inc.php';
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$prof_url = cln($_GET['prof_url']);
$sql = "SELECT prof_id FROM prof WHERE prof_url='{$prof_url}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error checking that URL has given valid data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
$prof_id = $row['prof_id'];
if (mysqli_num_rows($result) == 0) {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/404.html.php';
} else {
$sql = "SELECT prof_nm, prof_url FROM prof WHERE prof_id='{$prof_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error acquiring profession data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
$pagetitle = html($row['prof_nm']);
$prof_nm = html($row['prof_nm']);
$prof_url = html($row['prof_url']);
$sql = "SELECT 1 FROM prsnprof WHERE profid='{$prof_id}' UNION SELECT 1 FROM rel_prof INNER JOIN prsnprof ON rel_prof1=profid WHERE rel_prof2='{$prof_id}' LIMIT 1";
$result = mysqli_query($link, $sql);
示例8: cln
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/includes/helpers.inc.php';
include $_SERVER['DOCUMENT_ROOT'] . '/includes/time/index.inc.php';
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$tm_url = cln($_GET['tm_url']);
$sql = "SELECT tm_id FROM tm WHERE tm_url='{$tm_url}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error checking that URL has given valid data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
$tm_id = $row['tm_id'];
if (mysqli_num_rows($result) == 0) {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/404.html.php';
} else {
$sql = "SELECT tm_nm, tm_url FROM tm WHERE tm_id='{$tm_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error acquiring setting (time) data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
$pagetitle = html($row['tm_nm']);
$tm_nm = html($row['tm_nm']);
$tm_url = html($row['tm_url']);
$sql = "SELECT 1 FROM prdsttng_tm WHERE sttng_tmid='{$tm_id}'\n UNION\n SELECT 1 FROM rel_tm INNER JOIN prdsttng_tm ON rel_tm1=sttng_tmid WHERE rel_tm2='{$tm_id}'\n LIMIT 1";
$result = mysqli_query($link, $sql);
示例9: mysqli_error
if (!mysqli_query($link, $sql)) {
$error = 'Error deleting place-related place associations: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$sql = "DELETE FROM plc WHERE plc_id='{$plc_id}'";
if (!mysqli_query($link, $sql)) {
$error = 'Error deleting place: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
session_start();
$_SESSION['successclass'] = 'success';
$_SESSION['message'] = 'THIS PLACE HAS BEEN DELETED FROM THE DATABASE:' . ' ' . html($plc_nm_session);
header('Location: http://' . $_SERVER['HTTP_HOST'] . '/');
exit;
}
if (isset($_POST['delete']) and $_POST['delete'] == 'Cancel') {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$plc_id = cln($_POST['plc_id']);
$sql = "SELECT plc_url\n FROM plc\n WHERE plc_id='{$plc_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error acquiring place URL: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
header('Location: ' . $row['plc_url']);
exit;
}
示例10: cln
if (isset($_POST['delete']) and $_POST['delete'] == 'Cancel') {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$frmt_id = cln($_POST['frmt_id']);
$sql = "SELECT frmt_url FROM frmt WHERE frmt_id='{$frmt_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error acquiring format URL: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
header('Location: ' . $row['frmt_url']);
exit;
}
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$frmt_url = cln($_GET['frmt_url']);
$sql = "SELECT frmt_id FROM frmt WHERE frmt_url='{$frmt_url}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error checking that URL has given valid data: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
$frmt_id = $row['frmt_id'];
if (mysqli_num_rows($result) == 0) {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/404.html.php';
} else {
$sql = "SELECT frmt_nm FROM frmt WHERE frmt_id='{$frmt_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
示例11: generateurl
$rvw_crtc_url = generateurl($rvw_crtc_fll_nm . $rvw_crtc_sffx_rmn);
if (strlen($rvw_crtc_fll_nm) > 255 || strlen($rvw_crtc_url) > 255) {
$rvw_crtc_errors++;
$errors['rvw_crtc_fll_nm_excss_lngth'] = '</br>**Critic name and its URL are allowed a maximum of 255 characters each. Please amend entries that exceed this amount.**';
}
} else {
$rvw_crtc_errors++;
$rvw_crtc_smcln_err_arr[] = $rvw_crtc;
$errors['rvw_crtc_smcln'] = '</br>**You must assign a given name and family name to the following using [;;]: ' . html(implode(' / ', $rvw_crtc_smcln_err_arr)) . '.**';
}
if ($rvw_crtc_errors == 0) {
$rvw_crtc_frst_nm_cln = cln($rvw_crtc_frst_nm);
$rvw_crtc_lst_nm_cln = cln($rvw_crtc_lst_nm);
$rvw_crtc_fll_nm_cln = cln($rvw_crtc_fll_nm);
$rvw_crtc_sffx_num_cln = cln($rvw_crtc_sffx_num);
$rvw_crtc_url_cln = cln($rvw_crtc_url);
$sql = "SELECT prsn_frst_nm, prsn_lst_nm, prsn_sffx_num\n FROM prsn\n WHERE NOT EXISTS (SELECT 1 FROM prsn WHERE prsn_frst_nm='{$rvw_crtc_frst_nm_cln}' AND prsn_lst_nm='{$rvw_crtc_lst_nm_cln}')\n AND prsn_fll_nm='{$rvw_crtc_fll_nm_cln}' AND prsn_sffx_num='{$rvw_crtc_sffx_num_cln}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error checking for critic person full name with assigned given name and family name: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
if (mysqli_num_rows($result) > 0) {
if ($row['prsn_sffx_num']) {
$rvw_crtc_nm_error_sffx_dsply = '--' . $row['prsn_sffx_num'];
} else {
$rvw_crtc_nm_error_sffx_dsply = '';
}
$rvw_crtc_nm_err_arr[] = $row['prsn_frst_nm'] . ';;' . $row['prsn_lst_nm'] . $rvw_crtc_nm_error_sffx_dsply;
示例12: company
if (!mysqli_query($link, $sql)) {
$error = 'Error deleting company (location)-location (alternate location) associations: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$sql = "DELETE FROM lctn WHERE lctn_id='{$lctn_id}'";
if (!mysqli_query($link, $sql)) {
$error = 'Error deleting location: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
session_start();
$_SESSION['successclass'] = 'success';
$_SESSION['message'] = 'THIS LOCATION HAS BEEN DELETED FROM THE DATABASE:' . ' ' . html($lctn_nm_session);
header('Location: http://' . $_SERVER['HTTP_HOST'] . '/');
exit;
}
if (isset($_POST['delete']) and $_POST['delete'] == 'Cancel') {
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
$lctn_id = cln($_POST['lctn_id']);
$sql = "SELECT lctn_url\n FROM lctn\n WHERE lctn_id='{$lctn_id}'";
$result = mysqli_query($link, $sql);
if (!$result) {
$error = 'Error acquiring location URL: ' . mysqli_error($link);
include $_SERVER['DOCUMENT_ROOT'] . '/includes/error.html.php';
exit;
}
$row = mysqli_fetch_array($result);
header('Location: ' . $row['lctn_url']);
exit;
}
示例13: exc
if (is_numeric($curr->name[0])) {
exc('Cannot start a class name with a number', $lnum);
}
$curr->extends = trim(StringUtils::untilFirst(':', StringUtils::fromFirst('=', $d)));
$curr->implements = cln(StringUtils::fromFirst(':', $d));
$curr->ns = $ns;
} elseif ($line[0] == 'I') {
pointermove();
# Define new interface
$scope = 'interface';
$curr = new QJInterface();
$curr->name = trim(StringUtils::untilFirst(':', $d));
if (is_numeric($curr->name[0])) {
exc('Cannot start a interface name with a number', $lnum);
}
$curr->extends += cln(trim(StringUtils::fromFirst(':', $d)));
$curr->ns = $ns;
} elseif ($line[0] == 'E') {
pointermove();
$scope = 'enum';
$curr = new QJEnum();
$curr->name = trim($d);
if (is_numeric($curr->name[0])) {
exc('Cannot start an enum name with a number', $lnum);
}
$curr->ns = $ns;
} elseif ($line[0] == 'F') {
# Must be inside a class, interface or enum
if ($scope == 'class' || $scope == 'interface' || $scope == 'enum') {
# Define new method
$m = new QJMethod();