public function __construct() { $dbinfo = MyDatabase::getConnectionDetails(); $host = $dbinfo["host"]; $database = $dbinfo["database"]; $username = $dbinfo["username"]; $password = $dbinfo["password"]; $db = new MyDatabase($host, $database, $username, $password); $this->conn = $db->get_connection(); }
public static function getInstance() { if (!self::$instance instanceof self) { self::$instance = new static(); } return self::$instance; }
/** * Opens a connection to the database. */ public static function connect() { if (!self::isConfigured()) { return; } include self::CONFIG; self::$connection = @mysql_connect($server, $username, $password); if (!self::$connection) { return; } if (!mysql_select_db($database)) { /* fail */ $err_num = mysql_errno(); switch ($err_num) { case 1049: // database not found mysql_query('create database ' . $database . ';'); mysql_select_db($database); break; /* else */ echo 'Failed to create database.'; exit; } } }
public function __construct() { if (MyDatabase::isConfigured()) { MyDatabase::connect(); $this->querySize(); } $this->template = HtmlTemplate::fromFile('index.html'); $this->user = new User(); $this->template->assign('user'); }
function setstatus($data, $id = "") { $dbase = new MyDatabase(DBNAME, DBHOST, DBUSER, DBPASS); $ids = explode(',', $_POST['id']); for ($i = 0; $i < count($ids); $i++) { $result = $dbase->_query("SELECT * FROM " . TBLPREFIX . "subscribers where id=\"{$ids[$i]}\""); $recrow = mysql_fetch_row($result); $stat = $recrow[15]; unset($recrow); if ($stat == 1) { $stat = 0; } else { $stat = 1; } $in = "update " . TBLPREFIX . "subscribers set status = {$stat}\n where id=\"{$ids[$i]}\""; $result = $dbase->_query($in); } if ($result) { } else { } unset($dbase); }
</div> <?php if (isset($_POST["submit"])) { $username = trim($_POST["username"]); $password = trim($_POST["password"]); if (strlen($username) == 0 || strlen($password) == 0) { echo '<script type="text/javascript">' . '$(".error-message").removeClass("hidden");' . '$(".error-message p strong").html("You\'ve got an empty field");' . 'setTimeout(function() {$(".error-message").hide();}, 3000);' . '</script>'; return; } $dbinfo = MyDatabase::getConnectionDetails(); $host = $dbinfo["host"]; $database = $dbinfo["database"]; $db_username = $dbinfo["username"]; $db_password = $dbinfo["password"]; $db = new MyDatabase($host, $database, $db_username, $db_password); $conn = $db->get_connection(); $query = "SELECT * FROM authentication WHERE username = ?"; $stmt = $conn->prepare($query); $stmt->bindParam("1", $username); $stmt->execute(); $result = $stmt->fetch(PDO::FETCH_ASSOC); /*echo(var_dump($result));*/ if ($result == false) { echo '<script type="text/javascript">' . '$(".error-message").removeClass("hidden");' . '$(".error-message p strong").html("Your username or password is wrong");' . 'setTimeout(function() {$(".error-message").hide();}, 3000);' . '</script>'; } else { if (password_verify($password, $result["password"])) { if ($result["locked"] == 0) { $_SESSION["auth"] = true; $_SESSION["role"] = $result["role"]; $_SESSION["locked"] = $result["locked"];
$fp = fopen('mysql.php', 'w'); $filedata = '<?php $server = \'' . $_POST['server'] . '\'; $username = \'' . $_POST['username'] . '\'; $password = \'' . $_POST['password'] . '\'; $database = \'' . $_POST['database'] . '\'; ?>'; fwrite($fp, $filedata, strlen($filedata)); fclose($fp); chmod('mysql.php', 0400); mkdir(Image::PATH, 0755); mkdir(Statistics::STATS_DIR, 0755); $error = ''; } else { $error = 'no file'; } } } if ($error == '') { require_once 'tools/MyDatabase.php'; MyDatabase::connect(); $table_books = mysql_query('describe books;'); if ($table_books == null) { // no table, so create $new_table = 'CREATE TABLE `books` ('; $new_table .= '`id` bigint(20) NOT NULL auto_increment,'; $new_table .= '`auth_key` varchar(32) NOT NULL,'; $new_table .= '`mail` varchar(128) NOT NULL,'; $new_table .= '`created` datetime NOT NULL,'; $new_table .= '`expires` datetime NOT NULL,'; $new_table .= '`expired` datetime,'; $new_table .= '`author` varchar(128) NOT NULL,'; $new_table .= '`title` varchar(128) NOT NULL,'; $new_table .= '`year` decimal(4,0) NOT NULL,'; $new_table .= '`price` decimal(5,2) NOT NULL,'; $new_table .= '`isbn` varchar(17) NOT NULL,';
function getProfileDetails() { $detailsJSON = array(); $JSONData = json_decode(file_get_contents('php://input')); $breakerID = $JSONData->breaker_id; $dbase = new MyDatabase(DBNAME, DBHOST, DBUSER, DBPASS); $query = "SELECT B.id,B.socialid,B.mobile,B.country,B.name,B.username,B.email,B.profileimage,B.latitude,\n B.longitude,B.dateregistered,B.dateofbirth,B.about,B.gender,B.city,B.lang,\n (SELECT name_en FROM breakcategory WHERE id=(SELECT breakid FROM breaks WHERE pid={$breakerID} LIMIT 1)) as break_category_en,\n (SELECT name_ar FROM breakcategory WHERE id=(SELECT breakid FROM breaks WHERE pid={$breakerID} LIMIT 1)) as break_category_ar \n FROM breakers as B WHERE B.id={$breakerID}"; $result = $dbase->_query($query); while ($row = mysql_fetch_array($result)) { $details = array("id" => $row['id'], "socialid" => $row['socialid'], "mobile" => $row['mobile'], "country" => $row['country'], "name" => $row['name'], "username" => $row['username'], "email" => $row['email'], "breaker_image" => UPLOAD_SERVER . "/resources/images/profile/" . $row['profileimage'], "latitude" => $row['latitude'], "longitude" => $row['longitude'], "latitude" => $row['latitude'], "dateregistered" => $row['dateregistered'], "dateofbirth" => $row['dateofbirth'], "about" => $row['about'], "gender" => $row['gender'], "city" => $row['city'], "lang" => $row['lang'], "break_category_en" => $row['break_category_en'], "break_category_ar" => $row['break_category_ar']); $detailsJSON[] = $details; } giveResponseToApp($detailsJSON); }
* the Free Software Foundation, either version 2 of the License, or * (at your option) any later version. * * This program is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * GNU General Public License for more details. * * You should have received a copy of the GNU General Public License * along with this program. If not, see <http://www.gnu.org/licenses/>. */ /* * This script connects to the database or exits by sending an error message. * If a connection is etablished, old database entries will be deleted. */ require_once 'tools/MyDatabase.php'; require_once 'tools/Output.php'; require_once 'text/Template.php'; $templateText = <<<EOT <h2>Störung</h2> <div class="text"> Leider besteht zur Zeit keine Verbindung zur Datenbank. :-( </div> EOT; MyDatabase::connect(); if (!MyDatabase::getConnection()) { $tmpl = new Template($templateText); $output = new Output(); $output->send($tmpl->result()); exit; }
<?php include_once "php_class/auth.php"; include "/configs/db.php"; $page_title = "Application Setting"; include_once "layout/header.php"; $role = $_SESSION["role"]; if ($role === "normal") { header("LOCATION:index.php"); } $dbinfo = MyDatabase::getConnectionDetails(); $host = $dbinfo["host"]; $database = $dbinfo["database"]; $db_username = $dbinfo["username"]; $db_password = $dbinfo["password"]; $db = new MyDatabase($host, $database, $db_username, $db_password); ?> <div> <div class="row"> <!--shows result of any operation carried on this page--> <div class="hidden alert" id="alert-message"><p class="text-center"><strong>Successful</strong></p></div> </div> <div class="row"> <div class="col-xs-12 col-md-6"> <form role="form" class="form-horizontal" id="addUser" method="post" action="<?php $_SERVER['PHP_SELF']; ?> "> <fieldset> <legend>Add New User</legend>