Non mi funziona il layer di estrazione dati...
ecco il file
Codice PHP:
<?php
require_once 'Zend/Db.php';
require_once 'Zend/Db/Table.php';
$params = array (
'host' => 'localhost:3306',
'username' => 'xxx',
'password' => 'xxx',
'dbname' => 'creasito'
);
$db = Zend_Db::factory('pdo_Mysql', $params);
/* Assegnamo l'adapter di default che verrà utilizzato
* da ogni istanza di Zend_Db_table per accedere alla tabella
* specifica
*/
Zend_Db_Table::setDefaultAdapter($db);
// ... setup ...
class Authors extends Zend_Db_Table
{
}
class Articles extends Zend_Db_Table
{
public function insert($data)
{
if(!isset($data['data']))
{
$data['data'] = date('d/m/Y h:i:s');
}
parent::insert($data);
}
}
$articles = new Articles();
$authors = new Authors();
$adapter = $articles->getAdapter();
$gabriele_id = $authors->insert(array(
'name' => 'Gabriele',
'surname' => 'Farina'
));
for($i = 0; $i < 100; ++$i)
{
$articles->insert(array(
'title' => 'Titolo dell\'articolo '.$i,
'content' => 'Contenuto dell\'articolo'.$i,
'author_id' => $gabriele_id
));
}
$even = $articles->findAll('id % 2 == 0');
foreach($even as $article)
{
$article->title .= '(even)';
$article->save();
}
$tenth = $articles->find(10);
$author = $authors->find($tenth->author_id);
printf("
<h3>%s</h3>
%s</p>
<p style=\"text-align: right\">%s</p>",
$tenth->title,
$tenth->content,
$author->name." ".$author->surname
);
?>
mi da questo errore
codice:
Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with message 'SQLSTATE[HY000] [2005] Unknown MySQL server host 'localhost:3306' (11001)' in C:\Programmi\PAMPA\PAMPA\apache\htdocs\zend\library\Zend\Db\Adapter\Pdo\Abstract.php:103 Stack trace: #0 C:\Programmi\PAMPA\PAMPA\apache\htdocs\zend\library\Zend\Db\Adapter\Abstract.php(146): Zend_Db_Adapter_Pdo_Abstract->_connect() #1 C:\Programmi\PAMPA\PAMPA\apache\htdocs\zend\library\Zend\Db\Adapter\Abstract.php(309): Zend_Db_Adapter_Abstract->query('DESCRIBE articl...', NULL) #2 C:\Programmi\PAMPA\PAMPA\apache\htdocs\zend\library\Zend\Db\Adapter\Pdo\Mysql.php(86): Zend_Db_Adapter_Abstract->fetchAll('DESCRIBE articl...') #3 C:\Programmi\PAMPA\PAMPA\apache\htdocs\zend\library\Zend\Db\Table.php(181): Zend_Db_Adapter_Pdo_Mysql->describeTable('articles') #4 C:\Programmi\PAMPA\PAMPA\apache\htdocs\zend\library\Zend\Db\Table.php(123): Zend_Db_Table->_setup() #5 C:\Programmi\PAMPA\PAMPA\apache\htdocs\connessione.php(39): Zend_Db_Table->__construct() #6 {main} thrown in C:\Programmi\PAMPA\PAMPA\apache\htdocs\zend\library\Zend\Db\Adapter\Pdo\Abstract.php on line 103