Php 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

11 March, 2015   

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

23 October, 2012   

MySQL code example for sorting data in a GRID

07 April, 2013   

A simple example code for user login with a login form and database query

21 May, 2012   

PHP example for connecting to MySQL

14 February, 2012   

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

MySQL code to Find PHP code in database Drupal 6.x

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.

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

If you have a database driven site and you want to optimize MySQL tables then this is perfect. It goes through all the tables in a MySQL database and does table optimization on each one using the MySQL Optimize Table syntax.

26 December, 2012   

This cron will do the same on Windows as session management works on Linux

09 May, 2011   

This is a general code to use when inserting an item from a MySQL database. This code isn't considered definitive and can be written in many varied ways. An extention of this code would be to make sure the entry you are adding to the database doesn't already exist (to save dupicate entries). Note: This code requires you to connect to the MySQL...

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