However this will only function if your namespace follows a directory structure. I came across this on DreaminCode as i was looking for a very simple __autoload
Here is both the files, with the folder they are in in the head:
load_headScript.php:
<?php
// root: -> /classLib/load/load_headScript.php :
spl_autoload_extensions(".php");
spl_autoload_register();
use classLib\database\database_Connection as DB; // import namespace for code reuse
class load_headScript
{
public function headLoad()
{
$sql = "SELECT scriptCode FROM head_scripts WHERE active != '0'";
$stmt = DB::get()->prepare($sql);
$stmt->execute();
$stmt->setFetchMode(PDO::FETCH_ASSOC);
while($row = $stmt->fetch())
{
print "<script type='text/javascript'>";
print $row['scriptCode'];
print "</script>";
}
}
}
?>
database_Connection.php
<?php
// root -> /classLib/dataBase/database_Connection.php:
namespace classLib\database; // declare namespcae
class database_Connection {
/**
* @var PDO The database link.
*/
protected static $dbLink;
/**
* Returns an open PDO object. This object will be shared
* among all who call this method, so that you don't have
* to be creating multiple connections to MySQL in the
* same request.
* @return PDO
*/
public static function get()
{
if(self::$dbLink == null)
{
$dns = 'mysql:host=localhost;dbname=roundth4_rtb2';
self::$dbLink = new \PDO($dns, 'root', '');
self::$dbLink->exec("SET NAMES 'utf8'");
self::$dbLink->setAttribute(\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
}
return self::$dbLink;
}
/*
* We don't want this class to be able to spawn objects.
* By making these two methods private, we effectively
* prevent that from happening.
*/
private function __construct() {
return false;
}
private function __clone() { …
Fatal error: Class 'organization\projectname\database\Database' not found in G:\xampp_server\htdocs\classDrv_rtb\class\scripts\headScripts.php on line 17
This is the code of the script:
<?php
use organization\projectname\database\Database as DB;
#require("dbCon.php");
class headScript
{
public function headLoad()
{
/*$cxn = new dbConnection;
$cxn = $cxn->pdo();
$stmt = $cxn->prepare("SELECT scriptCode FROM head_scripts WHERE active != '0'");*/
$sql = "SELECT scriptCode FROM head_scripts WHERE active != '0'";
$stmt = DB::get()->prepare($sql);
$stmt->execute();
$stmt->setFetchMode(PDO::FETCH_ASSOC);
while($row = $stmt->fetch())
{
print "<script type='text/javascript'>";
print $row['scriptCode'];
print "</script>";
}
}
}
?>
Ok, following from my previous thread (now resolved) i want to convert and use namespace.
headScript.php:
<?php
class headScript
{
public function connection()
{
try
{
$dbh = new PDO("mysql:host=localhost;dbname=roundth4_rtb2", 'root', ''); // Dev
return $dbh;
}
catch(PDOException $e)
{
echo "Error :- " . $e->getMessage();
die();
}
}
public function headLoad()
{
$cxn = $this->connection()->prepare("SELECT scriptCode FROM head_scripts WHERE active != '0'");
$cxn->execute();
$cxn->setFetchMode(PDO::FETCH_ASSOC);
while($row = $cxn->fetch())
{
print "<script>";
print $row['scriptCode'];
print "</script>";
}
}
}
?>
I'd like to remove the connection function and put this in its own file, then using namespace to pull this in. That way i have one file which can be called via namespace and i can use this function.
Am I thinking this is possible when it is not?
I have tried a few things but cant seem to get it to work.
$stmt = $pdo->prepare("SELECT * FROM $tbl_name where id= :id AND cls= :cls ORDER BY id DESC");
This is a select statement not an insert. So you would not need the id= :id $stmt = $pdo->prepare("SELECT * FROM $tbl_name where cls= :cls ORDER BY cls DESC");
The :id is a placer. Using this is more secure, and allows you to clean the data. Because you are GETting data from the URL this could have been altered or used for SQL injection.
So we use a place holder.
You can use the same for name and cls, although this
<?php
// Using PDO
$tbl_name = "forum_question";
$pdo = new PDO('mysql:dbname=test;host=localhost', '', ''); // first '' is user, second '' is password
$stmt = $pdo->prepare("SELECT * FROM $tbl_name where id= :id ORDER BY id DESC");
$stmt->bindParam(':id', $_GET['id'], PDO::PARAM_INT);
$stmt->execute();
$stmt->setFetchMode(PDO::FETCH_ASSOC);
?>
Your above SQL using PDO, you would then step through the data or display it with something like:
