joymis

Members
  • Content count

    32
  • Joined

  • Last visited

Community Reputation

0 Neutral

About joymis

  • Rank
    Newbie
  1. ok, thank you for your help
  2. but my OUT bind type maybe number or string or array, or have any function can get OUT bind length? class DBObj{ public function spExec($sql, $params){ $stid = oci_parse($this->con, $sql); foreach ($params as $key => &$value) { if($value == 'sp_return') // I'm not sure $len // could I use something function get OUT bind length? oci_bind_by_name($stid, $key, $r, $len); else oci_bind_by_name($stid, $key, $value); } oci_execute($stid, OCI_DEFAULT) or die($this->dbError($stid)); return $r; } } $db = new DBObj(); // maybe this return number $sql = "BEGIN :ret := aaa(:p1, :p2, :p3); END;"; $params = array(':ret' => 'sp_return', ':p1' => '1', ':p2' => '2', ':p3' => '3'); $result = $db->spExec($sql, $params); echo $result; // maybe this return string or array $sql = "BEGIN :ret := bbb(); END;"; $params = array(':ret' => 'sp_return'); $result = $db->spExec($sql, $params); echo $result;
  3. Hello, I have some code like this $sql = "BEGIN :ret := sifw.sf_todoList('38000', '', 'all'); END;"; $stid = oci_parse($conn, $sql); oci_bind_by_name($stid, ':ret', $r); oci_execute($stid); I got a error : 「ORA-06502: PL/SQL: numeric or value error: character string buffer too small」 if I change oci_bind_by_name($stid, ':ret', $r) to oci_bind_by_name($stid, ':ret', $r, 200), it's work but I don't want to set a current length, because I do not know OUT bind type and length. how can I fixed this error? Thanks
  4. because it's height and scrollbar always out of control and let me crazy. It looks like I will have no choice.
  5. Hello, I have a page https://domainA.com/test.php and I hope embed an external page like http://domainB.com/test.php into https://domainA.com/test.php but I don't want to use iframe or frame In addition to these two methods there are other ways? thanks.
  6. Thank for your help, I'm not notice your main is $("#unexe_table").on("click", ".up, .down", function() {...}) not $(".up, .down").on("click", function() {...}) $("#unexe_table").on("click", ".up, .down", function() {...}) can be work thanks.
  7. Thank you for your help, I thought it would cover the original event handler my code was originally written like this, but tbody content from ajax return and I have use blockUI plugin function SearchQuery(){ $.ajax({ ...... async: false, beforeSend:function(){ $.blockUI({ css: { border: 'none', padding: '15px', backgroundColor: '#000', '-webkit-border-radius': '10px', '-moz-border-radius': '10px', opacity: .5, color: '#fff' }, message: '<p>Searching,please wait...</p>' }); }, success: function(response) { $("#query_content_unexe").html(response['query_content']); actOrder(); }, complete:function(){ $.unblockUI(); } }) } when I use "async: false" blockUI will not work, if I no use "async: false" up and down click will not work, so I used the function
  8. Hello, this is my code demo https://jsfiddle.net/ugkfk64o/ when I click "new" button and then click cell "c" -> "down" button, it will move 2 rows but if I don't click "new" button, I only click cell "c" -> "down" button, it's ok where is this error?
  9. ok, thank you for your help
  10. it's work. Thank you for your help.
  11. Hello, I have some html code like this <table> <thead>....</thead> <tbody id="content"> <tr> <td> <img ......> <img onclick="test()" src="1.jpg"> </td> </tr> <tr> <td><img onclick="test()" src="3.jpg"></td> </tr> <tr> <td> <img ......> <img ......> <img onclick="test()" src="2.jpg"> </td> </tr> </tbody> </table> when I onclick 3.jpg, I want get tr index is 1, and I onclick 1.jpg, I want get tr index is 0 how can I use jQuery or javascript get the tr index and no use like parentNode api? because I not sure parentNode of img must be td, maybe it's div, span, or a table. Thanks.
  12. Hello, I have some environment variables...like upload_path = 'abc/' upload_size = '5M' sys_id = 'w3c' session_time = '600' ...... I want use DB or use *.ini access these variables. whcih one is better and safe? Thanks.
  13. Hi all, I have a data like this, dept_no under_dept level 01000 01000 0 01010 01000 1 03000 01000 1 03010 03000 2 03016 03010 3 03020 03000 2 03050 03000 2 03056 03050 3 91020 91020 1 now I have a var $x = 01000, then I should get all data row, when $x = 03000, then I should get dept_no like '03%' row when $x = 03010, then I should only get dept_no = 03010 and 03016 row does anyone have good idea can tell me how can I do? thanks
  14. OK, Thank you for your help
  15. Thank you for your help and information. I learned a lot. Besides, which browsers maybe used IndexOf('/') ?