PHP Head::setTitle方法代码示例

<?php

/**
*¨[type] file
* [name] query_results.php
* [package] psa
* [since] 2010.09.22 -ok
*/
$res = unserialize($sessie->getS('psa-results'));
$sessie->unsetS('psa-results');
$html = new Page();
$html->setLanguage('nl_NL');
$html->build();
$head = new Head();
$head->setCharset('UTF-8');
$head->setTitle('PSA - query results');
$head->setCss('./css/psa.css');
$head->setJs('./js/PSA.js');
$head->build();
$body = new Body();
$body->build();
include_once './inc/menubar.php';
$body->line('Executed query : <br />');
$body->line('<p class="qs">' . $sessie->getS('psa-query-results') . '<hr />');
$sessie->unsetS('psa-query-results');
$titles = FALSE;
if (!$res) {
    $body->line('no further feedback');
} else {
    $table = new Table();
    $table->setClas('result');

    $col[] = $item->name;
}
if ($pk) {
    $q = "SELECT * FROM " . $req->get('table') . " WHERE id = " . $req->get('id');
} else {
    $q = "SELECT * FROM " . $req->get('table') . " WHERE ROWID = " . $req->get('id');
}
$sql->qo($q);
$res = $sql->fo_one();
// var_dump($res);
$html = new Page();
$html->setLanguage('nl_NL');
$html->build();
$head = new Head();
$head->setCharset('UTF-8');
$head->setTitle('PSA - edit record');
$head->setCss('./css/psa.css');
$head->build();
$body = new Body();
$body->build();
include_once './inc/menubar.php';
$form = new Form();
$form->setAction('controller.php');
$form->build();
$table = new Table();
$table->build();
$i = 0;
$inp = new Input();
$inp->setName('data_id');
$inp->setValue($req->get('id'));
$inp->setType('hidden');

                return view('website.packages', ['package' => false]);
            }
        }
    }
});
Route::get('/team', function () {
    Head::setTitle('Team');
    return view('website.team');
});
Route::get('/wiki/{path?}', function ($path = 'index') {
    if ($path == 'index') {
        Head::setTitle('Wiki');
    } else {
        $path = preg_replace('/\\/$/', '', $path);
        Head::setTitle('Wiki: ' . ucfirst(preg_replace('/^.*\\//', '', $path)));
    }
    // return the requested wiki page or a 404 if it doesn't exist
    if (file_exists(base_path() . '/resources/views/wiki/' . $path . '.md.blade.php')) {
        return view('website.wiki', ['path' => $path]);
    } else {
        if (file_exists(base_path() . '/resources/views/wiki/' . $path . '/index.md.blade.php')) {
            return view('website.wiki', ['path' => $path . '/index']);
        } else {
            abort(404);
        }
    }
})->where('path', '.*');
Route::get('/downloads', function () {
    Head::setTitle('Downloads');
    return view('website.downloads');
});

 * [type] file
 * [name] tableinfo.php
 * [package] psa
 * [since] 2010.10.20
 */
$sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . '');
$q = "PRAGMA table_info('" . $req->get('table') . "')";
$sql->qo($q);
$res = $sql->fo();
// var_dump($res);
$html = new Page();
$html->setLanguage('nl_NL');
$html->build();
$head = new Head();
$head->setCharset('UTF-8');
$head->setTitle('PSA - show table info for ' . $req->get('table'));
$head->setCss('./css/psa.css');
$head->setJs('./js/PSA.js');
$head->build();
$body = new Body();
$body->build();
include_once './inc/menubar.php';
$body->line('<h3>Structure for table : <b>' . $req->get('table') . '</b></h3>');
$table = new Table();
$table->setClas('result');
$table->setId('listing');
$table->build();
$th = new Th();
$th->add('name');
$th->add('type');
$th->add('size');

        $col[] = $item->name;
    }
}
if ($pk) {
    $q = "SELECT * FROM " . $req->get('table') . " ";
} else {
    $q = "SELECT ROWID as id,* FROM " . $req->get('table') . "  ";
}
$sql->qo($q);
$res = $sql->fo();
$html = new Page();
$html->setLanguage('nl_NL');
$html->build();
$head = new Head();
$head->setCharset('UTF-8');
$head->setTitle('PSA - csv');
$head->setCss('./css/psa.css');
$head->setjs('./js/PSA.js');
$head->build();
$body = new Body();
$body->build();
include_once './inc/menubar.php';
$body->line('<h3>Table : ' . $req->get('table') . '</h3>');
$odd = FALSE;
if (!$res) {
    $body->line('Table does not contain records');
} else {
    $resultset = '';
    $string = '';
    foreach ($res as $item) {
        $linear = (array) $item;

    }
}
$submit->setValue('Let\'s go');
$inp_naam = new Input();
$inp_naam->setName('name');
$inp_naam->setSize(20);
$inp_naam->setAutofocus(true);
$inp_pass = new Input();
$inp_pass->setName('geheim');
$inp_pass->setType('password');
$inp_pass->setSize(20);
$html = new Page();
$html->setLanguage('nl-nl');
$html->build();
$head = new Head();
$head->setTitle('PSA - login');
$head->setCss('./css/psa.css');
$head->setJs('./js/PSA.js');
$head->build();
$body = new Body();
$body->build();
$body->line('<h3>PHP SQLite Admin tool - log in</h3>');
$form = new Form();
$form->setAction('login.php');
$form->build();
$table = new Table();
$table->build();
$tr = new Tr();
$tr->add('Login');
$tr->add($inp_naam->dump());
$tr->build();

        header('location: controller.php');
        exit;
    } else {
        include_once './module/' . $req->get('cmd') . '.php';
    }
} else {
    $sessie->unsetS('psa-dir');
    $sessie->unsetS('psa-ext');
    $sessie->unsetS('psa-db');
    $cmd->setValue('base');
    $submit->setValue('Go');
    $html = new Page();
    $html->setLanguage('nl_NL');
    $html->build();
    $head = new Head();
    $head->setTitle('PSA - homepage');
    $head->setCss('./css/psa.css');
    $head->setJs('./js/PSA.js');
    $head->build();
    $body = new Body();
    $body->build();
    include_once './inc/menubar.php';
    $body->line('
	<p>Databases will be selected based on the preset directory and extension.
	Currently the following are stored : </p>');
    include_once './forms/form_base.php';
    $body->line('<hr />
	<p>PSA stands for PHP - SQLite - Administration. This application lets you
	do the basic operations with SQLite3 databases. The current version only
	supports the very basics. Check <a href="controller.php?cmd=bts">[here]</a> for
	more information.</p>

    unset($psa);
}
$sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . '');
// var_dump($sql);
$q = "SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY name";
// echo $q;
// $sql->qo('PRAGMA table_info('.$req->get('name').')');
$sql->qo($q);
$res = $sql->fo();
// unset($sql);
$html = new Page();
$html->setLanguage('nl_NL');
$html->build();
$head = new Head();
$head->setCharset('UTF-8');
$head->setTitle('PSA - show tables');
$head->setCss('./css/psa.css');
$head->setjs('./js/PSA.js');
$head->build();
$body = new Body();
$body->build();
include_once './inc/menubar.php';
$body->line();
$link = new Link();
$link->setHref('controller.php?cmd=table_add');
$link->setClas('butter');
$link->setName('Add table');
$link->build();
$body->line('<hr>');
if (!$res) {
    $body->line('No tables defined.');

$submit->setValue('Create');
$cmd->setValue('index_add_do');
$sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . '');
$fields = array();
$q = "PRAGMA table_info('" . $req->get('table') . "')";
$sql->qo($q);
$res = $sql->fo();
foreach ($res as $item) {
    $fields[] = $item->name;
}
$html = new Page();
$html->setLanguage('nl_NL');
$html->build();
$head = new Head();
$head->setCharset('UTF-8');
$head->setTitle('PSA - create index');
$head->setCss('./css/psa.css');
$head->setJs('./js/PSA.js');
$head->build();
$body = new Body();
$body->build();
include_once './inc/menubar.php';
$body->line("Index creation on table : <b>" . $req->get('table') . "</b><br>");
$form = new Form();
$form->setAction('controller.php');
$form->setJs(' onsubmit="return PSA.indexcol();" ');
$form->build();
// TODO: check if table name already exists
$name = new Input();
$name->setName('idxname');
$name->setSize(50);

<?php

/**
* [type] file
* [name] bts.php
* [package] psa
* [since] 2011.02.10
* [expl] documentation avant la lettre - Behind The Screens
*/
$html = new Page();
$html->setLanguage('nl_NL');
$html->build();
$head = new Head();
$head->setCharset('UTF-8');
$head->setTitle('PSA - connection');
$head->setCss('./css/psa.css');
$head->setJs('./js/PSA.js');
$head->build();
$body = new Body();
$body->build();
include_once './inc/menubar.php';
$body->line('<div class="xemel">');
$xml = simplexml_load_file('./inc/bts.xml');
// menu
foreach ($xml->item->caption as $cap) {
    $link = new Link();
    // $link->setHref('#'.$cap->name);
    $body->line('<a href="#' . $cap->name . '" >' . $cap->name . '</a><br />');
}
$body->line('<hr />');
// content

}
// PAGING
if (!$sessie->isS('bottom')) {
    $sessie->setS('bottom', 0);
}
$sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . '');
$q = "SELECT name FROM sqlite_master WHERE type = 'table' ORDER BY name";
$sql->qo($q);
$res = $sql->fo();
// echo "BOTTOM WAARDE  : <b><h1>".$sessie->getS('bottom')."</h1></b>";
$html = new Page();
$html->setLanguage('nl_NL');
$html->build();
$head = new Head();
$head->setCharset('UTF-8');
$head->setTitle('PSA - database schema');
$head->setCss('./css/psa.css', 'screen');
$head->setCss('./css/psaprint.css', 'print');
$head->setjs('./js/PSA.js');
$head->build();
$body = new Body();
$body->build();
include_once './inc/menubar.php';
if (!$res) {
    $body->line('no tables defined yet');
} else {
    foreach ($res as $item) {
        $body->line('<div class="schema"><h3>' . $item->name . '</h3>');
        $q_fields = "PRAGMA table_info('" . $item->name . "')";
        $sql->qo($q_fields);
        $res_fields = $sql->fo();

* [package] psa
* [since] 2011.02.10
*/
// $req->dump();
// begin with a fresh state
$base_sql = new LitePDO('sqlite:./data/base.sqlite');
$base_q = "DELETE FROM temp_table_fields";
$base_sql->qo($base_q);
unset($base_sql);
$sql = new LitePDO('sqlite:' . $sessie->getS('psa-dir') . '/' . $sessie->getS('psa-db') . '.' . $sessie->getS('psa-ext') . '');
$html = new Page();
$html->setLanguage('nl_NL');
$html->build();
$head = new Head();
$head->setCharset('UTF-8');
$head->setTitle('PSA - add table');
$head->setCss('./css/psa.css');
$head->setJs('./js/PSA.js');
$head->build();
$body = new Body();
$body->build();
include_once './inc/menubar.php';
// TODO: check if table name already exists
$name = new Input();
$name->setName('tblname');
$name->setSize(50);
$name->setMaxlength(128);
$name->setId('tblname');
$body->line('<span class="vet">Table name</span><br /> ');
$body->line($name->dump());
$create = new Link();

if (!$sessie->isS('psa-db')) {
    if ($req->get('db')) {
        $sessie->setS('psa-db', urldecode($req->get('db')));
    } else {
        $sessie->setS('psa-error', 'No database set.');
        header('location: controller.php?cmd=base');
        exit;
    }
}
$cmd->setValue('qs');
$submit->setValue('Go!');
$html = new Page();
$html->setLanguage('en_EN');
$html->build();
$head = new Head();
$head->setTitle('PSA - query');
$head->setCss('./css/psa.css');
$head->setJs('./js/PSA.js');
$head->build();
$body = new Body();
$body->build();
include_once './inc/menubar.php';
$body->line('Insert raw sql query : ');
$form = new Form();
$form->setAction('controller.php');
$form->build();
$inp_text = new Textarea();
$inp_text->setRows(15);
$inp_text->setCols(70);
$inp_text->setName('qs');
$inp_text->setId('to_text');