From apnsGuide

Contents 1 Connection Examples 1.1 PHP5 with mysqli extension 1.2 PHP4 with mysql extension 1.3 Perl 1.4 Ruby on Rails 1.5 Java 2 See Also

Connection Examples

Where *username* is the user, *password* is the password, and *database* is the database name.

PHP5 with mysqli extension

$conn = new mysqli("localhost","*username*","*password*");
$conn->select_db("*database");
$conn->prepare("SELECT ...");
/** OR you can use... */
$conn->query("SELECT ...");
 

PHP4 with mysql extension

$conn = mysql_connect("localhost","*username*","*password*");
mysql_select_db("*database*",$conn);
$stmt = mysql_query("SELECT ...", $conn);
 

Perl

use DBI;
my $conn = DBI->connect("dbi:mysql:database=*database*;".
                        "host=localhost;user=*username*;".
                        "password=*password*");
my $stmt = $conn->prepare("SELECT ...");
 

Ruby on Rails

Modify /config/database.yml in your application directory to look something like the following:

production: &production
  adapter: mysql
  database: *database*
  username: *username*
  password: *password*
  host: localhost
 
development:
  database: *database*
  <<: *production
 
testing:
  database: *database* 
  <<: *production
 

Java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
 
/** class declaration ... method declarations ... */
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/*database*",
                                              "*username*",
                                              "*password*");
stmt = conn.createStatement();
rs   = stmt.executeQuery("SELECT ...");
 

See Also

• MySQL: MySQL resource center section