忽略 - 在php中读取sql文件时，php中的sql注释

Question

I have a sql file like:

CREATE TABLE IF NOT EXISTS `sessionT` (
  `id` int(9) NOT NULL default '0',
  `time` varchar(14) NOT NULL default '',
  `id_session` varchar(200) NOT NULL default '',
  `token` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id_session`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

so I want to echo all sql statements, however if the sql file has a -- comment it is not working

$f = fopen($SQL_FILE,"r+");
$sql = fread($f, filesize($SQL_FILE));
$sqlArray = explode(';',$sql);
foreach ($sqlArray as $stmt) {
  //add logic to ignire -- comments,...
  if (strlen($stmt)>3 && substr(ltrim($stmt),0,2)!='/*') {
    echo $stmt;
  }
}

how to ignore comments in a file like:

-- --------------------------------------------------------
-- comment, relation etc
-- Estructure .
CREATE TABLE IF NOT EXISTS `sessionT` (
  `id` int(9) NOT NULL default '0',
  `time` varchar(14) NOT NULL default '',
  `id_session` varchar(200) NOT NULL default '',
  `token` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id_session`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Answer 1

I doubt the problem is this easy but maybe this will help:

if (strlen($stmt)>3 && (substr(ltrim($stmt),0,2)!='/*') || substr(ltrim($stmt),0,3)!='-- ')){
echo $stmt;
}