PHP Interview questions, PHP Examples, Mysql Examples

What is the reason for virus attack in the site?

2009-03-02T22:53:00.000-08:00

Reason for virus attack
---------------------------

Nowadays most of the sites are attacked by the virus which result to be the terrible cause for the owners. By means of E-commerce site and shopping cart site it will result in huge loss to the owners. So, most of the people would be thinking that what might be the reason for the virus attack. There might be some of the reasons for the virus attack below are some of the points specified for the cause of the virus attack. Check your site whether it escapes from these sequence.

Is there any open source is added in your site?
Is comment posting is enabled in your site?
Is there any iframe in your site?
Is there any third party site link is in your site?

If you have any one of the above said points please review the remedy for it.

If your site have included the open source then disable it.
Is there any option for comment posting, disable it
If you are using the iframe then remove it.
If any third party links are added in your site remove it. Because that third party site might be spreading the virus in your site. So be cautious while adding the third party link to your site.

.htaccess tutorial

2008-11-14T22:41:00.001-08:00

AuthUserFile /home/yourdomain/www/.htpasswd
AuthType Basic
AuthName "yourUsername"
Require valid-user

note: The password will be stored in .htpasswd file which is in root directory of the site.

PHP XML foreach loop

2008-09-13T13:03:00.000-07:00

<?php
$xmlDoc = new DOMDocument();
$xmlDoc->load("checkbox array.xml");

$x = $xmlDoc->documentElement;
foreach ($x->childNodes AS $item)
{
echo $item->nodeName . " = " . $item->nodeValue . "
";
}
?>

Load XML and Save XML - PHP

2008-09-13T12:57:00.000-07:00

<?php
$xmlDom = new DOMDocument();
$xmlDom->load("enthiran.xml");

print $xmlDom->saveXML();
?>

PHP array shift

2008-09-04T15:56:00.000-07:00

<?php
$stack = array("ajax", "php", "javascript", "mysql");
$fruit = array_shift($stack);
print_r($stack); // first value of the array off
?>

PHP array difference

2008-09-04T15:46:00.000-07:00

<?php
$array1 = array("a" => "php", "string", "array", "PHP");
$array2 = array("b" => "php", "PHP", "string");
$result = array_diff($array1, $array2);
print_r($result);
?>

Export datas to mysql tables

2008-08-30T15:23:00.000-07:00

Export CSV datas to mysql tables

LOAD DATA INFILE 'data.csv' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';

Export Excel sheet datas to mysql tables

LOAD DATA INFILE 'data.csv' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';

Export XML spread sheet datas to mysql tables

LOAD DATA INFILE 'data.csv' INTO TABLE tbl_name
FIELDS TERMINATED BY ',' ENCLOSED BY '"'
LINES TERMINATED BY '\n';

Load Data Infile Syntax

2008-08-30T15:19:00.000-07:00

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name'
   [REPLACE | IGNORE]
   INTO TABLE tbl_name
   [CHARACTER SET charset_name]
   [{FIELDS | COLUMNS}
       [TERMINATED BY 'string']
       [[OPTIONALLY] ENCLOSED BY 'char']
       [ESCAPED BY 'char']
   ]
   [LINES
       [STARTING BY 'string']
       [TERMINATED BY 'string']
   ]
   [IGNORE number LINES]
   [(col_name_or_user_var,...)]
   [SET col_name = expr,...]

PHP checkbox array checked

2008-08-20T13:48:00.000-07:00

<form action="checkbox_array_checked.php" method="post">
<input type="checkbox" name="check[]" value="sakkarakati" <? if (in_array('sakkarakati', $_POST['check'])) { ?> checked="checked" <? }?>/> Sakkarakati<br>
<input type="checkbox" name="check[]" value="kuselan" <? if (in_array('kuselan', $_POST['check'])) { ?> checked="checked"<? }?> /> Kuselan<br>
<input type="checkbox" name="check[]" value="villu" <? if (in_array('villu', $_POST['check'])) { ?> checked="checked"<? }?> /> Villu<br>
</form>

PHP file download using header functions

2008-08-09T15:23:00.001-07:00

header("Cache-Control: public");
header("Content-Description: File Transfer");
header('Content-disposition: attachment; filename='.basename($filename));
header("Content-Type: application/pdf");
header("Content-Transfer-Encoding: binary");
header('Content-Length: '. filesize($filename));
readfile($filename);

PHP header file types

2008-08-09T15:19:00.000-07:00

header('Content-type: application/pdf');
header('Location: http://ashokseenivas.blogspot.com/');
header("HTTP/1.0 404 Not Found");
header("Cache-Control: no-cache, must-revalidate");
header("Expires: Sun, 10 Aug 2008 05:00:00 GMT");
header('Content-type: text/xml');

PHP Filesystem - fopen, fread, fputs or fwrite, filesize

2008-08-04T16:43:00.000-07:00

<?
if (isset($_POST['Submit']))
{
$file = '\rajini-kuselan.php';
$filecontent = $_POST['filecontent'];
if ($fp = fopen ($file, 'w'))
{
fputs( $fp, stripslashes( $filecontent ) );
fclose( $fp );
}

}
$file = '\rajini-kuselan.php';
$fp = fopen( $file, 'r' );
$content = fread( $fp, filesize( $file ) );
$content = htmlspecialchars( $content );

?>
<form name="kuselan.php" method="post">
<textarea style="width:100%;height:500px" cols="110" rows="25" name="filecontent"><? echo $content;?></textarea>
<input type="submit" name="Submit" value="Submit" />
</form>

PHP Filesystems - fgets, feof, fclose

2008-07-26T12:26:00.000-07:00

<?
$phpfilesystem = fopen("php latest technologies.txt", "r");//read only

if ($phpfilesystem) {
while (!feof($phpfilesystem)) {
$buffer = fgets($phpfilesystem, 4096);
echo $buffer;
}
fclose($phpfilesystem);
}
?>

PHP Filesystem - fopen

2008-07-26T12:20:00.000-07:00

<?
$phpfilesystem = fopen("kuselan movie.txt", "r"); //read only
$phpfiles = fopen("rajini robo.txt", "w"); //write only file pointer at beginning
$phpexamples = fopen("rajini robo.txt", "a"); //write only file pointer at end
?>

PHP - WHILE LOOP

2008-07-17T16:11:00.000-07:00

$counter = 1;
while ( $counter <= 10 ) {
echo "Hello world";
$counter = $counter + 1;
}

PHP - FOR LOOP

2008-07-17T16:03:00.000-07:00

for ( $counter = 0; $counter <= 10; $counter += 1) {
echo "Hello world";
}

PHP Radio button array example

2008-07-15T12:37:00.000-07:00

HTML Code:
1 <input type="radio" name="Seenivasagaperumal" value="1"/>
2 <input type="radio" name="Seenivasagaperumal" value="2"/>
3 <input type="radio" name="Seenivasagaperumal" value="3"/>
4 <input type="radio" name="Seenivasagaperumal" value="4"/>

PHP code:
if(isset($_POST['Submit'])){
$eric = $_POST['Seenivasagaperumal'];
}

PHP array selected item delete

2008-07-03T16:33:00.000-07:00

<?
$tagCollection = array("AJAX", "Analytics", "CSS", "Javascript", "JoshSchumacher.com", "PHP", "Prototype", "Web 2.0");
function strMatch($val)
{
$query = isset($_REQUEST['sel']) ? $_REQUEST['sel'] : '';
return (stripos($val, $query) !== false);
}
$tags = array_filter($tagCollection, "strMatch");
$key = key($tags);
unset($tagCollection[$key]);
print_r($tagCollection);
?>

MySql Connect

2008-06-30T16:34:00.000-07:00

$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);

mysql_close($link);

Bulk email sending using sleep function

2008-06-28T16:20:00.000-07:00

$between_delay = 10;
$send_delay = 1;

for ( $sent=0; $row = mysql_fetch_array($result); $sent++ ) {

if ( ($sent % $between_delay) == 0 )
  sleep( $send_delay );

$emailall = $row[0];
$message = stripslashes($message);
mail("$emailall", "$subject", "$message", "From: $email");
}

PHP Get and Post method Example

2008-06-27T14:46:00.000-07:00

<form action="php manual.php" method="post">
Enter your name: <input name="name" type="text">
Enter your age: <input name="age" type="text">
<input type="submit">
</form>

<?php echo $_POST["name"]; ?>
<?php echo $_POST["age"]; ?>

<form action="php tutorial.php" method="get">
Name: <input type="text" name="name" />
Age: <input type="text" name="age" />
<input type="submit" />
</form>

<?php echo $_GET["name"]; ?>
<?php echo $_GET["age"]; ?>

PHP String Functions Part II

2008-06-26T13:03:00.000-07:00

$str = "My name is O\'Billa?";
echo stripslashes($str);// Outputs: My name is O'Billa?

$str = "My name is O'Billa?";
echo stripslashes($str);// Outputs: My name is O\'Billa?

$str = "Vijay's next film Villu";
$str = strtoupper($str);
echo $str; // Prints VIJAY'S NEXT FILM VILLU

$str = "AJITH'S NEXT FILM AEGAN";
$str = strtoupper($str);
echo $str; // Prints ajith's next film aegan

PHP String Funcitons

2008-06-25T12:40:00.000-07:00

$txt="PHP MYSQL";
echo $txt; // Returns PHP MYSQL (Print the text)

echo strlen("My first coding in PHP"); // Returns 22 (Print the string length)

echo strpos("Hello world","l"); // Returns 2 (Print the string position)

$email = 'ashokseenivas50@gmail.com';
$domain = strstr($email, '@');
echo $domain; // prints @gmail.com

$user = strstr($email, '@', true);
echo $user; // prints ashokseenivas50

PHP Array Functions

2008-06-18T15:39:00.000-07:00

Array Merge

$array1 = array("fruits" => "apple", 2, 4);
$array2 = array("a", "b", "fruits" => "orange", "shape" => "rectangle", 4);
$result = array_merge($array1, $array2);
print_r($result);

Array Combine

$a = array('a', 'b', 'c');
$b = array('d', 'e', 'f');
$c = array_combine($a, $b);
print_r($c);

Array Push

$stack = array("a", "b");
array_push($stack, "c", "d");
print_r($stack);

Array Pop

$stack = array("a", "b", "c", "d");
$fruit = array_pop($stack);
print_r($stack);

.htaccess tutorial

2008-06-12T14:24:00.000-07:00

1) Password Protected Directory

AuthUserFile /your/directory/here/.htpasswd
AuthGroupFile /dev/null
AuthName "Secure Document"
AuthType Basic
require user username

2) Password Protectection for a file

AuthName "Restricted File"
AuthType Basic
AuthUserFile /user/home/www/directory/.htpasswd
require valid-user

3) Protecting the file types

AuthName "Restricted"
AuthType Basic
AuthUserFile /user/home/www/directory/.htpasswd
require valid-user

4) Error Documents

ErrorDocument 400 /error/badrequest.htm
ErrorDocument 401 /error/authorisereqd.htm
ErrorDocument 403 /error/forbidden.htm
ErrorDocument 404 /error/filenotfound.htm
ErrorDocument 500 /error/servererror.htm

5) Redirecting Pages

Redirect /old-directory/oldpage.htm http://domain.com/new-directory/newpage.htm

Redirect /old-directory http://domain.com/new-directory/

6) Default page

DirectoryIndex default.htm

DirectoryIndex default.htm home.cgi sadass.pl otherfile.html

7) Add types and Add handler

AddType text/html .html
AddHandler server-parsed .html
AddHandler server-parsed .htm

8) Block Users by using IP

order deny,allow
deny from 123.456.789.000
deny from .domain.com
allow from all

PHP Secure mail example

2008-06-09T15:45:00.000-07:00

$to = 'ashokseenivas50@gmail.com' ;
$subject = 'PHP Technical Questions';
$message = '
Upload Your Resumes: PHP FAQ,
PHP interview questions,
PHP Frequently Asked Questions,
Earn More money from google,
Cricket Updates,
Cinema gossips,
Dating.
';
$headers = 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
$headers .= 'To: Mary , Kelly ' . "\r\n";
$headers .= 'From: Blog Creation ' . "\r\n";
$headers .= 'Cc: seenivasagaperumal@yahoo.com' . "\r\n";
$headers .= 'Bcc: seenivasagaperumal@yahoo.com' . "\r\n";
mail($to, $subject, $message, $headers);

PHP checkbox array example

2008-05-26T15:12:00.001-07:00

if (isset($_POST['submit'])) {

$fruit = $_REQUEST["fruit"];

echo("Fruits chosen: " . count($fruit));

for ($i=0; $i<count($fruit); $i++) {
echo( ($i+1) . ") " . $fruit[$i]);
}
}

PDF Generation Using PHP

2008-05-21T13:21:00.000-07:00

PDF Generation Using PHP

$pdf=new FPDF();
$pdf->AddFont('Calligrapher','','calligra.php');
$pdf->AddPage();
$pdf->SetFont('Calligrapher','',35);
$pdf->Cell(0,10,'Enjoy new fonts with FPDF!');
$pdf->Output();

More Examples:
PDF Generation using line breaks
PDF Generation using header footer

FAQ - PHP

2008-01-11T04:09:00.000-08:00

1) How can we extract string ‘rajinirobo.com ‘ from a string ‘http://info@rajinirobo.com’ using regular expression of PHP?

preg_match(”/^http:\/\/.+@(.+)$/”,’http://info@rajinirobo.com’,$found);
echo $found[1];

2) In how many ways we can retrieve the data in the result set of MySQL using PHP?

1. mysql_fetch_row.
2. mysql_fetch_array
3. mysql_fetch_object
4. mysql_fetch_assoc

3) What are the different types of table in mysql?

5 types of tables we can create
1. MyISAM
2. Heap
3. Merge
4. INNO DB
5. ISAM

4) Difference between MSSQL server & MYSQL?

MS SQL Server 2005

SQL Server is a full-fledged database system developed specifically for large enterprise databases. All advanced features of a relational database are fully implemented. Once you purchase the product, you are only limited to the Sybase-derived engine.

MySQL 5.x

The latest release of MySQL, the 5.X offering, has rounded up on features that lagged commercial equivalents such as SQL Server. Triggers, stored procedures, Views, Information Schema, Serverside Cursors, and Precision Math are features that are implemented but not yet stabilised.

5) What is the difference between echo and print statement?

Print is a function whereas echo is a language construct.

You can use something link $a = print $b while you cant use $a = echo $b.

Print return true or false value on printing. Echo doesn't

Print cannot have multiple expression whereas Echo can have Multiple Expression statement to echo the value.

6) What is the difference between echo and print statement?

echo() can take multiple expressions,Print cannot take multiple expressions.

echo has the slight performance advantage because it doesn't have a return value.

True, echo is a little bit faster.

Print is a function whereas echo is a language construct.

You can use something link $a = print $b while you cant use $a = echo $b.

7) What do you need to do to improve the performance for the script you have written?

Use EXPLAIN to monitor the amount of records retrieved for each query. You can use UNIQUE, LIMIT, WHERE to filter the no of records returned

8) How to reverse given string?

with function:

strrev()

without function:

for($i=0;sizeof($str_name)>$i;$i++)
{

for($l=1;$i-$l;$l--)
{
echo $str_name;
}

9. How many persons have hit my site?

session_start();
(!isset($_SESSION['count'])){ $_SESSION['count']=0;}
else{ $_SESSION['count']++;}
echo "session".$_SESSION['count'];

10. Will PHP supports inheritance?

Yes, PHP supports single inheritance

11. How do you create subdomains using PHP?

* Create the appropriate web root directory, for example /home/sites/username/web , and any subdirectories you wish
* Edit httpd.conf - add a new virtual host section
* Restart httpd

12. How to get the URL domain name in PHP?

$domainName=$_SERVER['HTTP_HOST'];
echo $domainName;

13. What is the difference between Split and Explode?

split() can work using regular expressions while explode() cannot.

Array Random

2007-12-31T05:05:00.001-08:00

((float) microtime() * 10000000);
$input = array("Neo", "Morpheus", "Trinity", "Cypher", "Tank");
$rand_keys = array_rand($input, 2);
echo $input[$rand_keys[0]] . "\n";
?>

Shuffle

2007-12-31T05:04:00.001-08:00

$numbers

= range(1, 20);
srand((float)microtime() * 1000000);
shuffle($numbers);
foreach ($numbers as $number) {
   echo "$number ";
}

Last Inserted ID

2007-12-31T04:52:00.000-08:00

$con = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
 die('Could not connect: ' . mysql_error());
}
mysql_select_db('mydb');

mysql_query("INSERT INTO mytable (product) values ('kossu')");
printf("Last inserted record has id %d\n", mysql_insert_id());

PHP - MYSQL Programmers

2007-12-26T02:30:00.000-08:00

DB Connection - mysql_connect('localhost', 'mysql_user', 'mysql_password')
Create DB
----------
$sql = 'CREATE DATABASE my_db';
if (mysql_query($sql, $link)) {
echo "Database my_db created successfully\n";
} else {
echo 'Error creating database: ' . mysql_error() . "\n";
}

Fetching datas
---------------

("localhost", "mysql_user", "mysql_password") or
   die("Could not connect: " . mysql_error());
mysql_select_db("mydb");

$result = mysql_query("SELECT id, name FROM mytable");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
   printf("ID: %s  Name: %s", $row["id"], $row["name"]);
}

mysql_free_result($result);
?>

Welcome

2007-11-20T20:22:00.000-08:00