msgbartop
A chronological documentation test project, nothing serious, really!
msgbarbottom

18 Jul 2007 Simple antivirus test using a text file

This is a simple test to check if your antivirus software is up and running

  1. Create a text file
  2. Insert the following text into the file
    X5O!P%@AP[4\PZX54(P^)7CC)7}$EICAR-STANDARD-ANTIVIRUS-TEST-FILE!$H+H* 
  3. Save the file with the filename eicar.com

Your antivirus software should detect this file as a virus and notify you about that. Your antivirus software is not working if this doesn’t happen!
Then it’s time to worry :)

Tags:

Posted by

03 Jul 2007 MySQL via PHP Cheat Sheet

Connect to MySQL and to the database

// Connect to MySQL

$connect = mysql_connect("localhost", "mysqluser", "userpassword") or die(mysql_error());

// Select the database

mysql_select_db("databasename", $connect) or die(mysql_error());

PHP Manual Reference
us2.php.net/manual/en/function.mysql-connect.php

Close connection

// Use the variable that was used to connect to MySQL

mysql_close($connect) or die(mysql_error());
// PHP Manual Reference: us2.php.net/manual/en/function.mysql-close.php

Create a database

mysql_create_db("dbname") or die(mysql_error());
// PHP Manual Reference: us2.php.net/manual/en/function.mysql-create-db.php

// W3Schools Reference: www.w3schools.com/sql/sql_create.asp

Delete (drop) a database

$query_drop_db = "DROP DATABASE dbname";

mysql_query($query_drop_db, $connect) or die(mysql_error());
// PHP Manual Reference: us2.php.net/manual/en/function.mysql-drop-db.php

// W3Schools Reference: www.w3schools.com/sql/sql_drop.asp

Create a table

/* If you don't want your script return an error if the table
already exists, you can replace "CREATE TABLE" by
"CREATE TABLE IF NOT EXISTS" which creates the table only
if the table does not already exist, without returning any errors. */

$table = "CREATE TABLE tablename (

table_id int(11) NOT NULL auto_increment,

table_default int(11) NOT NULL default 1,

table_varcharfield varchar(255) NOT NULL,

table_textfield text NOT NULL,

PRIMARY KEY (table_id)

)";

// Actually create the new table in the database.

$result = mysql_query($table) or die (mysql_error());
// W3Schools Reference: www.w3schools.com/sql/sql_create.asp

Select data

// Select specific fields in the table $query_select = "SELECT tablefield, tablefield2 FROM tablename WHERE tablefield = '" .$variable. "' AND tablefield2 = '" .$variable2. "'";

$result_select = mysql_query($query_select) or die(mysql_error());
// W3Schools Reference: www.w3schools.com/sql/sql_select.asp

// W3Schools Reference ("where" clause): www.w3schools.com/sql/sql_where.asp
// Select all the fields in the table $query_select = "SELECT * FROM tablename WHERE tablefield = '" .$variable. "' AND tablefield2 = '" .$variable2. "'";

$result_select = mysql_query($query_select) or die(mysql_error());// W3Schools Reference: www.w3schools.com/sql/sql_select.asp

Select data: Retrieve and display

// Retrieve as several variables
$row_select = mysql_fetch_array($result_select);
extract($row_select);
echo $tablefield;
// Retrieve as a loop
while ($row_select = mysql_fetch_array($result_select)) {
extract($row_select);
echo $tablefield;
}

Insert data

$query_insert = "INSERT INTO tablename(tablefield, tablefield2) VALUES('" .$variable. "', '" .$variable2. "')";
$result_insert = mysql_query($query_insert) or die(mysql_error());

// PHP Manual Reference: us2.php.net/manual/en/function.mysql-insert-id.php
// W3Schools Reference: www.w3schools.com/sql/sql_insert.asp

Insert data: Insert multiple rows

$query_insert = "INSERT INTO tablename(tablefield, tablefield2) VALUES ('" .$variable. "', '" .$variable2. "'),
('" .$variable. "', '" .$variable2. "'),
('" .$variable. "', '" .$variable2. "')";
$result_insert = mysql_query($query_insert) or die(mysql_error());

Update data

$query_update = "UPDATE tablename SET tablefield = '" .$variable. "', tablefield2 = '" .$variable. "' WHERE tablefield3 = '" .$variable3. "'";
$result_update = mysql_query($query_update) or die(mysql_error());

// W3Schools Reference: www.w3schools.com/sql/sql_update.asp

Delete data

// Delete a row from a table
$query_delete = "DELETE FROM tablename WHERE tablefield = '" .$variable. "'";
$result_delete = mysql_query($query_delete) or die(mysql_error());

// W3Schools Reference: http://www.w3schools.com/sql/sql_delete.asp

When you create database tables, you need field types. Certain field types are for certain reasons. Here is a small list of some of the more commonly used field types.

Field Name Description
int(length) Integer field that can range from negative 2147483648 to positive 2147483647. length can limit the length of the integer.
int(length) unsigned Same as int, but can store up to 4294967295, but no negative numbers.
char(length) Any character can be in this field, but the field is at a static length.
varchar(length) Any character can be in this field. The field value length can be from 1 to 255 characters. length is the maximum length it will store.
text Any characters can be in this field. The maximum size the value can be is 65536 characters.
decimal(length, decimal) A field for decimals, where length defines the length of the decimal (as a whole), and the decimal parameter is the number of decimal places.
datetime Field that stores both date and time. Stores as yyyy-mm-dd hh:mm:ss.

Tags: , ,

Posted by

02 Jul 2007 regex –make option

Get a ready regex

The –make option is described by its author as “a remedy for headaches.” It outputs a regexp for one of several common patterns that are given as arguments, as listed in table.

List of ready regexps available in txt2regex

Argument Description
date This argument matches dates in mm/dd/yyyy format, from 00/00/0000 to 99/99/9999.
date2 This argument matches dates in mm/dd/yyyy format, from 00/00/1000 to 19/39/2999.
date3 This argument matches dates in mm/dd/yyyy format, from 00/00/1000 to 12/31/2999.
hour This argument matches time in hh:mm format, from 00:00 to 99:99.
hour2 This argument matches time in hh:mm format, from 00:00 to 29:59.
hour3 This argument matches time in hh:mm format, from 00:00 to 23:59.
number This argument matches any positive or negative integer.
number2 This argument matches any positive or negative integer with an optional floating-point value.
number3 This argument matches any positive or negative integer with optional commas and an optional floating-point value.

For example, you can use this to get a ready regexp for any valid hour in military time, as shown in listing.

Listing. Getting a date regexp with txt2regex

$ txt2regex --make hour3
RegEx perl    : ([01][0-9]|2[0123]):[012345][0-9]
RegEx php     : ([01][0-9]|2[0123]):[012345][0-9]
RegEx postgres: ([01][0-9]|2[0123]):[012345][0-9]
RegEx python  : ([01][0-9]|2[0123]):[012345][0-9]
RegEx sed     : ([01][0-9]|2[0123]):[012345][0-9]
RegEx vim     : ([01][0-9]|2[0123]):[012345][0-9]

$

Tags: ,

Posted by