Friday, January 31, 2014

password protected folder on Apache with the help of .htaccess and .htpasswd file

.htpasswd file
The following code will be include in your .htpasswd

Admin:prplaCMT5hYjo

This is your login credential while browsing that directory. The password is encrypted with md5


Upload this file in that directory you want to password protect.

.htaccess

The following code will be include in your .htaccess

AuthType Basic
AuthName "restricted area"
AuthUserFile /home/path/public_html/dir_name/.htpasswd
require valid-user

Upload this file in that directory you want to password protect.





Thursday, November 7, 2013

PHP setting for oracle 11g Express Edition Database

After installing Oracle Database 11g Express Edition , you must need to do some PHP setting to connect and used the oracle database.
You need to enable the oci8_11g package for that. For this you may open your php.ini configuration file and find the extension=php_oci8_11g.dll
You may find following block of code like this

extension=php_mysql.dll
extension=php_mysqli.dll
;extension=php_oci8.dll      ; Use with Oracle 10gR2 Instant Client
;extension=php_oci8_11g.dll  ; Use with Oracle 11gR2 Instant Client
;extension=php_openssl.dll
;extension=php_pdo_firebird.dll
extension=php_pdo_mysql.dll

You just need to remove semicolon (;) from the begining of the extension=php_oci8_11g.dll  statement. Then restart all services and check it in your phpinfo.


Now, You can connect the database the sample code is as follows.

<?php

// Create connection to Oracle
$conn = oci_connect("user1", "password",  'localhost');

if (!$conn)
{
   $m = oci_error();
   echo $m['message'], "\n";
   exit;
}
else
{
   print "Connected to Oracle!";
}

$Rs = oci_parse($conn, 'select * from emp_master');
oci_execute($Rs);
echo "<pre>\n";

while (($row = oci_fetch_assoc($Rs)))
{
   print_r($row) ;
}

// Close the Oracle connection
oci_close($conn);
?>

Friday, October 25, 2013

How to change Apache port

The default port of Apache & IIS is 80. If you need to change your apache port. You may need to do small changes in your Apache setting file.

Open your httpd.conf file
IF you have Xampp then below path help you to find conf file
D:\xampp\apache\conf

IF you have wamp then below path help you to find conf file
D:\wamp\bin\apache\Apache2.2.21

In the file, find the line Listen 80 and change the port as per your need.
It like this

#Listen 0.0.0.0:80
#Listen [::]:80
Listen 80

Save the conf file and restart the server.

Saturday, July 13, 2013

Apache installation on ubuntu

How to install Apache on ubuntu
Please enter the following command into your terminal prompt.

sudo apt-get install apache2

Command for restart the Apache
sudo service apache2 restart
OR 
sudo /etc/init.d/apache2 restart

Command for start the Apache
sudo /etc/init.d/apache2 start

Command for stop the Apache
sudo /etc/init.d/apache2 stop


Installation of php on ubuntu

sudo apt-get install php5

-----------------------

mysql
----------------------


sudo service mysql start

Friday, July 12, 2013

Chief Ministers of Maharashtra

Yashwantrao Chavan
Marotrao Kannamwar
P. K. Sawant
Vasantrao Naik
Shankarrao Chavan
Vasantdada Patil
Sharad Pawar
Abdul RehmanAntulay
Babasaheb Bhosale
Shivajirao Nilangekar Patil
Shankarrao Chavan
Sudhakarrao Naik
Manohar Joshi
Narayan Rane
Vilasrao Deshmukh
Sushilkumar Shinde
Ashok Chavan
Prithviraj Chavan

Thursday, June 27, 2013

htmlentities & htmlspecialchars in php

htmlentities 

Convert all applicable characters to HTML entities

$str = "A 'quote' is <b>bold</b>";

Example
echo htmlentities($str);
// Outputs: A 'quote' is &lt;b&gt;bold&lt;/b&gt;



htmlspecialchars 

Convert special characters to HTML entities

'&' (ampersand) becomes '&amp;' 
'<' (less than) becomes '&lt;' 

Example
$new = htmlspecialchars("<a href='test'>Test</a>", ENT_QUOTES);
echo $new; //Outputs:  &lt;a href=&#039;test&#039;&gt;Test&lt;/a&gt;

(Uniform Resource Locator ) urlencode & urldecode in php

urlencode & urldecode in php

urlencode  — This function returns the string output

URL is converted into a valid ASCII format.
URL Encoding space is replaced by %20

Example
urlencode('Hello milind') return output ==>> Hello%20milind 

another example
urlencode('http://www.mywebsite.com/index.php?name=milind chaudhari&id=25');

Output is http://www.mywebsite.com/index.php?name=milind%20chaudhari&id=25


urldecode  — This function returns the string output
Decodes URL-encoded string

Returns the decoded string.

Example
urldecode('http://www.mywebsite.com/index.php?name=milind%20chaudhari&id=25');

Output
http://www.mywebsite.com/index.php?name=milind chaudhari&id=25