def add_business(self, name, category_id, description, address, phone, email, website): """Insert a new business listing""" if not name or not category_id: raise ValueError("Name and category are required") sql = "INSERT INTO businesses (name, category_id, description, address, phone, email, website) VALUES (?,?,?,?,?,?,?)" return db.execute(sql, [name, category_id, description, address, phone, email, website])
def search_businesses(self, keyword, location=None): """Search by name, description, or address""" sql = """ SELECT *, MATCH(name, description) AGAINST(? IN NATURAL LANGUAGE MODE) as relevance FROM businesses WHERE is_active = 1 AND (name LIKE ? OR description LIKE ? OR address LIKE ?) """ like_term = f"%{keyword}%" params = [keyword, like_term, like_term, like_term] if location: sql += " AND address LIKE ?" params.append(f"%{location}%") sql += " ORDER BY relevance DESC" return db.query(sql, params) business directory script
def get_top_rated(self, limit=10): """List businesses with highest average rating""" sql = """ SELECT b.id, b.name, b.logo_url, AVG(r.rating) as avg_rating, COUNT(r.id) as review_count FROM businesses b JOIN reviews r ON b.id = r.business_id WHERE b.is_active = 1 GROUP BY b.id HAVING review_count >= 3 ORDER BY avg_rating DESC LIMIT ? """ return db.query(sql, [limit]) <!-- Display category list --> <div class="categories"> <h2>Browse by Category</h2> <ul> <?php foreach($categories as $cat): ?> <li><a href="category.php?id=<?= $cat['id'] ?>"><?= htmlspecialchars($cat['name']) ?></a></li> <?php endforeach; ?> </ul> </div> <!-- Search form --> <form method="GET" action="search.php"> <input type="text" name="q" placeholder="e.g., plumber, cafe, dentist" required> <input type="text" name="location" placeholder="City or ZIP"> <button type="submit">Search</button> </form> OR address LIKE