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

Loading...

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