mysqlmusings.blogspot.com

blog.andrewrose.co.uk

Andrew Rose: May 2010

http://blog.andrewrose.co.uk/2010_05_01_archive.html

Wednesday, 26 May 2010. ExtJS - loading grid record into form with loadRecord() but getting the displayField instead of valueField submitted. A long title I know, but today was one of those days that every programmer dreads. a day with a small problem that takes more than 5minutes to figure out. This one took me a whole day! Reasons; partly because of a lack of documentation, partly me giving ExtJS to much magic credit and mostly me over-thinking the problem. You need to set the hiddenName value in the c...

blog.andrewrose.co.uk

Andrew Rose: January 2008

http://blog.andrewrose.co.uk/2008_01_01_archive.html

Wednesday, 30 January 2008. LAMP: The mailing lists you *SHOULD* be subscribed to. The LAMP stack consists of some complicated software, and this software from time to time will develop faults and security flaws. How do you keep yourself informed? Hope that the issues crop up on Digg, Slashdot? Well the best way is to join the Announce lists for each of the LAMP stack components. The first one is dependent on the GNU/Linux distribution your running, in my case it is Archlinux, so I've subscribed to:.

blog.andrewrose.co.uk

Andrew Rose: September 2011

http://blog.andrewrose.co.uk/2011_09_01_archive.html

Tuesday, 20 September 2011. MongoDb numeric field selection in PHP. If you are attempting to use numeric field selection with MongoCollection: find() and run into the error:. PHP Fatal error: Uncaught exception 'MongoException' with message 'field names must be strings'. It is caused by PHP converting an array key that is defined as a string into an integer, so:. Array('123' = 0);. Array(123 = 0);. Fields = new stdClass;. Fields- {123} = 0;. Posted by Andrew Rose. Subscribe to: Posts (Atom).

blog.andrewrose.co.uk

Andrew Rose: Roll your own N-server sandbox

http://blog.andrewrose.co.uk/2008/02/roll-your-own-n-server-sandbox.html

Tuesday, 5 February 2008. Roll your own N-server sandbox. Have you ever wanted to play around with(test ;) MySQL replication/clustering techniques, LVS/Apache load balancing etc but didn't have the hardware available and where smart enough not to use a production environment? Well an easy way to be able to do this is by creating a sandbox environment using something like qemu. Root@ishell ]# pacman -S user-mode-linux uml utilities. Root@ishell ]# mkdir servers. Root@ishell ]# cd servers. Root@ishell ]# i...

blog.andrewrose.co.uk

Andrew Rose: LAMP: The mailing lists you *SHOULD* be subscribed to.

http://blog.andrewrose.co.uk/2008/01/lamp-mailing-lists-you-should-be.html

Wednesday, 30 January 2008. LAMP: The mailing lists you *SHOULD* be subscribed to. The LAMP stack consists of some complicated software, and this software from time to time will develop faults and security flaws. How do you keep yourself informed? Hope that the issues crop up on Digg, Slashdot? Well the best way is to join the Announce lists for each of the LAMP stack components. The first one is dependent on the GNU/Linux distribution your running, in my case it is Archlinux, so I've subscribed to:.

blog.andrewrose.co.uk

Andrew Rose: April 2008

http://blog.andrewrose.co.uk/2008_04_01_archive.html

Friday, 11 April 2008. I wouldn't normally post OT on my blog but this is for a good cause. I'm running the Manchester 10k. On the 18th of May and am trying to raise £200 for the Rainbow Family Trust (Francis House) who support and improve the quality of life for terminally ill children diagnosed with 'no cure'. So dig deep and help me reach my target by going to this site and making a donation: http:/ www.justgiving.com/. Posted by Andrew Rose. Subscribe to: Posts (Atom). View my complete profile.

schlueters.de

Sharding PHP with MySQL Fabric - Johannes Schlüter

http://schlueters.de/blog/archives/175-Sharding-PHP-with-MySQL-Fabric.html

Sharding PHP with MySQL Fabric. This is a random item from my wishlist:. Advanced Compiler Design and Implementation. The full list is on amazon.de. Sharding PHP with MySQL Fabric. PHP users who attended any of my recent PHP&MySQL related talks or read Ulf's blog. Will know our mysqlnd ms plugin. At this year's MySQL Connect conference we've announced the initial labs release. So I'll be quite fast in some areas, for details please refer to the documentation and the mentiond blogs. Mysqlfabric setup $ my...

blog.andrewrose.co.uk

Andrew Rose: December 2007

http://blog.andrewrose.co.uk/2007_12_01_archive.html

Thursday, 6 December 2007. MySQL: Unlimited updates in one query - ish. One of the major parts of my job is/was developing the interface to our MIS that handles hundreds of connections on a nightly basis from other MIS systems which push data in a CSV format. These CSV files contain information that then needs to be pushed into our MIS (thousands of inserts and updates, plus some deletes). First create a test table:. Now we want to turn:. Update test1 set name = 'John 2' where sid = 1 and staffid = 'jm';.

blog.andrewrose.co.uk

Andrew Rose: June 2013

http://blog.andrewrose.co.uk/2013_06_01_archive.html

Friday, 21 June 2013. Uploading files with CURL in PHP the right way. Uploading files with CURL in PHP use to involve prefixing the file path with an @ using a POST param. But recently PHP has added curl file create() see: https:/ wiki.php.net/rfc/curl-file-upload. With this you can now upload a file as easily as:. Params = ['file key' = curl file create('. Curl setopt($ch, CURLOPT POST,1);. Curl setopt($ch, CURLOPT POSTFIELDS, $params);. PHP takes another step in the right direction ;-).