title: Converting regular mysql into prepared statements
body: <p>Im new to database and i have written a LOT of PHP code that accesses a database using MySQL. </p>
  
  <p>I didnt take into account SQL injection attacks so i have to re-write all that PHP code to use mysql prepared statements.</p>
  
  <p>After looking at videos on how to used prepared SQL statements, to perform just ONE SQL command requires a whole lot of "prepared" statements. My existing code has lots of different SQL statements all over the place, it would be a nightmare to change all that code to pack and unpack all the required preparation for each "prepared" statement command.</p>
  
  <p>Is there some kind of wrapper i can use to prevent turning one line of regular SQL into 6 or 7 lines of prepared statements?</p>
  
  <p>For example use to do this line line of SQL</p>
  
  <pre><code>SELECT * from users where userid=10
  </code></pre>
  
  <p>needs many more lines of prepared SQL statements, especially if there are lots of other SQL statements too it now becomes very complex.</p>
  
  <p>Is there was some sort of one line wrapper that i can call that accepts the template SQL string, plus the parameters, which also executes the command and returns the result in just one line of wrapper for different types of MYSQL statements it would be great and the code would be much less confusing looking and error prone.</p>
  
  <p>For example</p>
  
  <pre><code> $users=WrapAndExecute($db,"SELECT * from users where userid=?","s",$userid);
  
   $data=WrapAndExecute($db,"UPDATE table SET username=?,city=?","ss",$name,$city);
  
   $result=WrapAndExecute($db,"DELETE from table where id=?","s",$userid);
  
   $result=WrapAndExecute($db,"INSERT into ? (name,address) VALUES(?,?)","ss","users",$name,$address);
  </code></pre>
  
  <p>Each of those lines above would create a prepared statement template, do the bind, execute it and return the result that a regular MYSQL statement would. This would create minimal impact on existing code.</p>
  
  <p>Anybody knows how to do this or if some easy php library or class already exists to do this, that i can just import and start using it?</p>
  
  <p>Thanks</p>