How to establish oracle database connection in php
First of all you need to check whether “oci8” support is enabled or not, if not you have to enable that you can check this in your phpinfo file. Once…
How to import data into mysql db from sql file
Open your shell prompt navigate to the mysql directory (default is /var/lib/mysql) cd /pathToYourMysqlDirectory/ then type the below command $ mysql -u mysqlUserName -p Password -h HostName DatabaseName < /loactionOfYourSqlFile/yourSqlFileName.sql…
How to copy file from local machine to remote server in linux
scp fileName userName@remoteServerIP:remoteServerFolderPath Example : >scp abc.txt root@XXX.XXX.XXX.XXX:/home/xyzFolder/ once you type this command, system will ask for the remote server login password.once password is verified , file get copied to…
check whether any of the checkbox are checked or not
function isChecked(url) { f=document.frmName var checkFound = false; for (var counter=0; counter < f.length; counter++) { if ((f.elements.name == ‘checkBoxId’) && (f.elements.checked == true)) { checkFound = true; } }…
Check or uncheck multiple checkbox at a time in javascript
function checkUncheckAllCheckbox() { f=document.frmName if(f.mainCheckBox.checked) { f.checkBoxName.checked=true; for(i=0;i<f.checkBoxName.length;i++) f.checkBoxName.checked=true; } else if(!f.mainCheckBox.checked) { f.checkBoxName.checked=false; for(i=0;i<f.checkBoxName.length;i++) f.checkBoxName.checked=false; } }
How to add or condition in mysql query in symfony
$c->add(TblUsersPeer::USR_TYPE,array(2,3,6),Criteria::IN); $c1 = $c->getNewCriterion(TblUsersPeer::USR_PARENTID,$this->getUser()->getAttribute(‘userid’),Criteria::EQUAL); $c2 = $c->getNewCriterion(TblUsersPeer::USR_PARENTID,null, Criteria::ISNULL); $c1->addOr($c2); $c->add($c1);
How to configure the symfony project directory
Your symfony project derectory is “/var/www/html/sf_sandbox” so in the browser you can acess this by this URL : “http://localhost/sf_sandbox/web/frontend.php/” So if you want to map the symfony project directoy to…
How to redirect domain to other directory on the same domain
Open the .htaccess file of your root directory of your project and add the following line. RewriteEngine On RewriteCond %{HTTP_HOST} !^http://someDomainName.com RewriteCond %{HTTP_HOST} !^http://www.someDomainName.com RewriteCond %{HTTP_HOST} !^$ RewriteCond %{REQUEST_URI} !^/someOtherDirectory/…
integrate window media player in your website
<html> <head></head> <body leftmargin=”0″ topmargin=”0″> <table cellpadding=”0″ cellspacing=”0″ border=”0″> <tr height=”350″><td align=”center”> <table cellpadding=”0″ cellspacing=”0″ border=1 bordercolor=”black”> <tr> <td valign=”top”> <OBJECT ID=”MediaPlayer” WIDTH=”320″ HEIGHT=”290″ CLASSID=”CLSID:22d6f312-b0f6-11d0-94ab-0080c74c7e95″ STANDBY=”Loading Windows Media Player components…”…
Calculate no of years,month,days,hours,minutes and seconds past since given date
function getYMDHMSPastFromTwoDate($startTimeStamp,$endTimeStamp) { $years = ”; $Month = ”; $Days = ”; $Hrs = ”; $Mins = ”; $totalSecs = ”; $timePastArr = array(); $date1 = $startTimeStamp; $date2 = $endTimeStamp;…