public function find($where) { $db = Mysql::getInstance(); $db->setTable('catalog'); $this->id = $db->find()->where($where); return $this->id; }
<?php /** * Created by PhpStorm. * User: * Date: 11.06.2015 * Time: 19:04 */ require_once 'config/config.php'; $db = \lib\DB\Mysql::getInstance(); $db->setTable('catalog'); if (isset($_GET['cat_id'])) { $pid = intval($_GET['cat_id']); } else { $pid = 0; } //$t = new Table('catalog'); $table->setDefaultCharset(); $table->setEngine(); $table->setAutoIncrement(); $table->addField('id', 'INT', 11, false, true); $table->addField('pid', 'INT', 11); $table->addField('name', 'VARCHAR', 50); $table->addField('url', 'VARCHAR', 100); $table->addField('old_url', 'VARCHAR', 100); $table->addField('img', 'VARCHAR', 50); $table->addField('description', 'TEXT'); $table->addIndex('PRIMARY', 'id'); $table->addIndex('KEY', 'pid'); $table->addIndex('FULLTEXT', 'url', 'url_text_index'); $table->addIndex('FULLTEXT', 'old_url', 'old_url');