1. Home
2. php - Save random_bytes-generated key in database using Doctrine

75 votes

1 answers

php - Save random_bytes-generated key in database using Doctrine

Get the solution ↓↓↓

I am trying to generate a relatively secure key and store it in the database. I am using PHP Symfony and Doctrine to manage my MySQL-Database. Here is my code:

$account->setVk(random_bytes(32));
$entityManager = $this->getDoctrine()->getManager();
$entityManager->persist($account);
$entityManager->flush();
Copy code

I always get the following error:

SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xB7\xC3!\xEC\xE0\xCD...'
Copy code

Just using a normal String like '12345' works well. Vk is a column of type String with the length of 255. Why is the String weirdly formatted like that and why wont Doctrine not accept the String generated by random_bytes? (Although I think the error is more on the MySQL side of things)

Undefined asked

2021-11-24

Write your answer

---

57

votes

Answer

Solution:

You are triying to save a random string (random_bytes) in a property defined in database as DateTime type.

Go to account entity and check the $vk property. You should change ORM/Column to strig if you really need to save a random string.

Write your answer

---

Share solution ↓

Additional Information:

Date the issue was resolved:

2021-11-24

Link To Source
Link To Answer People are also looking for solutions of the problem: ftp_put(): can't open that file: no such file or directory

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Ask a Question

---

Similar questions

Find the answer in similar questions on our website.

44 php - Save data to two different tables in CakePHP 3

185 php - Using PHPThumb and Thickbox/Colorbox

431 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP

811 php - File format or extension invalid PHPExcel

570 Form action is not using the PHP file?

303 oop - php - access class parent variable not using $this

226 php - Database Error mysqli_init()

501 php - Cakephp 2.8.4 ignoring hasMany

492 php - Why should you validate forms using javascript?

510 php - Filter content from mysql db with checkboxes using jQuery?

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.

About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/

Symfony

Symfony compares favorably with other PHP frameworks in terms of reliability and maturity. This framework appeared a long time ago, in 2005, that is, it has existed much longer than most of the other tools we are considering. It is popular for its web standards compliance and PHP design patterns.
https://symfony.com/

MySQL

DBMS is a database management system. It is designed to change, search, add and delete information in the database. There are many DBMSs designed for similar purposes with different features. One of the most popular is MySQL. It is a software tool designed to work with relational SQL databases. It is easy to learn even for site owners who are not professional programmers or administrators. MySQL DBMS also allows you to export and import data, which is convenient when moving large amounts of information.
https://www.mysql.com/