PHP Model::runSql Examples

Example #1

File: Product.php Project: matthewleighton/online_shop

 public static function findProductCatagories($where, $join = [])
 {
     $sql = "SELECT base_product_id, product_catagory FROM base_product ";
     foreach ($join as $key => $value) {
         $sql .= "LEFT JOIN " . $key . " ON " . $value[0] . "=" . $value[1] . " ";
     }
     if (is_array($where)) {
         $sql .= $where['sql'];
         #echo "<br>" . $sql;die;
         $results = Model::buildAndRunPreparedStatement($sql, $where['datatypes'], $where['values']);
         return Model::createResultsArray($results);
     } else {
         $sql .= $where;
         $results = Model::runSql($sql);
         return Model::createResultsArray($results);
     }
 }