npm rebuild node-sassI tal com podeu veure en la imatge següent, després ja podrem executar l'aplicació normalment:
...
// Fonts
// --------------------------------------------------
//@import "roboto";
//@import "noto-sans";
@font-face {
font-family: "Poppins";
//font-style: normal;
//font-weight: 400;
src: url($font-path+'/Poppins-Regular.ttf');
}
@font-face {
font-family: "Poppins";
src: url($font-path+'/Poppins-Bold.ttf');
font-weight: bold;
}
@font-face {
font-family: "Poppins";
src: url($font-path+'/Poppins-Italic.ttf');
font-style: italic;
}
@font-face {
font-family: "Poppins";
src: url($font-path+'/Poppins-BoldItalic.ttf');
font-weight: bold;
font-style: italic;
}
$font-family-base: "Poppins";
$font-family-md-base: "Poppins";
$font-family-ios-base: "Poppins";
$font-family-wp-base: "Poppins";
...
// --- Custom icons -------------------------------------------------------------------
//
// https://stackoverflow.com/a/44575053/1581368
// To generate a font : https://yannbraga.com/2017/06/28/how-to-use-custom-icons-on-ionic-3/
ion-icon {
&[class*="custom-"] {
// Instead of using the font-based icons we're applying SVG masks
mask-size: contain;
mask-position: 50% 50%;
mask-repeat: no-repeat;
background: currentColor;
width: 1em;
height: 1em;
}
// custom icons
&[class*="custom-sunrise"] {
mask-image: url(../assets/icon/sunrise.svg);
}
&[class*="custom-sunset"] {
mask-image: url(../assets/icon/sunset.svg);
}
}
...
<ion-item-divider color="light">
{{ "APP.timetable" | translate }}
</ion-item-divider>
<ion-item>
<ion-icon name="custom-sunrise" color="orange" item-left></ion-icon>
<ion-note item-right>{{ sunrise }}</ion-note>
</ion-item>
<ion-item>
<ion-icon name="custom-sunset" color="blue" item-left></ion-icon>
<ion-note item-right>{{ sunset }}</ion-note>
</ion-item>
...
npm install @ngx-translate/core --save npm install @ngx-translate/http-loader --save
...
import { SplashScreen } from '@ionic-native/splash-screen';
// ngx-translate
import {TranslateModule, TranslateLoader} from '@ngx-translate/core';
import {TranslateHttpLoader} from '@ngx-translate/http-loader';
import { HttpClientModule, HttpClient } from '@angular/common/http';
...
import { LangService } from '../providers/lang-service';
// Translations
export function createTranslateLoader(http: HttpClient) {
return new TranslateHttpLoader(http, './assets/i18n/', '.json');
}
@NgModule({
...
imports: [
...
CalendarModule,
TranslateModule.forRoot({
loader: {
provide: TranslateLoader,
useFactory: (createTranslateLoader),
deps: [HttpClient]
}
}),
IonicModule.forRoot(MyApp)
],
...
providers: [
...
Network,
LangService
]
})
...
import { HttpClient } from '@angular/common/http';
import { Injectable } from '@angular/core';
import { BehaviorSubject } from 'rxjs/BehaviorSubject';
import { TranslateService } from '@ngx-translate/core';
@Injectable()
export class LangService {
onLang : BehaviorSubject = new BehaviorSubject("");
lang_sets : Array = [];
constructor(public translate: TranslateService) {
console.log('### LangService');
}
init(lang_default: string, lang_sets: Array, lang_fallback?: string) {
// Verify that some sets are present
if(lang_sets.length==0) {
console.error("[LangService] error: no lang_sets defined");
return;
} else {
this.lang_sets = lang_sets;
}
// Verify default is present in lang_sets
if(this.lang_sets.indexOf(lang_default) == -1) {
console.log("[LangService] Warning: trying to use default lang '"+
lang_default+"' which is not present in lang_sets");
console.log("[LangService] Warning: setting default to first"
"language in set");
lang_default = this.lang_sets[0];
}
// this language will be used as a fallback when a translation
// isn't found in the current language
if(!lang_fallback) lang_fallback = lang_default;
this.translate.setDefaultLang(lang_fallback);
let langRegex = new RegExp(this.lang_sets.join("|"), 'gi');
// get browser language by default
let userLang = navigator.language.split('-')[0];
userLang = langRegex.test(userLang) ? userLang : lang_default;
this.setLanguage(userLang);
// ----------------------------------------------------------------
}
getCurrentLang() {return this.translate.currentLang};
setLanguage(lang: string) {
// Verify default is present in lang_sets
if(this.lang_sets.indexOf(lang) == -1) {
console.log("[LangService] Warning: trying to use lang '"+lang+
"' which is not present in lang_sets");
return;
}
// the lang to use, if the lang isn't available, it will use
// the current loader to get them
this.translate.use(lang);
console.log("[LangService] Using language: "+
this.translate.currentLang);
// Inform to all subscriptors
this.onLang.next(lang);
}
}
...
import { LangService } from '../providers/lang-service';
...
constructor( ..., langService : LangService )
{
platform.ready().then(() => {
...
langService.init("en", ["en", "ca"]);
});
}
...
{
"APP.title": "Sortida/posta de Sol",
"APP.place": "Lloc",
"APP.lat": "Latitud",
...
}
<ion-header>
<ion-navbar>
<ion-title>{{ "APP.title" | translate }}</ion-title>
</ion-navbar>
</ion-header>
<ion-content padding>
<ion-list>
<ion-item-divider color="light">
{{ "APP.language" | translate }}
</ion-item-divider>
<ion-item>
<ion-label>{{ "APP.lang-current" | translate }}</ion-label>
<ion-select [(ngModel)]="lang" (ionChange)="doChangeLang()" item-right>
<ion-option value="ca">Català</ion-option>
<ion-option value="en">English</ion-option>
</ion-select>
</ion-item>
...
...
import {TranslateService} from '@ngx-translate/core';
import { LangService } from '../../providers/lang-service';
...
constructor( ...,
public translate: TranslateService,
public langService : LangService,
)
...
ionViewDidLoad() {
...
this.dateMsg = "APP.today";
this.langService.onLang.subscribe(lang=> {
this.lang = this.translate.currentLang;
console.log("[HomePage] Current lang: "+this.lang);
moment.locale(this.lang);
});
}
selectDate() {
const options: CalendarModalOptions = {
title: this.translate.instant("APP.date-choose"),
canBackwardsSelected: true,
closeLabel: this.translate.instant('APP.Cancel'),
doneLabel: this.translate.instant('APP.Done'),
...
}
...
doChangeLang() {
this.langService.setLanguage(this.lang);
}
}
...
import { LangService } from '../providers/lang-service';
...
constructor( ...,
public langService : LangService,
)
{
this.langService.onLang.subscribe(lang=> {
if(this.googleMapScriptElement) {
console.log("[GoogleMapsService] Current lang: "+lang);
this.updateScriptSrc();
}
});
}
...
updateScriptSrc() {
let lang = this.langService.getCurrentLang();
console.log("[GoogleMapsService].updateScriptSrc with lang: "+lang);
if(this.googleMapScriptElement) {
let head = document.getElementsByTagName('head')[0];
let scripts = Array.prototype.slice.call(head.getElementsByTagName('script'));
let styles = Array.prototype.slice.call(head.getElementsByTagName('style'));
scripts.forEach(s=> {
if(s.src.indexOf("://maps.google") != -1) head.removeChild(s);
else if(!s.src || s.src.indexOf("cordova.js") != -1 ||
s.src.indexOf("ion-dev.js") != -1) {}
else console.log("Skip removing <script src='"+s.src+"'");
});
styles.forEach(s=> {
if(s.textContent.indexOf(".gm-style") != -1) head.removeChild(s);
else console.log("Skip removing <style>", s);
});
document.body.removeChild(this.googleMapScriptElement);
}
let script = document.createElement("script");
script.id = "googleMaps";
if(this.apiKey){
script.src = 'http://maps.google.com/maps/api/js?key=' + this.apiKey +
'&callback=mapInit&libraries=places&language='+lang;
} else {
script.src = 'http://maps.google.com/maps/api/js?callback=mapInit&'
'amp;libraries=places&language='+lang;
}
this.googleMapScriptElement = document.body.appendChild(script);
}
...
$ ionic cordova plugin add cordova-plugin-network-information $ npm install --save @ionic-native/network $ npm install @types/google-maps --save
...
import { CalendarModule } from "ion2-calendar";
import { LocationSelect } from '../pages/location-select/location-select';
import { Connectivity } from '../providers/connectivity-service';
import { GoogleMapsService } from '../providers/google-maps-service';
import { Network } from '@ionic-native/network';
...
declarations: [
...
HomePage,
LocationSelect,
TabsPage
],
...
entryComponents: [
...
HomePage,
LocationSelect,
TabsPage
],
providers: [
...
Geolocation,
Connectivity,
GoogleMapsService,
Network
]
...
import { Injectable } from '@angular/core';
import { Network } from '@ionic-native/network';
import { Platform } from 'ionic-angular';
@Injectable()
export class Connectivity {
onDevice: boolean;
constructor(public platform: Platform, public network: Network) {
this.onDevice = this.platform.is('cordova');
}
isOnline(): boolean {
if(this.onDevice && this.network.type){
return this.network.type != 'none';
} else {
return navigator.onLine;
}
}
isOffline(): boolean {
if(this.onDevice && this.network.type){
return this.network.type == 'none';
} else {
return !navigator.onLine;
}
}
watchOnline(): any { return this.network.onConnect(); }
watchOffline(): any { return this.network.onDisconnect(); }
} import { Injectable } from '@angular/core';
import { Connectivity } from './connectivity-service';
import { Geolocation } from '@ionic-native/geolocation';
@Injectable()
export class GoogleMapsService {
mapElement: any;
pleaseConnect: any;
map: any;
mapInitialised: boolean = false;
mapLoaded: any;
mapLoadedObserver: any;
currentMarker: any;
apiKey: string; // = "YOUR_API_KEY";
lat: number = null;
lon: number = null;
constructor( public connectivityService: Connectivity,
public geolocation: Geolocation )
{
}
init( mapElement: any, pleaseConnect: any,
lat: number, lon: number
): Promise
{
this.mapElement = mapElement;
this.pleaseConnect = pleaseConnect;
this.lat = lat;
this.lon = lon;
return this.loadGoogleMaps();
}
loadGoogleMaps(): Promise {
return new Promise((resolve) => {
if(typeof google=="undefined" || typeof google.maps=="undefined") {
console.log("Google maps JavaScript needs to be loaded.");
this.disableMap();
if(this.connectivityService.isOnline()){
window['mapInit'] = () => {
this.initMap().then(() => {
resolve(true);
});
this.enableMap();
}
let script = document.createElement("script");
script.id = "googleMaps";
if(this.apiKey){
script.src = 'http://maps.google.com/maps/api/js?key=' +
this.apiKey + '&callback=mapInit&libraries=places';
} else {
script.src = 'http://maps.google.com/maps/api/js' +
'?callback=mapInit&libraries=places';
}
document.body.appendChild(script);
}
} else {
if(this.connectivityService.isOnline()){
this.initMap();
this.enableMap();
} else {
this.disableMap();
}
resolve(true);
}
this.addConnectivityListeners();
});
}
initMap(): Promise {
this.mapInitialised = true;
return new Promise((resolve) => {
if(this.lat && this.lon) {
this.initMapPos(this.lat, this.lon);
resolve(true);
} else {
this.geolocation.getCurrentPosition().then((pos) => {
this.initMapPos(pos.coords.latitude, pos.coords.longitude);
resolve(true);
}).catch((error) => {
console.log('Error getting location'+JSON.stringify(error));
return Promise.reject("Unable to get location");
});
}
});
}
initMapPos(lat: number, lon: number) {
let latLng = new google.maps.LatLng(lat, lon);
let mapOptions = {
center: latLng,
zoom: 15,
mapTypeId: google.maps.MapTypeId.ROADMAP
}
this.map = new google.maps.Map(this.mapElement, mapOptions);
}
disableMap(): void {
if(this.pleaseConnect){
this.pleaseConnect.style.display = "block";
}
}
enableMap(): void {
if(this.pleaseConnect){
this.pleaseConnect.style.display = "none";
}
}
addConnectivityListeners(): void {
this.connectivityService.watchOnline().subscribe(() => {
setTimeout(() => {
if(typeof google=="undefined" || typeof google.maps=="undefined") {
this.loadGoogleMaps();
} else {
if(!this.mapInitialised) {
this.initMap();
}
this.enableMap();
}
}, 2000);
});
this.connectivityService.watchOffline().subscribe(() => {
this.disableMap();
});
}
} ...
import { NavParams } from 'ionic-angular';
import { GoogleMapsService } from '../../providers/google-maps-service';
...
export class LocationSelect {
...
location: any;
lat: number = 42.582104;
lon: number = 1.0008419;
constructor( public navCtrl: NavController,
public params: NavParams,
public maps: GoogleMapsService,
public platform: Platform,
public geolocation: Geolocation,
public viewCtrl: ViewController)
{
this.searchDisabled = true;
this.saveDisabled = true;
this.lat = params.get('lat');
this.lon = params.get('lon');
}
ionViewDidLoad(): void {
this.maps.init( this.mapElement.nativeElement,
this.pleaseConnect.nativeElement,
this.lat, this.lon).then(() => {
this.autocompleteService =
new google.maps.places.AutocompleteService();
this.placesService =
new google.maps.places.PlacesService(this.maps.map);
this.searchDisabled = false;
});
}
... ...
import { LocationSelect } from '../location-select/location-select';
...
export class HomePage {
...
launchLocationPage() {
let modal = this.modalCtrl.create( LocationSelect,
{lat: this.lat, lon: this.lon});
modal.onDidDismiss((location) => {
if(location) {
console.log("Nou lloc: ", location);
this.lat = location.lat;
this.lon = location.lng;
this.posMsg = location.name;
this.posError = false;
this.getSunriseSunsetFromApi();
}
});
modal.present();
}
} ...
<ion-item color="light" *ngIf="posError" (click)="launchLocationPage()">
<h2 text-wrap>No s'ha pogut obtenir la posició actual.</h2>
<p text-wrap>Verifica el GPS i/o els permisos.</p>
<ion-icon name="warning" color="danger" item-left></ion-icon>
</ion-item>
<ion-item (click)="launchLocationPage()">
<ion-label>Latitud</ion-label>
<ion-note item-right>{{ lat | number: "1.1-7" }}</ion-note>
</ion-item>
<ion-item (click)="launchLocationPage()">
<ion-label>Longitud</ion-label>
<ion-note item-right>{{ lon | number: "1.1-7" }}</ion-note>
</ion-item>
...
$ npm install ion2-calendar moment --save
...
import { CalendarModule } from "ion2-calendar";
...
imports: [
BrowserModule,
HttpClientModule,
CalendarModule,
IonicModule.forRoot(MyApp)
],
...
import { Component } from '@angular/core';
import { ModalController } from 'ionic-angular';
import { HttpClient, HttpHeaders, HttpParams } from '@angular/common/http';
import { Geolocation } from '@ionic-native/geolocation';
import { CalendarModal,
CalendarModalOptions,
CalendarResult
} from "ion2-calendar";
import * as moment from 'moment';
@Component({
selector: 'page-home',
templateUrl: 'home.html'
})
export class HomePage {
API: string = "https://api.sunrise-sunset.org/json";
// Estany de Sant Maurici
lat: number = 42.582104;
lon: number = 1.0008419;
sunrise : string;
sunset : string;
date : Date = new Date();
dateMsg: string = "Avui";
posMsg : string;
posError : boolean = false;
constructor( public http: HttpClient,
private geolocation: Geolocation,
public modalCtrl: ModalController
)
{
moment.locale('ca-ES');
}
ionViewDidLoad() {
this.geolocation.getCurrentPosition().then((answer) => {
this.lat = answer.coords.latitude;
this.lon = answer.coords.longitude;
this.posMsg = "Posició actual";
this.getSunriseSunsetFromApi();
}).catch((error) => {
console.log('Error getting location', error);
this.posMsg = "Per defecte";
this.posError = true;
this.getSunriseSunsetFromApi();
});
}
selectDate() {
const options: CalendarModalOptions = {
title: 'Escull la data',
canBackwardsSelected: true,
closeLabel: "Cancel·lar",
doneLabel: "Fet",
weekdays: moment.weekdaysShort(),
weekStart: 1,
};
let myCalendar = this.modalCtrl.create(CalendarModal, {
options: options
});
myCalendar.present();
myCalendar.onDidDismiss((date: CalendarResult, type: string) => {
if(date) {
console.log(date);
this.date = date.dateObj;
this.dateMsg = this.date.toLocaleDateString("ca-ES");
this.getSunriseSunsetFromApi();
}
});
}
getSunriseSunsetFromApi() {
let data = { lat: this.lat.toString(),
lng: this.lon.toString(),
formatted: "0",
date: this.date.toISOString().slice(0,10)
};
console.log("Calling API with date= "+data.date);
const params = new HttpParams({fromObject: data});
const headers = new HttpHeaders().set("Accept", "application/json");
let options = {headers: headers, params: params, withCredentials: false};
this.http.get(this.API, options).subscribe(answer => {
if (answer['status']=="OK") {
let date_options = {hour: "2-digit", minute: "2-digit"};
this.sunrise = new Date(answer['results'].sunrise)
.toLocaleTimeString("ca-ES", date_options);
this.sunset = new Date(answer['results'].sunset)
.toLocaleTimeString("ca-ES", date_options);
}
},
err => console.log(err)
);
}
}
...
<ion-item-divider color="light">Data</ion-item-divider>
<ion-item (click)="selectDate()">
<ion-icon name="search" item-left color="primary"></ion-icon>
<ion-note item-right>{{ dateMsg }}</ion-note>
</ion-item>
...
$ ionic serve -c -sEn fer clic en la fila de la data, s'obre una finestra amb el calendari:
$ ionic cordova plugin add cordova-plugin-geolocation \\
--variable GEOLOCATION_USAGE_DESCRIPTION="Per posicionar-te"
$ npm install --save @ionic-native/geolocation
Ja veieu que es tracta d'un mòdul que requereix Cordova. Molts d'aquest mòduls només estan disponibles en un dispositiu físic (mòbil o tablet) i no en el navegador d'un PC. És important comprovar sempre la compatibilitat, per no tenir sorpreses.
import { Component } from '@angular/core';
import { NavController } from 'ionic-angular';
import { HttpClient, HttpHeaders, HttpParams } from '@angular/common/http';
import { Geolocation } from '@ionic-native/geolocation';
@Component({
selector: 'page-home',
templateUrl: 'home.html'
})
export class HomePage {
API: string = "https://api.sunrise-sunset.org/json";
// Estany de Sant Maurici
lat: number = 42.582104;
lon: number = 1.0008419;
sunrise : string;
sunset : string;
posMsg : string;
posError : boolean = false;
constructor( public navCtrl: NavController,
public http: HttpClient,
private geolocation: Geolocation
)
{ }
ionViewDidLoad() {
this.geolocation.getCurrentPosition().then((answer) => {
//console.log(answer);
this.lat = answer.coords.latitude;
this.lon = answer.coords.longitude;
this.posMsg = "Posició actual";
this.getSunriseSunsetFromApi();
}).catch((error) => {
console.log('Error getting location', error);
this.posMsg = "Per defecte";
this.posError = true;
this.getSunriseSunsetFromApi();
});
}
getSunriseSunsetFromApi() {
console.log("Calling API...");
let data = { lat: this.lat.toString(),
lng: this.lon.toString(),
formatted: "0"
};
const params = new HttpParams({fromObject: data});
const headers = new HttpHeaders().set("Accept", "application/json");
let options = {headers: headers, params: params, withCredentials: false};
this.http.get(this.API, options).subscribe(answer => {
console.log(answer);
if (answer['status']=="OK") {
let date_options = {hour: "2-digit", minute: "2-digit"};
this.sunrise = new Date(answer['results'].sunrise)
.toLocaleTimeString("ca-ES", date_options);
this.sunset = new Date(answer['results'].sunset)
.toLocaleTimeString("ca-ES", date_options);
console.log(this.sunrise);
console.log(this.sunset);
}
},
err => console.log(err)
);
}
}
...
<ion-content padding>
<ion-list>
<ion-item-divider color="light">Lloc: {{ posMsg }}</ion-item-divider>
<ion-item color="light" *ngIf="posError">
<h2>No s'ha pogut obtenir la posició actual</h2>
<p>Verifica els permisos</p>
<ion-icon name="warning" color="danger" item-left></ion-icon>
</ion-item>
...
https://api.sunrise-sunset.org/json?
lat=36.7201600&lng=-4.4203400&formatted=0
...
import { SplashScreen } from '@ionic-native/splash-screen';
import { HttpClientModule } from '@angular/common/http';
@NgModule({
declarations: [
...
],
imports: [
BrowserModule,
HttpClientModule,
IonicModule.forRoot(MyApp)
],
bootstrap: [IonicApp],
...
import { Component } from '@angular/core';
import { NavController } from 'ionic-angular';
import { HttpClient, HttpHeaders, HttpParams } from '@angular/common/http';
@Component({
selector: 'page-home',
templateUrl: 'home.html'
})
export class HomePage {
API: string = "https://api.sunrise-sunset.org/json";
// Estany de Sant Maurici
lat: number = 42.582104;
lon: number = 1.0008419;
sunrise : string;
sunset : string;
constructor( public navCtrl: NavController,
public http: HttpClient )
{ }
ionViewDidLoad() {
console.log("Calling API...");
let data = { lat: this.lat.toString(),
lng: this.lon.toString(),
formatted: "0"
};
const params = new HttpParams({fromObject: data});
const headers = new HttpHeaders().set("Accept", "application/json");
let options = { headers: headers,
params: params,
withCredentials: false
};
this.http.get(this.API, options).subscribe(answer => {
console.log(answer);
if (answer['status']=="OK") {
let date_options = {hour: "2-digit", minute: "2-digit"};
this.sunrise = new Date(answer['results'].sunrise)
.toLocaleTimeString("ca-ES", date_options);
this.sunset = new Date(answer['results'].sunset)
.toLocaleTimeString("ca-ES", date_options);
console.log(this.sunrise);
console.log(this.sunset);
}
},
err => console.log(err)
);
}
}
<ion-header>
<ion-navbar>
<ion-title>Sortida/posta de Sol</ion-title>
</ion-navbar>
</ion-header>
<ion-content padding>
<ion-list>
<ion-item-divider color="light">Lloc</ion-item-divider>
<ion-item>
<ion-label>Latitud</ion-label>
<ion-note item-right>{{ lat }}</ion-note>
</ion-item>
<ion-item>
<ion-label>Longitud</ion-label>
<ion-note item-right>{{ lon }}</ion-note>
</ion-item>
<ion-item-divider color="light">Data</ion-item-divider>
<ion-item>
<ion-note item-right>Avui</ion-note>
</ion-item>
<ion-item-divider color="light">Horari</ion-item-divider>
<ion-item>
<ion-icon name="sunny" color="orange" item-left></ion-icon>
<ion-note item-right>{{ sunrise }}</ion-note>
</ion-item>
<ion-item>
<ion-icon name="moon" color="blue" item-left></ion-icon>
<ion-note item-right>{{ sunset }}</ion-note>
</ion-item>
</ion-list>
</ion-content>
$ ionic serve -c -s
$ ionic cordova build android $ ionic cordova build ios
UPDATE LaMevaTaula SET ElMeuCamp=NouValor WHERE condicióEvidentment, podem modificar diversos camps, i la condició pot ser més o menys senzilla.
UPDATE LaMevaTaula
SET ElMeuCamp=NouValor
WHERE id IN
(
SELECT T.id FROM (
SELECT TS.id FROM LaMevaTaula AS TS
JOIN unió_complexe_amb_altres_taules
) AS T
)
Fixeu-vos com generem els identificadors a actualitzar amb la selecció complexe, i després s'utilitzen aquests per filtrar els registres en l'actualització en massa.
$ apache2 -v Server version: Apache/2.4.6 (Ubuntu) Server built: Aug 9 2013 14:28:56
$ cd /etc/apache2/sites-available $ sudo mv vhosts vhosts.conf $ sudo service apache2 restart
<table style="width: 100%;">
<tr>
<td width="60%"></td>
<td width="40%"></td>
</tr>
<tr>
<td>Primera columna</td>
<td>Segona columna</td>
</tr>
<tr >
<td>Contingut</td>
<td>Més contingut</td>
</tr>
</table>
| Primera columna | Segona columna |
| Contingut | Més contingut |
$ svn status --no-ignore | grep "I "
$ svn add nom_del_fitxerA veure si no se m'oblida ;-)
$ sudo cp RabbitVCS.py /usr/share/nautilus-python/extensions/
$ sudo ln -s /usr/lib/x86_64-linux-gnu/libpython2.7.so.1.0 \
/usr/lib/libpython2.7.so.1.0
$ nautilus -q
$DBH = new PDO("mysql:host=$server;dbname=$dbname",
$user, $pass,
array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));
I ja veureu com l'error desapareix dels vostres logs, i les dades s'obtenen correctament.
$ sudo apt-get install apache2 libapache2-mod-php5En el meu cas, tenia una instal·lació prèvia que m'ha donat problemes amb el PHP (no executava els codis). M'ha calgut reinstal·lar amb:
$ sudo apt-get purge libapache2-mod-php5 $ sudo apt-get install libapache2-mod-php5 $ sudo a2enmod php5 $ sudo /etc/init.d/apache2 restartAra, caldrà definir els servidors virtuals que volem utilitzar:
$ gksudo gedit /etc/apache2/sites-available/vhostsAmb un contingut semblant a (canvieu els noms dels servidors i el que volgueu):
# Use name-based virtual hosting.
#
NameVirtualHost *:80
# "fotos.localhost" VirtualHost:
#
<Directory "/var/www/fotos">
Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<VirtualHost *:80>
ServerAdmin webmaster@fotos.localhost
DocumentRoot "/var/www/fotos"
ServerName fotos.localhost
ErrorLog ${APACHE_LOG_DIR}/fotos_error.log
CustomLog ${APACHE_LOG_DIR}/fotos_access.log combined
</VirtualHost>
# "web.localhost" VirtualHost:
#
<Directory "/var/www/web">
Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
Allow from all
</Directory>
<VirtualHost *:80>
ServerAdmin webmaster@web.localhost
DocumentRoot "/var/www/web"
ServerName web.localhost
ErrorLog ${APACHE_LOG_DIR}/web_error.log
CustomLog ${APACHE_LOG_DIR}/web_access.log combined
</VirtualHost>
I l'activem amb:
$ sudo a2ensite vhosts $ sudo /etc/init.d/apache2 restartEn principi, amb això ja estaria. Només ens queda afegir els noms dels servidors virtuals al fitxer de noms coneguts:
$ gksudo gedit /etc/hostsNomés caldrà afegir una línia:
... 127.0.0.1 fotos.localhost web.localhost ...I per provar que tot ha anat bé, afegim un fitxer 'index.php' a cadascún dels nostres projectes. El contingut pot ser un simple 'Hola món' en PHP:
<?php echo 'web.localhost diu: Hola a tothom!';?>I comprovem que efectivament hi tenim accés i ens respon, anant a l'adreça http://web.localhost:
