I need some help. I am working on a project and I found myself writing a bunch of functions for grabbing information from the database:
For Example:
function getSlideByUserAndSortId($sort_order) { global $mysqli; global $user_id; if ($stmt = $mysqli->prepare("SELECT slide_id FROM user_slides WHERE user_id = ? AND sort_order = ?")) { $stmt->bind_param('ii', $user_id, $sort_order); $stmt->execute(); $stmt->bind_result($returnSlideId); $stmt->store_result(); $stmt->fetch(); return $returnSlideId; $stmt->close(); } } function getSlideText($var) { global $mysqli; global $user_id; global $current_slide; if ($stmt = $mysqli->prepare("SELECT text FROM slide_data WHERE slide_id = ? AND user_id = ? LIMIT 1")) { $stmt->bind_param('ii', $current_slide, $user_id); $stmt->execute(); $stmt->bind_result($text); $stmt->store_result(); $stmt->fetch(); $text = ($stmt->num_rows < 1 ? $var : $text); return $text; $stmt->close(); } } Which is so messy.. What I need is a class like Codeigniter where I can just do:
$this->db->select('*'); $this->db->from('blogs'); $this->db->join('comments', 'comments.id = blogs.id'); $query = $this->db->get(); How does everyone else do it? If you have a lot of information you need to grab and a lot of queries, what is the best way to display the data?
