Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Все значения сохраняются в MySQL как "0"
- $sql = 'insert into users values (
- user_id = :user_id,
- first_name = :first_name ,
- last_name = :last_name,
- email = :email,
- pass_hash = :pass_hash
- )';
- $stmt = $this->dbal->prepare($sql);
- $stmt->bindValue('user_id', null);
- $stmt->bindValue('first_name', 'Jack');
- $stmt->bindValue('last_name', 'Kname');
- $stmt->bindValue('email', 'sdfs@sdfdsf');
- $stmt->bindValue('pass_hash', 'name');
- $stmt->execute();
- // Сохраняет все норм
- $qB = $this->dbal->createQueryBuilder();
- $qB
- ->insert('users')
- ->values(
- array(
- 'user_id' => '?',
- 'first_name' => '?',
- 'last_name' => '?',
- 'email' => '?',
- 'pass_hash' => '?'
- )
- )
- ->setParameter(0, NULL)
- ->setParameter(1, 'Jack')
- ->setParameter(2, 'Jonson')
- ->setParameter(3, 'Jack4asd@mail.ru')
- ->setParameter(4, 'Jack123')
- ;
- $result = $qB->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement