How Can You Accept User Input with PHP and Use It in a SQL Command?

0 Comments

Problem scenario
You want to read in user input via a web page.  You then want that user input to participate in an invocation of a SQL command. How do you get user input to be a variable in the construction of a SQL command that is automatically executed when a web-page button is clicked?

Solution
Warning
This does not prevent against SQL injection attacks.

…

Continue reading “How Can You Accept User Input with PHP and Use It in a SQL Command?”

A List of E-Discovery Books

0 Comments

Cloud Computing and Electronic Discovery (Wiley CIO) by James P. Martin and Harry Cendrowski
E-Discovery and Data Privacy: A Practical Guide by Catrien Noorda and Stefan Hanloser
E-Discovery and the Federal Rules of Civil Procedure: A Pocket Guide by Bradley Schaufenbuel
E-discovery: Creating and Managing an Enterprisewide Program – A Technical Guide to Digital Investigation and Litigation Support by Karen A. Schuler
e-Discovery: Current Trends and Cases by Ralph C.

…

Continue reading “A List of E-Discovery Books”

How Do You Get a Web Page to Invoke a Postgres Command (e.g., for a RESTful API)?

0 Comments

Problem scenario
You want a REST call to invoke some SQL code on a Postgres database.  How do you do this?

Solution
Install Apache web server, PHP, and the PHP-pgsql package on your Postgresql database server.  This example assumes you have PHP, Apache web server, Postgres, and the php-pgsql package installed on your server.  Assuming the web server is running and the default directory for web pages is still /var/www/html/ do the following.

…

Continue reading “How Do You Get a Web Page to Invoke a Postgres Command (e.g., for a RESTful API)?”

How Do You Ingest (or Import) a CSV File into a Postgresql Database Table?

0 Comments

Problem scenario
You want to extract data from a .csv file.  In other words you want to  transform data from a flat file and import it into a database.  Is there an example of how to create a table, format a .csv file, and run a command to import the .csv file into the Postgresql database?

Solution
1.  Here is how to create a table to target for the import or ETL (Extract,

…

Continue reading “How Do You Ingest (or Import) a CSV File into a Postgresql Database Table?”

How Do You Give a Local Windows 2016 Server User Access to Remote into It?

0 Comments

Problem scenario
You have a local user account on a Windows 2016 server (e.g., jdoe).  You want to give it access to be able to start PowerShell sessions from other Windows servers.  What do you do?

Solution
1.  Open PowerShell as Administrator.
2.  Run this command:
Set-PSSessionConfiguration -ShowSecurityDescriptorUI -Name Microsoft.PowerShell
# This is an alternative command provided as a reference in case the above did not work:
# Set-PSSessionConfiguration -Name Microsoft.PowerShell -ShowSecurityDescriptorUI -Force

3. 

…

Continue reading “How Do You Give a Local Windows 2016 Server User Access to Remote into It?”

How Do You Create Two Tables with a Shared Column between Them (e.g., Have a Foreign Key Constraint)?

0 Comments

Problem scenario
You want to create two tables in a Postgresql database.  You want the tables to share a column to relate to one another.  You want to implement a foreign key constraint to achieve this goal.  Is there an example of SQL statements to do this?

Solution
Run these two SQL commands that start with the words “CREATE TABLE”:

CREATE TABLE table1 (id integer,

…

Continue reading “How Do You Create Two Tables with a Shared Column between Them (e.g., Have a Foreign Key Constraint)?”