Full Stack LAMP, MEAN, DevOps Consultant
In this post i would like to list basic to advanced database queries using ZF2. I am gonna use TableGateway methods here. Simple Select Query
|
1 2 3 4 5 6 7 |
// use Zend\Db\TableGateway\TableGateway; // use Zend\Db\Sql\Select; $adapter = $this->getServiceLocator()->get('Zend\Db\Adapter\Adapter'); $projectTable = new TableGateway('users', $adapter); $rowset = $projectTable->select(); print_r($rowset->toArray()); exit; |
|
1 |
SELECT `users`.* FROM `users` |
Recently i got “too many connections” errors in MySQL, after quick research i found a solution to fix this issue.This issue due to connection limit of my MySQL installation.We can change the max_connections […]
Here the simple AngularJS tutorial on creating Cascading DropDownList with Angular JS.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
<!DOCTYPE html> <html> <head> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/angularjs/1.0.7/angular.min.js"></script> <script> function CountryController($scope) { $scope.countries = { 'India': { 'Andhra Pradesh': ['Vijayawada', 'Guntur', 'Nellore', 'Kadapa'], 'Madhya Pradesh': ['Hyderabad', 'Warangal', 'Karimnagar'], }, 'USA': { 'San Francisco': ['SOMA', 'Richmond', 'Sunset'], 'Los Angeles': ['Burbank', 'Hollywood'] }, 'Australia': { 'New South Wales': ['Sydney','Orange','Broken Hill'], 'Victoria': ['Benalla','Melbourne'] } }; } </script> </head> <body> <div ng-app class="container"> <div ng-controller="CountryController"> <div class="form-group"> <label class="control-label" for="Country">Country:</label> <select class="form-control input-lg" id="country" ng-model="states" ng-options="country for (country, states) in countries"> <option value=''>Select</option> </select> </div> <div class="form-group"> <label class="control-label" for="States">States:</label> <select class="form-control input-lg" id="state" ng-disabled="!states" ng-model="cities" ng-options="state for (state,city) in states"> <option value=''>Select</option> </select> </div> <div class="form-group"> <label class="control-label" for="City">City:</label> <select class="form-control input-lg" id="city" ng-disabled="!cities || !states" ng-model="city" ng-options="city for city in cities"> <option value=''>Select</option> </select> </div> </div> </div> </body> </html> |
In this post i would like to write about Angular JS ngClassOdd,ngClassEven directives , by using this directories we can take effect only on odd rows or on even rows. This directives work exactly as ngClass and this directives […]
By default Xampp server is run on 80 port, if you want to change this port to something, just follow the below steps it is pretty easy. Before you start changing anything, make sure you don’t have Xampp running somewhere, […]
While moving databases from development to production and vice versa it is sometimes necessary to export individual tables so that they can be imported into another database. So in this post i will show you how to export […]
Syntax to copy one existent MySQL table from one database to another database:
|
1 |
CREATE TABLE `new_database`.`table` SELECT * FROM `old_database`.`table`; |
|
1 |
CREATE TABLE `database`.`table` SELECT * FROM `database`.`table`; |
Indexes allow the database application to find data fast, without reading the whole table.The CREATE INDEX statement is used to create indexes in tables. CREATE INDEX Syntax
|
1 |
CREATE INDEX index_name ON table_name (column_name) |
The PHP Internationalization extension is used in almost all modern frameworks. The extension is useful for formatting currency, number and date/time as well as UCA-conformant collations, for message formatting and normalizing […]
Recently i tried to install YII2 ,i got “The mcrypt PHP extension is not installed.” error. In this post, I will show you how to fix this issue and show you how to install mcrypt. What’s mcrypt? MCrypt […]
