Pages

Saturday 22 June 2013

Rajasthan Patwari Admit Card 2013

Rajasthan Patwari exam 2013| Rajasthan Patwari exam Admit card| Patwari Exam 2013|Board of Revenue for Rajasthan| Patwari Bharti Admit card 2013,Rajasthan Patwari Exam Admit Card 2013| Rajasthan Patwari Exam date| Rajasthan Patwari exam Result 2013

 
Get transfer on-line Rajasthan Patwari examinations admit card 2013 on-line. Rajasthan has direct recruit 2271 Patwari vacancies. Candidates who registered for Rajasthan patwari recruitment, they have to transfer admit card / hall ticket or call letter through on-line from its main official web site i.e. www.bor.rajasthan.gov.in. Candidates ought to follow given instruction for grasp Rajasthan patwari admit card 2013 online. 



Download Admit Card From

Click here to download patwari admit card 

How to connect mysql database in php and use of config file

Hello friends,
Now i am trying to connect mysql database in php.simple php code that connect database are here.

<?php
              mysql_connect("host_name","user_name","password")or die("database are not connected");
              mysql_select_db("db_name")or die("database are not selected");

?>

DoITC Rajasthan Information Assistant Question Paper / Old Question Paper

DoITC Rajasthan (IA) Information Assistant Question Paper/ Solved paper / Old Question Paper, Rajasthan Information Assistant Exam Sample Paper/Answer key DOITC, Information assistant,Suchna Sahayak Exam Sample Paper/Answer key


Department of Information Technology and Communication (DOITC) Rajasthan has invited online application for Informatics Assistant (IA)/Suchna Sahayak post. There are 6300 post will be filled by this recruitment process. Last date to submit online application for DOITC Rajasthan IA post is 30th May 2013. Now candidate want to know the paper pattern, download doitc previous year solved papers, model paper pdf etc.
 




 Click here to download Assistant Question Paper Question Paper

Thursday 13 June 2013

Which are Better Subdomain or Subdirectory

When comes to create a new addition to your website , two things will come to the mind of the webdevelopers . That is Subdomain & Subdirectory which one is best for my site. Probably , Everyday most of the people meets this question . In fact , i don`t know about that which is better
before facing this problem on offermandi.com.then i research about that and understand which is better Subdomain or Subdirectory. this is a serious matter , it is related to SEO ranking .
Understand About Sub domain :
You can create a sub domain under your top level domain name for instance ,
Top level : offermandi.com
Subdomain : jaipur.offermandi.com
Even sub domain are running under your top level domain, search engines consider it is a different website.you don’t get any SEO rank of Top level domain name to the subdomains name . Subdomain should earn those things from beginning.
Why I need Sub domain
you can create a sub domain when you start a new concept, which is not related to your existing website. For example, you are running a website about tourism , it is covering world wide. At now you are going to create a website about recipe then you can start the site in subdomains.
Understand About Subdirectory:
You can create a folder under the top level domain name is known as subdirectory.
Top level: offermandi.com
Subdirectory :offermandi.com/jaipur
where /jaipur is subdirectory.
There are having so many advantages by create a subdirectory, it is search engine friendly process. The subdirectory gets the SEO Ranking of your top level domain name because it is part of the domain not like sub domain.
Why I need Subdirectory
if you are going to create a content which is related to your existing site concept then you can create a subdirectory. For example , your exist website is about vehicle, then you can create many subdirectory as bicycles,car,trucks etc. Its gets a good web traffic from search engine to your site.In my view sub directory is good for getting traffic .


if you like this please comment this.

Sunday 9 June 2013

Convert text into number in MySQL query with php

Convert text into number in MySQL query using  php.when input type is set in mysql text then the enter numbers are used as string and these number are not sorted prorperly .
now we are conver this field into interger in mysql query with php.

 <?php
// mysql query that change integer
          $rs=mysql_query("select * from table order by price CONVERT(SUBSTRING(price,6),SIGNED INTEGER)  asc");
        
// this will fetch correct data in ascending order
  ?>

if you like this please comment.

Tuesday 4 June 2013

Url Rewriting Using .htaccess


Url rewriting: there are two type  urls according to my knowledge.one is absolute url and other is relative url.in absolute url we are define the path of server in a variable.(.htaccess file,absolute url,mod rewriting in .htaccess)

Step 1: Create a config file for database connectivity (config.php)

   <?php
       mysql_connect("localhost","username","password");
       mysql_select_db("database_name");
      $path="http://yourdomainname.com";

    ?>

Step 2:now cteate a php link file

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>
      include("config.php");
     <?php
              $rs=mysql_query("select * from table_name");
               while($row=mysql_fetch_array($rs)) { ?>
                   <a href="<?php echo $path."/search/".$row["name"]."-".$row["id"];  ?>"><?php echo $row["name"]; ?></a>
<?php }           

       ?>
</body>
</html>

Step 3: Create a .htaccess file

Options +FollowSymLinks

RewriteEngine on

RewriteBase /

RewriteRule ^search/(.*)-([0-9]+)$ search.php?name=$1&id=$2 [NC,L]

Step 4:now use this data into search.php page

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

Advance Search Engine Using PHP

Search is used in many websites.bigneers that enter in web development are facing  a problem that how to make a search engine using php.now i try to solve this problem in simple way.(search in php,search suggestion in php,search engine in php)

Step 1: Cteate a html search box with submit button (index.php)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Search Using PHP</title>
</head>

<body>
<form action="search.php" method="post" >
<input type="text" name="search_box" />
<input type="submit" />
</form>
</body>
</html>


Step 2: Create  search.php page

<?php 
            $keyword = explode(" ", $_POST["search_box"]);
            $rs="select * from table_name where name LIKE '%".$keyword['0']."%' ";
                for ($i=1; $i<count($keyword); $i++) {
                $rs = $rs."AND name LIKE '%".$keyword[$i]."%' and name LIKE '%".$keyword[$i]."%'    and name LIKE '%".$keyword[$i]."%' and product_name LIKE '%".$keyword[$i]."%'";
                       }

          $rs=mysql_query($rs);
              while($row=mysql_fetch_array($rs)){
                     echo $row["name"];
               }
?>