Life is but a dream

자바스크립트로 쿼리스트링 값 받아오기...흠.

function GetParameter(sName)
{

 var sUrl = location.href;
 var nStartPoint = sUrl.indexOf("?");
 var sQueryStr = sUrl.substring(nStartPoint + 1, sUrl.length);
 var arrName = new Array();
 var arrValue = new Array();
 var nNextStartPoint = 0;
 var sItem;
 var nValuePoint;
 
 while (sQueryStr.indexOf("&") > -1)
 {

  nNextStartPoint = sQueryStr.indexOf("&")
  sItem = sQueryStr.substring(0, nNextStartPoint);
  nValuePoint = sItem.indexOf("=");
  arrName[arrName.length] = sItem.substring(0, nValuePoint);
  arrValue[arrValue.length] = sItem.substring(nValuePoint+1, sItem.length);
  sQueryStr = sQueryStr.substring(nNextStartPoint+1, sQueryStr.length);

 }
 
 sItem = sQueryStr;
 nValuePoint = sItem.indexOf("=");
 arrName[arrName.length] = sItem.substring(0, nValuePoint);
 arrValue[arrValue.length] = sItem.substring(nValuePoint+1, sItem.length);
 
 var sValue = "";
 for(var cnt = 0; cnt < arrName.length; cnt++)
 {
       if (arrName[cnt] == sName)
      {
                sValue = arrValue[cnt];
      }
 
 }
 
 return sValue;

}

 예> ..../test.html?params=1234 

GetParameter("params");     // 결과 : 1234

instr 은 있는데 ..  뒤에서 부터 찾는 instrb 가 없어서 만들어봤다.

DELIMITER $$

DROP FUNCTION IF EXISTS `dbname`.`uft_InStrB` $$
CREATE DEFINER=`username`@`%` FUNCTION `uft_InStrB`(v_str varchar(1000), v_index varchar(100)) RETURNS int
BEGIN
  BEGIN
    DECLARE x_index int;

     SET v_str = REVERSE(v_str);

     SELECT instr(v_str, v_index) into x_index;

     SET x_index = (Length(v_str) - x_index) + 1;

    RETURN x_index;
  END;
END $$

DELIMITER ;

예>
SELECT uft_instrb ('123_123_23', '_');    //결과 :  8