INSERT INTO `user`(`firstname`, `lastname`, `email`, `gender`, `age`, `comments`, `regdate`) VALUES ('James','Smith',SHA2('Jamessmith@example.com',256),'M', '30-60', 'I like to do test insert SQL using PHP code', NOW())

Success!