Windows / Linux / macOS
Su Debian 10 "Buster" il sistema di default dei permessi di amministrazione per l'utente non vengono gestiti da sudo ma da pkexec.Lanciando da terminale il pannello di controllo di xamp con "pkexec /opt/lampp/manager-linux-x64.run" il programma non partirà per errori riguardanti la policy di pkexec.
Scaricare quindi il file "com.debian.pkexec.xampp.policy" e copiarlo da utente root nella path "/usr/share/polkit-1/actions/"
com.debian.pkexec.xampp.policy
Scaricare i file "xhost+silocaluserroot.desktop", "xhost+silocaluserroot.sh" e copiarli da utente root nella path "/etc/xdg/autostart/"
xhost+silocaluserroot.desktop
xhost+silocaluserroot.sh
Dare i permessi di esecuzione al file: chmod a+x /etc/xdg/autostart/xhost+silocaluserroot.sh
Scaricare il file "xamppcontrolpanel.sh"
xamppcontrolpanel.sh
Dare i permessi di esecuzione al file: chmod a+x xamppcontrolpanel.sh
Infine lanciare il comando
chmod a+x /opt/lampp/manager-linux-x64.run
Riavviare il sistema.
Lanciare il pannello di controllo di xamp eseguendo il file:
sh xamppcontrolpanel.sh
First create NTFS partition type primary on your hard drive and rename in WORKSPACE################## XAMPP ON LINUX ########################################################################################################################################
apt install ntfs-3g
/sbin/fdisk -l(look for /dev/sdaX NTFS partition)
/sbin/blkid /dev/sdaX(look for /dev/sdaX partition UUID="XXXXXXXXXXXXXXXX")
mkdir -P /media/yourusername/WORKSPACE
/usr/sbin/groupadd workspace
nano /etc/fstab# X (daemon youruser id, look for it into /etc/passwd file)# XXXX (workspace group id, look for it into /etc/group file) UUID=XXXXXXXXXXXXXXXX /media/yourusername/WORKSPACE ntfs-3g auto,users,uid=XXXX,gid=XXXX,utf8,dmask=002,fmask=113 0 0
run command as a root:mount /dev/sdaXmkdir -P /media/yourusername/WORKSPACE/Apache_htdocs_www
Download and install Xampp for Linux
Backup file /opt/lampp/etc/httpd.conf to /opt/lampp/etc/httpd.conf.ORIGedit file /opt/lampp/etc/httpd.conf
..should have:
#Listen 80Listen 0.0.0.0:80Listen [::0]:80
ServerName localhost:80
Include etc/extra/httpd-vhosts.conf
User daemonGroup workspace
Edit file /etc/hosts127.0.0.1 localhost
Backup file /opt/lampp/etc/extra/httpd-vhosts.conf to /opt/lampp/etc/extra/httpd-vhosts.conf.ORIGEdit file /opt/lampp/etc/extra/httpd-vhosts.conf
# Virtual Hosts#
Now just work on yor browser adding url http://127.0.0.1
################## WAMP ON WINDOWS ######################################################################################################################################
Download and install WAMP for Windows
Backup file file C:\\wamp64\bin\apache\apache2.4.37\conf\httpd.conf to C:\\wamp64\bin\apache\apache2.4.37\conf\httpd.conf.ORIGEdit file file C:\\wamp64\bin\apache\apache2.4.37\conf\extra\httpd-vhosts.conf.. shold have:Listen 0.0.0.0:80Listen [::0]:80ServerName localhost:80User daemonGroup daemonInclude conf/extra/httpd-vhosts.conf
Backup file file C:\\wamp64\bin\apache\apache2.4.37\conf\extra\httpd-vhosts.conf to C:\\wamp64\bin\apache\apache2.4.37\conf\extra\httpd-vhosts.conf.ORIGEdit file file C:\\wamp64\bin\apache\apache2.4.37\conf\extra\httpd-vhosts.conf
Create folder X:/Apache_htdocs_www
Edit file C:\\Windows\System32|Drivers\etc\host127.0.0.1 localhost
################## MAMP ON MAC ###########################################################################################################################################
Install Tuxera NTFS or similar software tools on your system and reboot.
Download and install MAMP for macOS.
Backup file /Applications/MAMP/conf/apache/httpd.conf to /Applications/MAMP/conf/apache/httpd.conf.ORIG
Edit file /Applications/MAMP/conf/apache/httpd.conf
Listen 80
User yourusernameGroup daemon
#Group #-1
DocumentRoot "/Applications/MAMP/htdocs"
Include /Applications/MAMP/conf/apache/extra/httpd-vhosts.conf
Backup file /Applications/MAMP/conf/apache/extra/httpd-vhosts.conf to /Applications/MAMP/conf/apache/extra/httpd-vhosts.conf.ORIGEdit file /Applications/MAMP/conf/apache/extra/httpd-vhosts.conf
Create folder /Volumes/WORKSPACE/Apache_htdocs_www/
Previa implementazione di jQueryUISortable:
https://jqueryui.com/sortable/
Parte interessata del file di esempio galleria1.php
// Quando la pagina è caricata definisci l'ordine attuale e gli elementi da riordinare $(document).ready(function() { $("#lista").sortable({ //definisco il contenitore di elementi da riordinare handle : '.trascinabile', //definisco con la classe .trascinabile quali sono gli elementi trascinabili update : function () { //aggiorno l'ordine ed eseguo una callback var ordina = $('#lista').sortable('serialize'); // salvo una variabile che contiene l'array con il nuovo ordine degli elementi $("#info").load("pages/riordinamento1.php?"+ordina); //Per concludere salviamo una variabile (ordina) che contiene l’array con il nuovo ordine degli elementi ed inviamo in GET questo valore alla pagina riordinamento.php usando la funzione load() } }); });
Parte interessata del file di esempio riordinamento1.php
foreach ($_GET['oggettoItem'] as $position => $item) : $select_image = $dbh->query("UPDATE galleria1 SET position = '".$position."' WHERE id = '".$item."' AND img <> 'empty.png'") or die(mysqli_error()); mysqli_stmt_execute($select_image); endforeach; //var_dump($result); //print_r ($sql); print ('Operazione di spostamento riuscita !');