PHP Pg, aprilchild Examples

Example #1

File: pg.php Project: aprilchild/aprilchild

 public static function get_connection()
 {
     global $_AMY_CONF;
     if (!self::$connection) {
         if ('development' == $GLOBALS['_AMY_CONF']['environment']) {
             self::$connection = pg_connect($_AMY_CONF['servers'][$_SERVER['HTTP_HOST']]);
         } else {
             self::$connection = @pg_connect($_AMY_CONF['servers'][$_SERVER['HTTP_HOST']]);
         }
     }
     return self::$connection;
 }

Example #2

File: t5c52015.php Project: sandbox-dev/jarmuvek

<?php

session_start();
require_once 'autoloader.php';
new Autoloader();
$pg = Pg::getPg();
// Kimenet tárazása
ob_start();
// Csatlakozás az adatbázishoz.
// Html példány:
$h = new Html();
// vissza link
$h->setBackRef();
// Html fejléc
$h->header("2015.  - T5C5");
$h->msgOk("2015. évi T5C5  dátumok");
$h->btnMenu(array("Átfutási idők - diagram" => "t5c52015diagram.php", "Vissza a főmenühöz" => "index.php"));
$sql = "select id, psz, ";
$sql .= "sorszam, erkezett, allapotfelvetel, reszatvetel, vegatvetel, hazaadas, megjegyzes ";
$sql .= "from jarmu_alap where ev=2015 and jarmutipus ilike 't5c5k2mod' order by sorszam";
$res = $pg->query($sql);
// Van-e visszaadott sor
$count = $res->rowCount();
if ($res) {
    if ($count) {
        echo "<table class='jmu-info-table' border=1 style='border-collapse:collapse'>";
        $h->infoTableCaption("2015. évi T5C5 kocsik");
        echo "<tr>\r\n    <th>Pályaszám</th>\r\n    <th>Sorszám</th>\r\n    <th>Érkezett</th>\r\n    <th>Állapotfelvétel</th>\r\n    <th>Részátvétel</th>\r\n    <th>Végátvétel</th>\r\n    <th>Hazaadás</th>\r\n    <th>Megjegyzés</th>\r\n    </tr>";
        while ($row = $res->fetch(PDO::FETCH_BOTH)) {
            echo "<tr onclick=jmuInfo({$row['0']});>\r\n      <td class='tdc5p'>{$row['1']}</td>\r\n      <td class='tdc5p'>{$row['2']}</td>\r\n      <td class='tdc5p'>{$row['3']}</td>\r\n      <td class='tdc5p'>{$row['4']}</td>\r\n      <td class='tdc5p'>{$row['5']}</td>\r\n      <td class='tdc5p'>{$row['6']}</td>\r\n      <td class='tdc5p'>{$row['7']}</td>\r\n      <td class='tdc5p'>{$row['8']}</td>\r\n      </tr>";
        }

Example #3

File: func.php Project: hezrul/seashell

function papar_upload($name, $id_upload, $action = '')
{
    global $key;
    if ($action != '') {
        ?>
                  
    <table border="0">
        <tr>
            <td><input type="file" name="<?php 
        echo $name;
        ?>
" id="<?php 
        echo $name;
        ?>
" /></td>
            <td>
                <?php 
        if (chk($id_upload) != '') {
            $src = Db::table_display('fw_uploads', 'nama,link', "id='" . chk($id_upload) . "'");
            ?>
                        <div class="input-group">
                            <input type="text" class="form-control" value="<?php 
            echo $src['nama'];
            ?>
">
                            <div class="input-group-addon"><a href="action.dload?id=<?php 
            echo emenu($key, $id_upload);
            ?>
" target="_blank"><i class="i-file-download" title="Download"></i></a></div>
                            <div class="input-group-addon"><a href="<?php 
            echo $action . "&id_upload={$id_upload}";
            ?>
 "><i class="i-file-remove" title="Remove"></i></a></div>
                        </div>            
                        <?php 
        }
        ?>
            </td>
        </tr>
    </table>      
    <?php 
    } else {
        if (chk($id_upload) != '') {
            $src = Pg::table_display('fw_uploads', 'nama,link', "id='" . chk($id_upload) . "'");
            ?>
                <div class="input-group">
                    <input type="text" class="form-control" value="<?php 
            echo $src['nama'];
            ?>
">
                    <div class="input-group-addon"><a href="action.dload?id=<?php 
            echo emenu($key, $id_upload);
            ?>
" target="_blank"><i class="i-file-download" title="Download"></i></a></div>
                </div>            
                <?php 
        }
    }
}