{{ 'http://' ~ app.request.host }}
$request = $this->container->get('request');
$currentRouteName = $request->get('_route');
{{ game.gameDate|date('Y-m-d') }}
{{ dump(user) }}
$name=$request->query->get('name');
composer global show
var http = require("http"); http.createServer(function(request, response) { response.writeHead(200, {'Content-Type': 'text/html'}); response.write("<html>"); response.write("<head>"); response.write("<title>Hello World Page</title>"); response.write("</head>"); response.write("<body>"); response.write("Hello World!"); response.write("</body>"); response.write("</html>"); response.end(); }).listen(8081);
npm install httpdispatcher
dispatcher.onGet("/contactus", function(req, res) { res.writeHead(200, {'Content-Type': 'text/html'}); res.end('<h3> Contact US Page</h3> '); });
dispatcher.onPOST("/contactus", function(req, res) { res.writeHead(200, {'Content-Type': 'text/plain'}); res.end('<h3> Received POST Data</h3> '); });
var dispatcher = require('httpdispatcher'); function handleRequest(request, response) { try { //log the request on console console.log(request.url); //Disptach dispatcher.dispatch(request, response); } catch (err) { console.log(err); } } dispatcher.setStatic('resources'); //A sample GET request dispatcher.onGet("/contactus", function(req, res) { res.writeHead(200, {'Content-Type': 'text/html'}); res.end('<h3> Contact US Page</h3> '); }); dispatcher.onGet("/aboutus", function(req, res) { res.writeHead(200, {'Content-Type': 'text/html'}); res.end('<h3> About US Page</h3> '); }); var http = require('http'); var server = http.createServer(handleRequest); //Lets start our server server.listen(8081, function() { //Callback triggered when server is successfully listening. Hurray! console.log("Server listening on: http://localhost:%s", 8081); });
npm install packagename
npm install mysql
npm update mysql
var mysql = require("mysql");
var mysql = require("mysql");
var con = mysql.createConnection({
host: "localhost",
user: "root",
password: "",
database: "mydb"
});
con.connect(function(err) {
if (err) {
console.log('Error connecting to database');
return;
}
console.log('Connection established Successfully');
});
var mysql = require("mysql");
var con = mysql.createConnection('mysql://arun:arun@localhost/database');
con.connect(function(err) {
if (err) {
console.log('Error connecting to database');
return;
}
console.log('Connection established Successfully');
});
var mysql = require("mysql");
var con = mysql.createConnection({
host: "localhost",
user: "root",
password: "",
database: "enterprisedev2"
});
con.query('SELECT * FROM admin_members where id<=10 ', function(err, rows) {
for (var i = 0; i < rows.length; i++) {
console.log(rows[i]);
}
});
var mysql = require("mysql");
var con = mysql.createConnection('mysql://arun:arun@localhost/mydb');
var post = {
'userID': "1",
'userName': 'username',
'device': 'web',
'stream_time': "0",
'user_display_name': "arun kumar gupta",
'user_photo': "hello"
};
con.query('INSERT INTO messages set ?', post, function(err, result) {
if (err) {
console.log(err.message);
} else {
console.log('record added in db');
}
});
var mysql = require("mysql");
var con = mysql.createConnection('mysql://arun:arun@localhost/mydb');
var post = {
'userID': "1",
'userName': 'username',
'device': 'web',
'stream_time': "0",
'user_display_name': "arun kumar gupta",
'user_photo': "hello"
};
var mysqlProfiler = con.query('INSERT INTO messages set ?', post, function(err, result) {});
console.log(mysqlProfiler.sql);
var mysql = require("mysql");
var con = mysql.createConnection('mysql://arun:arun@localhost/enterprisedev2');
/* data insert in db */
var postData = {
userID: "1",
userName: "arunkg",
userRole: "1",
text: 'kkkkkkkkkkkkkkkk',
status: "1",
vid: '21'
};
var mysqlProfiler = con.query('INSERT INTO `messages` (`userID`, `userName`, `userRole`,`text`,`status`,`vid`) VALUES (' + [postData.userID, mysql.escape(postData.userName), postData.userRole, mysql.escape(postData.text), postData.status, postData.vid] + ')', function(err, result) {
if (err) {
//console.log(err.message);
} else {
console.log('record added in db');
}
});
db.user.find('{"likes": {$gt:10}"likes"}').explain("executionStats");
You can check the problem with the queries and fix the issue.db.user.find('{"likes": {$gt:10}"likes"}').limit(10);
db.user.createIndex({ country: 1 });
db.user.find().sort({ country: 1, city: 1 });
db.user.find().sort({ country: 1, city: -1 });
db.user.find().sort({ country: -1, city: 1 });
db.setLogLevel(0);0 is the MongoDB's default log verbosity level, to include Informational messages.
db.getProfilingLevel()
db.setProfilingLevel(1)
db.user.find('{"likes": {$gt:10}"likes"}').maxTimeMS(100);
$userQueryToExecute = Model_Article::query()
->select('users')
->where('blocked', '=', 1);
echo $userQueryToExecute->get_query();
try
{
$redis = \Redis::instance();
}
catch(\RedisException $e)
{
//here error will come
}
$queryObj = \Services\Model_Org::query()
->related('org')
->related('profile_image')->related( array( 'comments' => array( 'where' => array( array('visible' , '=' , '0') )
) ))
->where('rating','!=', 'null')
->order_by('rating','desc')
->get();
ManagerID (unique) Name Title DepartmentID
Suppose we have a table named Employee which has two columns EmpID and EmpMail, both are not null and have unique value. Both Field are Candidate keys.
Suppose we have a table named Employee which has two columns EmpID and EmpMail, both are not null and have unique value. So both columns are treated as candidate key. IF we make EmpID as a primary key, then EmpMail is known as alternate key.
products (table)
id (primary key)
name
price
sale_price
size
reviews (another table)
id (primary key),
product_id (foreign key)
review by
title
start_rating
mongod --dbpath "d:\mongodb\data"
mongod --version
db.users.ensureIndex({"title":1})
1- Indexing in Ascending Order.db.users.ensureIndex({"title":1,"description":-1})
1- Indexing in Ascending Order.db.users.ensureIndex({"username":1},{unique:true,sparse:true})
Now you can't add duplicate username in users collection.db.users.ensureIndex({"title":1},{background:true})
db.users.ensureIndex({"title":1},{dropDups:true})
db.users.ensureIndex({"title":1},{name:'bankdb_users_index'})
db.users.dropIndex({"title":1})
db.users.dropIndexex()
db.collection.reIndex()
db.users.ensureIndex({"profile.city":1})
db.users.find( { "profile.city" : "newYork" } )
[
{
"_id": ObjectId("52ffc33cd85242f436099901"),
"contact": "987654321",
"dob": "01-01-1991",
"name": "Tom Benzamin",
"address": [
{
"pincode": 123456,
"city": "Los Angeles",
"state": "California"
},
{
"pincode": 456789,
"city": "Chicago",
"state": "Illinois"
}
]
}
]
[
{
"_id": ObjectId("52ffc33cd85242f436099901"),
"contact": "987654321",
"dob": "01-01-1991",
"name": "Tom Benzamin",
"address": [
ObjectId("63ffc4a5d85242602e000000"),
ObjectId("63ffc4a5d85242602e000001")
]
}
]
/*select * from users where name like "%B%";*/
db.users.find({name: /B/});
/*select * from users where name like "B%"; */
db.users.find({name: /^B/});
/*select * from users where name like "%B"; */
db.users.find({name: /B$/});
/*select * from users where name like "%B%" OR like "%b%"; */
db.users.find({name: /b/i});
db.getCollectionNames()
show collections
show tables
db.users.find()
db.users.find().pretty()
db.users.find().sort({_id:-1}).limit(20);
/* -1 means descending order */
mongoexport --host localhost --db bank --collection users --csv --out e:/dump/mycsv.csv --fields name,age,gender
mongoimport -d bank -c users --type csv --file e:/dump/mycsv.csv --headerline
db.students.updateMany( {}, { $rename: { "name": "full_name" } } )
db.users.insert({date: ISODate("2014-02-10T10:50:42.389Z")})
var myCursor=db.users.find({"age":30});
while (myCursor.hasNext()) {
print(tojson(myCursor.next()));
}
var data=10; typeof data; var data='10'; typeof data;Output
number string
db.users.find({"age":30}).forEach(printjson);
db.users.find({"age":30}).forEach(function(data){
print(data.name);
});
Output
name1 name2 name3
db.users.find({"age":30}).limit(5).pretty();
Now, cursor will return maximum 5 records.
db.users.find({"age":30}).toArray()
db.users.find({"age":30}).size(); //2
db.users.find({"age":30}).sort({"name":1}).forEach(function(data){print(data.name);});
db.users.find({"age":30}).sort({"name":-1}).forEach(function(data){print(data.name);});
db.users.find({"age":30}).skip(4).forEach(function(data){print(data.name);});
db.users.find({"age":30}).hint({"age":1}).pretty();
db.stats();
{
"db": "bank",
"collections": 4,
"objects": 12,
"avgObjSize": 245.33333333333334,
"dataSize": 2944,
"storageSize": 28672,
"numExtents": 4,
"indexes": 2,
"indexSize": 16352,
"fileSize": 67108864,
"nsSizeMB": 16,
"extentFreeList": {
"num": 0,
"totalSize": 0
},
"dataFileVersion": {
"major": 4,
"minor": 22
},
"ok": 1
}
db.users.stats();Output
{
"ns": "bank.users",
"count": 5,
"size": 2480,
"avgObjSize": 496,
"numExtents": 1,
"storageSize": 8192,
"lastExtentSize": 8192,
"paddingFactor": 1,
"paddingFactorNote": "paddingFactor is unused and unmaintained in 3.0. It remains hard coded to 1.0 for compatibility only.",
"userFlags": 1,
"capped": false,
"nindexes": 1,
"totalIndexSize": 8176,
"indexSizes": {
"_id_": 8176
},
"ok": 1
}
JSON Data load_data.php[script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.4.8/angular.min.js"][/script] [script src="http://ajax.googleapis.com/ajax/libs/angularjs/1.4.8/angular-animate.js"][/script] [style] .secdsubmenu{position:absolute; right:22px; top:2px; border:1px solid #eee; background:#fff; z-index:99} .secdsubmenu ul {padding:10px; margin:0} .secdsubmenu ul li{list-style:none; font-size:13px; color:#333; padding:0; margin:0; white-space:nowrap; border-bottom:1px solid #eee; height:30px; line-height:30px; } .secdsubmenu ul li a{color:#333; text-decoration:none} [/style] <div ng-app="myAppName" ng-controller="myCtrl"> <div class="inputfield"> <input ng-model="$ctrl.query" placeholder="Search" type="text" /> </div> <table border="1" cellpadding="2" cellspacing="0" style="width: 500pxpx;"> <tbody> <tr> <th>Title <button ng-click="sortBy('Title')">></button></th> <th>Date & Time</th> <th>Status</th> <th>Action</th> </tr> <tr ng-repeat="x in names| filter:$ctrl.query | orderBy:Title:reverse"> <td>{{x.Title}}</td> <td>{{x.DateTime}}</td> <td>{{x.Status}}</td> <td><a href="https://www.blogger.com/blogger.g?blogID=5911253879674558037#" ng-click="mySubmenu = !mySubmenu">...</a> <br /> <div class="secdsubmenu" ng-show="mySubmenu"> <ul> <li><a href="https://www.blogger.com/blogger.g?blogID=5911253879674558037#">Edit</a></li> <li><a href="https://www.blogger.com/blogger.g?blogID=5911253879674558037#">Delete</a></li> <li><a href="https://www.blogger.com/blogger.g?blogID=5911253879674558037#">View URL</a></li> <li><a href="https://www.blogger.com/blogger.g?blogID=5911253879674558037#">Embeded Code</a></li> </ul> </div> </td> </tr> </tbody></table> </div> [script] var myApp = angular.module('myAppName', ['ngAnimate']); myApp.controller('myCtrl', function($scope, $http) { $http.get("load_data.php") .then(function(response) { $scope.names = response.data.records; }); $scope.mySubmenu = false; $scope.Title = 'title'; $scope.reverse = true; $scope.sortBy = function(title) { $scope.reverse = ($scope.title === title) ? !$scope.reverse : false; $scope.title = title; }; }); [/script]
{ "records":[
{"Title":"Title 1","DateTime":"Jul 29 2016, 01:00 AM","Status":"Completed"},
{"Title":"Title 2","DateTime":"Jul 28 2016, 02:00 PM","Status":"Completed"},
{"Title":"Title 3","DateTime":"Jul 27 2016, 03:00 AM","Status":"Completed"},
{"Title":"Title 4","DateTime":"Jul 26 2016, 04:00 AM","Status":"Completed"},
{"Title":"Title 5","DateTime":"Jul 25 2016, 05:00 AM","Status":"Completed"},
{"Title":"Title 6","DateTime":"Jul 24 2016, 06:00 AM","Status":"Completed"},
{"Title":"Title 7","DateTime":"Jul 23 2016, 09:00 AM","Status":"Completed"},
]}
function sum(int ...$ints) {
return array_sum($ints);
}
print(sum(2, '20', 4.2)); //26.2
function returnIntValue(int $value): int {
return $value;
}
print(returnIntValue(5));
print( 1 <=> 1); //0 print( 1 <=> 2); //-1 print( 2 <=> 1); //1
define('CLIENTS', [
'client 1',
'client 2',
'client 3'
]);
class A {
private $x = 1;
}
$value = function() {
return $this->x;
};
print($value->call(new A));
use com\mytestclass\ClassA; use com\mytestclass\ClassB; use com\mytestclass\ClassC as C;
use com\mytestclass\{ClassA, ClassB, ClassC as C};
class A {
function A() {
print('Deprecated');
}
}
class A {
function b() {
print('Deprecated');
}
}
A::b();
trait Hello {
public function sayHello() {
echo 'Hello ';
}
}
use Hello, World;When two traits have same function, it would conflict but we can fix using insteadof like below
A::bigTalk insteadof B;We can set the visibility of function using "as" like below
use HelloWorld { sayHello as protected; }
__get(), __set(), __isset() __unset() __call() __callStatic()