Gaston_Phone
08/05/2011, 14h40

protected function _initDb()
{
$configuration = new Zend_Config_Ini(APPLICATION_PATH . '/configs/application.ini', APPLICATION_ENV);
$dbAdapter = Zend_Db::factory($configuration->resources->db);
$DB_host = $configuration->resources->db->params->host;
$DB_user = $configuration->resources->db->params->username;
$DB_pass = $configuration->resources->db->params->password;
$fh_db = mysql_connect($DB_host, $DB_user, $DB_pass);
$sel = mysql_select_db($DB_user, $fh_db);
// $dbAdapter->getConnection()->exec("SET NAMES 'utf8'");
Zend_Db_Table_Abstract::setDefaultAdapter($dbAdapt er);
}
Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /homez.17/monlogin/application/models/maclasse.php on line 47
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /homez.17/monlogin/application/models/maclasse.php on line 47
bool(false
mysql_connect=Resource id #1 - Erreur=
mysql_select_db=1 - Erreur=
$DBhost = "mysql5-22.perso"; // Par exemple
$DBowner = ""; // ton login SQL
$DBpw = ""; // ton password SQL
$DBName = $DBowner;
$fh_db = mysql_connect($DBhost, $DBowner, $DBpw);
$Erreur = mysql_error();
echo " mysql_connect=".$fh_db." - Erreur=".mysql_error()."
\n";
error_reporting(E_ALL); // Activer le rapport d'erreurs PHP
function getmicrotime()
{
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}
$Date_start = getmicrotime();
// ****** Exemples de configuration selon les hébergements mutualisés ******
// Perso
// ------
// $DBhost = "mysql5-14.perso";
// $DBowner = ""; // Ton login SQL
// $DBName = $DBowner;
// Pro
// ---
// $DBhost = "mysql5-6.pro";
// $DBowner = ""; // Ton login SQL
// $DBName = $DBowner;
// ****** Fin des exemples de configuration
// ****** Configuration - Debut ******
$DBhost = "mysql5-6"; // Par exemple
$DBowner = ""; // ton login SQL
$DBpw = ""; // ton password SQL
$DBName = $DBowner;
// ****** Configuration - Fin ******
$Table_SQL = "Tab_test_DB";
$fh_db = mysql_connect($DBhost, $DBowner, $DBpw);
$Erreur = mysql_error();
echo " mysql_connect=".$fh_db." - Erreur=".mysql_error()."
\n";
if (strlen($Erreur) > 0) exit;
$sel = mysql_select_db($DBName, $fh_db);
echo " mysql_select_db=".$sel." - Erreur=".mysql_error()."
\n";
echo " Test de DROP/CREATE de la table '" .$Table_SQL. "' dans la base '" .$DBName. "' sur le serveur '" .$DBhost. "'
";
// Supression de la table Tab_test_DB
$sql_query="DROP TABLE IF EXISTS `Tab_test_DB` "; // Requête
$result_query=mysql_query($sql_query); // Exécution de la requête
$Erreur = mysql_error();
echo "Supression de la table Tab_test_DB - Erreur=".mysql_error()." - \$sql_query=$sql_query - \$result_query=$result_query
\n";
if (strlen($Erreur) > 0) exit;
// Création de la table Tab_test_DB
$sql_query="CREATE TABLE `Tab_test_DB` ( `Id` int(11) NOT NULL auto_increment, `NOM` varchar(32) NOT NULL default '', `PRENOM` varchar(32) NOT NULL default '', PRIMARY KEY (`Id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 "; // Requête
$result_query=mysql_query($sql_query); // Exécution de la requête
$Erreur = mysql_error();
echo "Création de la table Tab_test_DB- Erreur=".mysql_error()." - \$sql_query=$sql_query - \$result_query=$result_query
\n";
if (strlen($Erreur) > 0) exit;
// Ajout d'un Premier enregistrement
$sql_query="INSERT INTO `Tab_test_DB` values ('','DURANDAL','Michel') "; // Requête
$result_query=mysql_query($sql_query); // Exécution de la requête
$Erreur = mysql_error();
echo "Ajout d'un enregistrement - Erreur=".mysql_error()." - \$sql_query=$sql_query - \$result_query=$result_query
\n";
if (strlen($Erreur) > 0) exit;
// Ajout d'un Deuxième enregistrement
$sql_query="INSERT INTO `$Table_SQL` values ('','DURANDAL','Pierre') "; // Requête
$result_query=mysql_query($sql_query); // Exécution de la requête
$Erreur = mysql_error();
echo "Ajout d'un enregistrement - Erreur=".mysql_error()." - \$sql_query=$sql_query - \$result_query=$result_query
\n";
if (strlen($Erreur) > 0) exit;
// Ajout d'un Troisième enregistrement
$sql_query="INSERT INTO `Tab_test_DB` values ('','accents-éèàâ','Jean-Noël') "; // Requête
$result_query=mysql_query($sql_query); // Exécution de la requête
$Erreur = mysql_error();
echo "Ajout d'un enregistrement - Erreur=".mysql_error()." - \$sql_query=$sql_query - \$result_query=$result_query
\n";
if (strlen($Erreur) > 0) exit;
// SELECT dans la table Tab_test_DB : NOM='DURANDAL'
$sql_query="SELECT Id, NOM, PRENOM FROM `Tab_test_DB` WHERE NOM='DURANDAL' "; // Requête
$result_query=mysql_query($sql_query); // Exécution de la requête
$Erreur = mysql_error();
echo "SELECT dans la table Tab_test_DB - Erreur=".mysql_error()." - \$sql_query=$sql_query - \$result_query=$result_query
\n";
if (strlen($Erreur) > 0) exit;
// SELECT dans la table Tab_test_DB : tous les enregistrements
$sql_query="SELECT Id, NOM, PRENOM FROM `Tab_test_DB` "; // Requête
$result_query=mysql_query($sql_query); // Exécution de la requête
$Erreur = mysql_error();
echo "SELECT dans la table Tab_test_DB - Erreur=".mysql_error()." - \$sql_query=$sql_query - \$result_query=$result_query
\n";
if (strlen($Erreur) > 0) exit;
$result_count_row_get = mysql_num_rows($result_query);
$Erreur = mysql_error();
echo " Nombre d'enregistrements trouvés = $result_count_row_get
\n";
if (strlen($Erreur) > 0) exit;
if ($result_query)
{
$Count = 0;
while ($result_query && $row=mysql_fetch_array($result_query))
{
$Count = $Count + 1;
$NOM = $row['NOM'];
$PRENOM = $row['PRENOM'];
echo " Table Tab_test_DB : ".$Count." - \$NOM=".$NOM." - \$PRENOM=".$PRENOM."
\n";
}
}
// Fermeture de la connexion
mysql_close($fh_db);
$Date_end = getmicrotime();
$Duree = $Date_end - $Date_start;
$Duree = sprintf("%01.2f", $Duree);
echo "
Durée du traitement = $Duree secondes
\n";
?>
class Bootstrap extends Zend_Application_Bootstrap_Bootstrap { protected function _initDb() { $configuration = new Zend_Config_Ini(APPLICATION_PATH . '/configs/application.ini', APPLICATION_ENV); $dbAdapter = Zend_Db::factory($configuration->resources->db); // $dbAdapter->getConnection()->exec("SET NAMES 'utf8'"); // KO si décommenté Zend_Db_Table_Abstract::setDefaultAdapter($dbAdapter); } }
; - database resources.db.adapter = Pdo_Mysql resources.db.params.host = "mysql5-22.perso" resources.db.params.username = monlogin resources.db.params.password = monmotdepasse resources.db.params.dbname = mabase resources.db.params.charset = "UTF8"