-
@ symbol before any variable
Why do we put @ symbol before any variable?
-
ob_start()
What is the use of ob_start() in PHP?
abc
- Sep 12th, 2011
It starts object buffering
bansal richa
- Aug 23rd, 2011
This function will turn output buffering on. While output buffering is active no output is sent from the script (other than headers), instead the output is stored in an internal buffer.
-
Average Department Salary
How to Get the employee details whose salary is less than the average salary of the department.
dj_dj_dj
- May 20th, 2010
select emp_name, avg(salary)from employees group by emp_namehaving avg(salary) < (Select avg(salary) &...
g.sreemayee
- May 19th, 2010
SELECT * FROM emp e WHERE sal> (SELECT AVG(sal) FROM emp GROUP BY deptno HAVING deptno=e.deptno) ORDER BY deptno;
-
Create MySQL Database in PHP
How to create a MySQL Database in PHP?
Tejanshu
- Mar 8th, 2010
mysql_query("CREATE DATABASE databasename", connector) is the answer. Where mysql_query() is the PHP function that uses the CREATE DATABASE mysql command.Here is a small code snippet. ...
rubin2008
- Jan 14th, 2010
Mysql database can be created using php by executing CREATE DATABASE query using mysql_query() function in php
-
Arrays
How to combine 2 arrays?
rubin2008
- May 16th, 2010
Arrays can be combined using array_merge() function Description of array_merge function is as follows.array_merge() merges the elements of one or more arrays together so that the values of one are appended to the end of the previous one. It returns the resulting array.
gmanon
- Feb 3rd, 2010
//The array_merge() and array_combine(), both combine arrays. /*It merges two arrays, one after the other.*/$comArrays = array_merge(Array1,Array2);$comArrays = $larger_array12; /*It combines tw...
-
Set JavaScript Variable Value
Can you set JavaScript variable value to php variable? Justify your answer?
El Houba Mohammed Amine
- Jun 2nd, 2014
No impossible , php is server side , java script is executed in client browser. we can set a java script variable with some php value , not the opposite
-
PHP Form Hijacking
How to prevent form hijacking in PHP?
rubin2008
- May 16th, 2010
To prevent form hijacking(1) Escape data which is being passed into sql query using mysql_real_escape_string() function.(2) Also input data must be filtered before being passed into sql query using proper validation methods and use of htmlentities() function
d4deepikajain
- Jul 13th, 2009
Few more coding practices can be done to avoid PP Form HijackingUser Input Sanitization-Never trust web user submitted data. Follow good clieint side data validation practices with regular expressions...
-
session_register and $_session
What is the difference between session_register and $_session?
abc
- Sep 12th, 2011
$_session for one or more variable
session_register for global variablesrubin2008
- May 16th, 2010
session_register is php function used to register variables with the current session.But it will work only when register globals is turned on in php.ini configuration file.$_SESSION is a supergl...
-
-
Database Connectivity in Joomla
How will you connect to the Database using Joomla?
rubin2008
- May 16th, 2010
Connection can be made to database in joomla by specifying database parameter information such as host,mysqlusername and mysql password into configuration file of joomla
technicalsathish
- Mar 23rd, 2009
What Vikas said is absolutely Correct. In Joomla there is no need to write the code for
database connectivityIf we hosted the site local into web, we have to change the configuration.php
fileIn that we have to mention the database username and password details.
CheersRegards,Sathish -
PHP Session
Where does the session stored, either client side or server side?
-
count hits
If we have a button on a simple page and a user clicks on the button, then how we can come to know how many times the user has clicked on the button?
rubin2008
- May 16th, 2010
You can try following script for determing click count on button<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt...
ashishdmc4
- Feb 8th, 2010
<html><head><script type="text/javascript">var ctr=0;function countercall(){ ctr++;}function show(){ alert(ctr); }</script></head><body><div style=&quo...
-
Create a query that will display the total number of employees and of that total the number who were hired in 1980, 1981, 1982, and 1983. Give appropriate column headings.
Read Best Answer
Editorial / Best Answer
letsconverse- Member Since Sep-2009 | Sep 21st, 2009
This one is better I guess:
query:
SELECT ((count(DECODE(to_char(hire_date,'YYYY'), 1995, 'c1')) )+(count(DECODE(to_char(hire_date,'YYYY'), 1996, 'c2')))+(count(DECODE(to_char(hire_date,'YYYY'), 1997, 'c3')))+(count(DECODE(to_char(hire_date,'YYYY'), 1998, 'c4')))) as TOTAL,
count(DECODE(to_char(hire_date,'YYYY'), 1995, 'c1')) "1995",
count(DECODE(to_char(hire_date,'YYYY'), 1996, 'c2')) "1996",
count(DECODE(to_char(hire_date,'YYYY'), 1997, 'c3')) "1997",
count(DECODE(to_char(hire_date,'YYYY'), 1998, 'c4')) "1998"
FROM employees;
Results for the above query is like:
TOTAL 1995 1996 1997 1998
---------- ---------- ---------- ---------- ----------
65 4 10 28 23
Revert if you have a question. I'll try.
NOTE: You may want to change the spl characters and the years based on your requiremnet.
Thanksserine
- Aug 26th, 2016
Why did we use c1?
ashwini
- Jun 22nd, 2015
Can anybody tell me how to get the count of the test cases that was run by a person?
-
-
what are the various methods to pass data from one web page to another web page ?
abc
- Sep 12th, 2011
Post
get
session
cookies
querystringrubin2008
- Aug 28th, 2011
We can pass data from one page to another page using get post methods. Also data stored in session will be accessible across all pages
-
How is sub queries handled in MySQL?
rubin2008
- Jan 31st, 2010
Subqueries in MySQL are handled in the following way.For e.g Schema for sailor table :Sid:int(2) PKSName:varchar(15)Rating:int(3)Age int(3)If you want to select name and age of oldest sailor, its query will be as followsSELECT Sname,Age FROM sailors WHERE Age IN (SELECT max(Age) FROM sailors)
amitverma
- Sep 25th, 2008
Sub queries in MySQL handled nested way, You can see the example and understand yourself -SELECT name, headofstate, population FROM Country WHERE population=(SELECT MAX(population) FROM Country);
-
Is it possible to have primary key and foreign key in one table if yes so what is the use of foreign key?
rubin2008
- Jan 31st, 2010
Yes it is possible to have primary key and foreign key in one table.For e.g the schema for table category is as followsCategory_id: int primary keyCategory_title: varchar(30)parent_id: int(3)In the ab...
Shri
- Nov 1st, 2007
Dear Vivek,If I understand your question well, you mean to say that "is there any possibility to have both primary & foreign keys in the same table".Well, the answer is No. The foreign key (by defini...
-
When the variables are pushed into the stack, which method is used to retrieve them from it? A. pop B. pull C. remove D. none of these.
A.pop
-
How do i put a background on a website using css coding?
rubin2008
- Jan 31st, 2010
If you want to put background color you can use background-color property of CSS in body tagIf you want to put background image you can use background-image property of CSS in body tag
-
How can i store images in database?
mzeeshan
- Jun 25th, 2010
We can store images and videos as well by converting the picture or audio/video into the byte array using C#/ VB and store it in a database as binary file (set the type of the field as binary).because at the end every file is a binary so if you store it as binary it will definitely works!
-
if GET method is less secure than POST method then why they introduced GET method.and we\'ll use only POST method alone.wats the need for GET here?
rubin2008
- Jan 31st, 2010
Using GET method form data is appended to URL while using POST method it is transferred in the message body.GET method is intended for information retrieval. It should be used to retrieve ...
-
how to print a text file in java script?
-
The command �codebase� is used in applets when
A) When the applet class file is not in the same directoryB) When the applet class file is in the same directoryC) When we need to get the parameters of the appletD) None of the above
-
