Recent changes Random page
GAMING
Technology
 
Gaming
Entertainment
Science Fiction
Biggest wikis
Hobbies
Music
See more...

MySQL connection

From Programmer's Wiki

Jump to: navigation, search
 

Contents


[edit] C

[edit] C++

[edit] PHP

<?php
$dbhost = 'localhost';  // Name of the server
$dbuser = 'root';       // Username
$dbpass = 'password';   // Password

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'dbname';    // Database Name

mysql_select_db($dbname);
?>

[edit] Java

//...necessary import packages
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException; //helpful but not used in this example

//...code within a class
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection("jdbc:mysql:///test","root", "secret");
//...preform actions with the open database connection
con.close();

[edit] Perl

[edit] Python

Rate this article:
Share this article: