ASP -> PHP

I am converting a website from Classic ASP to PHP. I need some help with the database calls. I am using the PHP PDO data object as follows: $strSql="SELECT ...."; $stmt = $conn->prepare($strSql); $stmt->execute(); I need the code equivalents (using PDO) for the following two ASP database transactions, add and edit a record: 'ADD A NEW RECORD TO THE TABLE Set rs = [login to view URL]("[login to view URL]") strSql="SELECT TOP 0 * FROM providers" [login to view URL] strSql,conn,1,3 [login to view URL] rs("prov_fname")=prov_fname rs("prov_lname")=prov_lname rs("prov_title")=prov_title rs("prov_credential")=prov_credential [login to view URL] 'get the prov_id for the new record prov_id=rs("prov_id") [login to view URL] set rs=nothing 'EDIT AN EXISTING RECORD IN THE TABLE Set rs = [login to view URL]("[login to view URL]") strSql="SELECT * FROM providers WHERE prov_id=" & [login to view URL]("id") [login to view URL] strSql,conn,1,3 if [login to view URL] then else rs("prov_fname")=prov_fname rs("prov_lname")=prov_lname rs("prov_title")=prov_title rs("prov_credential")=prov_credential [login to view URL] end if [login to view URL] set rs=nothing