<?php # FileName="Connection_php_mysql.htm" # Type="MYSQL" # HTTP="true" $hostname_connect = "localhost"; $database_connect = "base_xxx"; $username_connect = "nom"; $password_connect = "passe"; $connect = mysql_pconnect($hostname_connect, $username_connect, $password_connect) or trigger_error(mysql_error(),E_USER_ERROR); ?>
function KT_Connection(&$connection, $databasename) { $this->connection = &$connection; $this->databaseName = $databasename; }
require_once(connect.php); class KT_Connection { /** * The database name * @var string * @access private */ var $databaseName = ''; /** * The connection Resource ID * @var object ResourceID * @access private */ var $connection = null; /** * Flag. what server model is. * @var string * @access private */ var $servermodel = "mysql"; /** * for ADODB compatibility * @var string * @access public */ var $databaseType = "mysql"; private function initConnection() { if($this->connection == null) { $this->connect = mysql_pconnect($hostname_connect, $username_connect, $password_connect) or trigger_error(mysql_error(),E_USER_ERROR); } } /** * The constructor * Sets the connection and the database name * @param object ResourceID &$connection * @param string $databasename * @access public */ function KT_Connection(&$connection, $databasename) { initConnection(); $this->connection = &$connection; $this->databaseName = $databasename; } /** * Executes a SQL statement * @param string $sql * @return object unknown * true on success * response Resource ID if one is returned by the wrapper function * @access public */ function Execute($sql) { if (!mysql_select_db($this->databaseName, $this->connection)) { return false; } $response = mysql_query($sql, $this->connection); if (!is_resource($response)) { return $response; } else { $recordset = new KT_Recordset($response); return $recordset; } } /** * Executes a SQL statement * @param string $sql * @return mysql resource * true on success * response MYSQL Resource ID * @access public */ function MySQL_Execute($sql) { if (!mysql_select_db($this->databaseName, $this->connection)) { return false; } $response = mysql_query($sql, $this->connection); return $response; } /** * Gets the error message * @return string * @access public */ function ErrorMsg() { return mysql_error($this->connection); } /** * Gets the auto-generated inserted id (if any) * @return object unknown * @access public */ function Insert_ID($table, $pKeyCol) { return mysql_insert_id($this->connection); } }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionmysql_select_db($bdBase)pour te place sur la base de données correspondante.
<?php function Connexion() { //initialise les variables globales /* LOCAL */ $bdServeur = "localhost"; $bdUser = "root"; $bdMdp = ""; $bdBase = "nom_base"; mysql_connect($bdServeur, $bdUser, $bdMdp) or die("Erreur de connexion au serveur") ; mysql_select_db($bdBase) or die("Erreur sur le nom de la base de donnée") ; } ?>