Skip to content

Instantly share code, notes, and snippets.

@Kcko

Kcko/like.php

Last active March 20, 2019 14:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Kcko/2f2d8f1b146e57ed63aaf235f8d479e7 to your computer and use it in GitHub Desktop.
Save Kcko/2f2d8f1b146e57ed63aaf235f8d479e7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
like.php
<?php
$con->table('table_name')->where('name LIKE ?',new \Nette\Database\SqlLiteral($con->getSupplementalDriver()->formatLike('John Doe', 0)));
$con->table('table_name')->get(1)->update(array('updated_at'=>new \Nette\Database\SqlLiteral('NOW()')))
// SET quantity = quantity + 1
array('quantity' => new \Nette\Database\SqlLiteral('quantity + 1'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment