<?php mb_internal_encoding("UTF-8"); $finded = 'шел по лесу ежик'; $finded = mb_strtoupper(mb_substr($finded, 0, 1)) . mb_substr($finded, 1); $finded = preg_replace('/\s+/u', ' ', $finded); var_dump($finded); Come back.string 'Шел по лесу ежик' (length=29)

I think the request should look like:select * from ( select dateTime, a, b, c from followers where toId = :id AND dateTime >= NOW() - INTERVAL 30 DAY order by dateTime desc limit 50 ) A UNION ALL select * from ( select dateTime, a, b, c from likes where toId = :id AND dateTime >= NOW() - INTERVAL 30 DAY order by dateTime desc limit 50 ) A order by dateTime desc limit 50 If there's no need to remove the duplicates better UNION ALLit's faster (and it's unlikely to be duplicated from different tables).Data should be reduced as soon as possible in each part of the request, so that union Do not do any extra work by uniting what will be left out.The number of columns and data types returned by each request shall be the same

You don't have the entire code where the $sstmt is involved in the request.That's where you're supposed to have some sort of htmlentities at the time of the swinging of the terms from selecting where you've got it in query.

$data = $pdo->query("SELECT * FROM table")->fetchAll(); $keys = array_keys($data[0]); foreach ($keys as $title) echo "<th>$title</th>"; foreach ($data as $row) // выводим строки с данными

and$sql = $this->db->prepare('SELECT login FROM Users WHERE login = :login'); $sql->execute(array('login'=>$login)); return $sql->rowCount();

Got it. When I set up a block with conditions, I made parameters in ''. Something like:WHERE param = ':param'It turns out that this cannot be done and should be right:WHERE param = :paramThank you all for your help!

The function may be used to obtain the identifier of the last recorded record. lastInsertId♪In this case, it should be called after the first challenge. execute:$lastId = $db->lastInsertId(); // $db коннект к базе. Then you can use it. $latsId follow-up requests. http://php.net/manual/ru/pdo.lastinsertid.php

Thank you, everyone.$dsn = "dblib:host=$host;dbname=$dbname"; $dbh = new PDO($dsn, $user, $password); $val='blinstvo'; $tmt = $dbh->prepare( "INSERT INTO pbx.dbo.tmp (name) VALUES( '$val' )"); $dbh->beginTransaction(); $tmt->execute(); $dbh->commit();

In pdo there are transactions and prepared expressions http://php.net/manual/ru/pdo.commit.php $dbh->beginTransaction(); /* Вставка множества записей по принципу "все или ничего" */ $sql = 'INSERT INTO fruit (name, colour, calories) VALUES (?, ?, ?)'; $sth = $dbh->prepare($sql); foreach ($fruits as $fruit) { $sth->execute(array( $fruit->name, $fruit->colour, $fruit->calories, )); } /* Фиксация изменений */ $dbh->commit(); But I'm not sure it'll help.

(1) We need to check the empty lines. before <?php and after ?>If you find empty lines, remove them.(2) Do the same at config.php.UPD DocumentsIf the file contains only the PHP code, it is preferable to delete closing the tag at the end of the file. It helps to avoid adding Instantaneous symbols ruptured or retransmitted after closing the current PHP, which may cause undesirable effects, as PHP begins to release data to the buffer without intention The programmer shall release any data at this point of the crypt.

You're a genius.case 'news': $NewsModel = new NewsModel(); $newsArray = $NewsModel->getAllNews(); $pageNavigation = new Pagination($newsArray, $_limitPerPage); //Навигация: Получаю весь масив, потом делю его на равные части | array_chunk() $newsContent = $pageNavigation->dividedArray($_position); break; Why would you choose all the news to make a partial conclusion? It is possible to limit itself to a request SELECT COUNT(*) FROM news_content; Use LIMIT $page * $per_page, $per_page;Another place $rightBotNews = $NewsModel->getAllNews(); $rightBotNew = DataAssist::shuffle($rightBotNews, 3); Can I help you?SELECT * FROM news_content ORDER BY RAND() LIMIT 3;

I found the answer: the problem was htaccess. There's rules rewrite. This file was processed twice.

In addition to reply @Firepro. Usually it's easier to put the parameters in execution - because he's asking for an associated inlet, which is very good for the eye:$stmt = $dbh->prepare("INSERT INTO REGISTRY (name, value) VALUES (:name, :value)"); $stmt->execute([':name' => 'one', ':value' => 1]); $stmt->execute([':name' => 'two', ':value' => 2]); Let's see what $dbh->quote For all the parameters of the request, this is automatic.

It's just that he doesn't find a Db file.In your lorem.php, the import of Class Db is prescribed and a relative path is indicated. When you're calling to include, all the relative paths of the included file begin to be considered as to the location of file B, which it is included.So if your lorem.php saysrequire 'class/Db.php'; To do soinclude_once('/../models/lorem.php'); Db.php Not looking for /../models/class♪ class/ concerning the catalogue of starts of the basic violin.Read it. http://php.net/manual/ru/language.oop5.autoload.php

It doesn't matter. Type code$dbh = new PDO(...); $dbh2 = new PDO(...); Always. It'll open two compounds. Relative to what type of compound is used and what parameters are transmitted.I also wish to point out that, in the case of access to different databases that are accessible to the same user, more than one connection in this case is not necessary: it is always possible to select an OBD or a standard request. USE db_name or indicate directly in the request through reference to the name of the table.

We'll use the function of the electorate. PDO::fetchAll and sampling styles FETCH_GROUP which group data in the first column and FETCH_NUM Make the line masks indexed only by order of column (excluding the names of columns).$sql = "select X,col1,col2 from TableX"; $stmt = $db->query($sql); $result = $stmt->fetchAll(PDO::FETCH_GROUP|PDO::FETCH_NUM);

Remove INSERT WHERE login = :loginWHERE operator is not defined for design INSERT.

One of the fetch fucations, for example, can be used. fetchAll()$prepare = $db -> prepare("SELECT * FROM table WHERE a = ?"); $prepare -> execute(["value"]); $results = $prepare->fetchAll(); foreach($results as $result) echo $result['name']."<br />";

Every php user, not even a software player, should make a habit of reading error reports. And it's important to read the whole thing, not just the first few words.Usually, the erroneous report details what the problem is.For example, in this case, we're writing that the user is trying to copy with the name DATABASE_USERNAME, which looks quite unusual, and more like the name. Constantsthan in the name of the database.We're looking at the code and we're convinced that, yes, the constant is taken for some reason, and in the end, it's not its meaning, it's literally the line DATABASE_USERNAME. If you remove the skirts, the connection to the PDO will be successful.To use the constants in the DSN line, the content should be:$dsn = 'mysql:dbname='.DATABASE_NAME.';host='.DATABASE_HOST Again, I recall the need to record the correct and relevant values in the above-mentioned constants.

At least... $query->fetch(0 > 0)♪ You're a function. fetch transfer value equal to falseAnd the check is out. if($query->fetch(false))... There's no way to getRow. prepare() execute() for example fetchAll()by prepare() describes the requestby execute() Implementing the request by adding the phoneby fetchAll() You get everything you find.Example: $query = $pdo->prepare("SELECT COUNT(id) FROM products WHERE tel=:telephone"); $query->execute(array(':telephone' => $_POST['telephone'])); $result = $query->fetchAll();