function wrconf() { $Host = $_REQUEST['host']; $User = $_REQUEST['username']; $Pass = $_REQUEST['password']; $Name = $_REQUEST['nama']; createDB($Host, $User, $Pass, $Name); // Buka template $tpl = "./install/connectdb.php.txt"; if (file_exists($tpl)) { $ft = fopen($tpl, 'r'); $tpldb = fread($ft, filesize($tpl)); fclose($ft); // Buka file konfigurasi $file = "./config/connectdb.php"; $f = fopen($file, "w"); $_t = $tpldb . chr(12); $_t = str_replace('~Host~', $Host, $_t); $_t = str_replace('~User~', $User, $_t); $_t = str_replace('~Pass~', $Pass, $_t); $_t = str_replace('~Name~', $Name, $_t); // tulis fwrite($f, $_t); fclose($f); Berhasil($User, $Pass, $Host, $Name); } else { echo "failed"; } }
function importDB($connection, $name, $file, $dbs) { // initialize $returnValue = ""; $sql = ""; if (!in_array($name, $dbs)) { createDB($connection, $name); } mysql_select_db($name, $connection); // start reading in the file, if it exists $lines = file($file); foreach ($lines as $line) { if (strlen($line) > 1) { // to avoid blank lines $sql .= ltrim(rtrim($line)); // if we've found a semi-colon it's time to execute if (strpos($sql, ";")) { if (!mysql_query($sql, $connection)) { // rule out DROP calls to nonexistant tables $error = mysql_error(); if (!stristr($error, "Unknown table")) { $returnValue .= $error; } } $sql = ""; } } } // return any errors encountered if ($returnValue) { return 'Error importing database: ' . $returnValue; } }
function connectAndSelectDB() { // Gets the DB config global $dbName, $dbServer, $dbUser, $dbPassword; // Connects to the DB server mysql_connect($dbServer, $dbUser, $dbPassword); // Selects the relevant DB if (!mysql_select_db($dbName)) { if (mysql_errno() == 1049) { // Selection failed because the DB does not exist // Calls the createDB function createDB(); } else { // Selection failed because of other error echo "Could not select DB"; } } }
function init() { createDB(); createTable_USER(); }
$saldo = isset($data->saldo) ? $data->saldo : "0"; $observacoes = isset($data->observacoes) ? $data->observacoes : "0"; $link = createDB(); $sql = "UPDATE trabalho SET crianca_id = " . $crianca_id . ", valor = " . $valor . ", parcelas = " . $parcelas . ", saldo = " . $saldo . ", observacoes = '" . $observacoes . "' WHERE id = " . $idTrabalho . ";"; $result = mysql_query($sql, $link); if (mysql_errno($link) > 0) { echo json_encode(array("erro" => true, "mysql_errno" => mysql_errno($link), "mysql_error" => mysql_error($link), "sql" => $sql)); } else { if ($result) { echo json_encode(array("erro" => false)); } } mysql_close($link); }); // Delete $app->get('/excluirTrabalho/:idTrabalho', 'auth', function ($idTrabalho) use($app) { $idTrabalho = (int) $idTrabalho; $link = createDB(); $sql = "DELETE FROM Trabalho WHERE id = " . $idTrabalho . ";"; $result = mysql_query($sql, $link); if (mysql_errno($link) > 0) { echo json_encode(array("erro" => true, "mysql_errno" => mysql_errno($link), "mysql_error" => mysql_error($link), "sql" => $sql)); } else { if ($result) { echo json_encode(array("erro" => false)); } } mysql_close($link); }); // fim Crud Trabalho $app->run();
<?php include_once '../arc/ARC2.php'; $DEBUG = false; if (isset($_GET['cmd'])) { $cmd = $_GET['cmd']; if ($cmd == "create-db") { echo createDB(); } else { if ($cmd == "create-store") { createStore(); } else { echo "<p>Sorry, I didn't understand the command ...</p>"; } } } function createDB() { global $DEBUG; $host = urldecode($_GET['host']); $name = $_GET['name']; $user = $_GET['user']; $pwd = $_GET['pwd']; $ret = "<p>"; $dbExists = false; $con = mysql_connect($host, $user, $pwd); // try to connect if (!$con) { die('Could not connect: ' . mysql_error()); } $dblist = mysql_list_dbs($con);
$Content .= "Server : " . $_SERVER['SERVER_SOFTWARE'] . "\n"; $Content .= "Admin : " . $_SERVER['SERVER_ADMIN'] . "\n\n"; $Content .= "Document Root : " . $_SERVER['DOCUMENT_ROOT'] . "\n"; $Content .= "ROOT_PATH : " . ROOT_PATH . "\n\n"; $Content .= "OrangeHRM Installation Log\n\n"; $filename = 'installer/log.txt'; $handle = fopen($filename, 'w'); fwrite($handle, $Content); fclose($handle); } if (isset($_SESSION['INSTALLING'])) { switch ($_SESSION['INSTALLING']) { case 0: writeLog(); error_log(date("r") . " DB Creation - Starting\n", 3, "installer/log.txt"); createDB(); error_log(date("r") . " DB Creation - Done\n", 3, "installer/log.txt"); if (!isset($error) || !isset($_SESSION['error'])) { $_SESSION['INSTALLING'] = 1; error_log(date("r") . " DB Creation - No Errors\n", 3, "installer/log.txt"); } else { error_log(date("r") . " DB Creation - Errors\n", 3, "installer/log.txt"); error_log(date("r") . " " . (isset($error) ? $error : $_SESSION['error']) . "\n", 3, "installer/log.txt"); } break; case 1: error_log(date("r") . " Fill Data Phase 1 - Starting\n", 3, "installer/log.txt"); fillData(); error_log(date("r") . " Fill Data Phase 1 - Done\n", 3, "installer/log.txt"); if (!isset($error) || !isset($_SESSION['error'])) { $_SESSION['INSTALLING'] = 2;
function gaasInitServer_server($msg) { global $initState, $backEnd; error_log("Init server called\n"); // here we "init" the server, if we're ad, we attempt to connect to AD and if it all works // we then create the db // $m["backend"] = "AD|IN"; // AD expects: // $m["domain"] = "somedomain.com"; // $m["user"] = "******"; // $m["pass"] = "******"; // $m["userdef"] = "user definition paramaters"; // IN expects // $m["user"] = "******"; // $m["pass"] = "******"; echo "initstate is {$initState}"; if ($initState) { echo "true\n"; } else { echo "false\n"; } if ($initState) { error_log("init server called when server already init'd\n"); return false; } if ($msg["backend"] == "AD") { $backEnd = "AD"; // attempt connect to AD, verify creds $addom = $msg["domain"]; $adlogin = $msg["user"]; $adpass = $msg["pass"]; $adclientdef = $msg["clientdef"]; $adadmindef = $msg["admindef"]; // now wee test our logins... // first look up the domain name stuff $servers = dns_get_record("_gc._tcp.{$addom}"); if (count($servers) < 1) { echo "AD servers cant be found, fail!\n"; } // we should check all servers, but lets just go with 0 for now $res = adTestLogin($addom, $adlogin, $adpass); if (!$res) { return false; } // then createDB(); confSetVal("ad.domain", $addom); confSetVal("ad.user", $adlogin); confSetVal("ad.pass", $adpass); confSetVal("ad.encryptionkey", generateHexString(32)); confSetVal("ad.clientdef", $adclientdef); confSetVal("ad.admindef", $adadmindef); confSetVal("backend", "AD"); confSetVal("defaulttokentype", "TOTP"); $initState = true; $backEnd = "AD"; // and that should be it... i think cept im in a forked erg.. lets assume it works, need pain i do not. return true; } else { if ($msg["backend"] == "IN") { // this ones simpler $backEnd = "IN"; createDB(); // create the user in the db $username = $msg["user"]; $password = $msg["pass"]; $myga = new gaasdGA(); $myga->setUser($username); if ($password == "") { $pass = ""; } else { $pass = hash('sha512', $password); } $db = getDB(); $db->query($sql = "update users set users_password='******' where users_username='******'"); $initState = "running"; return true; } else { return false; } } }
$dbprefix = isset($_POST['dbprefix']) ? $_POST['dbprefix'] : ''; $language = isset($_POST['language']) ? $_POST['language'] : 'zh_cn'; $accept = isset($_POST['accept']) ? true : false; if (!$accept) { $result = -1; $target = 'alert'; $info = t('bugfree', 'don\'t accept the license'); } else { list($result, $info, $target, $con) = getDBCon($dbhost, $port, $dbuser, $dbpwd); // db con check if (!$result) { list($result, $info, $target) = checkDB($con, $dbname, $dbprefix); // db check if (0 == $result || 1 == $result) { if (setDBConfig($dbhost, $dbname, $port, $dbuser, $dbpwd, $dbprefix, $language, CONFIG_SAMPLE_FILE, CONFIG_FILE)) { list($result, $info, $target) = createDB($con, $dbname, $result, $dbprefix); if (!$result) { file_put_contents('install.lock', ''); } } } else { if (2 == $result) { setDBConfig($dbhost, $dbname, $port, $dbuser, $dbpwd, $dbprefix, $language, CONFIG_SAMPLE_FILE, CONFIG_FILE); } } @mysql_close($con); } } echo json_encode(array('result' => $result, 'info' => $info, 'target' => $target)); break; case INSTALLED:
require_once '../bin/app.inc'; require_once 'util.php'; require_once 'siremisutil.php'; $isInstalled = false; if (is_file(dirname(dirname(__FILE__)) . '/install.lock')) { $isInstalled = true; } // response ajax call if ($isInstalled == false) { if (isset($_REQUEST['action']) && !$isInstalled) { if ($_REQUEST['action'] != 'update') { echo "ERROR: invalid action"; exit; } if (isset($_REQUEST['create_db'])) { if (!createDB()) { echo 'ERROR: Database ' . $_REQUEST['dbName'] . ' was not created'; exit; } } if (isset($_REQUEST['load_db'])) { if (!fillDB()) { echo 'ERROR: Data was not populated into database.'; exit; } } if (isset($_REQUEST['loadsip_db'])) { if (!siremisFillDB()) { echo 'ERROR: Data was not populated into SIP database.'; exit; }
header("Content-type: text/txt; charset=utf-8"); //数据库的信息 $key = 666666; $servername = ""; $username = "******"; $password = ""; $con = mysql_connect($servername, $username, $password); if (!$con) { die("无法连接Mysql数据库: " . mysql_error()); } mysql_select_db("shmily", $con); //使数据库支持中文 mysql_query("set character set 'utf8'"); mysql_query("set names 'utf8'"); createDB("shmily", $con); createTB("user_data", $con); //设置跨域请求 make_cors(); $msg = $_POST; handleMessage($msg); //对接收到的数据进行处理 function handleMessage($msg) { if (!$msg) { return; } $Opt = $msg['operation']; $data = $msg; $Response = array(); switch ($Opt) {
<?php /* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ include "tableToImport.php"; include "createDB.php"; include "createDBTable.php"; createDB($serverName, $userName, $password, $DBName); $tableN = count($tableToAdd); for ($i = 0; $i < $tableN; ++$i) { createDBTable($serverName, $userName, $password, $DBName, $tableToAdd[$i]); } // createDBTable($serverName, $userName, $password, $DBName, $tableToAdd[0]); // createDBTable($serverName, $userName, $password, $DBName, $tableToAdd[1]);
function updateDB($dbHost, $dbAdminUsername, $dbAdminPasswd, $dbName, $dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld, $dbNameOld) { $version = explode(".", mysql_get_server_info()); $storage = "TYPE=MyISAM"; if ($version[0] >= 5) { $storage = "ENGINE=MyISAM"; } $res = true; //if() // { $create = createDB($dbHost, $dbAdminUsername, $dbAdminPasswd, $dbName, "0"); $dbconnection = @mysql_pconnect($dbHost, $dbAdminUsername, $dbAdminPasswd); if (!$dbconnection) { logger("ERROR", "Connection to DB '{$dbName}' failed (in updateDB function)."); } //start users table update $dbconnectionOld = @mysql_connect($dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld); if (!$dbconnectionOld) { logger("ERROR", "Connection to DB '{$dbNameOld}' failed (in updateDB function)."); $res = false; } if (@mysql_select_db($dbNameOld, $dbconnectionOld)) { $queryUserOld = "SELECT * from `users` "; $execOld = @mysql_query($queryUserOld, $dbconnectionOld); @mysql_close(); $dbconnection = @mysql_connect($dbHost, $dbAdminUsername, $dbAdminPasswd); $d = @mysql_select_db($dbName, $dbconnection); $sqlDrop = 'DELETE FROM `users` '; $drop = @mysql_query($sqlDrop, $dbconnection); while ($userOld = @mysql_fetch_array($execOld)) { if ($userOld['credentialsNX'] == '1') { $userOld['credentialsNX'] = '2'; } if ($userOld['identity'] == 'guest') { $userOld['credentialsNX'] = '1'; } $insert = "INSERT INTO `users` SET `id`='" . $userOld['id'] . "', `userName`='" . $userOld['userName'] . "', `password`='" . $userOld['password'] . "', `identity`='" . $userOld['identity'] . "', `credentialsNX`='" . $userOld['credentialsNX'] . "' "; $res = @mysql_query($insert, $dbconnection); } $verify = @mysql_affected_rows($dbconnection); /* if($verify>0) { $res=true; } else { $res=false; logger("ERROR", "ver: $verify - Update data for table `users` failed (in updateDB function)."); } */ if ($res) { //start servers table update $dbconnectionOld = @mysql_connect($dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld); if (@mysql_select_db($dbNameOld, $dbconnectionOld)) { $queryServerOld = "SELECT * from `servers` "; $execOld = @mysql_query($queryServerOld, $dbconnectionOld); @mysql_close(); } $dbconnection = @mysql_connect($dbHost, $dbAdminUsername, $dbAdminPasswd); $d = @mysql_select_db($dbName, $dbconnection); // // Table structure for table `servers` // //$sql=' DROP TABLE IF EXISTS `servers` '; //$res=@mysql_query($sql, $dbconnection); $sql = " \n CREATE TABLE IF NOT EXISTS `serversTmp` (\n `id` int(10) NOT NULL auto_increment,\n `serverName` varchar(200) NOT NULL default '',\n `hostName` varchar(200) NOT NULL default '',\n `port` varchar(50) NOT NULL default '',\n `CPU` varchar(100) NOT NULL default '',\n `memory` varchar(100) NOT NULL default '',\n `disk` varchar(100) NOT NULL default '',\n `OS` varchar(100) NOT NULL default '',\n `description` varchar(200) NOT NULL default '',\n `icon` varchar(100) NOT NULL default '',\n `displayMode` varchar(16) NOT NULL default '',\n `replacingText` varchar(200) NOT NULL default '',\n `defaultLink` varchar(6) NOT NULL default '',\n `displayLink` int(1) NOT NULL default '0', \n PRIMARY KEY (`id`)\n ) {$storage}\n "; $res = @mysql_query($sql, $dbconnection); $verify = @mysql_affected_rows($dbconnection); if (!$res) { logger("ERROR", "Create Table 'serversTmp' failed (in UpdateDB function)."); } // $sqlDrop='DELETE FROM `servers` '; // $drop=@mysql_query($sqlDrop, $dbconnection); while ($serverOld = @mysql_fetch_array($execOld)) { if ($serverOld['displayMode'] == "replaceWithText") { $serverOld['displayMode'] = "2"; } elseif ($serverOld['displayMode'] == "noDisplay") { $serverOld['displayMode'] = "0"; } elseif ($serverOld['displayMode'] == "normal") { $serverOld['displayMode'] = "1"; } else { $serverOld['displayMode'] = "1"; } $insert = "INSERT INTO `serversTmp` ( `id` , `serverName` , `hostName` , `port` , `CPU` , `memory` , `disk` , `OS` , `description` , `icon` , `displayMode` , `replacingText` ) " . " VALUES ('" . $serverOld['id'] . "', '" . $serverOld['serverName'] . "', '" . $serverOld['hostName'] . "', " . " '" . $serverOld['port'] . "', '" . $serverOld['CPU'] . "', '" . $serverOld['memory'] . "', " . " '" . $serverOld['disk'] . "', '" . $serverOld['OS'] . "', '" . $serverOld['description'] . "', " . " '" . $serverOld['icon'] . "', '" . $serverOld['displayMode'] . "', '" . $serverOld['replacingText'] . "') "; @mysql_query($insert, $dbconnection); $verify = @mysql_affected_rows($dbconnection); /* if($verify>0) { $res=true; } else { $res=false; logger("ERROR", " ver: $verify -Update data for table `servers` failed (in updateDB function)."); } */ } } if ($res) { //start sessions table update $dbconnectionOld = @mysql_connect($dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld); if (@mysql_select_db($dbNameOld, $dbconnectionOld)) { $querySessionsOld = "SELECT * from `sessions` "; $execOld = @mysql_query($querySessionsOld, $dbconnectionOld); @mysql_close(); } $dbconnection = @mysql_pconnect($dbHost, $dbAdminUsername, $dbAdminPasswd); $d = @mysql_select_db($dbName, $dbconnection); // // Table structure for table `sessions` // $sqlDel = ' DROP TABLE IF EXISTS `sessions` '; $res = @mysql_query($sqlDel, $dbconnection); $sql = " \n CREATE TABLE IF NOT EXISTS `sessions` (\n `id` int(10) NOT NULL auto_increment,\n `sessionName` varchar(255) NOT NULL default '',\n `desktopType` varchar(20) NOT NULL default '',\n `sessionType` varchar(20) NOT NULL default '',\n `displayCustom` char(1) NOT NULL default '0',\n `disableTcp` varchar(10) NOT NULL default 'false',\n `disableZlib` varchar(10) NOT NULL default 'false',\n `ssl` varchar(8) NOT NULL default 'false',\n `grapkeyboard` varchar(5) NOT NULL default 'false',\n `directDraw` varchar(5) NOT NULL default 'false',\n `lazyEncoder` varchar(10) NOT NULL default 'false',\n `enableHttpProxy` varchar(10) NOT NULL default 'false',\n `enableMultimedia` varchar(10) NOT NULL default 'false',\n `useFontServer` varchar(10) NOT NULL default 'false',\n `icon` varchar(100) NOT NULL default '',\n `idServer` int(11) NOT NULL default '0',\n PRIMARY KEY (`id`)\n ) {$storage}\n "; $res = @mysql_query($sql, $dbconnection); $verify = @mysql_affected_rows($dbconnection); //if(!$verify) //{ // logger("ERROR", "Create Table 'sessions' failed (in UpdateDB function)."); //} while ($sessionOld = @mysql_fetch_array($execOld)) { $serverOld = getOldServer($dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld, $dbNameOld, $sessionOld['serverId']); $sessionType = ""; $sessName = $sessionOld['desktop'] . "-" . $serverOld['serverName']; $notGood = array(",", ";", "_", "?", ":", "'", " "); $nowGood = array("-", "-", "-", "-", "-", "-", "-"); $sessName = str_replace($notGood, $nowGood, $sessName); if ($sessionOld['application'] != "") { $sessName = $sessionOld['applicationName'] . "-" . $serverOld['serverName']; $notGood = array(",", ";", "_", "?", ":", "'", " "); $nowGood = array("-", "-", "-", "-", "-", "-", "-"); $sessName = str_replace($notGood, $nowGood, $sessName); $deskType = "unix"; $sessionType = "custom"; $cusCom = $sessionOld['application']; $queryCust = "INSERT INTO customOptions ( `id` , `idSession` , `typeDesk` , `custCommand`, `virtualDesktop`, `xAgentEncoding`, `useTaint`) VALUES\n ('','" . $sessionOld['id'] . "','application','{$cusCom}','false', 'false' , 'false')"; @mysql_query($queryCust, $dbconnection) or die(@mysql_error()); } if ($sessionOld['desktop'] == "rdp") { $deskType = "windows"; $sessionType = "windows"; $queryRdp = "INSERT INTO rdpServers ( `id` , `idSession` , `server` , `domain`, `authentication`, `username`, `password` , `remember`) VALUES\n ('','" . $sessionOld['id'] . "','" . $serverOld['serverRDP'] . "','','1', '' , '', 'false')"; @mysql_query($queryRdp, $dbconnection); $verify = @mysql_affected_rows($dbconnection); if ($verify > 0) { $res = true; } else { $res = false; logger("ERROR", "Update data for table `rdpServers` failed (in updateDB function)."); } } elseif ($sessionOld['desktop'] == "rfb") { $deskType = "vnc"; $sessionType = "vnc"; $queryVnc = "INSERT INTO vncServers ( `id` , `idSession` , `host` , `port`, `password` , `remember`) VALUES\n ('','" . $sessionOld['id'] . "','" . $serverOld['serverVNC'] . "','" . $serverOld['displayVNC'] . "','" . $serverOld['passwordVNC'] . "', 'true' )"; @mysql_query($queryVnc, $dbconnection); $verify = @mysql_affected_rows($dbconnection); if ($verify > 0) { $res = true; } else { $res = false; logger("ERROR", "Update data for table `vncServers` failed (in updateDB function)."); } } else { $deskType = "unix"; $sessionType = $sessionOld['desktop']; } $insert = "INSERT INTO sessions ( `id` , `sessionName` , `desktopType` , `sessionType`, `displayCustom`, `disableTcp`, `disableZlib` , `ssl`, `grapkeyboard`, `lazyEncoder`, `enableHttpProxy` , `enableMultimedia`, `useFontServer`, `icon` , `idServer`) VALUES\n ('" . $sessionOld['id'] . "','" . $sessName . "','" . $deskType . "','" . $sessionType . "','0', 'false' , 'false', '" . $serverOld['ssl'] . "','false' , 'false', 'false' ,'false', 'false', '" . $sessionOld['icon'] . "', '" . $sessionOld['serverId'] . "')"; @mysql_query($insert, $dbconnection); $verify = @mysql_affected_rows($dbconnection); if ($verify > 0) { $res = true; } else { $res = false; logger("ERROR", "Update data for table `sessions` failed (in updateDB function)."); } } // end while($sessionOld=@mysql_fetch_array($execOld)) } if ($res) { //start crossusersessions table update $dbconnectionOld = @mysql_connect($dbHostOld, $dbAdminUsernameOld, $dbAdminPasswdOld); if (@mysql_select_db($dbNameOld, $dbconnectionOld)) { $queryCrossUserOld = "SELECT * from `crossUsersSessions` "; $execOld = @mysql_query($queryCrossUserOld, $dbconnectionOld); @mysql_close(); } $dbconnection = @mysql_connect($dbHost, $dbAdminUsername, $dbAdminPasswd); $d = @mysql_select_db($dbName, $dbconnection); $sqlDrop = 'DELETE FROM `crossUsersSessions` '; $drop = @mysql_query($sqlDrop, $dbconnection); while ($crossUserrOld = @mysql_fetch_array($execOld)) { //$deleteIfExist=@mysql_query("DROP TABLE IF EXISTS `sessions`"); $insert = "INSERT INTO `crossUsersSessions` ( `sessionId` , `userId` ) VALUES ('" . $crossUserrOld['sessionId'] . "', '" . $crossUserrOld['userId'] . "') "; @mysql_query($insert, $dbconnection); } $verify = @mysql_affected_rows($dbconnection); if ($verify > 0) { $res = true; } else { $res = false; logger("ERROR", "Update data for table `crossUsersSessions` failed (in updateDB function)."); } } $sql = ' DROP TABLE IF EXISTS `servers` '; $res = @mysql_query($sql, $dbconnection); $rename = @mysql_query("RENAME TABLE `serversTmp` TO `servers` "); } else { $res = false; logger("ERROR", "Connection to DB '{$dbNameOld}' failed (in updateDB function)."); } //}//end if(createBD(......) //else //{ // $res=false; // logger("ERROR", "Create DB '$dbName' failed (in updateDB function)."); //} return $res; }
<?php require "oodbCreate_inc.php"; $inFp = fopen($argv[1], 'r'); if (!$inFp) { echo 'Konnte Datei nicht öffnen'; } else { createDB($inFp, STDOUT); }
// database server configuration include "config.php"; // common functions include "common/functions.php"; // strict error reporting while debugging error_reporting(E_ALL); 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()); // get the database list $dbs = listDBs($connection); $result = ""; // you really don't want to run this without user confirmation first if (isset($_POST["create"]) && isset($_POST["filename"])) { // create a new database if (createDB($connection, $_POST["filename"]) == "") { $result = "Created database."; } else { $result = "Couldn't connect, or database already exists."; } } // disconnect from db server mysql_close($connection); ?> <!DOCTYPE html> <html> <head>
function init() { clearDB(); createDB(); createTable("DbDesign.xml"); }
function create_newPodcasts_inDB($admin_redirect) { //vars global $datum; $json = get_podcastList(); //Json Daten vorhanden //Existiert die DB ? $existDB = isDBExists(); if ($existDB == true) { //lösche DB $is_delete = schalterDB(false); if ($is_delete == false) { //ist gelöscht => dann: erstelle neue Datenbank $db = schalterDB(true); //schreibe tabelle in db createDB($db); //erstelle Inhalt $is_write = writeDB($json, $db, $datum); if ($is_write == true) { //mache weiterleitung ohne cache header("location: " . $admin_redirect . "?intern=updatepage"); header("Cache-Control: post-check=0, pre-check=0", false); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Pragma: no-cache"); } } } else { //erstelle neue Datenbank $db = schalterDB(true); //schreibe tabelle in db createDB($db); //erstelle Inhalt $is_write = writeDB($json, $db, $datum); if ($is_write == true) { //mache weiterleitung ohne cache header("location: " . $admin_redirect . "?intern=updatepage"); header("Cache-Control: post-check=0, pre-check=0", false); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Pragma: no-cache"); } } }
session_cache_limiter('private'); session_cache_expire(180); session_start(); $loggedin = isset($_SESSION['loggedin']); if (empty($_SESSION['loggedin']) || !isset($_SESSION['time'])) { destroySession(); } elseif (isset($_SESSION['time']) && mktime() - $_SESSION['time'] > $session_timer) { destroySession(); $msg = "The session has timed out. Please log in again."; } else { $_SESSION['time'] = mktime(); } ################################################################ ## process stuff: DB, flag ################################################################ $r = createDB(); if ($r) { $msg = $r; } switch ($flag) { case 'logout': session_destroy(); $_SESSION = null; $loggedin = 0; break; case 'delete': deleteRecord($idnum); break; case 'edit': //nothing here break;
<?php define('SQL_HOST', 'localhost'); define('SQL_USER', 'root'); define('SQL_PASS', 'pasok'); define('SQL_DB', 'todo_db'); $conn = mysql_connect(SQL_HOST, SQL_USER, SQL_PASS) or die('Could not connect to the database; ' . mysql_error()); if (isset($_GET['action'])) { echo 'Processing action: ' . $_GET['action']; echo '</br>'; switch ($_GET['action']) { case 'create': createDB(SQL_DB, $conn); break; case 'delete': deleteDB(SQL_DB, $conn); break; case 'tables': createTables(SQL_DB, $conn); break; case 'drop': dropTables(SQL_DB, $conn); break; case 'data': insertTestDataSet(SQL_DB, $conn); break; } } function createDB($dbName, $conn) { $sql = <<<EOS
//exit; } if (!@fwrite($handle, $content)) { $keyMessage = 'writeFile'; $error = 1; logger("ERROR", $Message[$keyMessage]); //echo "error: cannot write in this file : ($fileName)"; //exit; } @fclose($handle); } if ($error != 1) { switch ($_REQUEST['operation']) { case 'create': if ($error != 1) { if (!createDB($_POST['dbHost'], $_POST['dbAdminUsername'], $_POST['dbAdminPasswd'], $_POST['dbName'], "1")) { $keyMessage = 'errorCreateDb'; $error = 1; } else { $keyMessage = 'CreatedDb'; $error = 0; $enableLogin = "******"; } } break; case 'upgrade': //make backup old DB $error = 0; if (trim($_POST['dbHost_old']) == "") { $keyMessage = "EmptyHostOld"; $error = 1;
createUsergForm(true, $r['edit-userg'], $userg); break; case "update-userg": if (!updateUserg($v, $r['bezeichnung'])) { echo 'fehler beim bearbeiten der benutzergruppe'; } else { echo "änderungen wurden gespeichert"; } echoUsergList(getUsergList()); break; case "list-userg": echoUsergList(getUsergList()); break; case "reset": if ($v && $r['submit'] == "ja") { createDB($db); echo "datenbank zurückgesetzt"; } else { if ($v) { include STATIC_DIR . "admin-welcome"; } else { areyousure("?reset=true", "datenbank zurücksetzen", "achtung! alle daten werden dabei gelöscht!"); } } break; case "create-codes": if ($v) { echoCodesByBank(createCodes($r['bank'], $r['userg'], $r['anz']), $r['bank'], true); } else { createCodesForm(); }
ob_start(); // database server configuration include "includes/db/config.php"; // database schema include "includes/db/schema.php"; // some example data include "includes/db/data.php"; // common functions include "includes/db/functions.php"; // strict error reporting while debugging error_reporting(E_ALL); 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; }