Antipattern mysql
<?php
///////////////
//on config.php
$config = array (
'DB_HOST' => 'localhost'
'DB_USERNAME' => 'root'
'DB_PASSWORD' => 'tutsplus' ) ;
////////////////////
function connect( $host = 'localhost', $username, $password, $db = '' ) {
$conn = mysql_connect($host, $username, $password);
if( !$conn ) die ("Could not connect to Database, Check credentials");
if ( !empty( $db ) ) {
mysql_select_db('your-database', $conn);
}
return $conn;
}
function query ( $query ) {
$results = mysql_query ($query ) ;
if( $results ) {
$rows = array();
while ( $row = mysql_fetch_object($results) ) {
$rows[] = $row;
}
return $row;
}
return false;
}
on HTML View:
$conn = connect( $config['DB_HOST'] , $config['DB_USERNAME'], $config['DB_PASSWORD'], 'dbname');
$results = query ( 'SELECT * FROM users') ;
if ($results ) {
foreach( $results as $row ) {
echo $row->username
}
}