Brinkster Knowledge Base
Database Connection Strings - Linux Hosting
Database Connection String Samples
Important information regarding the following code samples.
All references to "mysql_user" need to be replaced with your actual Brinkster UserName.
All references to "mysql_password" need to be replaced with your actual Brinkster Password.
All references to "mysql_host" need to be replaced with your actual MySQL HostName.
Please log into your account, select the web site settings, and use the MySQL database name listed there.
username is case sensitive and must be all lower case.
PHP MySQL Connection <?php // Connecting, selecting database $link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password') or die('Could not connect: ' . mysql_error()); echo 'Connected successfully'; mysql_select_db('mysql_user') or die('Could not select database'); // Performing SQL query $query = 'SELECT * FROM testphp'; $result = mysql_query($query) or die('Query failed: ' . mysql_error()); // Printing results in HTML echo "<table>\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { echo "\t<tr>\n"; foreach ($line as $col_value) { echo "\t\t<td>$col_value</td>\n"; } echo "\t</tr>\n"; } echo "</table>\n"; // Free resultset mysql_free_result($result); // Closing connection mysql_close($link); ?> |