function startup() { setlocale(LC_ALL, 'ru_RU.UTF-8'); // Языковая настройка mb_internal_encoding('UTF-8'); session_start(); return getDbConnect(); }
function articles_delete($id_article) { $sql1 = "DELETE FROM `articles` WHERE `id_article`='%s'"; $query = sprintf($sql1, sql_escape($id_article)); $result = mysqli_query(getDbConnect(), $query); if (!$result) { die(mysqli_error()); } return true; }
function getallbook($name) { $conn = getDbConnect(); $sqlQueryStr = "SELECT * FROM BOOK"; $result = mysql_query($sqlQueryStr, $conn); // execute the SQL query //fetch the results as array. while ($row = mysql_fetch_array($result)) { $items[] = array('cd' => $row['cd'], 'title' => $row['title'], 'author' => $row['author'], 'publisher' => $row['publisher']); } return json_encode($items); }
function getallbooks($name) { $conn = getDbConnect(); $sqlQueryStr = "SELECT * FROM BOOK"; $result = mysql_query($sqlQueryStr, $conn); // execute the SQL query //fetch the results as array. $bookArray = array(); while ($row = mysql_fetch_array($result)) { $book = array('cd' => $row['cd'], 'title' => $row['title'], 'author' => $row['author'], 'publisher' => $row['publisher']); array_push($bookArray, $book); } return $bookArray; }
<?php require_once 'function.php'; require 'classes.php'; require 'repo.php'; $link = getDbConnect(); $title = "Справочник: Ключевые слова"; $error = false; $all_wordpairs = WordpairRepository::loadAll($link); $all_persons = PersonRepository::loadAll($link); $pair_person = ''; if (isset($_POST['submit'])) { $person_id = $_POST['persons']; if ($person_id != 0) { $person = PersonRepository::load($link, $person_id); $one_person = $person->getName(); $pair_person = WordpairRepository::loadByPerson($link, $person_id); } else { $error = true; } } include 'view/header.php'; include 'view/v_wordpairs.php'; include 'view/footer.php';
<?php // start a session. The session_start() function must appear BEFORE the <html> tag: session_start(); // require the dbfunction.php file require 'dbFunction.php'; $adminid = $_POST["adminID"]; // retrieve the adminid from login form $mypassword = $_POST["password"]; // retrieve the password from login form $con = getDbConnect(); // invoke the getDbConnect() function to get a database connection if ($con) { // connection to database is successful // To protect MySQL injection (more detail about MySQL injection) $sqlQueryStr = "SELECT recordid,email " . "FROM account AC " . "WHERE AC.email = '{$adminid}' AND " . "AC.password= '******'"; $result = mysql_query($sqlQueryStr, $con); // execute the SQL query //fetch the results as array. $arResult = mysql_fetch_array($result); $row = mysql_num_rows($result); if ($row > 0) { // fetch the record // $_SESSION['basicinfo'] = $result; // put the record into the session $_SESSION['basicinfo'] = $arResult; header('Location: homepage.php'); // redirect to the homepage. } else { // header('Location: LoginPage.html'); // redirect to the login page. echo 'login not successful'; }
function sql_select($sql) { // Выполнение запроса $result = mysqli_query(getDbConnect(), $sql); if (!$result) { die(mysqli_error(getDbConnect())); } // извлекаем из БД данные $array = array(); while ($row = mysqli_fetch_assoc($result)) { $array[] = $row; } return array($array); }
function sql_escape($param) { return mysqli_escape_string(getDbConnect(), $param); }