PHP Classes

miss param on sql file

Recommend this page to a friend!

      Bootstrap PHP Comment System with MySQL  >  All threads  >  miss param on sql file  >  (Un) Subscribe thread alerts  
Subject:miss param on sql file
Summary:require 'pid' field from database and is not on sql file
Messages:3
Author:cototec
Date:2016-01-04 23:45:37
 

  1. miss param on sql file   Reply   Report abuse  
Picture of cototec cototec - 2016-01-04 23:45:37
Hi,

Sorry in line 150 of bootstrapcomment.php require 'pid' field from database:

$sql = "SELECT * FROM ".$this->table." WHERE `url` = '".$uri."' AND `pid` = $parent ORDER BY id DESC $limit";


but is not in sql file comment.sql :



CREATE TABLE IF NOT EXISTS `comment` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`email` varchar(100) NOT NULL,
`comment` varchar(300) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` int(1) NOT NULL DEFAULT '1',
`url` varchar(100) NOT NULL,
`tm` varchar(20) NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;




i add on sql and works fine for me


Thanks a lot for this pack!! Really good job!! Thanks!


  2. Re: miss param on sql file   Reply   Report abuse  
Picture of Vishv Sahdev Vishv Sahdev - 2016-01-05 03:37:14 - In reply to message 1 from cototec
thanks

  3. Re: miss param on sql file   Reply   Report abuse  
Picture of Superluk Superluk - 2016-01-11 15:52:39 - In reply to message 1 from cototec
another parameter missing? i my demo "thumb up" or "thumb down" does not work??