php - Getting the number of affected rows including those not changed -

-

i doing statement this:

update tbl set x = 1 y = 2

and using rowcount pdo whether or not row changed (y unique, either none or 1 row updated). isn't need though, since, using previous example, if x already 1, rowcount() 0 since no row changed previous value. need know whether row matched where clause.

is there way without doing query?

it turns out pdo has thing: pdo::mysql_attr_found_rows.


Comments

Post a Comment

Popular posts from this blog

rest - Spring boot: Request method 'PUT' not supported -

-
i getting request method 'put' not supported error on hitting put method on restful api upload file. following information uploaded ticket. client log restcontroller spring boot app config tomcat log pom.xml 1. client log $ curl -x put -t "/cygdrive/c/a/documents/test.pptx" http://localhost:8080/piranha-storage-service/buckets/gnaval.bucket1/test.pptx <html><head><title>apache tomcat/7.0.52 - error report</title><style><!--h1 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:22px;} h2 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:16px;} h3 {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;font-size:14px;} body {font-family:tahoma,arial,sans-serif;color:black;background-color:white;} b {font-family:tahoma,arial,sans-serif;color:white;background-color:#525d76;} p {font-family:tahoma,arial,sans-serif;background:white;co...
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

symfony - imagine_filter() not generating the correct url in LiipImagineBundle -

-
i think there bug in bundle liipimaginebundle. explain: here new config of bundle: liip_imagine: resolvers: default: web_path: web_root: %kernel.root_dir%/../web/img # %kernel.root_dir%/../web/img folder filtered images created! cache_prefix: media/cache # media/cache prefix of folder cached images created filter_sets: cache: ~ my_thumb: quality: 75 filters: thumbnail: { size: [120, 90], mode: outbound } this twig part displaying image: {# way filtered image not created!#} <img src="{{ 'img/test.jpg' | imagine_filter('my_thumb') }}" /> {# way, filted images created. asset() must used. #} <img src="{{ asset('img/test.jpg' | imagine_filter('my_thumb')) }}" /> the generated link of image not correct! in fact, obtained link is: http://localhost/media/cache...
Read more