Ejemplo n.º 1
0
function addZimmerModal($hotelid, $hotelname)
{
    $zarray = array("Zimmer-ID", "m<sup>2</sup>", "Typ", "Bettenzahl", "Preisfaktor");
    echo '<div>
			<div id="' . $hotelid . '" class="modalDialog2">
				<div>
					<a href="#close" title="Close" class="close">X</a>
					<h2>' . $hotelname . ' (' . getHotelZimmerzahl($hotelid, TRUE) . ' gesamt)</h2>
					
					<table id="myTable" class="tablesorter">
						<thead>
							<tr>
								';
    echo addTable($zarray, 2);
    echo '
							</tr>
						</thead>
						<tbody>
								';
    echo getZimmerTableData($hotelid);
    echo '					
						</tbody>
					</table>
					<input type="button" class="popup" name="neuesZimmer" value="neues Zimmer hinzufügen" onclick=\'window.location.href = "../phpdata/zimmerHinzufuegen.php?0=' . $hotelid . '#openModal"\'/>
				</div>
			</div>
		</div>';
}
Ejemplo n.º 2
0
 static function sqlInstall()
 {
     global $sql_tables;
     foreach ($sql_tables as $table => &$query) {
         if (self::tableExists($table) === true) {
             continue;
         } else {
             addTable($table);
         }
     }
 }
Ejemplo n.º 3
0
    } else {
        if ($_POST['view'] === 'add') {
            echo '<div class="form-group">';
            echo sprintf('<label for="%s">%s</label>', $key, $key);
            echo sprintf('<input type="%s" name="%s" class="form-control" maxlength="%s" %s>', $type, $key, $maxLength, $required);
            echo '</div>';
        } else {
            echo '<div class="form-group">';
            echo sprintf('<label for="%s">%s</label>', $key, $key);
            echo sprintf('<input type="%s" name="%s" class="form-control" maxlength="%s" %s>', $type, $key, $maxLength, $required);
            echo '</div>';
        }
    }
}
if (isset($_POST['add'])) {
    if (addTable()) {
        $path = sprintf('location: ' . HTTP_PATH . 'public/views/%s.php', $_POST['page']);
        header($path);
    } else {
        echo 'something went wrong!';
    }
    var_dump($_POST);
    die;
}
if (isset($_POST['edit'])) {
    if (editTable()) {
        $path = sprintf('location: ' . HTTP_PATH . 'public/views/%s.php', $_POST['page']);
        unset($_POST['edit']);
        header($path);
        die;
    } else {
Ejemplo n.º 4
0
						<?php 
genMenu();
?>
					</div>

					<div class="container2" >
						<div class="ueberschrift">
							<p style="font-size:20px;">
								Hotels
							</p>
							<div class="flugLabel">
								<table id="myTable" class="tablesorter">
									<thead>
										<tr>
											<?php 
addTable($larray, 2);
?>
										</tr>
									</thead>
									<tbody>
										<?php 
addTableData();
?>
									</tbody>
								</table>
							</div>
						</div>
						<?php 
addZimmer();
?>
						<div class="clear"></div>
}
### Dispatch actions
$action = getRequestedAction();
if (!$action || $action == 'listTables') {
    if (@$_REQUEST['newOrder']) {
        updateMenuOrder();
    }
    if (@$action == '' && !alert()) {
        createMissingSchemaTablesAndFields();
    }
    // skip if action specified or alerts, such as when user is redirected back to this page
    showInterface('database/listTables.php');
} elseif ($action == 'addTable') {
    include "lib/menus/database/addTable.php";
} elseif ($action == 'addTable_save') {
    addTable();
} elseif ($action == 'editTable') {
    include "lib/menus/database/editTable.php";
} elseif ($action == 'adminHome') {
    showInterface('admin/home.php');
} elseif ($action == 'recreateThumbnails') {
    recreateThumbnails();
} elseif ($action == 'previewDefaultDate') {
    previewDefaultDate();
} else {
    alert("Unknown action '" . htmlencode($action) . "'");
    showInterface('admin/home.php');
}
//
function updateMenuOrder()
{
Ejemplo n.º 6
0
						<?php 
genMenu();
?>
					</div>

					<div class="container2" >
						<div class="ueberschrift">
							<p style="font-size:20px;">
								Autos
							</p>
							<div class="flugLabel">
								<table id="myTable" class="tablesorter">
									<thead>
										<tr>
											<?php 
addTable($larray);
?>
											<th></th>
											<th></th>
										</tr>
									</thead>
									<tbody>
										<?php 
addTableData();
?>
									</tbody>
								</table>
							</div>
						</div>
						<div class="clear"></div>
					</div>
Ejemplo n.º 7
0
function migrate($options)
{
    if (!isset($options['action'])) {
        die("Usage: php zombie.php migrate action=<action>\n" . "Actions:\n" . "\tadd-column\n" . "\tadd-table\n" . "\tapply\n" . "\tnew\n" . "\trun\n");
    }
    if ($options['action'] == "apply") {
        applyMigration($options['name']);
    } else {
        if ($options['action'] == "run") {
            runMigrations();
        } else {
            if ($options['action'] == "new") {
                if (!isset($options['name'])) {
                    die("Usage: php zombie.php migrate action=new name=<name>\n");
                }
                newMigration($options['name']);
            } else {
                if ($options['action'] == "add-table") {
                    if (!isset($options['name']) || !isset($options['table'])) {
                        die("Usage: php zombie.php migrate action=add-table name=<name> table=<table>\n");
                    }
                    addTable($options['name'], $options['table']);
                } else {
                    if ($options['action'] == "add-column") {
                        if (!isset($options['name']) || !isset($options['table']) || !isset($options['column']) || !isset($options['type'])) {
                            die("Usage: php zombie.php migrate action=add-column name=<name> " . "table=<table> column=<column> type=<type> [extra=<extra>]\n");
                        }
                        if (!isset($options['extra'])) {
                            $options['extra'] = '';
                        }
                        addColumn($options['name'], $options['table'], $options['column'], $options['type'], $options['extra']);
                    } else {
                        die("Error: Unkown action '" . $options['action'] . "'.\n");
                    }
                }
            }
        }
    }
}
Ejemplo n.º 8
0
genMenu();
?>
					</div>

					<div class="container2" >
						<div class="ueberschrift">
							<p style="font-size:20px;">
								Fl&uuml;ge
							</p>
							<div class="flugLabel">
								<table id="myTable" class="tablesorter">
									<thead>
										<tr>
											<!--Tabelle einfügen(Überschriften, leere Spalten)-->
											<?php 
addTable($larray, 0);
?>
										</tr>
									</thead>
									<tbody>
										<?php 
addTableData();
?>
									</tbody>
								</table>
							</div>
						</div>
						<div class="clear"></div>
					</div>
					<div>
						<a class="button" href="#openModal">neuen Flug hinzufügen</a>
Ejemplo n.º 9
0
ini_set('display_errors', 'On');
// connect to db server
$connection = @mysql_connect($config["host"]["name"], $config["host"]["user"], $config["host"]["password"]) or die('Couldn\'t connect: ' . mysql_error());
// create a new database
if (createDB($connection, $config["db"]["name"]) == "") {
    // select this database
    if (mysql_select_db($config["db"]["name"])) {
        //
        // initial setup
        //
        // get some information about the database environment
        echo "<h2>Displaying databases</h2>";
        listDBTables($connection);
        // create tables
        foreach ($db_schema as $table => $keys) {
            $tableResult = addTable($connection, $table, $keys);
            // if there's an error, show it
            if ($tableResult) {
                echo $tableResult;
            }
        }
        // populate tables
        foreach ($db_data as $table => $items) {
            $tableResult = populateTable($connection, $table, $items);
            // if there's an error, show it
            if ($tableResult) {
                echo $tableResult;
            }
        }
        // display the tables on screen so we can see they were created
        echo "<h2>Showing script-created tables</h2>";