Database Connection Snippets

18 June, 2013   

Define few variables with your MySQL database connection settings and connect to MySQL database using mysql_connect() and mysql_select_db() functions.

13 April, 2011   

Connecting to a MySQL database to make the data from the database available in your Web application, can be done in many different ways. Here are two often used methods.

24 September, 2012   

Connects to a database, and runs a query

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.

Basic Database Connection, Random Query, Display Result

23 October, 2012   

MySQL code example to optimize all tables of database

14 February, 2012   

MySQL code to connect to db. Don't forget to change the parameters.

15 July, 2013   

This is a method that can be used to take a connection string and a valid oledb command and perform a scalar. This returns an Integer/Int32 value.

11 March, 2015   

PHP code shows how to upload images into a mysql database using

15 June, 2014   

Example for updating a record in a database with perl and the DBU module.

05 May, 2012   

ASP code example with Sql Statement

30 August, 2011   

Calculates the total size of a MySQL database in KB/MB or GB...

09 April, 2013   

How to "bounce" an Oracle database

01 January, 2014   

Example shown here how to call a stored procedured in C#

05 July, 2012   

Backup MySQL Database to SQL File with mysqldump

05 May, 2012   

ASP code example to return a long representing the record count returned by an SQL statement

Exam code to backup MySQL Database to SQL File

05 September, 2011   

This class is for simplifying and accelerating working with SQL, using this class is very simple; there is a sample below for this class, which I hope is useful.

Oracle 10G has enhanced the flashback feature further and has turned it into a much more powerful feature by introducing a number of additional function. Some of the more common ones are discussed here. - Flashback Table - Flashback Drop - Flashback Database

13 October, 2013   

To create 'examples' database on your MySQL server you should run the following script