SELECT users.fname, planets.name
FROM users
LEFT JOIN planets ON (users.planet_id = planets.id)
WHERE users.lname LIKE '%hawk%'
$name = "hawk";
$userResults = DB::table('users')
->leftJoin('planets', function($join) {
$join->on('users.planet_id', '=' , 'planets.id');
})
->where('users.lname' , 'like', '%'.$name.'%')
->get(array('users.fname', 'planets.name'));
SELECT *
FROM users
WHERE planet = 'earth'
AND (fname LIKE '%hawk%' OR lname LIKE '%hawk%')
AND state = 'FL'
ELOQUENT SQL:
$name = "hawk";
$usersResults = DB::table('users')
->where('planet', '=', 'earth')
->where(function($query) use ($name){
$query->where('fname' , 'like', '%'.$name.'%');
$query->orWhere('lname' , 'like', '%'.$name.'%');
})
->where('state', '=', 'FL')
->get();
<link rel=”stylesheet” href=”<?php bloginfo(‘stylesheet_url’); ?>” type=”text/css” media=”screen” />
<link rel=”stylesheet” href=”<?php bloginfo(‘stylesheet_url’); ?>” type=”text/css” media=”screen, print” />
SUBSTR([input],[start],[length])
select substr('orange.apple',1,(instr('orange.apple','.')) - 1)
from dual
select substr('orange.apple',1,(instr('orange.apple,'.')) - 1) as First,
substr('orange.apple', (instr('orange.apple','.')) + 1) as Second
from dual
$("#sample").modal({
maxWidth:800, minHeight:800,
onShow: function(dialog) {
$("html,body").css("overflow","hidden");
//YOur remaining javascript...
},
onClose: function(dialog) {
$("html,body").css("overflow","auto");
$.modal.close();
}
});
app/tmp/cache/models/*.
curl -s https://raw.github.com/xdissent/ievms/master/ievms.sh | bashcurl -s https://raw.github.com/xdissent/ievms/master/ievms.sh | IEVMS_VERSIONS="7" bashcurl -s https://raw.github.com/xdissent/ievms/master/ievms.sh | IEVMS_VERSIONS="8" bashcurl -s https://raw.github.com/xdissent/ievms/master/ievms.sh | IEVMS_VERSIONS="9" bashsvnadmin dump /path/to/repository > repo_name.dump
svnadmin create /path/to/repository
svnadmin load /path/to/repository < repo_name.dump