'Need help properly executing db2_bind_param

I am trying to edit some HTML in our database, specificaly, I am trying to edit a class styling from auto; to 100%; the problem is the html sometimes has ' and sometimes " in it. I figured the easiest way would be to use db2_bind_param to safely run a few SQL queries. However, I do not understand how to use the db2_bind_param function in order to run my queries. My code below :

foreach($as400response as $as){
  //replace the current string with the desired string
            $newAS = str_replace('width: auto;', '100%', htmlentities($as['PARV']));

 //draft the query to be passed to sql
            $fix = "update swind.pimpd set parv='".$newAS."' where sku='".$as[SKU]."' and sprc='".$as[SPRC]."' and flddef='".$as[FLDDEF]."'";

 //prepare the db2_connection/sql query
            $stmt =  db2_prepare($conn, $fix);

 //call db2_bind_param, with $stmt being the preparedstatement, 1 being the position of the variable in the statement as 1-index, $newAS being the variable to be bound
            db2_bind_param($stmt, 1, $newAS);

 //test echo
            echo $fix;

 //execute query
            db2_execute($stmt, array());

 //show errors 
            print_r(db2_stmt_errormsg());
        }

the reponse I am getting back from db2_stmt_errormsg() is : Schlüsselwort OPEN nicht erwartet. Gültige Token: USE SKIP WAIT WITH FETCH LIMIT ORDER WHERE OFFSET. SQLCODE=-199. "OPEN" being the name of the font where the first ' appears in HTML
Am I not calling db2_bind_param properly?
Should the result of db2_bind_param then be passed into the drafted query?
Thank you in advance :)



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source