title: ADO to MySQL: CursorType and LockType
body: <p>I am trying to convert an <code>ASP-ADO</code> code to <code>PHP-MySQL</code> code and i have following code block to convert next:</p>
  
  <pre><code>Function FindBankName(bankNo)
  
      If IsNull(bankNo) Or IsNumeric(bankNo) = False Then Exit Function
      Dim recordSet
  
      Set recordSet = Server.CreateObject("Adodb.Recordset")
      recordSet.Open "SELECT Id, MainPos FROM bank WHERE MainPos = "&amp; bankNo &amp;"", db, 1, 3
      If Not recordSet.EOF Then
          FindBankName = recordSet("Id")
      End If
      recordSet.Close
      Set recordSet = Nothing
  
  End Function
  </code></pre>
  
  <p>Last two parameters , 1 and 3, of <code>Open</code> function is defined in Microsoft documents as:</p>
  
  <blockquote>
    <p>CursorType</p>
    
    <p>Optional. A CursorTypeEnum value that determines the type of cursor that the provider should use when opening the Recordset. The default value is adOpenForwardOnly.</p>
    
    <p>LockType</p>
    
    <p>Optional. A LockTypeEnum value that determines what type of locking (concurrency) the provider should use when opening the Recordset. The default value is adLockReadOnly.</p>
  </blockquote>
  
  <p>Are there corresponding options in MySQLi that covers them? How should i proceed? Can i ignore them?</p>