title: Create Stored Procedures with PDO in PHP
body: <p>I am reading a TEXT file from PHP and trying to execute commands from it, like creating a DB and all the tables and procedures it has. My code creates the tables but does not create Stored Procedures given in the file.</p>
  
  <pre><code> DELIMITER $$
   DROP PROCEDURE IF EXISTS `add_hits`$$
   CREATE DEFINER=`root`@`localhost` PROCEDURE `add_hits`( In id varchar(255))
   BEGIN
   select hits into @hits from db_books where Book_ID = id;
   update db_books set hits=@hits+1 where Book_ID = id;
   END$$
  </code></pre>
  
  <p>The PDO is not creating the SPs, how will be able to accomplish this task?
  I have tried executing all the code part together and line by line, but nothing works.<br>
  I am trying to make a DB installer script.</p>