Business Directory Script ^new^ Link

def get_business_profile(self, business_id): """Fetch full business details + reviews""" biz = db.query_one("SELECT * FROM businesses WHERE id = ?", [business_id]) if not biz: return None reviews = db.query("SELECT * FROM reviews WHERE business_id = ? ORDER BY created_at DESC", [business_id]) biz['reviews'] = reviews return biz

CREATE TABLE reviews ( id INT PRIMARY KEY AUTO_INCREMENT, business_id INT NOT NULL, rating INT CHECK (rating BETWEEN 1 AND 5), comment TEXT, reviewer_name VARCHAR(100), created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (business_id) REFERENCES businesses(id) ON DELETE CASCADE ); # Example Python/Flask-style logic (read as pseudo-code) class BusinessDirectory: 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> IN NATURAL LANGUAGE MODE) as relevance FROM businesses

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) params) def add_review(self

def add_review(self, business_id, rating, comment, reviewer_name): """Submit a review and rating""" if rating < 1 or rating > 5: return False sql = "INSERT INTO reviews (business_id, rating, comment, reviewer_name) VALUES (?,?,?,?)" return db.execute(sql, [business_id, rating, comment, reviewer_name])