PHP convstr примеры использования

Пример #1

Файл: mod_user.php Проект: BackupTheBerlios/dep

?>
">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
  <tr class="tblhead">
    <th>&nbsp;</th>
    <th width="1%" nowrap>Zugang</th>
    <th>&nbsp;</th>
    <th width="1%">Status</th>
    <th>&nbsp;</th>
    <th width="92%">Name</th>
    <th>&nbsp;</th>
    <th width="1%" nowrap>Zugang bis</th>
  </tr>
<?php 
$_zaehler = 1;
$users = $sql->query_all("SELECT u.*, g.gruppe FROM user u LEFT JOIN gruppe g ON u.zugang=g.zugang" . ($isVerwalter ? "" : " WHERE u.eigentuemer=" . convstr($user)) . " GROUP BY u.zugang ORDER BY g.gruppe DESC, u.zugang");
foreach ($users as $_user) {
    $_trClass = "tbl" . ($_zaehler % 2 ? "First" : "Second");
    if ($_user['tmpdel']) {
        $_trClass .= "Del";
    } else {
        if ($_user['tmppass']) {
            $_trClass .= "New";
        }
    }
    echo "\n\n<!-- actionChange: " . formSubmittedValue('actionChange') . ", zugang: " . $_user['zugang'] . " (" . transformRequestValueInName($_user['zugang']) . "), formChangeZugang {$formChangeZugang} -->\n\n";
    if (formSubmittedValue('actionChange') == transformRequestValueInName($_user['zugang']) || $formChangeZugang == $_user['zugang'] && !formSubmittedValue('actionChange')) {
        ?>
  <input type="hidden" name="formChangeZugang" value="<?php 
        echo $_user['zugang'];
        ?>

Пример #2

Файл: mod_download.php Проект: BackupTheBerlios/dep

meine Dateien:
<table width="100%" border="0" cellspacing="0" cellpadding="3">
  <tr class="tblhead">
    <th width="93%">Name</th>
    <th width="1%">Gr&ouml;&szlig;e</th>
    <th>&nbsp;</th>
    <th width="1%">Datum</th>
    <th>&nbsp;</th>
    <th width="1%">verf&auml;llt</th>
    <th>&nbsp;</th>
    <th width="1%">verantwortlich</th>
  </tr>
<?php 
$_zaehler = 1;
$dateien = $sql->query_all("SELECT f.*, r.verfallsdatum AS zugriffbis, u.name AS eigentuemername FROM files f LEFT JOIN user u ON f.eigentuemer=u.zugang LEFT JOIN rechte r ON f.id=r.fileid WHERE /* r.freischalten=0 AND */ r.verfallsdatum>now() AND u.verfallsdatum>now()" . ($isVerwalter ? "" : " AND r.zugang=" . convstr($user)) . " GROUP BY f.id ORDER BY f.anzeigename");
// f.eigentuemer=".convstr($user))
foreach ($dateien as $datei) {
    $_trClass = "tbl" . ($_zaehler % 2 ? "First" : "Second");
    // der Datei : echo formatDate($sql->mktime($datei['verfallsdatum']));
    ?>
  <tr class="<?php 
    echo $_trClass;
    ?>
" valign="top">
    <td><a target="_blank" href="?area=<?php 
    echo $area;
    ?>
&getFile=<?php 
    echo $datei['name'];
    ?>

Пример #3

Файл: actions.php Проект: BackupTheBerlios/dep

<?php

/**
 * Plattform für Dokumenaustausch
 *
 * Bearbeitung Actions
 */
/**
 * Handle fileupload
 */
if ($_REQUEST['getFile']) {
    $file = $sql->query_first("SELECT * FROM files WHERE name=" . convstr($_REQUEST['getFile']));
    // $attachment = (strstr($HTTP_USER_AGENT, "MSIE")) ? "" : " attachment"; // IE 5.5 fix.
    header("Cache-control: private", true);
    // another fix for IE
    header("Content-type: application/octet-stream", true);
    header("Content-disposition: attachment; filename=" . $file['anzeigename'] . "", true);
    header("Content-transfer-encoding: binary", true);
    header("Content-length: " . $file['groesse'], true);
    // echo "huhu";
    readfile($cfgDownloaddir . $_REQUEST['getFile']);
    // $fd = fopen($cfgDownloaddir.$_REQUEST['getFile'],"rb");  fpassthru($fd); fclose($fd);
    die;
}

Пример #4

Файл: mod_rights.php Проект: BackupTheBerlios/dep

<br>
bestehende Zugriffsrechte:
<table width="100%" border="0" cellspacing="0" cellpadding="3">
  <tr class="tblhead">
    <th width="1%">&nbsp;</th>
    <th width="94%">Name</th>
    <th width="1%">Gr&ouml;&szlig;e</th>        
    <th>&nbsp;</th>
    <th width="1%">Datum</th>
    <th>&nbsp;</th>
    <th width="1%">verf&auml;llt</th>
  </tr>
<?php 
$_zaehler = 1;
$dateien = $sql->query_all("SELECT *, verfallsdatum<now() AS verfallen FROM files WHERE eigentuemer=" . convstr($user) . " ORDER BY anzeigename,datum,id");
foreach ($dateien as $datei) {
    $_trClass = "tbl" . ($_zaehler % 2 ? "First" : "Second");
    if ($datei['verfallen']) {
        $_trClass .= 'Del';
    }
    if (formSubmittedValue('actionChange') == $datei['id'] || $formChangeFile == $datei['id'] && !formSubmittedValue('actionChange')) {
        ?>
  <form method="post" action="<?php 
        echo $PHP_SELF;
        ?>
">
  <input type="hidden" name="area" value="<?php 
        echo $area;
        ?>
">

Пример #5

Файл: mod_workflow.php Проект: BackupTheBerlios/dep

 $_fileOk = $_REQUEST['fileOk'];
 $_fileNo = $_REQUEST['fileNo'];
 if (is_array($_fileOk)) {
     foreach ($_fileOk as $_key => $_val) {
         // echo "freischalten $_key => $_val <br>";
         $_recht = $sql->query_first("SELECT r.loeschen, r.tmpverfall AS tmpverfall, f.id AS f_id, f.verfallsdatum<r.tmpverfall AS file_datum_updaten FROM rechte r LEFT JOIN files f ON r.fileid=f.id WHERE r.id=" . intval($_key) . " LIMIT 1");
         // var_dump($_recht);
         if ($_recht['loeschen']) {
             // echo "delete";
             $sql->query("DELETE FROM rechte WHERE id=" . intval($_key) . " LIMIT 1");
         } else {
             // echo "freischalten";
             $sql->query("UPDATE rechte SET verfallsdatum=tmpverfall, tmpverfall='0000-00-00', freischalten=0 WHERE id=" . intval($_key) . " LIMIT 1");
             if ($_recht['file_datum_updaten']) {
                 echo "<br>";
                 $sql->query("UPDATE files SET verfallsdatum=" . convstr($_recht['tmpverfall']) . " WHERE id=" . intval($_recht['f_id']) . " LIMIT 1");
             }
         }
     }
 }
 if (is_array($_fileNo)) {
     foreach ($_fileNo as $_key => $_val) {
         // echo "löschen $_key => $_val <br>";
         $_recht = $sql->query_first("SELECT * FROM rechte WHERE id=" . intval($_key) . " LIMIT 1");
         // var_dump($_recht);
         if ($_recht['loeschen']) {
             // echo "delete";
             $sql->query("UPDATE rechte SET loeschen=0 WHERE id=" . intval($_key) . " LIMIT 1");
         } else {
             // echo "freischalten";
             $sql->query("DELETE FROM rechte WHERE id=" . intval($_key) . " LIMIT 1");

Пример #6

Файл: index.php Проект: BackupTheBerlios/dep

$PHP_SELF = basename($PHP_SELF);
set_magic_quotes_runtime(0);
include 'functions' . $cfgEndung;
include 'class.mysql' . $cfgEndung;
$sql = new Sql('localhost', 'root', '', 'bmftausch');
/**
 * User und Gruppe ermitteln
 */
$user = '******';
$user = '******';
$user = '******';
// $user = $_SERVER["PHP_AUTH_USER"];
// DB-Abfrage
$db_user = $sql->query_first("SELECT * FROM user WHERE zugang=" . convstr($user) . " LIMIT 1");
// var_dump($db_user);
$db_group = $sql->query_first("SELECT gruppe FROM gruppe WHERE zugang=" . convstr($user) . " ORDER BY gruppe DESC LIMIT 1");
// var_dump($db_group);
// Gruppe
$group = '';
if (isset($db_group) && is_array($db_group) && isset($db_group['gruppe'])) {
    $group = $db_group['gruppe'];
}
$isVerwalter = strcmp($group, 'verwalter') == 0;
/**
 * Sicht inkludieren
 */
if ($group) {
    include 'actions' . $cfgEndung;
    include 'grp_' . $group . $cfgEndung;
} else {
    include 'error_login' . $cfgEndung;

Пример #7

Файл: mod_upload.php Проект: BackupTheBerlios/dep

<br>
meine Dateien:
<table width="100%" border="0" cellspacing="0" cellpadding="3">
  <tr class="tblhead">
    <th width="1%">&nbsp;</th>
    <th width="97%">Name</th>
    <th width="1%">Gr&ouml;&szlig;e</th>
    <th>&nbsp;</th>
    <th width="1%">Datum</th>
    <th>&nbsp;</th>
    <th width="1%">verf&auml;llt</th>
  </tr>
<?php 
$_zaehler = 1;
$dateien = $sql->query_all("SELECT * FROM files WHERE eigentuemer=" . convstr($user));
foreach ($dateien as $datei) {
    $_trClass = "tbl" . ($_zaehler % 2 ? "First" : "Second");
    ?>
  <tr class="<?php 
    echo $_trClass;
    ?>
">
    <td align="center">&nbsp;</td>
    <td><a href="?area=<?php 
    echo $area;
    ?>
&getFile=<?php 
    echo $datei['name'];
    ?>
"><?php