26 mar 2009

Klasa do połączenia z baza danych mysql

class DB {
 private
  $host, $base, $user, $pass, $dbconn;

public function __construct DB($host, $base, $user, $pass) {
  $this->host = $host;
  $this->base = $base;
  $this->user = $user;
  $this->pass = $pass;
  $this->dbconn = mysql_connect($this->host, $this->user,$this->pass);
  mysql_select_db($this->base);
 }
}

$dbconn = new DB($host, $base, $user, $pass);
$result = mysql_query("SELECT * FROM content");
20 mar 2009

Powtórzenie stringa

if($category) {
 $category_stars = str_repeat('*', $category);
 echo $category_stars;
}

prosty sposób na wygenerowanie gwiazdek dla hotelu

11 mar 2009

Zapytanie o miasta w okolicy

$latlng = array(51.9, 19.1);

if($latlng) {
 list($lat, $lng) = $latlng;
 $r  = 0.3;
 $sql_where_array[] = 'lat < '.($lat + $r).' and lat > '.($lat - $r).' and lng < '.($lng + $r).' and lng > '.($lng - $r);
}

if($sql_where_array)
 $sql_where = ' where ' . implode(' AND ', $sql_where_array);
$sql = 'select name from Cities '.$sql_where . ' ORDER BY name asc';