![]() |
C[]
This article is missing a code example in the C language.
C++[]
This article is missing a code example in the C++ language.
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); ?>
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();
Perl[]
use DBI; $dbh = DBI->connect('DBI:mysql:databasename;host=db.example.com', 'username', 'password', { RaiseError => 1 } ); # do something with your db... $dbh->disconnect();
Python[]
import MySQLdb connection = MySQLdb.connect(user='myuser', passwd='my password', host='localhost', db='database_name') cursor = connection.cursor() cursor.execute('SELECT * FROM my_table') results = cursor.fetchall() print 'Total of %d rows' % len(results) for result in results: print result