Insert Snippets

Note that to add a new column to the query, just add in an input box to the HTML, the PHP generates an insert for each field.

The mysql_fetch_assoc "converts" a row from a table into an associative array. The mysql_insert_array "converts" an associative array into a row in a table.

14 August, 2014   

Easy way to copy the contents of one table to another table.

05 November, 2012   

PL/SQL example shown below how to use BFILENAME

01 September, 2014   

MySQL code example to assign random passwords

01 October, 2013   

This class has lots of common functionality built right into it. It also supports Mysql and Sphinx.

09 April, 2011   

On form, insert a Page Break after the first group of fields. This creates two "pages" in the form, which can be toggled using a command button on each.

24 June, 2015   

Create a table with the results from a SELECT statement.

02 November, 2016   

A PHP template for dealing with any sort of error

How to get number of rows in tables of database

12 July, 2014   

This block finds all employees whose monthly wages (salary plus commission) are higher than $2000.

01 December, 2011   

The following code block shows how to run DML statements in PL/SQL. Basically they look similar to the SQL. Note that the SELECT statement retrieves the single-row value and store into a variable using INTO clause.

Whenever a row is inserted in the Customers Table, the following trigger will be executed.

30 December, 2010   

Class to back up entire databases and email them out, or individual tables

20 August, 2011   

Source code for C++ program printing various data to the console.

09 February, 2011   

Class to back up entire databases and email them out, or individual tables.

Make a MySQL Database called "db" with a table named "variables" with three rows ("id", "title", and "content"). Insert your data. Then call the page by going variables.php?id=1 etc.

MS SQL triggers for automatic Create and LastModified Dates

Using a stored procedure as the source in an OLE_DB Source for SSIS, the package can’t detect the output of the stored proc.

20 August, 2015   

Basic setup code for jQuery, linking to Google APIs for the jQuery library.