how to search string from text file in php

search string from text file in php or find string from text file in php
Note: In this file we store ( write ) all string ( value ) in text ( txt ) file. And searching string start from "name:", "address" and mend with ";".

Note: Save bellow string for search in "test.txt" file.

Hi my name:Kamran; and address:Delhi;. Working as a Software Developer and my area of expertise in PHP and Java/J2EE and I would like to work in software company providing cutting edge PHP and Java base web application.
In this file I am searching string in php name:ahmad; and address:delhi; with php program bellow. searching string from text file in php.

Note: Save bellow file "searchstring.php".
Note: Remove "\" every place from program

<\?php
    $filename = "test.txt";
    $fp = fopen($filename, "r") or die("couldn't open $filename");
    while(!feof($fp))
    {
        $char = fgets($fp);
        $name = strstr($char,'name:');
        $name1 = substr($name, 5);
        $name2 = strpos($name1, ';');

        echo $name3 = substr($name1, 0, $name2);
        echo "<\br>";

        $address = strstr($char,'address:');
        $address1 = substr($address, 8);
        $address2 = strpos($address1, ';');

        echo $address3 = substr($address1, 0, $address2);
        echo "<\br>";
    }
?>

JSP Connectivity with SQL Server

Note :-
For the connectivity with JSP to SQL Server first Download Microsoft SQL Server JDBC 2.0 Driver for java on the bellow URL:

http://www.microsoft.com/downloads/details.aspx?FamilyID=99b21b65-e98f-4a61-b811-19912601fdc9&displaylang=en

or

http://go.microsoft.com/fwlink/?LinkId=144633&clcid=0x409

After download it gives sqljdbc_2.0.1803.100_enu.exe. Run it, then it will gives a zip file, extract  Zip file. Copy and paste sqljdbc4.jar in  Paste java->jdk->jre->->lib->ext Folder after that restart the Tomcat-Apache webserver.



<%@ page language="java" import="java.sql.*" %>
<%
    Connection con = null;
    Statement stmt =null;
    ResultSet rs = null;
    try{ 
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String url = "jdbc:sqlserver://localhost:1433;username=mysqlusername;password=mysqlpassword;databasename=dbname";
        conn = DriverManager.getConnection(url);
        stmt = con.createStatement();
        out.println("Database connected");
        String queryCountry = "Select * from table";
        ResultSet countResultSet = stmt.executeQuery(queryCountry);
            while(countResultSet.next()){
                    out.println(countResultSet.getString("name"));
                    out.println("\n");
            }
   
      }catch(Exception e){
            out.println(e);
      }

 %>

jsp connectivity with mysql

Download connector/j  Jar file Copy and Paste java->jdk->jre->ext->lib Folder folder.

create a mysqlconnection.jsp file

<%@ page language="java" import="java.sql.*" %>
<%
    Connection con = null;
    Statement stmt =null;
    ResultSet rs = null;
    try
   {
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        con = DriverManager.getConnection("jdbc:mysql:mysql_databsename","mysql_username", "mysql_password");
        stmt = con.createStatement();
        rs = stmt.executeQuery("SELECT * FROM tab");
        while (rs.next())
       {
             out.println(rs.getString("field"));
       }
       rs.close();
   }
  catch (SQLException ex)
  {
            //Catch Errors
            out.println("SQLException: " + ex.getMessage());
            out.println("SQLState: " + ex.getSQLState());
            out.println("VendorError: " + ex.getErrorCode());
   }
  %>

JSP Connectivity with Oracle 8i and 9i

Step - 1 :- Copy Oracle JDBC folder's *.jar files and classes111.zip or classes12.zip
Step - 2 :- Paste java->jdk->jre->ext->lib Folder

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@page import="java.net.*"%>
<%@ page import="oracle.jdbc.driver.*" %>
<%@ page import="oracle.sql.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="java.math.*" %>
<%@ page import="java.*" %>
<%
    Connection con = null;
    Statement stat = null;
    ResultSet rs = null;
    String sql=null;
    try
    {
            DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
           Class.forName("oracle.jdbc.driver.OracleDriver");
                con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:databasename","scott","tiger");
                stat = con.createStatement();
    }
        catch(SQLException e)
    {
        out.print("Error = " + e );
    }
%>

How To Create A Pagination In PHP

Use Pagination to display results of your MySQL query over multiple pages in PHP.

Note : Remove "\" with a href tag

pagination.php

 ////// Connection with mysql Database////////

$connect = mysql_connect("yourhostname", "username", "password", "true") or die(mysql_error());
mysql_select_db("databaseName", $connect) or die(mysql_error());

////// pagination limit 10 records in a page //////

$limit =10;
if(!isset($_GET['page']))
{
     $page=1;
}
else
{
    $page=$_GET['page'];
}
$limitstart = ($page-1)*$limit;
$strgry = "select * from tableName";
$num =mysql_num_rows(mysql_query($strgry));
$pages = ceil($num/$limit);
$strgry = "select * from tableName Limit $limitstart, $limit";
$query = mysql_query($strgry) or die (mysql_error());
while($row=mysql_fetch_array($query))
{
    echo $row[0];
    echo $row[1];
    echo "\n";
}
if($page!=1)
{
    $pr=$page-1;
    echo "<\a href='pagination.php?page=$pr'>Prev<\/a>";
    echo " ";
}
for($i;$i<=$pages;$i++)
{
    if($i!=$page)
   {
        echo "<\a href='pagination.php?page=$i'>";
        echo $i;
        echo "<\/a>";
   }
   else
  {
        echo $i;
        echo " ";
   }
}
if($page!=$pages)
{
    $nxt=$page+1;
    echo "<\a href='pagination.php?page=$nxt'>Next<\/a>";
    echo " ";
}

How to store multiple values in a session variable with in a form submit in php

Note : Save this page session.php
Note : Remove "\" from all HTML tag and php start tag

<\?php
session_start();

$sessValue = "";
    if(isset($_REQUEST['submit']))
    {
        $sessValue = $_REQUEST['sessValue'];
        if(!isset($_SESSION['sessValue1']))
        {
            echo $_SESSION['sessValue1']=$sessValue;
        }
        else
        {
            echo $_SESSION['sessValue1']=$_SESSION['sessValue1'].$sessValue;
        }
    }
?>
<\html>
<\body>
<\form name="frm" action="session.php" method="post">
    <\input type="text" name="sessValue">
    <\input type="submit" name="submit" value="submit">
<\/form>
<\/body>
<\/html>

How to upload file in php

Step 1 - Save Bellow code name "upload.php"
Step 2 - Create a folder name upload for file upload
Note : Remove "\" from all HTML tag and php start tag

<\?php
        if(isset($_REQUEST['submit']))
        {
            $tmp_file = $_FILES['upload']['tmp_name'];
            $filename = $_FILES['upload']['name'];
           
            if(move_uploaded_file("$tmp_file", "upload/$filename"))
            {
                echo "File Success Fully Uploaded";
            }
            else
            {
                echo "File Upload Failed";
            }
        }
?>
<\html>
<\body>
<\form name="frm" method="post" action="upload.php" enctype="multipart/form-data">
    <\input type="file" name="upload">
    <\input type="submit" name="submit" value="Upload">
<\/form>
<\/body>
<\/html>