jcadima
5/29/2015 - 3:59 AM

Antipattern mysql

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
	}
}