yavuz's blog

sqlite kullanıyorsanız basitinden bir sqlite class_ı

class DB {
	public static $dbpath = './databasename';
	public static $conn;

	public static function Connect() {
		if(self::$conn = sqlite_open(self::$dbpath))
			return true;
		else
			return false;
	}

	public static function Query($sql) {
		self::Connect();
		if ($query = sqlite_query(self::$conn,$sql))
			return $query;
		else
			return false;
	}

	public static function GetData($sql) {
		if($query = self::Query($sql)) {
			while ($result = sqlite_fetch_array($query, SQLITE_ASSOC))
				$data[] = $result;
			return $data;
		} else {
			return false;
		}
	}

	public static function GetNumRows($sql) {
		$query = self::Query($sql);
		return sqlite_num_rows($query);
	}

	public static function Close() {
		sqlite_close(self::$conn);
	}
}

Örnek

$data = DB::GetData('select * from tablename');
print_r($data);
DB::Query('insert into tablename (name,dev) values ("yavuz","php")');

sıkıntıdan neler yapıyor insan