---------------------------------------------------------------
1) TITLE          : ASP, PHP, JSP Mapping Table
2) DATE           : 2002.09.17
3) ABSTRACT       : 
4) FILE NAME      : asptophptojsp.txt
5) REL. FILE NAME : 
6) REFERENCE      :  
7) DOC, HISTORY   : 2002.09.17 Creation
8) COPYRIGHT      : muralimedisetti@yahoo.com
----------------------------------------------------------------


----------------------------------------------------------------
NO.   ASP	,PHP, JSP
----------------------------------------------------------------
0. Script Tag
	ASP :
		<%  .....  %>
  PHP :
		<?  .....  ?>
  JSP :
    <%@ page language="java" %>
    <%  .....  %>

1. Redirect URL	
	ASP :
		<%	Response.Redirect(url) %>
  PHP :
	  <? 
		echo("<META http-equiv='refresh' content='0;url=$PHP_SELF?table=$table'>");
		exit;
		?>
		Or Using com function
		<? Redirect($url) ?>
  JSP :
    <jsp:forward page="<%=url%>" />
  
2. Include File
	ASP :
		<!--#include file="include/include_com.asp"-->
  PHP :
  	<?  include ("./config/base_var.php")  ?>
  JSP :
    <%@ include file="include/include_com.jsp" %>
    
3. Refer SELF URL
	ASP :
		NONE
	PHP :
		<? echo("$PHP_SELF") ?>
  JSP :
    NONE

4. Request
  ASP :
    user_id = Request("user_id")
  PHP : direct using $user_id
  JSP :
    String user_id = request.getParameter("user_id");
        
5. Session to Cookie
	ASP :
		Session("user_id") = user_id
	PHP : No Session. Instead using cookie.
  JSP :
    HttpSession session = request.getSession(ture);
    String str = (String)session.getValue(session.getId());
    if (str == null)
    {
      str = "Session Value";
      session.putValue(session.getId(), str);
    }
    
6. Cookie
	ASP :
	  If Request.Cookies("login") = "" Then
      Response.Cookies("login")=login_id
      Response.Cookies("login").Expires=Date+120
    End If

	PHP : 
	      (Inform: You set the cookie in the first line of your page.)
	      (Inform: You set the cookie with different name.)
		setcookie("user_id","$user_id","now()+3600","/");
		setcookie("user_id","$user_id","time()+0","/"); //Release Cookie
		
  JSP :
    Cookie[] cookies = request.getCookies();
    for (int i=0; i < cookies.length; i++)
    {
      if (cookies[i].getName() == "login")
      {
        if (cookie[i].getValue() == null) 
        {
          Cookie loginCookie = new Cookie("login", user_id);
          loginCookie.setDomain(url);
          loginCookie.setPath("/");
          response.addCookie(loginCookie);
        }
      }
    }
    
6. DB Connection
	ASP :
		Sub DB_Connection(conn)
		    Set conn = Server.CreateObject("ADODB.Connection")
				conn.ConnectionTimeout = 60
				conn.CommandTimeout = 60
				conn.Open "jinybbs", "jinybbs", "" '** ConnectionString, UserID, Password
		End Sub
	PHP :
		function DB_Connection()
		{
	    $conn = mysql_connect("localhost","jinybbs","")
			        or die("Error: Can't connect to the DB Server");
			mysql_select_db("jinybbs", $conn);
			return $conn;
		}
  JSP : import java.sql.*;
    Connection DB_Connection() throws ClassNotFoundException, SQLException
    {
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
      Connection conn=DriverManager.getConnection("jdbc:odbc:jinybbs","jinybbs","");
      return conn;
    }

7. Query Result RecordSet
	ASP :
		Sub SelectADMIN_Owner(conn, table_owner,is_admin, rs)
		  sqlstr = " SELECT * FROM ADMIN " 
			If table_owner <> "*" Then
			  sqlstr = sqlstr + " WHERE table_owner = '"+table_owner+"' "
			End If
			If is_admin = "Y" Then
				sqlstr = sqlstr + " AND is_admin = 'Y' "
			End If
			sqlstr = sqlstr + " ORDER BY table_id "
												  
			Set rs = Server.CreateObject("ADODB.RecordSet")
			rs.CursorType = 3
			rs.Open sqlstr, conn
		End Sub
	PHP :
	function SelectADMIN_Owner($conn, $table_owner,$is_admin)
	{
	  $sqlstr = " SELECT * FROM admin " ;
		if ($table_owner != "*") 
			$sqlstr = $sqlstr." WHERE table_owner = '$table_owner' ";
		if ($is_admin == "Y") 
			$sqlstr = $sqlstr." AND is_admin = 'Y' ";

		$sqlstr = $sqlstr." ORDER BY table_id ";
									  
		$result = mysql_query($sqlstr)
							or die("Error: Not Good Query Statement: ".mysql_error());
		return $result;
	}
	JSP :
	ResultSet SelectADMIN_Owner(Connection conn, String table_owner) throws SQLException
	{
	  Statement stmt = conn.createStatement();
	  String sqlstr = " SELECT * FROM admin " ;
	  ResultSet rs = stmt.executeQuery(sqlstr,TYPEFORWARD_ONLY); (or TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE) 
	  return (rs==null)?null:rs;
	}

8. Multiple RecordSet Fetch
	ASP :
		<% Do While Not rs.EOF %>
	  <% If rs("is_admin") = "N" Then %>
		<OPTION value="<%=rs("table_name")%>"><%=rs("table_alias")%>
		<% End If %>
		<% rs.MoveNext
		   Loop %>
	PHP :
		<?
	    while($row = mysql_fetch_array($result))
			{
				if ($row[is_admin] == "N")
					echo("<OPTION value='$row[table_name]'>$row[table_alias]");
			}
	  ?>
	JSP :
	  <%
	    while(rs.next())
	    {
	      String is_admin = new String(rs.getString("is_admin").getBytes("KSC5601"),"8859_1");
	      if (is_admin == "N")
	        {
	          out.println("<OPTION value='"+rs.getString("table_name")+"'>"+rs.getString("table_alias).getBytes("KSC5601"),"8859_1"));
	        }
	    }
	  %>

9. Response.Write in one line(asp_tags = Off ; allow ASP-style <% %> tags at php3.ini)
	ASP :
		<%=user_id%>
	PHP :
		<? echo($user_id) ?>
  JSP :
    <%=user_id%>

10. Function Call
	ASP :
		<% Call CopyRightLogo %>
	PHP :
		<? CopyRightLogo() ?>
  JSP :
    <% CopyRightLogo() %>

11. Is Record Set
	ASP :
		If Not rs.EOF Then
		... ' Exist Record Set
		Else
		 url = "../db_fail.asp" ' No Record
		End If
	PHP :
		if($row = mysql_fetch_array($result))
			....; // Exist
	  else
			....; // No RecordSet
		or
		if($result)
		...
	JSP :
	  if(rs.next())
	  {
	  }
	  else
	  {
	  }
	  
12. DB Connection and Query Usage
	ASP :
		Call DB_Connection(jinybbs_db)
		Call SelectADMIN_Owner(jinybbs_db, "*", "", rs)
	PHP :
		$connect =  DB_Connection();
		$result =  SelectADMIN_Owner($connect, "*", "");
	JSP :
	  Connection jinybbs_db = DB_Connection();
	  ResultSet rs = SelectADMIN_Owner(jinybbs_db,"*","");
	  
13. Recordset count
	ASP :
		rs.MoveLast
		postcount = rs.RecordCount
	PHP :
		$postcount = mysql_affected_rows();
  JSP :
    rs.Last();
    int postcount = rs.getRow();
    
14. Operator
	ASP :
		\   (Integer Division)
		Mod (Modulus)
		<> (Not Equal)
	PHP :
		floor(a/b) (Integer Division)
		%  (Modulus)
		!= (Not Equal)

15. For Control Statement
	ASP :
		For i=1 To ipp
		...
		Next
	PHP :
		for($i=1;$i<=$ipp;$i++)
		{
		...
		}
	JSP :
	  for (int i=1; i <=ipp; i++)
	  {
	  ...
	  }

16. Transaction (SQL*Server is good for Transaction, but MySQL don't work Transaction)
	ASP :
		On Error Resume Next
		jinybbs_db.BeginTrans

		Call InsertADMIN(jinybbs_db, table_name, table_alias, table_desc, table_owner, table_passwd,"N")

		If jinybbs_db.Errors.Count = 0 Then
		  jinybbs_db.CommitTrans ' Successful Commit
			... 
		Else
			jinybbs_db.RollbackTrans ' Fail Rollback
		End If

	PHP :
		$result =  InsertADMIN($connect, $table_name, $table_alias, $table_desc, $table_owner, $table_passwd,"N")

		if($result)
		{ //Successful
		}
		else
		{ //fail
		}
  JSP : for update, insert, delete transaction(using executeUpdate)
    jinybbs_db.setAutoCommit(false);
    int trans1 = InsertADMIN(jinybbs_db, table_name, table_alias...);
    int trans2 = InsertADMIN2(jinybbs_db, table_name, table_alias...);
    if ((trans1 >0) && (trans2 > 0)
    {
      jinybbs_db.commit();
    }
    else
    {
      jinybbs_db.rollback();
    }    
    
    * For InsertADMIN
    int InsertADMIN(Connection conn, ...)
    {
      Statement stmt = conn.createStatement();
      String sqlstr = "INSERT INTO ADMIN ...";
      stmt.executeUpdate(sqlstr);
      int trans = stmt.getUpdateCount();
      return trans;
    }    
	
17. Date Difference
	ASP :
		If DateDiff("d",rs("create_date"),now)<1 Then
		... ' Today
		End If
	PHP :
		$today = date("Y.m.d",time());
		$compday = date("Y.m.d",$row[create_date);
		If ($today == $compday)
			... //Today
		End If
		Or using Function
		if (DateDiff($row[create_date])
			... //Today
  JSP :

18. String Function
	ASP :
		Len()
		Left, Right
	PHP :
		strlen()
		substr($string,0,17)
  JSP :

19. Date Function
	ASP :
		<%=Formatdatetime(rs("create_date"),2) %>
	PHP :
		<? echo(date("Y.m.d",$row[create_date]) ?>

20. The Correction of DB Insert
	ASP :
		subject = CheckQuoteMark(Request("subject")) (util_com.asp)
	PHP :
		$subject = addslashes($subject);

21. The Correction of CR
	ASP :
		subject = CheckQuoteMarkUpWithCR(rs("subject")) (util_com.asp)
	PHP :
		$subject = stripslashes($row[subject]);