php postgre

 install dependencies  sudo apt-get install php7.0-pgsql

yum install php-pgsql

restart apache

https://stackoverflow.com/questions/38981799/unable-to-install-php5-pgsql-on-ubuntu-16-04/42772824

<?php

   $host        = "host = hus-west-2.rds.amazonaws.com";

   $port        = "port = 5432";

   $dbname      = "dbname = product";

    $pass="dElm0zL";

$pid=$argv[1];

    $credentials = "user=phone  password=$pass";

   $db = pg_connect( "$host $port $dbname $credentials"  );

   if(!$db) {

      echo "Error : Unable to open database\n";

   } else {

      echo "Opened database successfully\n";

   }

   $sql =<<<EOF

      SELECT * FROM public.howardmillerinventory where "Clock"='$pid'

EOF;

   $ret = pg_query($db, $sql);

   if(!$ret) {

      echo pg_last_error($db);

      exit;

   }

   while($row = pg_fetch_row($ret)) {

      echo "Item# = ". $row[0] . "\n";

      echo "Stock= ". $row[1] ."\n";

      }

   echo "Operation done successfully\n";

   pg_close($db);

?>

mysql export to csv

 https://makitweb.com/how-to-export-mysql-table-data-as-csv-file-in-php/

https://www.itechempires.com/2016/05/export-data-from-mysql-to-csv-using-php/

php iptables

run   sudo visudo

root  ALL=(ALL) ALL

wwwrun ALL=NOPASSWD: /usr/sbin/iptables

<?php

$ip=$_SERVER['REMOTE_ADDR'];

echo " Welcome your IP $ip has been white listed";

 $web=shell_exec("sudo iptables -I INPUT 2 -m state --state NEW,RELATED,ESTABLISHED -m tcp -p tcp --dport 80 -s $ip -j ACCEPT");

 $sip=shell_exec("sudo iptables -I INPUT 2 -m state --state NEW,RELATED,ESTABLISHED -m udp -p udp --dport 28614 -s $ip -j ACCEPT"

?>

https://exain.wordpress.com/2007/11/24/execute-system-commands-via-php/