function dbconnect($config_arr)
{
    $ads_db = new mysqli($config_arr['server_name'], $config_arr['user_name'], $config_arr['password'], $config_arr['database']);
    //устанавливаем соденинение
    if ($ads_db->connect_errno > 0) {
        die('Unable to connect' . $ads_db->connect_error() . '<a href="./install.php">You might want to install it first </a>');
    }
    if (!$ads_db->set_charset("utf8")) {
        die('Error while applying utf8 charset:  ' . $ads_db->error);
    }
    return $ads_db;
}
 function db_connect()
 {
     // DEBUG MODE:
     //mysqli_report(MYSQLI_REPORT_ALL);
     global $GlobalConfig, $mysqli;
     $mysqli = new mysqli($GlobalConfig->dbserver, $GlobalConfig->dbuser, $GlobalConfig->dbpass, $GlobalConfig->dbname);
     if (!$mysqli) {
         dead("Connect failed: " . $mysqli->connect_error());
     } else {
         $this->db_mysql_query('SET NAMES utf8', 'db_connect');
     }
 }
function connect()
{
    global $conn;
    $servername = "localhost";
    $username = "******";
    $password = "******";
    $dbname = "MiniProject";
    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_errno) {
        die("<div class=\"alert alert-danger\" role=\"alert\">Connection failed: " . $conn->connect_error() . "</div>");
    }
}
Beispiel #4
0
Datei: MySQL.php Projekt: jasny/Q
 /**
  * Reconnect to the db server
  */
 public function reconnect()
 {
     if (isset($this->native) && @$this->native->ping()) {
         return;
     }
     $native = new mysqli($this->settings['host'], $this->settings['user'], $this->settings['password'], $this->settings['dbname'], $this->settings['port'], $this->settings['unix_socket']);
     if (!$native) {
         throw new DB_Exception("Connecting to mysql database failed: " . \mysqli::connect_error());
     }
     $this->native = $native;
 }
Beispiel #5
0
<?php

//session_set_cookie_params(0);
session_start();
$name = $_POST['name'];
$phone = $_POST['phone'];
$address = $_POST['address'];
$email = $_POST['email'];
$id = $_POST['id'];
$usr = $_POST['Username'];
$conn = new mysqli("localhost", "root", "", "accessit");
if ($conn->connect_error) {
    die("connection failed " . $conn->connect_error());
}
$stmt = $conn->prepare("insert into user (id,Name,PhoneNo,Address,Email) values (?,?,?,?,?)");
$stmt->bind_param("isiss", $id, $name, $phone, $address, $email);
$stmt->execute();
$_SESSION['id'] = $id;
$_SESSION['Username'] = $usr;
header("location:onlogin.php");
<?php

//Konexioa egin datu-basearekin
//$link = new mysqli("localhost","root","","quiz");
$link = new mysqli("mysql.hostinger.es", "u526113874_rb15", "123456789", "u526113874_quiz");
if ($link->connect_errno) {
    die("Huts egin du konexioak MySQL-ra: (" . $link->connect_errno() . ") " . $link->connect_error());
}
$balioak = $link->query("Select * from galdera");
?>

<!DOCTYPE html>
<html>
	<head>
		<meta name="tipo_contenido" content="text/html;" http-equiv="content-type" charset="utf-8">
		<title>Sign Up</title>
		<link rel="stylesheet" type="text/css" href="stylesPWS/estiloa.css"/>
		<link rel='stylesheet' 
		   type='text/css' 
		   media='only screen and (max-width: 480px)'
		   href='stylesPWS/smartphone.css' />
		<script type="text/javascript" language="javascript" src="funtzioak.js">
		</script>
	</head>
	<body>
		<div class ="nav" id="nav">
			<ul>
				<li class ="ezkerra"><a href ="layout.html">Home</a></li>
				<li class ="ezkerra"><a href ="credits.html">Credits</a></li>
				<li class ="ezkerra"><a href ="quiz.php">Quizzes</a></li>
			</ul>
Beispiel #7
0
<?php

ini_set("display_errors", On);
error_reporting(E_ALL);
mb_language("uni");
mb_internal_encoding("utf-8");
mb_http_input("auto");
mb_http_output("utf-8");
require "constant.php";
//?id=ほげほげ で指定する!
if (isset($_GET['id'])) {
    $cont_id = $_GET['id'];
}
$sql = "SELECT contribution.id, user.name, user.img, reaction.reaction, reaction.created_at FROM reaction INNER JOIN user ON reaction.user_id = user.id INNER JOIN contribution ON reaction.cont_id = contribution.id WHERE contribution.id=" . $cont_id . " ORDER BY created_at";
$link = new mysqli("localhost", "{$db_usr}", "{$db_pwd}", "{$db_name}");
$link->set_charset('utf8');
if (mysqli_connect_errno()) {
    printf("connect failed: %s\n", $link->connect_error());
    exit;
}
$user = array();
if ($result = mysqli_query($link, $sql)) {
    while ($row = mysqli_fetch_object($result)) {
        $user[] = array('id' => $row->id, 'name' => $row->name, 'img' => $row->img, 'reaction' => $row->reaction, 'created_at' => $row->created_at);
    }
    mysqli_free_result($result);
}
header('Content-type: application/json');
echo json_encode($user);
mysqli_close($link);
Beispiel #8
0
    return $rowdb;
}
//Fungsi Fetch_Array
function arraydb($sql)
{
    $arraydb = mysqli_fetch_array($sql);
    return $arraydb;
}
//Fungsi Nums_Row
function numrows($sql)
{
    $numrows = mysqli_num_rows($sql);
    return $numrows;
}
//Fungsi Close Database
function closedb()
{
    global $koneksi_db;
    mysqli_close($koneksi_db);
}
function freedb($hsl)
{
    $free = mysqli_free_result($hsl);
}
/*** Koneksi dg OOP ***/
$mysqli = new mysqli($myHost, $myUser, $myPass, $myDbs);
/* check connection */
if (mysqli_connect_errno()) {
    printf("Connect failed: %s\n", $mysqli->connect_error());
    exit;
}
Beispiel #9
0
// определяем IP
define('PAGEVISIT', $_SERVER['REQUEST_URI']);
// определяем страницу
// ***************   Проверка версии PHP и поключение к базе данных по mysql если она меньше или равна 5.2 или MysqLi ООП если она больше   ******************* //
if (PHP_VERSION <= 5.2) {
    $CONNECTION = mysql_connect(DBHOST, DBUSER, DBPASS);
    if ($CONNECTION) {
        $DATABASE = mysql_select_db(DBNAME);
    } else {
        exit(mysql_error());
    }
    $CONNECT_FUNCTION = "mysql_query";
} else {
    $CONNECTION = new mysqli(DBHOST, DBUSER, DBPASS, DBNAME);
    if (!$CONNECTION->connect_error) {
        $DATABASE = NULL;
    } else {
        exit($CONNECTION->connect_error());
    }
    $CONNECT_FUNCTION = '$CONNECTION->query';
}
// **************          Конец проверки    ********************************************************** //
ignore_user_abort(true);
// Прерывание скрипта при отсоединении клиента
$languagesCOOKIE = explode(";", strtolower($_SERVER['HTTP_ACCEPT_LANGUAGE']));
for ($langsCount = 0; $langsCount < count($languagesCOOKIE); $langsCount++) {
    $LANG_SPLIT = explode(",", $languagesCOOKIE[$langsCount]);
    $LANG_SPLIT[1] = strtok($LANG_SPLIT[1], '-');
    // Языки пользователя $LANG_SPLIT[1]
}
define("LANGUAGE", "ru");
Beispiel #10
0
<!DOCTYPE html>
<html>
<head>
	<?php 
include "header.php";
$conn = new mysqli("localhost", "root", "", "organizer");
if ($conn == false) {
    echo "Connection error : " . $conn->connect_error();
}
$query = "SELECT * FROM account WHERE User='******'";
$result = mysqli_query($conn, $query);
while ($row = mysqli_fetch_assoc($result)) {
    $name = $row["nama_guru"];
    $ID = $row["ID"];
    $username = $row["User"];
    $Priv = $row["Priv"];
    if ($Priv == 1) {
        $jabatan = "Guru";
    } else {
        if ($Priv == 2) {
            $jabatan = "Wakil Kepala Sekolah";
        } else {
            if ($Priv == 3) {
                $jabatan = "Kepala Sekolah";
            }
        }
    }
    $bidang = $row["Subjek"];
    $lahir = $row["tgl_lahir"];
}
?>
 static function buildDB($menuPages)
 {
     $mysqli = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
     if ($mysqli->connect_errno) {
         exit("Couldn't connect to the database." . $mysqli->connect_error());
     }
     $admin_u = DEV_NAME;
     $admin_e = DEV_EMAIL;
     $admin_p = AdminUtilities::createSaltedHash(DEV_PASS);
     $sql = "CREATE DATABASE IF NOT EXISTS `" . DB_NAME . "`\n                DEFAULT CHARACTER SET " . DEFAULT_CHARACTER_SET . " COLLATE " . DEFAULT_COLLATION . ";\n                CREATE TABLE IF NOT EXISTS `" . DB_NAME . "`.`" . DB_PREFIX . "entryMgr`\n                (\n                    `id`        INT UNSIGNED NOT NULL PRIMARY KEY auto_increment,\n                    `page`      VARCHAR(64) NOT NULL,\n                    `title`     VARCHAR(255) DEFAULT NULL,\n                    `subhead`   VARCHAR(75) DEFAULT NULL,\n                    `body`      TEXT DEFAULT NULL,\n                    `img`       VARCHAR(128) DEFAULT NULL,\n                    `imgcap`    VARCHAR(128) DEFAULT NULL,\n                    `data1`     VARCHAR(255) DEFAULT NULL,\n                    `data2`     VARCHAR(255) DEFAULT NULL,\n                    `data3`     VARCHAR(255) DEFAULT NULL,\n                    `data4`     VARCHAR(255) DEFAULT NULL,\n                    `data5`     VARCHAR(255) DEFAULT NULL,\n                    `data6`     VARCHAR(255) DEFAULT NULL,\n                    `data7`     VARCHAR(255) DEFAULT NULL,\n                    `data8`     VARCHAR(255) DEFAULT NULL,\n                    `author`    VARCHAR(64) DEFAULT '" . SITE_CONTACT_NAME . "',\n                    `created`   INT(12),\n                    INDEX(`page`),\n                    INDEX(`created`),\n                    INDEX(`title`),\n                    FULLTEXT KEY `search` (`title`,`body`,`data2`)\n                ) ENGINE=MYISAM CHARACTER SET " . DEFAULT_CHARACTER_SET . " COLLATE " . DEFAULT_COLLATION . ";\n                CREATE TABLE IF NOT EXISTS `" . DB_NAME . "`.`" . DB_PREFIX . "adminMgr`\n                (\n                    `id`        INT UNSIGNED NOT NULL PRIMARY KEY auto_increment,\n                    `admin_u`    VARCHAR(60) UNIQUE,\n                    `admin_e`    VARCHAR(100) UNIQUE,\n                    `admin_p`    VARCHAR(150) DEFAULT NULL,\n                    `admin_v`    VARCHAR(150) NOT NULL,\n                    `is_admin`    TINYINT(1) DEFAULT '0',\n                    INDEX(admin_v)\n                ) ENGINE=MYISAM CHARACTER SET " . DEFAULT_CHARACTER_SET . " COLLATE " . DEFAULT_COLLATION . ";\n                INSERT INTO `" . DB_NAME . "`.`" . DB_PREFIX . "entryMgr`\n                (\n                    `page`, `title`, `body`, `img`, `imgcap`,\n                    `data2`, `data6`, `author`, `created`\n                )\n                VALUES\n                (\n                    '" . DEFAULT_PAGE . "', 'Welcome to the ECMS!',\n                    '<p>You have successfully installed the " . "<a href=\"http://ennuicms.com/\">ECMS</a>.</p>" . "\r\n<p>To get started:</p>\r\n<ul>\r\n<li>" . "<a href=\"/admin\">Log in</a> using the username " . "and password you set up in the config files</li>\r\n" . "<li>Edit this entry to contain the content for your " . "site''s home page</li>\r\n<li>Add content to the " . "rest of the pages on your site</li>\r\n</ul>\r\n" . "<h2>HTML Element Style Test (h2)</h2>\r\n" . "<blockquote>\r\n<p>This is a blockquote. Putamus " . "lectores litterarum dynamicus facilisi dolore. " . "Facilisi qui zzril legunt nibh in. Nostrud nonummy " . "sequitur autem consequat ut. Assum tincidunt " . "vulputate gothica molestie veniam.</p>\r\n" . "</blockquote>\r\n<h3>H3 Element</h3>\r\n<p>Sed " . "consequat tempor ex formas dignissim. Lobortis " . "anteposuerit consectetuer consequat ullamcorper " . "dolore. Dolore imperdiet amet iis sed iriure. " . "Luptatum adipiscing lorem augue diam te. Cum autem " . "claritas tempor sed augue.</p>\r\n<h4>H4 Element" . "</h4>\r\n<ol>\r\n<li>This is an ordered list</li>" . "\r\n<li>Typi at doming usus lectores parum.</li>" . "\r\n<li>Parum quod legentis qui nonummy mirum. Nunc " . "quis consequat in seacula consectetuer.</li>\r\n" . "</ol>\r\n<h5>H5 Element</h5>\r\n<p>Parum quod " . "legentis qui nonummy mirum. Nunc quis consequat in " . "seacula consectetuer. Est humanitatis eros duis qui " . "quarta. Enim quod in aliquip placerat insitam. " . "Putamus consequat hendrerit demonstraverunt " . "eleifend claram. Videntur molestie typi hendrerit " . "duis qui.</p>\r\n<h6>H6 Element</h6>\r\n<p>Mazim ut " . "euismod formas amet in. Ex blandit nulla tincidunt " . "wisi consequat. Typi illum ad luptatum " . "Investigationes legentis.</p>',\n                    'blog, entry, testing', 'welcome-to-the-ecms',\n                    'Ennui Design', " . time() . "\n                )\n                ON DUPLICATE KEY UPDATE `created`=" . time() . ";";
     if (DEV_PASS != '') {
         $sql .= "INSERT INTO `" . DB_NAME . "`.`" . DB_PREFIX . "adminMgr`\n                    (`admin_u`, `admin_e`, `admin_p`, `admin_v`, `is_admin`)\n                VALUES\n                    ('{$admin_u}', '{$admin_e}', '{$admin_p}', '" . sha1(time()) . "', '1')\n                ON DUPLICATE KEY UPDATE `is_admin`=1;";
     }
     if (array_key_exists('blog', $menuPages)) {
         $sql .= "\n                CREATE TABLE IF NOT EXISTS `" . DB_NAME . "`.`" . DB_PREFIX . "blogCmnt`\n                (\n                    `id`        INT(5) PRIMARY KEY auto_increment,\n                    `bid`        INT(5),\n                    `user`        VARCHAR(60),\n                    `email`        VARCHAR(100),\n                    `link`        VARCHAR(100),\n                    `comment`    TEXT,\n                    `timestamp`    INT(12),\n                    `subscribe`    TINYINT(1) DEFAULT '0',\n                    INDEX(bid),\n                    INDEX(timestamp),\n                    INDEX(subscribe)\n                ) ENGINE=MYISAM CHARACTER SET " . DEFAULT_CHARACTER_SET . " COLLATE " . DEFAULT_COLLATION . ";";
     }
     if ($mysqli->multi_query($sql)) {
         do {
             if ($result = $mysqli->store_result()) {
                 echo "Table created.<br />\n";
                 $result->close();
             }
         } while ($mysqli->next_result());
     } else {
         exit('Database tables could not be created. ' . $mysqli->error());
     }
     $mysqli->close();
     return true;
 }
            city_cat_load('categories');
            break;
        case 'categories':
            userfunc_query('SELECT * FROM `categories`');
            while ($row = $result->fetch_assoc()) {
                $categories[$row['cat_name']][$row['subcat_id']] = $row['subcat_name'];
            }
            $result->free();
            break;
    }
}
//конец функций
$ads_db = new mysqli($_SESSION['server_name'], $_SESSION['user_name'], $_SESSION['password'], $_SESSION['database']);
//устанавливаем соденинение
if ($ads_db->connect_errno > 0) {
    die('Unable to connect' . $ads_db->connect_error());
}
if (!$ads_db->set_charset('utf8')) {
    die('Error while applying utf8 charset' . $ads_db->error);
}
city_cat_load('cities_and_categories');
//подгружаем наши массивы с городами и категориями
$ads_container = "";
$showform_params = array('return_private' => "0", 'namereturn' => "", 'email_return' => "", 'return_send_email' => "1", 'phonereturn' => "", 'city' => "", 'returncategory' => "", 'returntitle' => "", 'returndescription' => "", 'returnprice' => "0", 'notice_field_is_empty' => "");
if (isset($_POST['main_form_submit'])) {
    //блок проверки какая кнопка была нажата. Если Отправить, то передаем записи из поста в сессию
    if ($_POST['title']) {
        if (isset($_SESSION['save_changes_id'])) {
            //при нажатой кнопке Отправить если в сессии сохранен ключ редактируемого обьявления, то сохраняем в него вместо создания нового.
            $statement = $ads_db->prepare('UPDATE `ads_container` SET `private` = ?, `seller_name` = ?, `email` = ?, `allow_mails` = ?, `phone` = ?, `location_id` = ?, `category_id` = ?, `title` = ?, `description` = ?, `price` = ? WHERE `id` = ?');
            $statement->bind_param('ississssssi', $_POST['private'], $_POST['seller_name'], $_POST['email'], allow_mails(), $_POST['phone'], $_POST['location_id'], $_POST['category_id'], $_POST['title'], $_POST['description'], $_POST['price'], $_SESSION['save_changes_id']);
Beispiel #13
0
<?php

$db_ini = parse_ini_file('../dbconf.ini');
$conn = new mysqli($db_ini['server'], $db_ini['username'], $db_ini['password']);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error());
}
$sql = "CREATE DATABASE ourDB";
if ($conn->query($sql) === TRUE) {
    echo "Database created successfuly";
} else {
    echo "Error creating database: " . $conn->error;
}
$conn->close();