Potes'n'Roll

<?php
/* $Id: config.inc.php,v 1.28 2000/07/13 13:52:48 tobias Exp $ */

/*
 *  phpMyAdmin Configuration File
 *  All directives are explained in Documentation.html
 */

// The $cfgServers array starts with $cfgServers[1].  Do not use $cfgServers[0].
// You can disable a server config entry by setting host to ''.
$cfgServers[1]['host'] = 'sql2';           // MySQL hostname
$cfgServers[1]['port'] = '';                    // MySQL port - leave blank for default port
$cfgServers[1]['adv_auth'] = false;             // Use advanced authentication?
$cfgServers[1]['stduser'] = '';             // MySQL standard user (only needed with advanced auth)
$cfgServers[1]['stdpass'] = '';                 // MySQL standard password (only needed with advanced auth)
$cfgServers[1]['user'] = 'cpttsuba';                // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = 'MOTDEPASSE';                // MySQL password (only needed with basic auth)
$cfgServers[1]['only_db'] = 'cpttsuba';                 // If set to a db-name, only this db is accessible
$cfgServers[1]['verbose'] = '';                 // Verbose name for this host - leave blank to show the hostname

$cfgServers[2]['host'] = '';
$cfgServers[2]['port'] = '';
$cfgServers[2]['adv_auth'] = false;
$cfgServers[2]['stduser'] = '';
$cfgServers[2]['stdpass'] = '';
$cfgServers[2]['user'] = '';
$cfgServers[2]['password'] = '';
$cfgServers[2]['only_db'] = '';
$cfgServers[2]['verbose'] = '';

$cfgServers[3]['host'] = '';
$cfgServers[3]['port'] = '';
$cfgServers[3]['adv_auth'] = false;
$cfgServers[3]['stduser'] = '';
$cfgServers[3]['stdpass'] = '';
$cfgServers[3]['user'] = 'root';
$cfgServers[3]['password'] = '';
$cfgServers[3]['only_db'] = '';
$cfgServers[3]['verbose'] = '';

/* 
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pmausr';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';

/* 
 * End of servers configuration
 */

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['controluser'] = 'pmausr';

$cfg['Servers'][$i]['controlpass'] = 'pmapass';

$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';

Version supérieur a 2.2.3 : 

$cfg['PmaAbsoluteUri'] = 'http://www.hiei-tf.fr/repertoire de phpMyAdmin/';
 
$i++;
$cfg['Servers'][$i]['host']                   = 'mysql5-2';
$cfg['Servers'][$i]['port']                   = '';
$cfg['Servers'][$i]['socket']                 = '';
$cfg['Servers'][$i]['connect_type']           = 'tcp';
$cfg['Servers'][$i]['controluser']            = '';
$cfg['Servers'][$i]['controlpass']            = '';
$cfg['Servers'][$i]['auth_type']              = 'config';
$cfg['Servers'][$i]['user']                   = 'UTILISATEUR';
$cfg['Servers'][$i]['password']               = 'MOTDEPASSE';
$cfg['Servers'][$i]['only_db']                = 'BDD';
$cfg['Servers'][$i]['verbose']                = '';
$cfg['Servers'][$i]['pmadb']                  = '';
$cfg['Servers'][$i]['bookmarktable']          = '';
$cfg['Servers'][$i]['relation']               = '';
$cfg['Servers'][$i]['table_info']             = '';
$cfg['Servers'][$i]['table_coords']           = '';
$cfg['Servers'][$i]['column_comments']        ='';
$cfg['Servers'][$i]['pdf_pages']              = '';
$cfg['Servers'][$i]['AllowDeny']['order']     = '';
$cfg['Servers'][$i]['AllowDeny']['rules']     = array();

$sql="CREATE TABLE compteur_visite (
	compteur double DEFAULT '0' NOT NULL,
	date date DEFAULT '0000-00-00' NOT NULL,
	time int(9) NOT NULL default '0',
	duree int(9) NOT NULL default '0',
	ip varchar(50) NOT NULL,
	PRIMARY KEY (ip),
	KEY compteur (compteur, date),
	KEY ip (ip)
	)
	";
	$res=mysql_query($sql, $db);
	$sql="INSERT INTO compteur_visite VALUES ('$compteur', '$date', '$time', '$duree', 'compteur')";
	$res=mysql_query($sql, $db);
	if ($res==1)

CREATE TABLE compteur_visite (
	compteur double DEFAULT '0' NOT NULL,
	date date DEFAULT '0000-00-00' NOT NULL,
	time int(9) NOT NULL default '0',
	duree int(9) NOT NULL default '0',
	ip varchar(50) NOT NULL,
	PRIMARY KEY (ip),
	KEY compteur (compteur, date),
	KEY ip (ip)
	)

CREATE TABLE compteur_visite (
	compteur double DEFAULT \'0\' NOT NULL,
	date date DEFAULT \'0000-00-00\' NOT NULL,
	time int(9) NOT NULL default \'0\',
	duree int(9) NOT NULL default \'0\',
	ip varchar(50) NOT NULL,
	PRIMARY KEY (ip),
	KEY compteur (compteur, date),
	KEY ip (ip)
	)

MySQL a répondu:


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '\'0\' NOT NULL,
	date date DEFAULT \'0000-00-00\' NOT NULL,
	time int(9) NOT N' at line 2