Basic Database Connection, Random Query, Display Result

<?php $hostname = 'localhost'; $user = 'username'; $pass = 'password'; $database = 'database_name'; $db_connection = new PDO( "mysql:host=" . $hostname . ";dbname=" . $database, $user, $pass ); $results = $db_connection->query( 'SELECT testimonial, author FROM recommendations WHERE 1 ORDER by rand() LIMIT 1' ); foreach ( $results as $row ) {	echo '<p id="quote">' . $row['testimonial'] . '</p>';	echo '<p id="author">&ndash;' . $row['author'] . '</p>'; } // Close the connection $db_connection = null;

Comments

Guilherme Barbosa

# August 20, 2009

Sweet!
Not the basic only. I liked it.
Thanks.

Eddie

# September 3, 2009

You are most welcome!

rajan

# February 2, 2012

Hi, this script can only be implemented for a single table. Do you have any other script that works for more than one table.
Thank you.

Casey

Permalink to comment# January 30, 2013

You could write this into a query function, and then use multiple SQL queries.

I find this to be a more secure and robust implementation. It’s definitely more dynamic. Not knocking the author’s code, it’s two years old, and I am sure this was just a starting point.

Check out this class:
https://github.com/ajillion/PHP-MySQLi-Database-Class/blob/master/MysqliDb.php

KedarLasane

# September 5, 2012

You can store Login Details Like Username & Password in different file and then include it into above page instead of directly specified.Something like following

 <?php include "secure.php"; // include file for i.e username & password $db = mysql_connect(HOSTNAME, USERNAME, PASSWORD) or die ('I cannot connect to MySQL.'); mysql_select_db(DATABASE_NAME); $query = "SELECT testimonial,author FROM recommendations WHERE 1 ORDER by rand() LIMIT 1"; $result = mysql_query($query); while ($row = mysql_fetch_array($result)) { echo "" , ($row['testimonial']) , " \n –" , nl2br($row['author']) , ""; } mysql_free_result($result); mysql_close(); ?>

——–
and secure.php contains following data.

 <?php define ('HOSTNAME', 'localhost'); define ('USERNAME', 'username'); define ('PASSWORD', 'password'); define ('DATABASE_NAME', 'recommendations'); ?>

—
It is very secure method than above one.

Casey

# January 30, 2013

Just an FYI for newcomers. I suggest using the new php syntax. This is deprecated. You should be using prepared statements and mysqli connection, otherwise you’re vulnerable to sql injection.

http://php.net/manual/en/book.mysqli.php

Brent

# June 18, 2013

USE PDO! mysql_connect is an anti-pattern and not as secure as it should be.

Milton

# February 20, 2014

PDO style. After reading, trial and error!! First post of a newbee!

 <?php Try { require_once('db.php'); $link = new \PDO('mysql:host='.HOSTNAME.';dbname='.DATABASE.';charset=utf8mb4', USERNAME, PASSWORD, array(\PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION, \PDO::ATTR_PERSISTENT => false)); $handle2 = $link->prepare('SELECT * FROM tabla1'); $handle2->execute(); $result = $handle2->fetchAll(\PDO::FETCH_OBJ); } catch(\PDOException $ex) { echo $ex->getMessage(); } ?>

Wage

# October 19, 2014

 'usernamehere', 'password' => 'passwordhere' ); // Establish a connection to the database using PDO. try { $connect = new PDO('mysql:host=localhost;dbname=test_db', $config['username'], $config['password']); } catch (PDOException $e){ echo 'ERROR: '.$e->getMessage(); } ?>

Jaylord Ferrer

# March 17, 2015

This should be updated. MySQLi or PDO.

Keyx

# June 2, 2015

Indeed, when will you update this?

THOMPSON

# March 14, 2016

PLEASE FRIENDS AND FAM I NEED YOUR HELP I WANT TO BUILD A DYNAMIC WEBSITE USING PHP I NEED ALL THE HELP I CAN GET AS I AM KIND OF NEW TO PHP

Comments

Leave a Reply Cancel reply