You can also choose to use Perl and the DBI Perl Module to access your database. A commented example: <\/p>\n
#!\/usr\/bin\/perl <\/p>\n
use DBI; <\/p>\n
# Connect To Database
\n# * The DBI interface to MySQL uses the method “connect” to make a
\n# * connection to the database. It takes as it’s first argument
\n# * the string “DBI:mysql:database:hostname”, where database is equal
\n# * to the name of your database, and hostname to the server that it’s
\n# * located on. The second and third arguments, respectively, should
\n# * be your account username and password. The connection is assigned.
\n# * to a variable that is used by most other methods in the module.
\n$database = “your database name”;
\n$username = “your database username”;
\n$password = “your database password”;
\n$hostname = “your database hostname”;
\n$db = DBI->connect(“DBI:mysql:$database:$hostname”, $username, $password); <\/p>\n
# Execute a Query
\n# * executing a query is done in two steps. First,
\n# * the query is setup using the “prepare” method.
\n# * this requires the use of the variable used to
\n# * initiate the connection. Second, the “execute”
\n# * method is called, as shown below.
\n$query = $db->prepare(“SELECT * FROM test”);
\n$query->execute; <\/p>\n
# How many rows in result?
\n# * the “rows” method using the variable name the
\n# * query was executed under returns the number
\n# * of rows in the result.
\n$numrows = $query->rows; <\/p>\n
# Display Results
\n# * the fetchrow_array method executed on the
\n# * query returns the first row as an array.
\n# * subsequent calls return the other rows in
\n# * sequence. It returns zero when all rows have
\n# * been retrieved.
\nwhile (@array = $query->fetchrow_array) { ($field1, $field2, $field3) = @array; print “field1 = $field1, field2 = $field2, field3 = $field3 \\n”; } <\/p>\n
# Cleaning Up
\n# * with the DBI module, it is a good idea to clean up by
\n# * explicitly ending all queries with the “finish” method,
\n# * and all connections with the “disconnect” method.
\n$query->finish;
\n$db->disconnect; <\/p>\n
exit(0); <\/p>\n
The DBI Module provides other methods you might find useful. More information is available by running “perldoc DBI” while logged on to your account via SSH. <\/p>\n","protected":false},"excerpt":{"rendered":"