PDO koda sašķelšana

[dxshindeo]

Sveiki,

ejošs kods:

 

index.php

//---------connect part-----------------
try
{
$hostname = "localhost";
$dbname = "resursi";
$username = "root";
$pw = "root";
$pdo = new PDO ("mysql:host=$hostname;dbname=$dbname","$username","$pw");
}

catch (PDOException $e)
{
echo "Failed to get DB handle: " . $e->getMessage() . "\n";
exit;
}

//-----------Fetching part-----------
$from = 0;
$limit = 10;
$query = $pdo->prepare("SELECT * FROM archive ORDER BY id desc LIMIT $from, $limit");
$query->execute();

for($i=0; $row = $query->fetch(); $i++)
{
echo $i." - ".$row['author']."<br/>";
}

 

 

 

 

Es vēlos šo kodu sadalīt index.php un connect.php.

 

connect.php

//---------connect part-----------------
try
{
$hostname = "localhost";
$dbname = "resursi";
$username = "root";
$pw = "root";
$pdo = new PDO ("mysql:host=$hostname;dbname=$dbname","$username","$pw");
}  

catch (PDOException $e)
{
echo "Failed to get DB handle: " . $e->getMessage() . "\n";
exit;
}

 

 

index.php

include "connect.php";

//-----------Fetching part-----------

$from = 0;
$limit = 10;

$query = $pdo->prepare("SELECT * FROM archive ORDER BY id desc LIMIT $from, $limit");
$query->execute();

for($i=0; $row = $query->fetch(); $i++)
{
echo $i." - ".$row['author']."<br/>";
}

 

Throws "Fatal error: Call to a member function prepare() on a non-object ".

 

Vai ir kāds veids kā to paveikt?

Edited July 25, 2012 by dxshindeo

[Kavacky]

die(); @ connect.php

var_dump($pdo); @ index.php

[v3rb0]

connect.php pēdējā rinda:

return $pdo;

 

index.php sākumā:

$pdo = include 'connect.php';

[dxshindeo]

Paldies :)