pdo

Hi everyone, heh. In general, if it is not difficult to tell me what the problem may be, the execute method does not save any ... RAM_INT); if ($result->execute()) { return $db->lastInsertId(); } return 0; }

Help me figure out how to tell the PDOStatement object that it would give an array with SELECT, SHOW, DESCRIBE or EXPLAIN, an ... ;fetch( PDO::FETCH_ASSOC ) ){ $response->rows[] = $row; } return $response; } } Thank you for your answers.

The world has long used mysqli and PDO. Many people actively promote them: there are prepared variables, everything becomes s ... it does, then... I'm shocked)) P.S. Perhaps this question has already been considered, I don't know, I'm sorry in advance.

There is a function that returns an associative array: public function getSports(): array { $sql = 'SELECT id, n ... y id and name? P.s. I read the documentation, it seems that you need to pass constants to fetchAll(), but I didn't find any.

In general, I work with PDO recently and have already broken the govolu to understand I can't understand what the error is he ... rver\\d...') #3 {main} thrown in D:\OpenServer\domains\InterMag.ru\model\model.php on line 138 Tell me where the error is??

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1130] Host 'xxx.xxx.xxx.xxx' is not all ... up? All rights to the user for remote connections are given, through Mysql Workbrench is normally connected. XAMPP server.

Good afternoon! I'm trying to output data from the database to an html table. There is a table The output code itself: ` ... esult, for some reason, the values are output 2 times. In addition, since you are not very familiar with Pdo, criticize it.

For a long time I have been tormented by the question: How to protect your site from SQL-Injection. In the old days, I used ... atabase data " , the connection is the same as specified in the article. How can you protect yourself from these injections?

$sql = 'INSERT INTO `sell`.`themes` (`name`, `preview`, `them`, `price`, `create_at`) VALUES (?, ?, ?, ?, NOW())'; $pdo->p ... ariables have quotes, they are inserted into the database without escaping, is this normal? Here is a screenshot from PMA

Salute people, krch I do not want to connect... Mysql.php <? class Mysql { private $db; private $config; ... market\core\mysql.php on line 9 Fatal error: in E:\OpenServer\OpenServer\domains\blackmarket\core\mysql.php on line 9

I have a folder config where the file is locateddb.php, which contains the following code: <?php $host = 'localhost'; $d ... on functions, like page loading and template loading. So: how do I properly initialize the PDO and connect it to the model?

Hello, friends. I can't figure out how to delete one record from the table by id when clicking on the "Delete" button <td& ... ert("Запись НЕ добавлена в список дел! Попробуйте еще");</script>'; } } ?> </body> </html>

It is impossible to bind, and PDO has no analogues mysql_real_escape_string(). Would it be correct to use PDO::quote() ? "SELECT * FROM" . $pdo->quote( $table ) ."; Or what to do in this case?

There is such a code: ... function pdq($sql, $params = array()) { global $pdo; $stmt = $pdo->prepare($sql); $stmt->exe ... orresponding "pole", in the above code, for some reason always gets the value from the text1 field. What could be the reason?

I just started learning PDO, but that's not the point, it's that I don't know where and why I'm not executing a MySQL query c ... FederatedX pluggable storage engine Aria Crash-safe tables with MyISAM heritage I use free web hosting...

I ran into a problem. How do I check if the table is empty? Via PDO

I am having difficulty viewing and inserting the data into the database, it is giving this error: SQLSTATE[42000]: Synta ... td> </tr> </table> </div><!--container--> <?php include_once 'footer.php';?>

I am studying a book in which I have to perform some queryes through a design pattern TableDataGateway but I am getting the f ... $conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION); return Produto::setConnection($conn); } }

I'm trying to send some values to SQL, but PDO doesn't work as it should, or I'm forgetting something, I'm new to using PDO. ... y? Maybe this post here from SO-pt will help. @Edit Error note: I cannot use placeholders to name tables or columns.

Well I'm with an object ' X ' that one of its properties is a JSON. This JSON contains the column name and column value respe ... T_SINCR] => N [COD_IDULT_ATUAL] => -1 [DAT_ULTIM_ATUAL] => 2015-11-05 09:13:56 ) )